JavaBean+servlet+jsp真分页.docVIP

JavaBean+Servlet+jsp真分页实现 (2010-06-10 23:50:11) 转载 标签： 分类： JavaBean package Bean;//物品类public class Goods{?private int goodsid; ?// 物品编号?public String goodsname;? ?// 物品名称?private float price;?????? ?// 物品单件 ?public void setGoodsid(int goodsid)?{??this.goodsid = goodsid;?}?public int getGoodsid()?{??return goodsid;?}?// 物品名称?public void setGoodsname(String goodsname)?{??this.goodsname = goodsname;?}?public String getGoodsname()?{??return goodsname;?}?// 物品价格?public void setPrice(float price)?{??this.price = price;?}?public float getPrice()?{??return price;?}} 单例类 package util; import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException; public class DbConnection {?private static Connection conn=null;?private String driver=com.mysql.jdbc.Driver;?private String url=jdbc:mysql://localhost:3306/mydata;?private String user=root;?private String password=1234567;??private DbConnection(){??try {???Class.forName(driver);???conn=DriverManager.getConnection(url, user, password);??} catch (ClassNotFoundException e) {???e.printStackTrace();??} catch (SQLException e) {???e.printStackTrace();??}?}??public static Connection getConnection() {??if(conn==null){???new DbConnection();??}??return conn;?}} 数据库访问实现 package DAO; import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.ArrayList; import Bean.Goods; import util.DbConnection; public class Dao {?private static Connection conn;?private static ResultSet rs;?private static Statement stmt;?private static int pagesize=5;?static{??conn=DbConnection.getConnection();?}??//通用的查询方法?public static ResultSet ExecuteQuery(String sql) {??try {???stmt=conn.createStatement();???rs=stmt.executeQuery(sql);??} catch (SQLException e) {???e.printStackTrace();??}??return rs;?}??//分页逻辑?public static ArrayListGoods getGoodsList(int currentpageno){??ArrayListGoods GoodsList