struts实现数据库分页的代码及实现步骤.doc

Struts2.1实现数据分页 第一步：先建数据库 数据库中的数据： 第二步：先建立数据库的连接 数据库连接用的是数据库连接池 package org; import java.sql.Connection; import java.sql.ResultSet; import java.sql.Statement; import javax.naming.Context; import javax.naming.InitialContext; import javax.naming.NamingException; import javax.sql.DataSource; public class DbPool { private Connection conn; public void createConn()throws Exception { try { Context initContext = new InitialContext(); Context envContext = (Context)initContext.lookup(java:/comp/env); DataSource ds = (DataSource)envContext.lookup(jdbc/mysql); conn=ds.getConnection(); System.out.println(数据库连接成功); } catch (Exception e) { System.out.println(数据库连接失败); e.printStackTrace(); } } public Connection getConn() throws Exception{ if(conn==null){ createConn(); } return conn; } public ResultSet executeQuery(String sql) throws Exception{ ResultSet rs=null; if(conn==null){ createConn(); } try { Statement st=(Statement)this.conn.createStatement(); rs=st.executeQuery(sql); } catch (Exception e) { e.printStackTrace(); } return rs; } } 然后在下建一个context.xml用来读取配置信息 ?xml version=1.0 encoding=utf-8? Context Resource name=jdbc/mysql auth=Container type=javax.sql.DataSource driverClassName=com.mysql.jdbc.Driver url=jdbc:mysql://localhost/user1 username=root password=516146194 maxActive=50 maxIdle=20 maxWait=10000 / /Context 第三步：建web工程及文件部署 第四步：建立相应显示数据库分页显示的jsp页面 Show.jsp %@ page language=java import=java.util.* pageEncoding=gbk% %@ taglib uri=/struts-tags prefix=s% % 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% titleMy JSP show.jsp starting page/title meta http-equiv=pragma content=no-cache meta http-equiv=cache-control content=no-cache