我用jsp做了一个简单的表格(eclipse),用jdbc连接的mysql数据库,只实select功能即可,请各位大神帮忙做一个分页功能,不需要12345的分页,只要上页、下页就行,代码和页面截图我都会贴上来,急啊!
我的所有代码:(其中上下页按钮里写了href,可以忽略)
<%@page contentType="text/html;charset=GBK" import="java.sql.*"%><html><head><title>用户注册:使用JDBC处理用户提交数据</title><%try {Class.forName("com.mysql.jdbc.Driver").newInstance();Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb?user=root&password=&useUnicode=true&characterEncoding=GB2312");Statement stmt = con.createStatement();String query = "SELECT * FROM userinfo";// ResultSet rs = stmt.executeQuery(query);ResultSet rs = stmt.executeQuery(query);%><style type="text/css"><!--body,table{ font-size:12px;}table{ table-layout:fixed; empty-cells:show; border-collapse: collapse; margin:0 auto;}td{ height:25px; Text-align:center;}h1,h2,h3{ font-size:20px; margin:0; padding:0;}table.t1{ font-family: sans-serif; border:1px solid #cad9ea; color:#696969;}table.t1 th { background-image: url(bg_list_title.gif); background-repeat::repeat-x; height:24px;}table.t1 td,table.t1 th{ border:1px solid #cad9ea; padding:0 1em 0;}table.t1 tr.a1{ background-color:#DCDCDC;}#nav { list-style: none; display: inline; } #nav li { display: inline; margin-right: 100px; float: center; height: 50px; width: 30px; H4 { padding-top: 20px; padding-bottom: 5px; padding-left: 90px; padding-right: 0px } } #nav a { color: #666666; text-decoration: none; display: block; font-size: 15px; font-family: Geneva, Arial, Helvetica, sans-serif; border: 1 solid #999; width: 35px; height: 10px; line-height: 20px; text-align: center; background-image: url(bg_list_title.gif); background-repeat::repeat-x; height:24px; }</style></head><body><table width="60%" heigh="10%" id="mytab" border="0" class="t1"><tr><th width="10%">序号</th><th>部门名称</th><th>数据类型</th><th>数据量</th></tr><%while (rs.next()) {%><tr><td><%=rs.getString("number")%></td><td><%=rs.getString("name")%></td><td><%=rs.getString("type")%></td> <td><%=rs.getString("data")%></td></tr><%}%></table><br><ul id="nav"> <li><a href="#">上页</a></li> <li><a href="#">下页</a></li> </ul> <%rs.close();stmt.close();con.close();} catch (SQLException sqle) {out.println("sqle=" + sqle);} finally {}%></body></html>这是已经做好的页面截图
http://photo.renren.com/photo/229507399/photo-6297730132#/229507399/photo-6297730132
我的所有代码:(其中上下页按钮里写了href,可以忽略)
<%@page contentType="text/html;charset=GBK" import="java.sql.*"%><html><head><title>用户注册:使用JDBC处理用户提交数据</title><%try {Class.forName("com.mysql.jdbc.Driver").newInstance();Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb?user=root&password=&useUnicode=true&characterEncoding=GB2312");Statement stmt = con.createStatement();String query = "SELECT * FROM userinfo";// ResultSet rs = stmt.executeQuery(query);ResultSet rs = stmt.executeQuery(query);%><style type="text/css"><!--body,table{ font-size:12px;}table{ table-layout:fixed; empty-cells:show; border-collapse: collapse; margin:0 auto;}td{ height:25px; Text-align:center;}h1,h2,h3{ font-size:20px; margin:0; padding:0;}table.t1{ font-family: sans-serif; border:1px solid #cad9ea; color:#696969;}table.t1 th { background-image: url(bg_list_title.gif); background-repeat::repeat-x; height:24px;}table.t1 td,table.t1 th{ border:1px solid #cad9ea; padding:0 1em 0;}table.t1 tr.a1{ background-color:#DCDCDC;}#nav { list-style: none; display: inline; } #nav li { display: inline; margin-right: 100px; float: center; height: 50px; width: 30px; H4 { padding-top: 20px; padding-bottom: 5px; padding-left: 90px; padding-right: 0px } } #nav a { color: #666666; text-decoration: none; display: block; font-size: 15px; font-family: Geneva, Arial, Helvetica, sans-serif; border: 1 solid #999; width: 35px; height: 10px; line-height: 20px; text-align: center; background-image: url(bg_list_title.gif); background-repeat::repeat-x; height:24px; }</style></head><body><table width="60%" heigh="10%" id="mytab" border="0" class="t1"><tr><th width="10%">序号</th><th>部门名称</th><th>数据类型</th><th>数据量</th></tr><%while (rs.next()) {%><tr><td><%=rs.getString("number")%></td><td><%=rs.getString("name")%></td><td><%=rs.getString("type")%></td> <td><%=rs.getString("data")%></td></tr><%}%></table><br><ul id="nav"> <li><a href="#">上页</a></li> <li><a href="#">下页</a></li> </ul> <%rs.close();stmt.close();con.close();} catch (SQLException sqle) {out.println("sqle=" + sqle);} finally {}%></body></html>这是已经做好的页面截图
http://photo.renren.com/photo/229507399/photo-6297730132#/229507399/photo-6297730132
解决方案 »
- jsp连接Bean出错
- 帮帮忙!!!!急急急急急急急急~~~~~~~~谢谢!!!!!!!!!在线
- 要面试了,大家进来吧
- Servlet中连接Mysql出现的奇怪现象,请高手们指点。
- 如何知道客户端是通过哪一个URL访问本页面的?急!!!
- 学习用MyEclipse 2013开发SSH项目遇到java.lang.NullPointerException问题,请帮助
- javabean与map在使用上有何区别,使用javabean的优势是什么?
- JSP,小鳥提問!
- 向高手请教如何将一字符串从十进制轮换为十进制?
- 最简单的解决Jsp和Servlet中文问题的方法。
- 寻java语言的浏览器类
- 求教 关于 jdom生成xml问题
mssql的top一搜一大把。