企业招聘网站，JSP实现代码

/** * */ package s2jsp.bysj.dao; import java.sql.SQLException; import java.util.ArrayList; import s2jsp.bysj.entity.Product; /** * @author Administrator * */ public class ProductDAO extends BaseDAO { /** * 增加的方法 * * @throws SQLException * @throws ClassNotFoundException */ public int add(Product product) { int id = 0; try { getConn(); String sql = "insert into Product values('" + product.getSerialNumber() + "','" + product.getProductName() + "','" + product.getBrand() + "','" + product.getModel() + "','" + product.getPrice() + "','" + product.getPicture() + "','" + product.getDecription() + "')"; String str = "select @@identity from Product"; conn = getConn(); stm = conn.createStatement(); stm.executeUpdate(sql); rs=stm.executeQuery(str); while (rs.next()) { id = rs.getInt(1); } } catch (ClassNotFoundException e) { // TODO Auto-generated catch block logger.debug(e.getMessage()); } catch (SQLException e) { // TODO Auto-generated catch block logger.debug(e.getMessage()); } finally { closeAll(); } return id; } /** * 删除方法 */ public int Delete(int productID) { int num=0; try { String sql = "delete from Product where productId=" + productID; conn = getConn(); stm = conn.createStatement(); num=stm.executeUpdate(sql); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block logger.debug(e.getMessage()); } catch (SQLException e) { // TODO Auto-generated catch block logger.debug(e.getMessage()); } finally { closeAll(); } return num; } /** * 改方法 */ public int Update(Product product) { int num = 0; try { String sql = String .format( "update Product set serialNumber='%s',productName='%s',brand='%s',model='%s',price='%s',picture='%s',description='%s' where productId=%d", product.getSerialNumber(), product.getProductName(), product.getBrand(), product.getModel(), product.getPrice(), product .getPicture(), product.getDecription(),product.getProductID()); conn = getConn(); stm = conn.createStatement(); num=stm.executeUpdate(sql); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block logger.debug(e.getMessage()); } catch (SQLException e) { // TODO Auto-generated catch block logger.debug(e.getMessage()); } finally { closeAll(); } return num; } /** * 查询方法 */ public ArrayList<Product> query(int num) { ArrayList<Product> lst = new ArrayList<Product>(); try { String sql = String.format("select top 5 * from Product where productid not in(select top %d productid from Product ) ", 5 * (num - 1)); conn = getConn(); stm = conn.createStatement(); rs = stm.executeQuery(sql); while (rs.next()) { Product product = new Product(); product.setProductID(rs.getInt(1)); product.setSerialNumber(rs.getString(2)); product.setProductName(rs.getString(3)); product.setBrand(rs.getString(4)); product.setModel(rs.getString(5)); product.setPrice(rs.getDouble(6)); product.setPicture(rs.getString(7)); product.setDecription(rs.getString(8)); lst.add(product); } } catch (ClassNotFoundException e) { // TODO Auto-generated catch block logger.debug(e.getMessage()); } catch (SQLException e) { // TODO Auto-generated catch block logger.debug(e.getMessage()); } finally { closeAll(); } return lst; } /** * 查询方法 */ public ArrayList<Product> queryAllProduct(int num) { ArrayList<Product> lst = new ArrayList<Product>(); try { String sql = String.format("select top 15 * from Product where productid not in(select top %d productid from Product ) ", 15 * (num - 1)); conn = getConn(); stm = conn.createStatement(); rs = stm.executeQuery(sql); while (rs.next()) { Product product = new Product(); product.setProductID(rs.getInt(1)); product.setSerialNumber(rs.getString(2)); product.setProductName(rs.getString(3)); product.setBrand(rs.getString(4)); product.setModel(rs.getString(5)); product.setPrice(rs.getDouble(6)); product.setPicture(rs.getString(7)); product.setDecription(rs.getString(8)); lst.add(product); } } catch (ClassNotFoundException e) { // TODO Auto-generated catch block logger.debug(e.getMessage()); } catch (SQLException e) { // TODO Auto-generated catch block logger.debug(e.getMessage()); } finally { closeAll(); } return lst; } public ArrayList<Product> queryAll(int num) { ArrayList<Product> lst = new ArrayList<Product>(); try { String sql = String.format("select top 10 * from Product where productid not in(select top %d productid from Product ) ", 10 * (num - 1)); conn = getConn(); stm = conn.createStatement(); rs = stm.executeQuery(sql); while (rs.next()) { Product product = new Product(); product.setProductID(rs.getInt(1)); product.setSerialNumber(rs.getString(2)); product.setProductName(rs.getString(3)); product.setBrand(rs.getString(4)); product.setModel(rs.getString(5)); product.setPrice(rs.getDouble(6)); product.setPicture(rs.getString(7)); product.setDecription(rs.getString(8)); lst.add(product); } } catch (ClassNotFoundException e) { // TODO Auto-generated catch block logger.debug(e.getMessage()); } catch (SQLException e) { // TODO Auto-generated catch block logger.debug(e.getMessage()); } finally { closeAll(); } return lst; } /** * 根据ID来获取商品的详细信息 */ public Product findProductByID(int productID){ Product product=new Product(); try { String sql=String.format("select * from product where productID=%d", productID); conn=getConn(); stm=conn.createStatement(); rs=stm.executeQuery(sql); while(rs.next()){ product.setProductID(rs.getInt(1)); product.setSerialNumber(rs.getString("serialNumber")); product.setProductName(rs.getString("productName")); product.setBrand(rs.getString("brand")); product.setModel(rs.getString("model")); product.setPrice(rs.getDouble("price")); product.setPicture(rs.getString("picture")); product.setDecription(rs.getString("description")); } } catch (ClassNotFoundException e) { // TODO Auto-generated catch block logger.debug(e.getMessage()); } catch (SQLException e) { // TODO Auto-generated catch block logger.debug(e.getMessage()); }finally { closeAll(); } return product; } public int getCount() { String sql="select count(*) from product"; int count=0; try { conn=getConn(); stm=conn.createStatement(); rs=stm.executeQuery(sql); while(rs.next()) { count=rs.getInt(1); } } catch (ClassNotFoundException e) { logger.debug(e.getMessage()); } catch (SQLException e) { logger.debug(e.getMessage()); }finally{ closeAll(); } return count; } public ArrayList<Product> findAll() { ArrayList<Product> lst = new ArrayList<Product>(); try { String sql ="select top 8 * from Product "; conn = getConn(); stm = conn.createStatement(); rs = stm.executeQuery(sql); while (rs.next()) { Product product = new Product(); product.setProductID(rs.getInt(1)); product.setSerialNumber(rs.getString(2)); product.setProductName(rs.getString(3)); product.setBrand(rs.getString(4)); product.setModel(rs.getString(5)); product.setPrice(rs.getDouble(6)); product.setPicture(rs.getString(7)); product.setDecription(rs.getString(8)); lst.add(product); } } catch (ClassNotFoundException e) { // TODO Auto