jsp+sql2005电子商务（手机网站）

package com.accp.s2.product; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import com.accp.s2.commons.DBUtil; /** * 数据库操作 * @author YangKe * */ public class ProductDAO { //按条件查询 public List<TelephoneInfo> qunByCo(TelephoneInfo acc){ List<TelephoneInfo> teaList = new ArrayList<TelephoneInfo>(); TelephoneInfo account = null; Connection conn = null; Statement stmt = null; PreparedStatement pstmt = null; ResultSet rs = null; try { conn = DBUtil.getConn(); String sql = "select * from TELEPHONE_INFO where 1=1 "; if(!"".equals(acc.getPhoneName())&& acc.getPhoneName()!=null){ sql += " and TELEPHONE_NAME like '%" + acc.getPhoneName()+"%'"; } if(!"".equals(acc.getPrice())&& acc.getPrice()!=null){ sql += " and TELEPHONE_PRICE = " + acc.getPrice(); } pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while( rs.next() ){ account = new TelephoneInfo(); account.setId(rs.getInt("TELEPHONE_ID")); account.setPhoneName(rs.getString("TELEPHONE_NAME")); account.setPhBrandId(rs.getInt("BRAND_ID")); account.setWaiGuan(rs.getString("WG_ID")); account.setSealtime(rs.getString("TELEPHONE_TIME")); account.setBigPic(rs.getString("TELEPHONE_IMG_MAX")); account.setSmallPic(rs.getString("TELEPHONE_IMG_MIN")); account.setWeight(rs.getString("TELEPHONE_WEIGHT")); account.setPrice(rs.getString("TELEPHONE_PRICE")); teaList.add(account); } } catch (Exception e) { e.printStackTrace(); }finally{ DBUtil.closeDB(rs, stmt, pstmt, conn); } return teaList; } //按ID查询 public AccountList qulById(int id){ AccountList account = null; Connection conn = null; Statement stmt = null; PreparedStatement pstmt = null; ResultSet rs = null; try { conn = DBUtil.getConn(); String sql = "select TELEPHONE_ID,TELEPHONE_NAME,BRAND_NAME,WG_TYPE,TELEPHONE_TIME,TELEPHONE_IMG_MAX,TELEPHONE_IMG_MIN,TELEPHONE_WEIGHT,TELEPHONE_SCREEN,TELEPHONE_V,TELEPHONE_DIRVE,TELEPHONE_PRICE,FUNCTION_TYPE from TELEPHONE_INFO as telephone " +" inner join BRAND_TYPE as brand on telephone.BRAND_ID = brand.BRAND_ID " +" inner join FUNCTION_TYPE as fun on telephone.FUNCTION_ID = fun.FUNCTION_ID " +" inner join TELEPHONE_WG as wg on telephone.WG_ID = wg.WG_ID where TELEPHONE_ID = "+id; pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); if( rs.next() ){ account = new AccountList(); account.getTelephone().setId(rs.getInt("TELEPHONE_ID")); account.getTelephone().setPhoneName(rs.getString("TELEPHONE_NAME")); account.getBrandType().setBRAND_NAME(rs.getString("BRAND_NAME")); account.getWaiGuan().setWaiGuan(rs.getString("WG_TYPE")); account.getTelephone().setSealtime(rs.getString("TELEPHONE_TIME")); account.getTelephone().setBigPic(rs.getString("TELEPHONE_IMG_MAX")); account.getTelephone().setSmallPic(rs.getString("TELEPHONE_IMG_MIN")); account.getTelephone().setWeight(rs.getString("TELEPHONE_WEIGHT")); account.getTelephone().setScreen(rs.getString("TELEPHONE_SCREEN")); account.getTelephone().setSize(rs.getString("TELEPHONE_V")); account.getTelephone().setDirve(rs.getString("TELEPHONE_DIRVE")); account.getTelephone().setPrice(rs.getString("TELEPHONE_PRICE")); account.getFun().setFunction(rs.getString("FUNCTION_TYPE")); } } catch (Exception e) { e.printStackTrace(); }finally{ DBUtil.closeDB(rs, stmt, pstmt, conn); } return account; } //查询所有手机详细信息信息(运用到实体类集合) public List<AccountList> selAll(){ List<AccountList> accountList = new ArrayList<AccountList>(); AccountList account = null; Connection conn = null; Statement stmt = null; PreparedStatement pstmt = null; ResultSet rs = null; try { conn = DBUtil.getConn(); String sql = "select TELEPHONE_ID,TELEPHONE_NAME,BRAND_NAME,WG_TYPE,TELEPHONE_TIME,TELEPHONE_IMG_MAX,TELEPHONE_IMG_MIN,TELEPHONE_WEIGHT,TELEPHONE_SCREEN,TELEPHONE_V,TELEPHONE_DIRVE,TELEPHONE_PRICE,FUNCTION_TYPE from TELEPHONE_INFO as telephone " +" inner join BRAND_TYPE as brand on telephone.BRAND_ID = brand.BRAND_ID " +" inner join FUNCTION_TYPE as fun on telephone.FUNCTION_ID = fun.FUNCTION_ID " +" inner join TELEPHONE_WG as wg on telephone.WG_ID = wg.WG_ID"; pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while( rs.next() ){ account = new AccountList(); account.getTelephone().setId(rs.getInt("TELEPHONE_ID")); account.getTelephone().setPhoneName(rs.getString("TELEPHONE_NAME")); account.getBrandType().setBRAND_NAME(rs.getString("BRAND_NAME")); account.getWaiGuan().setWaiGuan(rs.getString("WG_TYPE")); account.getTelephone().setSealtime(rs.getString("TELEPHONE_TIME")); account.getTelephone().setBigPic(rs.getString("TELEPHONE_IMG_MAX")); account.getTelephone().setSmallPic(rs.getString("TELEPHONE_IMG_MIN")); account.getTelephone().setWeight(rs.getString("TELEPHONE_WEIGHT")); account.getTelephone().setScreen(rs.getString("TELEPHONE_SCREEN")); account.getTelephone().setSize(rs.getString("TELEPHONE_V")); account.getTelephone().setDirve(rs.getString("TELEPHONE_DIRVE")); account.getTelephone().setPrice(rs.getString("TELEPHONE_PRICE")); account.getFun().setFunction(rs.getString("FUNCTION_TYPE")); accountList.add(account); } } catch (Exception e) { e.printStackTrace(); }finally{ DBUtil.closeDB(rs, stmt, pstmt, conn); } return accountList; } //添加商品 public boolean addPhone(TelephoneInfo account){ boolean flag = false; Connection conn = null; Statement stmt = null; PreparedStatement pstmt = null; ResultSet rs = null; try { conn = DBUtil.getConn(); String sql = "insert into TELEPHONE_INFO values(?,?,?,?,?,?,?,?,?,?,?,?)"; pstmt = conn.prepareStatement(sql); pstmt.setString(1, account.getPhoneName()); pstmt.setInt(2, account.getPhBrandId()); pstmt.setString(3, account.getWaiGuan()); pstmt.setString(4, account.getSealtime()); pstmt.setString(5, account.getBigPic()); pstmt.setString(6, account.getSmallPic()); pstmt.setString(7, account.getWeight()); pstmt.setString(8, account.getScreen()); pstmt.setString(9, account.getSize()); pstmt.setString(10, account.getDirve()); pstmt.setString(11, account.getPrice()); pstmt.setString(12, account.getFunction()); int res = pstmt.executeUpdate(); if(res > 0){ flag = true; } } catch (Exception e) { e.printStackTrace(); }finally{ DBUtil.closeDB(rs, stmt, pstmt, conn); } return flag; } //修改商品 public boolean updatePhone(TelephoneInfo acc){ boolean flag = false; Connection conn = null; Statement stmt = null; PreparedStatement pstmt = null; ResultSet rs = null; try { conn = DBUtil.getConn(); String sql = "update TELEPHONE_INFO set TELEPHONE_NAME ='?',BRAND_ID=?,WG_ID=?,TELEPHONE_TIME='?',TELEPHONE_IMG_MAX='?',TELEPHONE_IMG_MIN='?', " +"TELEPHONE_WEIGHT=?,TELEPHONE_SCREEN='?',TELEPHONE_V='?',TELEPHONE_DIRVE='?',TELEPHONE_PRICE=?,FUNCTION_ID=? where TELEPHONE_ID=?"; pstmt = conn.prepareStatement(sql); pstmt.setString(1, acc.getPhoneName()); pstmt.setInt(2, acc.getPhBrandId()); pstmt.setString(3,acc.getWaiGuan()); pstmt.setString(4, acc.getSealtime()); pstmt.setString(5, acc.getBigPic()); pstmt.setString(6, acc.getSmallPic()); pstmt.setString(7, acc.getWeight()); pstmt.setString(8, acc.getScreen()); pstmt.setString(9,acc.getSize()); pstmt.setString(10,acc.getDirve()); pstmt.setString(11, acc.getPrice()); pstmt.setString(12,acc.getFunction()); pstmt.setInt(13, acc.getId()); int res = pstmt.executeUpdate(); if(res >