20170614的代码

来源：互联网发布：h5易企秀模板源码编辑：程序博客网时间：2024/06/05 16:45
<!DOCTYPE html><html><head><meta charset="utf-8" /><title></title><style type="text/css">*{font-size: 24px;list-style: none;margin: 0;padding: 0;}#t1{width: 30%;border: 1px solid black;border-collapse: collapse;margin-top: -300px;}tr{height: 25px;border: 1px solid black;border-collapse: collapse;}td{border: 1px solid black;border-collapse: collapse;}#div1{width: 30%;height: 330px;background-color: goldenrod;}</style></head><body>hello~<%// 请求连接Class.forName("com.mysql.jdbc.Driver");//// 连接到数据库java.sql.Connection con =  java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/school_system", "root", "");//// 进行搜索操作java.sql.PreparedStatement p1 = con.prepareStatement("select * from t_character");//// 获得结果集java.sql.ResultSet  r1 = p1.executeQuery();//// 输出表格out.print("<div id = 'div1'><table id = 't1'>");out.print("<tr><td>ID</td><td>code</td><td>name</td></tr><br />");while (r1.next()) {    String name = r1.getString("name");    String code = r1.getString("code");    int id = r1.getInt("ID");    out.print("<tr><td>"+id+"</td><td>"+code+"</td><td>"+name+"</td></tr><br />");}out.print("</table></div>");//// 关闭搜索操作p1.close();//// 关闭连接con.close();%><h1>hello,jsp!</h1></body><script type="text/javascript"></script></html>
阅读全文
0 0