mysql分页查询数据库在jsp页面显示_JSP读取MySql数据库实现分页效果

下面是用MV模式做的一个简单的登录后实现分页显示数据信息的页面，后面会用MVC模式改写。

package com.ly.model;

import java.sql.*;

import java.util.ArrayList;

public class UserbeanCl {

private Statement st = null;

private ResultSet rs = null;

private Connection ct = null;

private int pageSize = 10;

private int rowCount = 0;

private int pageCount = 0;

//得到应显示的页码数

public int pageCount() {

try {

// 得到连接

ct = new connDB().getConn();

st=ct.createStatement();

rs = st.executeQuery("select count(*) from students");

//

if(rs.next()){

rowCount=rs.getInt(1);

}

if(rowCount%pageSize==0){

pageCount=rowCount/pageSize;

}else{

pageCount=rowCount/pageSize+1;

}

} catch (Exception e) {

e.printStackTrace();

} finally {

shutup();

}

return pageCount;

}

// 返回分页信息，用ArrayList对象存储

public ArrayList getUsersByPage(int PageNow) {

pageCount = pageCount();

ct = new connDB().getConn();

int startRow=(PageNow-1)*pageSize;

ArrayList al = new ArrayList();

try {

st = ct.createStatement();

rs=st.executeQuery("SELECT * FROM `students` LIMIT "+startRow+","+pageSize);

while(rs.next()){

Userbean ub=new Userbean();

ub.setId(rs.getInt(1));

ub.setName(rs.getString(2));

ub.setGrade(rs.getInt(3));

ub.setBatch(rs.getInt(4));

ub.setPassword(rs.getInt(5));

ub.setGxqm(rs.getString(6));

al.add(ub);

}

} catch (Exception e) {

e.printStackTrace();

} finally {

shutup();

}

return al;

}

//验证用户登录

public boolean checkUser(String u, String p) {

boolean b = false;

ct = new connDB().getConn();

try {

st = ct.createStatement();

ResultSet rs = st

.executeQuery("select password from students where name='"

+ u + "'");

if (rs.next()) {

// 说明用户名存在

if (rs.getString(1).equals(p)) {

// 密码正确

b = true;

} else {

return false;

}

}

} catch (Exception e) {

e.printStackTrace();

} finally {

shutup();

}

return b;

}

// 关闭连接释放资源

public void shutup() {

try {

if (rs != null)

rs.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} finally {

try {

if (st != null)

st.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} finally {

try {

if (ct != null)

ct.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

}

}