java中mysql分页代码_分页技术具体代码及其实现效果(基于java连接mysql)

3.用户欢迎界面 Wel3.java

package com.tsinghua;

import javax.servlet.http.*;

import java.io.*;

import java.sql.*;

public class Wel3 extends HttpServlet {

public void doGet(HttpServletRequest req,HttpServletResponse res) {

//数据库

Connection con = null;

PreparedStatement ps = null;

ResultSet rs = null;

try {

//html格式

res.setContentType("text/html;charset=utf8");

//分页

int pageCount=0; //总共页数

int pageSize=3; //每页记录数

int rowCount=0; //总共记录数

int pageNow=1; //希望当前页数

//动态的接收pageNow

String sPageNow = req.getParameter("pageCur");

if(sPageNow!=null) {

pageNow = Integer.parseInt(sPageNow);

}

PrintWriter pw = res.getWriter();

//获取session属性

HttpSession hs = req.getSession(true);

String name = (String)hs.getAttribute("uname");

//session不存在

if(name==null) {

//跳转登陆页面,提醒用户未登录

res.sendRedirect("login3?info1=err1");

}

//session存在

//数据库连接

Class.forName("com.mysql.jdbc.Driver");

con = DriverManager.getConnection("jdbc:mysql://localhost:3306/db_user","root","");

ps = con.prepareStatement("select count(*) from users");

rs = ps.executeQuery();

if(rs.next()) {

rowCount = rs.getInt(1);

}

ps = con.prepareStatement("select * from users limit ?,?");

//给?赋值

ps.setInt(1,(pageNow-1)*pageSize);

ps.setInt(2,pageSize);

rs=ps.executeQuery(); //欢迎用户(用户名)

pw.println("Welcome your coming,"+name+"
");

//图片

pw.println("");

//输出分页后users表中信息

pw.println("

pw.println("

");

pw.println("

userid");

pw.println("

username");

pw.println("

passwd");

pw.println("

email");

pw.println("

priority");

pw.println("

");

while(rs.next()) {

pw.println("

");

pw.println("

"+rs.getInt(1)+"");

pw.println("

"+rs.getString(2)+"");

pw.println("

"+rs.getString(3)+"");

pw.println("

"+rs.getString(4)+"");

pw.println("

"+rs.getInt(5)+"");

pw.println("

");

}

pw.println("

");

//计算pageCount

if(rowCount % pageSize == 0) {

pageCount = rowCount / pageSize;

}else {

pageCount = rowCount / pageSize + 1;

}

//上一页

if(pageNow!=1) {

pw.println("上一页");

}

//页数链接

for(int i=pageNow;i

//想要显示的当前页

pw.println(""+i+"");

}

//下一页

if(pageNow!=pageCount) {

pw.println("下一页");

}

}catch(Exception ex) {

ex.printStackTrace();

}finally {

try {

if(rs!=null) {

rs.close();

}

if(ps!=null) {

ps.close();

}

if(con!=null) {

con.close();

}

}catch(Exception ex) {

ex.printStackTrace();

}

}

}

public void doPost(HttpServletRequest req,HttpServletResponse res) {

this.doGet(req,res);

}

}