package dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import model.Cart; import model.Product; import db.DBManager; public class ProductDAO { //���typeID�ҵ�������Ʒ public List<Product> getProductByTypeId(int typeID){ Connection conn = DBManager.getConn(); PreparedStatement pstmt = null; String sql = null; List<Product> product = new ArrayList<Product>(); try { try { sql = "select * from product where typeID=?"; pstmt = conn.prepareStatement(sql); pstmt.setInt(1, typeID); ResultSet rs = pstmt.executeQuery(); while(rs.next()) { Product p=new Product(); p.setProductID(rs.getInt("productID")); p.setProductname(rs.getString("productname")); p.setPrice(rs.getFloat("price")); p.setDiscribe(rs.getString("discribe")); p.setImage(rs.getString("Image")); p.setTypeID(rs.getInt("typeID")); p.setDiscribe2(rs.getString("discribe2")); p.setColor(rs.getString("Color")); p.setNum(rs.getInt("num")); p.setEdition(rs.getString("edition")); product.add(p); } }finally { conn.close(); } } catch (Exception e) { e.printStackTrace(); } return product; } //���productID�ҵ�����Ʒ public List<Product> getProductByproductID(int productID){ Connection conn = DBManager.getConn(); PreparedStatement pstmt = null; String sql = null; List<Product> product = new ArrayList<Product>(); try { try { sql = "select * from product where productID=?"; pstmt = conn.prepareStatement(sql); pstmt.setInt(1, productID); ResultSet rs = pstmt.executeQuery(); while(rs.next()) { Product p=new Product(); p.setProductID(rs.getInt("productID")); p.setProductname(rs.getString("productname")); p.setPrice(rs.getFloat("price")); p.setDiscribe(rs.getString("discribe")); p.setImage(rs.getString("Image")); p.setTypeID(rs.getInt("typeID")); p.setDiscribe2(rs.getString("discribe2")); p.setColor(rs.getString("Color")); p.setNum(rs.getInt("num")); p.setEdition(rs.getString("edition")); product.add(p); } }finally { conn.close(); } } catch (Exception e) { e.printStackTrace(); } return product; } //���productname�ҵ�����Ʒ public List<Product> getProductByproductname(String searchname){ Connection conn = DBManager.getConn(); PreparedStatement pstmt = null; String sql = null; List<Product> product = new ArrayList<Product>(); try { try { sql = "select * from product where productname=?"; pstmt = conn.prepareStatement(sql); pstmt.setString(1, searchname); ResultSet rs = pstmt.executeQuery(); while(rs.next()) { Product p=new Product(); p.setProductID(rs.getInt("productID")); p.setProductname(rs.getString("productname")); p.setPrice(rs.getFloat("price")); p.setDiscribe(rs.getString("discribe")); p.setImage(rs.getString("Image")); p.setTypeID(rs.getInt("typeID")); p.setDiscribe2(rs.getString("discribe2")); p.setColor(rs.getString("Color")); p.setNum(rs.getInt("num")); p.setEdition(rs.getString("edition")); product.add(p); } }finally { conn.close(); } } catch (Exception e) { e.printStackTrace(); } return product; } // /** // * ��ѯ��ݿ��в������ ����1����ʼλ�ã���0��ʼ ����2��������¼ // */ public List<Product> getPageList (int begin, int count){ Connection conn = DBManager.getConn(); PreparedStatement pstmt = null; List<Product> products = new ArrayList<Product>(); String sql = "select * from product limit ?,?"; try { pstmt = conn.prepareStatement(sql); pstmt.setInt(1, begin); pstmt.setInt(2, count); ResultSet rs = pstmt.executeQuery(); while(rs.next()) { Product p=new Product(); p.setProductID(rs.getInt("productID")); p.setProductname(rs.getString("productname")); p.setPrice(rs.getFloat("price")); p.setDiscribe(rs.getString("discribe")); p.setImage(rs.getString("Image")); p.setTypeID(rs.getInt("typeID")); p.setDiscribe2(rs.getString("discribe2")); p.setColor(rs.getString("Color")); p.setNum(rs.getInt("num")); p.setEdition(rs.getString("edition")); products.add(p); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return products; } // /** // * ��ѯ���еļ�¼���� // */ public int getSum(){ int count = 0 ; PreparedStatement pstmt = null; String sql = "select count(*) from product"; Connection conn = DBManager.getConn(); try { pstmt = conn.prepareStatement(sql); ResultSet rs = pstmt.executeQuery(); while(rs.next()) { count = rs.getInt(1); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return count; } // /** // * ����2/��ѯ���� // */ public List<Product> getAllProducts() { List<Product> products = new ArrayList<Product>(); PreparedStatement pstmt = null; String sql = "select * from product"; Connection conn = DBManager.getConn(); try { pstmt = conn.prepareStatement(sql); ResultSet rs = pstmt.executeQuery(); while(rs.next()) { Product p=new Product(); p.setProductID(rs.getInt("productID")); p.setProductname(rs.getString("productname")); p.setPrice(rs.getFloat("price")); p.setDiscribe(rs.getString("discribe")); p.setImage(rs.getString("Image")); p.setTypeID(rs.getInt("typeID")); p.setDiscribe2(rs.getString("discribe2")); p.setColor(rs.getString("Color")); p.setNum(rs.getInt("num")); p.setEdition(rs.getString("edition")); products.add(p); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return products; } }

微信网友_7294439741132800 LV1
2024年12月18日
krispeng LV13
2024年10月28日
www的行为 LV2
2024年6月20日
sdfddd LV4
2024年5月16日
abandan LV4
2023年11月6日
微信网友_6699076084797440 LV7
2023年11月2日
微信网友_6680567232876544 LV8
2023年10月10日
zhuorui LV3
2023年10月7日
936684178 LV2
2023年6月26日
768881787 LV7
2023年6月26日