自己写的jsp企业网站代码

package s2jsp.bysj.dao; import java.sql.*; import java.util.*; import s2jsp.bysj.entity.*; public class ProductDao extends BaseDao { private Connection conn = null; private PreparedStatement pstmt = null; private ResultSet rs = null; public static final int PAGE_NUM = 5; // taotao public List findAllProduct() { List list = new ArrayList(); String sql = "select * from Product"; try { conn = this.getConn(); pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while (rs.next()) { Product p = new Product(); p.setProductID(rs.getInt(1)); p.setSerialNumber(rs.getString(2)); p.setName(rs.getString(3)); p.setBrand(rs.getString(4)); p.setModel(rs.getString(5)); p.setPrice(rs.getDouble(6)); p.setPicture(rs.getString(7)); p.setDescription(rs.getString(8)); list.add(p); } } catch (SQLException e) { System.out.println("查询商品信息失败！"); e.printStackTrace(); } catch (ClassNotFoundException e) { e.printStackTrace(); } finally { this.closeAll(conn, pstmt, rs); } return list; } // taotao在页面中显示商品信息 public Product findProductByID(int productID) { Product p = new Product(); String sql = "select * from product where productID=?"; try { conn = this.getConn(); pstmt = conn.prepareStatement(sql); pstmt.setInt(1, productID); rs = pstmt.executeQuery(); while (rs.next()) { p.setProductID(rs.getInt(1)); p.setSerialNumber(rs.getString(2)); p.setName(rs.getString(3)); p.setBrand(rs.getString(4)); p.setModel(rs.getString(5)); p.setPrice(rs.getDouble(6)); p.setPicture(rs.getString(7)); p.setDescription(rs.getString(8)); } } catch (SQLException e) { System.out.println("查询商品详细信息失败！"); e.printStackTrace(); } catch (ClassNotFoundException e) { e.printStackTrace(); } finally { this.closeAll(conn, pstmt, rs); } return p; } // 分页的实现 public List findProductGroup(int page) { List list = new ArrayList(); int number = 0; if (page > 1) { number = PAGE_NUM * (page - 1); } String sql = "select top " + PAGE_NUM + " * from product where productid not in(select top " + number + " productid from product order by productid desc)order by productid desc"; try { conn = this.getConn(); pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while (rs.next()) { Product p = new Product(); p.setProductID(rs.getInt(1)); p.setSerialNumber(rs.getString(2)); p.setName(rs.getString(3)); p.setBrand(rs.getString(4)); p.setModel(rs.getString(5)); p.setPrice(rs.getDouble(6)); p.setPicture(rs.getString(7)); p.setDescription(rs.getString(8)); list.add(p); } } catch (SQLException e) { System.out.println("分页查询失败！"); e.printStackTrace(); } catch (ClassNotFoundException e) { e.printStackTrace(); } finally { this.closeAll(conn, pstmt, rs); } return list; } // longlong添加Product public int InsertProduct(Product product) { int result = 0; String sql = "insert into product (serialNumber,name,brand,model,price,picture,description) values(?,?,?,?,?,?,?)"; try { conn = this.getConn(); pstmt = conn.prepareStatement(sql); pstmt.setString(1, product.getSerialNumber()); pstmt.setString(2, product.getName()); pstmt.setString(3, product.getBrand()); pstmt.setString(4, product.getModel()); pstmt.setDouble(5, product.getPrice()); pstmt.setString(6, product.getPicture()); pstmt.setString(7, product.getDescription()); result = pstmt.executeUpdate(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { this.closeAll(conn, pstmt, rs); } return result; } // longlong查询Product public List selectProduct() { List list = new ArrayList(); String sql = "select * from product"; try { conn = this.getConn(); pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while (rs.next()) { Product p = new Product(); p.setProductID(rs.getInt(1)); p.setSerialNumber(rs.getString(2)); p.setName(rs.getString(3)); p.setBrand(rs.getString(4)); p.setModel(rs.getString(5)); p.setPrice(rs.getDouble(6)); p.setPicture(rs.getString(7)); p.setDescription(rs.getString(8)); list.add(p); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { this.closeAll(conn, pstmt, rs); } return list; } // longlong删除product public int deleteProduct(Product product) { int result = 0; String sql = "delete from product where productid=?"; try { conn = this.getConn(); pstmt = conn.prepareStatement(sql); pstmt.setInt(1, product.getProductID()); result = pstmt.executeUpdate(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { this.closeAll(conn, pstmt, rs); } return result; } // longlong通过productid查询procuct public Product selectProductById(int productid) { Product product = new Product(); String sql = "select * from product where productid=?"; try { conn = this.getConn(); pstmt = conn.prepareStatement(sql); pstmt.setInt(1, productid); rs = pstmt.executeQuery(); while (rs.next()) { product = new Product(); product.setProductID(productid); product.setSerialNumber(rs.getString(2)); product.setName(rs.getString(3)); product.setBrand(rs.getString(4)); product.setModel(rs.getString(5)); product.setPrice(rs.getDouble(6)); product.setPicture(rs.getString(7)); product.setDescription(rs.getString(8)); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { this.closeAll(conn, pstmt, rs); } return product; } // longlong修改product public int updateProduct(Product product) { int result = 0; String sql = "update product set name=?,brand=?,model=?,price=?,description=? where productid=?"; try { conn = this.getConn(); pstmt = conn.prepareStatement(sql); pstmt.setString(1, product.getName()); pstmt.setString(2, product.getBrand()); pstmt.setString(3, product.getModel()); pstmt.setDouble(4, product.getPrice()); pstmt.setString(5, product.getDescription()); pstmt.setInt(6, product.getProductID()); result = pstmt.executeUpdate(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { this.closeAll(conn, pstmt, rs); } return result; } }