JSP 连接池技术实现分页(源码贴出来了)

最新推荐文章于 2024-04-26 20:19:53 发布

置顶 zihan11201120

最新推荐文章于 2024-04-26 20:19:53 发布

阅读量497

点赞数 1

文章标签： jsp 数据库 sqlserver border jdbc microsoft

本文链接：https://blog.csdn.net/zihan11201120/article/details/7429314

版权

在工作目录下META-INF中创建一个context.xml,其代码如下：

<Resource

name="jdbc/zihan" //随便自己的命名

type="javax.sql.DataSource"

password="yd"

driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"

maxIdle="2"

maxWait="5000"

username="sa"

url="jdbc:microsoft:sqlserver://localhost;DatabaseName=news"

maxActive="10"/>

</Context>

在这里配置移植性强。

二、

然后创建JDBC.java文件，其代码如下：

package com.mwq.database;

import java.sql.CallableStatement;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import javax.naming.Context;

import javax.naming.InitialContext;

import javax.naming.NamingException;

import javax.sql.DataSource;

/**

* @author mwq

public class JDBC {

protected Connection conn;

protected Statement stmt;

protected PreparedStatement prpdStmt;

protected CallableStatement cablStmt;

protected ResultSet rs;

static DataSource ds;

static {

try {

Context initCtx=new InitialContext();

ds=(DataSource)initCtx.lookup("java:comp/env/jdbc/zihan");

} catch (NamingException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

public boolean openConn(boolean autoCommit) {

boolean isOpen = true;

try {

conn = ds.getConnection();

if (!autoCommit)

conn.setAutoCommit(false);

} catch (SQLException e) {

isOpen = false;

System.out.println("------ 在创建数据库连接时抛出异常，内容如下：");

e.printStackTrace();

}

return isOpen;

}

public boolean closeConn() {

boolean isCommit = true;

try {

conn.commit();

} catch (SQLException e) {

isCommit = false;

System.out.println("------ 在提交数据库事务时抛出异常，内容如下：");

e.printStackTrace();

try {

conn.rollback();

} catch (SQLException e1) {

System.out.println("------ 在回滚数据库事务时抛出异常，内容如下：");

e1.printStackTrace();

}

} finally {

try {

conn.close();

} catch (SQLException e) {

System.out.println("------ 在关闭数据库连接时抛出异常，内容如下：");

e.printStackTrace();

}

return isCommit;

}

三、创建存放数据的OperateTb.java文件

package com.mwq.database;

import java.util.ArrayList;

import java.util.List;

public class OperateTb extends JDBC {

public List<Object[]> selectBySQL(String sql) {

List<Object[]> notes = new ArrayList<Object[]>();

this.openConn(true);

try {

this.stmt = conn.createStatement();

this.rs = this.stmt.executeQuery(sql); // 通过父类的属性操作数据库

int l = rs.getMetaData().getColumnCount(); // 获得数据表的列数

while (rs.next()) { // 通过循环将记录保存到List中

Object[] note = new Object[l];

for (int i = 0; i < l; i++) {

note[i] = rs.getObject(i + 1);

}

notes.add(note);

}

this.rs.close();

this.stmt.close();

} catch (Exception e) {

System.out.println("------ 在检索记录时抛出异常，内容如下：");

e.printStackTrace();

}

this.closeConn(); // 调用父类的关闭数据库连接的方法

return notes;

}

分页的Pagination.java文件

package com.mwq.tool;

import java.util.ArrayList;

import java.util.List;

/**

* @作者紫寒11202010-05-23

public class Pagination {

private int currentPage; // 当前页

private int totalPages; // 总页数

private int pageRows; // 每页记录数

private int totalRows; // 总记录数

private int pageStartRow; // 每页开始记录

private int pageEndRow; // 每页结束记录

private boolean hasPreviousPage;// 是否有上一页

private boolean hasNextPage; // 是否有下一页

private List<Object[]> totalList; // 要分页的数据

public Pagination() {

}

// 初始化分页信息

public void initPageBean(List<Object[]> totalList, int pageRows) {

this.totalList = totalList;

this.pageRows = pageRows;

this.totalRows = totalList.size();

this.currentPage = 1;

// 计算总页数

if ((totalRows % pageRows) == 0) {

totalPages = totalRows / pageRows;

if (this.totalRows == 0)

this.totalPages = 1;

} else {

totalPages = totalRows / pageRows + 1;

}

// 默认无上一页

this.hasPreviousPage = false;

// 判断是否有下一页

if (currentPage == totalPages) {

hasNextPage = false;

} else {

hasNextPage = true;

}

// 默认第一页开始的记录数为1

this.pageStartRow = 1;

// 确定第一页结束的记录数

if (totalRows < pageRows) {

this.pageEndRow = totalRows;

} else {

this.pageEndRow = pageRows;

}

// 获得当前页信息

public List<Object[]> getCurrentPageList() {

if (currentPage * pageRows < totalRows) {

pageEndRow = currentPage * pageRows;

pageStartRow = pageEndRow - pageRows;

} else {

pageEndRow = totalRows;

pageStartRow = pageRows * (totalPages - 1);

}

List<Object[]> pageList = new ArrayList<Object[]>(pageEndRow

- pageStartRow + 1);

if (totalRows != 0) {

for (int i = pageStartRow; i < pageEndRow; i++) {

pageList.add(totalList.get(i));

}

return pageList;

}

// 获得上一页信息

public List<Object[]> getPreviousPageList() {

currentPage = currentPage - 1;

if (currentPage < 1)

currentPage = 1;

if (currentPage >= totalPages) {

hasNextPage = false;

} else {

hasNextPage = true;

}

if ((currentPage - 1) > 0) {

hasPreviousPage = true;

} else {

hasPreviousPage = false;

}

List<Object[]> pageList = this.getCurrentPageList();

return pageList;

}

// 获得下一页信息

public List<Object[]> getNextPageList() {

currentPage = currentPage + 1;

if (currentPage > totalPages)

currentPage = totalPages;

if ((currentPage - 1) > 0) {

hasPreviousPage = true;

} else {

hasPreviousPage = false;

}

if (currentPage >= totalPages) {

hasNextPage = false;

} else {

hasNextPage = true;

}

List<Object[]> pageList = this.getCurrentPageList();

return pageList;

}

// 获得指定页信息

public List<Object[]> getAppointPageList(int currentPage) {

this.currentPage = currentPage;

if (currentPage > this.totalPages)

this.currentPage = this.totalPages;

if (currentPage < 1)

this.currentPage = 1;

if (this.currentPage > 1) {

this.hasPreviousPage = true;

} else {

this.hasPreviousPage = false;

}

if (this.currentPage < this.totalPages) {

this.hasNextPage = true;

} else {

this.hasNextPage = false;

}

List<Object[]> pageList = this.getCurrentPageList();

return pageList;

}

// 返回当前页

public int getCurrentPage() {

return currentPage;

}

// 返回每页记录数

public int getPageRows() {

return pageRows;

}

// 返回当前页开始记录

public int getPageStartRow() {

return pageStartRow;

}

// 返回当前页结束记录

public int getPageEndRow() {

return pageEndRow;

}

// 返回总页数

public int getTotalPages() {

return totalPages;

}

// 返回总记录数

public int getTotalRows() {

return totalRows;

}

// 返回是否有上一页

public boolean isHasPreviousPage() {

return hasPreviousPage;

}

// 返回是否有下一页

public boolean isHasNextPage() {

return hasNextPage;

}

实现分页的index.jsp文件

<%@ page language="java" import="java.util.*" pageEncoding="GB2312"%>

<jsp:useBean id="optb" class="com.mwq.database.OperateTb" scope="page"/>

<jsp:useBean id="pagination" class="com.mwq.tool.Pagination" scope="session"/>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<title>利用数据分页Bean对ResultSet结果集进行分页</title>

</head>

<!--

function checkPage(formName){

if (formName.requestPage.value==""){

alert("请填写欲跳转页码！");

formName.requestPage.focus();

return false;

}

if (isNaN(formName.requestPage.value)){

alert("欲跳转页码必须为数值！");

formName.requestPage.value="";

formName.requestPage.focus();

return false;

}

//-->

</script>

<tr>

</tr>

<tr>

<tr>

</tr>

<tr>

<td align="center"><font size="2"><b>利用数据分页Bean对ResultSet结果集进行分页</b></font></td>

</tr>

<tr>

</tr>

List<Object[]> pageList=null;

if(request.getParameter("requestPage")==null){

List<Object[]> totalList=optb.selectBySQL("select * from news");

pagination.initPageBean(totalList,5);

pageList=pagination.getCurrentPageList();

}else{

String requestPage=request.getParameter("requestPage");

if(requestPage.equals("previousPage")){

pageList=pagination.getPreviousPageList();

}elseif(requestPage.equals("nextPage")){

pageList=pagination.getNextPageList();

}

else{

int appointPage=Integer.valueOf(requestPage);

pageList=pagination.getAppointPageList(appointPage);

}

<tr>

<td>NewsID</td>

<td>Title</td>

<td>shijain</td>

</tr>

for(int m=0;m<pageList.size();m++){

if((m+1)%2==0)

out.println("<tr align=center bgcolor=#E6E6E6 >");

else

out.println("<tr align=center bgcolor=white>");

Object[] note=pageList.get(m);

out.println("<td>"+note[0]+"</td>");

out.println("<td>"+note[1]+"</td>");

out.println("<td>"+note[2]+"</td>");

out.println("<td>"+note[3]+"</td>");

out.println("<td>"+note[4]+"</td>");

out.println("<td>"+note[5]+"</td>");

out.println("<td align='left'>"+note[6]+"</td>");

</tr>

}

</table>

<tralign="right">

<td>共有<font color="red" size="1"> <%=pagination.getTotalRows() %> </font>条记录，

当前是第<font color="red" size="1"> <%=pagination.getCurrentPage()+"/"+pagination.getTotalPages() %> </font>页 

<%if(pagination.isHasPreviousPage())out.print("<a href='index.jsp?requestPage=previousPage'>上一页</a> "); %>

<%if(pagination.isHasNextPage())out.print(" <a href='index.jsp?requestPage=nextPage'>下一页</a> "); %> 

第<input type="text" name="requestPage" size="3" maxlength="2">页  

</tr>

</form>

</td>

</tr>

<tr>

</tr>

</table></td>

</tr>

</table>

</body>

</html>

zihan11201120

关注

1
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
JSP 连接池技术实现分页(源码贴出来了)

在工作目录下META-INF中创建一个context.xml,其代码如下：Context> Resourcename="jdbc/zihan" //随便自己的命名type="javax.sql.DataSource"password="yd"driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDrive
复制链接

扫一扫