要在web页面显示分页后的学生信息,首先我们在navicat创建一个学生信息表 ,在这里我在表里插入了30 条数据
1,创建Student实体类
package com.lanou.entity;
public class Student {
private int studentId;
private String studentName;
private int studentAge;
private int studentSex;
public int getStudentId() {
return studentId;
}
public void setStudentId(int studentId) {
this.studentId = studentId;
}
public String getStudentName() {
return studentName;
}
public void setStudentName(String studentName) {
this.studentName = studentName;
}
public int getStudentAge() {
return studentAge;
}
public void setStudentAge(int studentAge) {
this.studentAge = studentAge;
}
public int getStudentSex() {
return studentSex;
}
public void setStudentSex(int studentSex) {
this.studentSex = studentSex;
}
}
2,创建StudentDao类(操作层),获取数据总条数
package com.lanou.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.lanou.entity.Student;
import com.lanou.util.DBConnUtil;
/**
* 根据页数查数据
*
* @return
*/
public