链接数据库+分页
<%
//定义分页用变量
int pageSize=3;
int pageNow=1;//默认显示第一页
int rowCount=0;//从数据库中获得
int pageCount;//计算得到
//接收pageNow
String tmpPageNow=request.getParameter("pageNow");
if(tmpPageNow!=null)
{
//接收到pageNow
pageNow=Integer.parseInt(tmpPageNow);
}
//链接数据库,验证密码
//1.加载驱动
// 驱动程序名
String driver = "com.mysql.jdbc.Driver";
Class.forName(driver);
//2.得到链接
// URL指向要访问的数据库名world
String url = "jdbc:mysql://127.0.0.1:3306/user_manager";
Connection conn=DriverManager.getConnection(url,"root","123456");
//3.得到statement
Statement statement = conn.createStatement();
//4查询数据库
String sql="select count(*) from users";
ResultSet rs = statement.executeQuery(sql);
if(rs.next())
{
rowCount=rs.getInt(1);
}
if(rowCount%pageSize==0)
{
pageCount=rowCount/pageSize;
}
else
{
pageCount=rowCount/pageSize+1;
}
sql="select * from users limit "+(pageNow-1)*pageSize+","+pageSize;
rs=statement.executeQuery(sql);
%>
<table border="1px">
<tr><td>用户id</td><td>用户名</td><td>密码</td><td>电子邮件</td><td>级别</td></tr>
<%
while(rs.next())
{
%>
<tr>
<td><%=rs.getInt(1)%></td>
<td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getString(4)%></td>
<td><%=rs.getInt(5)%></td>
</tr>
<%
}
%>
</table>
<%
//上一页
if(pageNow>1)
{
out.println("<a href='welcome.jsp?pageNow="+(pageNow-1)+"'>["+"上一页"+"]</a>");
}
for(int i=0;i<pageCount;i++)
{
out.println("<a href='welcome.jsp?pageNow="+(i+1)+"'>["+(i+1)+"]</a>");
}
//下一页
if(pageNow<pageCount)
{
out.println("<a href='welcome.jsp?pageNow="+(pageNow+1)+"'>["+"下一页"+"]</a>");
}
%>