效果截图:
数据库表:
1. Student.java实体类:
自动生成get,set方法,带参构造方法。
package com.ltt.model;
public class Student {
public static final int PAGE_SIZE=3; //每页显示记录数
private String id; //学号
private String name; //姓名
private int grade; //年级
private String professional; //专业
private String gender; //性别
private String password; //密码
public Student() {
super();
// TODO Auto-generated constructor stub
}
......
}
2. StudentDaoImpl.java
具体实现的方法:
package com.ltt.dao.impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.ltt.model.Student;
import com.ltt.util.DataBase;
public class StudentDaoImpl{
// 分页显示信息
public List<Student> find(int page) {
List<Student> list = new ArrayList<Student>();
Connection con = DataBase.getConnection(); //连接数据库
PreparedStatement ps;
try {
ps = con.prepareStatement("select * from student limit ?,?");
ps.setInt(1, (page - 1) * Student.PAGE_SIZE); //设置参事
ps.setInt(2, Student.PAGE_SIZE);
ResultSet rs = ps.executeQuery();// 查询
while (rs.next()) {
Student student = new Student();
student.setId(rs.getString("id"));
student.setName(rs.getString("name"));
student.setGrade(rs.getInt("grade"));
student.setProfessional(rs.getString("professional"));
student.setGender(rs.getString("gender"));
list.add(student);
}
ps.close();
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
// 计算总页数
public int findCount() {
int count = 0;
Connection con = DataBase.getConnection();
String sql = "select count(*) from student";
try {
Statement stmt = con.createStatement()