一 分页操作的分析:
1.层的问题
Com.csdn.domaim
Com.csdn.dao
Com.csdn.daoImpl
Com.csdn.service 接口
Com.csdn.serviceImpl 实现类
Com.csdn.web 控制器
Com.csdn.web.filter
Com.csdn.web.listener
Com.csdn.util
2.如何实现的问题
StuentBean中定义了几个私有的属性: id name age address
StudentDao接口用于实现对数据库中属性的封装。
StudntService接口:定义方法,用数据库处理的方法
StudentServicImpl实现类
ControllerService:控制器:接收客户端的请求
List.jsp 显示所有的信息
3.分页显示:
首先先检查是否与数据库连接,可以先把所有的都输出。
然后要点击浏览器中的超链接来获取从数据库中读取的数据并显示,在超链接的时候要传参数,通过对servlet层的访问,在servlet层中对从数据库中的数据进行读取之后,通过判断再把参数传给浏览器并显示从数据库中调用的数据
二 代码的实现和说明
1.首先创建数据库,如图:
并从数据库中插入数据
2.在java中把数据库中的数据封装成类 StudentBean.java
public class StudentBean {
private int id;
private String name;
private int age;
private String address;
public StudentBean() {
super();
// TODO Auto-generated constructor stub
}
public StudentBean(int id, String name, int age, String address) {
super();
this.id = id;
this.name = name;
this.age = age;
this.address = address;
}
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;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
@Override
public String toString() {
return "StudentBean [address=" + address + ", age=" + age + ", id="
+ id + ", name=" + name + "]";
}
}
3.创建实现对数据库数据的查找和分页的查找,首先先创建一个dao层,并在dao层写上一个接口和一个daoImpl两个java类,接口是为了在service层中与servetl成的连接,首先创建StudentDao.java
import java.util.List;
import com.hbsi.domain.StudentBean;
public interface StudentDao {
//返回所有记录行
public List<StudentBean> findAll();
//返回指定页中显示的记录行(一共有多少页,共多长)
public List<StudentBean> listPage(int currentPage,int pageSize);
//返回所有记录的行数
public int getSize();
}
再创建实现类 StudentDaoImpl.java
package com.hbsi.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.LinkedList;
import java.util.List;
import com.hbsi.domain.StudentBean;
//接口的实现类
public class StudentDaoImpl implements StudentDao {
//声明操作的数据库对象
private static Connection conn;
private PreparedStatement pstmt;
private ResultSet rs;
//第一步:准备驱动程序,构造到项目路径中
private static final String URL="jdbc:mysql://localhost:3306/demo?user=root&password=qiao&useUnicode=true&characterEncoding=utf8";
static{
try {
//第二步:加载驱动程序
Class.forName("com.mysql.jdbc.Driver");
//第三步:获取连接对象
conn = DriverManager.getConnection(URL);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private int size;//记录多少行
public List<StudentBean> findAll() {
//存放读取的数据
List<StudentBean> list = new LinkedList<StudentBean>();
try {
pstmt = conn.prepareStatement("select * from student");
rs = pstmt.executeQuery();
//从结果集中读取
while(rs.next()){
StudentBean s = new StudentBean();
s.setId(rs.getInt(1));
s.setName(rs.getString(2));
s.setAge(rs.getInt(3));
s.setAddress(rs.getString(4));
list.add(s);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
size=list.size();
return list;
}
//获取总的记录行数
public int getSize() {
// TODO Auto-generated method stub
findAll();
return size;
}
//截取的读取
public List<StudentBean> listPage(int currentPage, int pageSize) {
//存放读取的数据
List<StudentBean> list = new LinkedList<StudentBean>();
try {
//记录行
int recordIndex=(currentPage-1)*pageSize;
pstmt = conn.prepareStatement("select * from student limit ?,?");
int index =1;
pstmt.setInt(index++, recordIndex);
pstmt.setInt(index++, pageSize);
//从结果集中读
rs = pstmt.executeQuery();
while(rs.next()){
StudentBean s = new StudentBean();
s.setId(rs.getInt(1));
s.setName(rs.getString(2));
s.setAge(rs.getInt(3));
s.setAddress(rs.getString(4));
list.add(s);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
}
4.service层是业务层,是是和其他接口的层
首先创建StudentService.java
package com.hbsi.service;
import java.util.List;
import com.hbsi.domain.StudentBean;
public interface StudentService {
public List<StudentBean> findAll();
public List<StudentBean> listPage(int currentPage,int pageSzie);
//得到所有的记录行
public int getSize();
}
再创建StudentserviceImpl.java
package com.hbsi.service;
import java.util.List;
import com.hbsi.dao.StudentDaoImpl;
import com.hbsi.domain.StudentBean;
public class StudentServceImpl implements StudentService {
StudentDaoImpl dao = new StudentDaoImpl();
public List<StudentBean> findAll() {
// TODO Auto-generated method stub
return dao.findAll();
}
public List<StudentBean> listPage(int currentPage, int pageSize) {
// TODO Auto-generated method stub
return dao.listPage(currentPage, pageSize);
}
public int getSize() {
// TODO Auto-generated method stub
return dao.getSize();
}
}
5.jsp页面的实现 list.jsp
<%@ page language="java" import="java.util.*,com.hbsi.domain.*"
pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'list.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<!-- 读取集合中 的数据 -->
<%
List<StudentBean> list = (List<StudentBean>) request.getAttribute("list");
int pageNo = Integer.parseInt(request.getParameter("pageNo"));
%>
<h3>
学生信息表
</h3>
<!-- 读取 -->
<table>
<%
for (int i = 0; i < list.size(); i++) {
%>
<tr>
<td><%=list.get(i).getId() %></td>
<td><%=list.get(i).getName() %></td>
<td><%=list.get(i).getAge()%></td>
<td><%=list.get(i).getAddress() %></td>
</tr>
<%
}
%>
</table><br/>
<a href="listStudent?pageNo=1">第一页</a> <a href="listStudent?pageNo=<%=pageNo-1 %>">上一页</a> <a href="listStudent?pageNo=<%=pageNo+1 %>">下一页</a> <a href="">最后页</a>
</body>
</html>
6.servlet层的实现 ControllerServlet.java
package com.hbsi.web;
import java.io.IOException;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.hbsi.domain.StudentBean;
import com.hbsi.service.StudentServceImpl;
public class ControllerServlet extends HttpServlet {
/**
*
*/
private static final long serialVersionUID = 1L;
public ControllerServlet() {
super();
}
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// 通过服务层得到数据
StudentServceImpl service = new StudentServceImpl();
// List<StudentBean> list = service.findAll();
// 分页的操作
// 计算一下一共有多少页
int total = service.getSize();// 一共有多少行记录
int pageSize = 3;// 每页显示的记录行数
int totalPages = total / pageSize;//共有多少个页面显示
totalPages = (total % pageSize == 0) ? totalPages : totalPages + 1;// 总共有total页
//显示的页数
int currentPage = 1;
if (request.getParameter("pageNo") != null) {
currentPage = Integer.parseInt(request.getParameter("pageNo"));
}
if (currentPage < 1) {
currentPage = 1;
}
if(currentPage>totalPages){
currentPage=totalPages;
}
List<StudentBean> list =service.listPage(currentPage, pageSize);
// servlt和jsp的桥梁,设置作用域的范围
request.setAttribute("list", list);
// 通过jsp页面显示所有的数据,请求的转向
RequestDispatcher rd = request.getRequestDispatcher("list.jsp?pageNo="+currentPage);
rd.forward(request, response);
}
public void init() throws ServletException {
// Put your code here
}
}