代码如下：
//实体类代码
package Test;
public class UserInfo {
private int id;
private String name;
private int age;
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}
//数据库访问类代码
package Test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
public class UserDao {
public static ArrayList<UserInfo> getUsers(int pagesize, int pagenum) {
String sql = "select top " + pagesize + " * from userinfo"
+ " where id not in " + "(select top "
+ ((pagenum - 1) * pagesize) + " id from userinfo order by id)"
+ " order by id";
ArrayList<UserInfo> al = new ArrayList<UserInfo>();
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
Connection conn = null;
PreparedStatement pst = null;
ResultSet rs = null;
try {
conn = DriverManager.getConnection("jdbc:odbc:test");
pst = conn.prepareStatement(sql);
rs = pst.executeQuery();
while (rs.next()) {
UserInfo user = new UserInfo();
user.setId(rs.getInt("id"));
user.setName(rs.getString("name"));
user.setAge(rs.getInt("age"));
al.add(user);
}
} catch (SQLException e) {
// TODO 青年人网站提示自动生成 catch 块
e.printStackTrace();
} finally {
try {
if (rs != null)
rs.close();
if (pst != null)
pst.close();
if (conn != null)
conn.close();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
return al;
}
public static int getCount() {
String sql = "select count(*) from userinfo";
int count = 0;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
Connection conn = null;
PreparedStatement pst = null;
ResultSet rs = null;
try {
conn = DriverManager.getConnection("jdbc:odbc:test");
pst = conn.prepareStatement(sql);
rs = pst.executeQuery();
rs.next();
count = rs.getInt(1);
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
} finally {
try {
if (rs != null)
rs.close();
if (pst != null)
pst.close();
责任编辑：小草
