下面是用MV模式做的一個簡單的登錄后實(shí)現(xiàn)分頁顯示數(shù)據(jù)信息的頁面，后面會用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;
//得到應(yīng)顯示的頁碼數(shù)
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;
}
//驗(yàn)證用戶登錄
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;
}
// 關(guān)閉連接釋放資源
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();
}
}
}
}
}