JSP+servlet+javabean订单系统

package com.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.*; import javax.servlet.jsp.jstl.sql.*; import com.bean.*; import com.tool.*; /* * 对手机产品表和产品信息表的操作 */ public class GoodsDao { private Connection connection = null;//定义的连接对象 private JDBConnection jdbc = null;//定义数据库连接对象 private PreparedStatement ps = null; //定义预准备的对象 Date date = new Date(); public GoodsDao(){ jdbc = new JDBConnection(); connection = jdbc.connection;//利用构造方法来获得连接对象 } //查询所有的手机 //return List对象 public List selectAllGoods(){ List list = new ArrayList(); GoodsBean goods = null; try{ SQLCommandBean sqlCommandBean = new SQLCommandBean(); sqlCommandBean.setConnection(connection); //设置连接对象 sqlCommandBean.setSqlValue(FinalConstants.goods_select); //设置查询语句 Result result = sqlCommandBean.executeQuery(); //执行查询语句 if(result==null||result.getRowCount()==0){ //没有查询到 System.out.println("没有手机产品"); }else{ int rowCount = result.getRowCount(); //得到影响行数 //读取行数据 for(int i = 0;i<rowCount; i++){ Map row = result.getRows()[i]; goods = new GoodsBean(); goods.setId(((Integer)row.get("id")).intValue()); goods.setName((String)row.get("goodsName")); goods.setIntroduce((String)row.get("introduce")); goods.setCreatetime(row.get("creaTime").toString()); goods.setPrice((String)row.get("price")); goods.setNumber(((Integer)row.get("number")).intValue()); goods.setPicture((String)row.get("picture")); list.add(goods); } } }catch(Exception ex){ ex.printStackTrace(); } //释放资源 finally{ try{ if(connection!=null&&(!connection.isClosed())){ connection.close(); } }catch(Exception ex){ ex.printStackTrace(); } } return list; } //根据id查询手机信息表 //return list; public List selectAllGoodsDetail(Integer id){ List list = new ArrayList(); GoodsDetailBean goods = null; try{ SQLCommandBean sqlCommandBean = new SQLCommandBean(); sqlCommandBean.setConnection(connection); sqlCommandBean.setSqlValue(FinalConstants.goodsDetail_select); List values = new ArrayList(); values.add(id); sqlCommandBean.setValues(values); Result result = sqlCommandBean.executeQuery(); if(result == null ||result.getRowCount()==0){ System.out.println("没有结果!"); }else{ int rowCount = result.getRowCount(); //得到影响行数 //读取行数据 for(int i = 0;i<rowCount; i++){ Map row = result.getRows()[i]; goods = new GoodsDetailBean(); goods.setType(row.get("type").toString()); goods.setZhishi(row.get("zhishi").toString()); goods.setPinduan(row.get("pinduan").toString()); goods.setNet(row.get("net").toString()); goods.setCaizhi(row.get("caizhi").toString()); goods.setColor(row.get("color").toString()); goods.setScreen(row.get("sreen").toString()); list.add(goods); } } }catch(Exception ex){ ex.printStackTrace(); } // 释放资源 finally{ try{ if(connection!=null&&(!connection.isClosed())){ connection.close(); } }catch(Exception ex){ ex.printStackTrace(); } } return list; } //根据ID修改手机的数量 public void updateGoodsNumber(int number,Integer id){ try{ SQLCommandBean sqlCommandBean = new SQLCommandBean(); sqlCommandBean.setConnection(connection); sqlCommandBean.setSqlValue(FinalConstants.goods_updateNumber); List values = new ArrayList(); values.add(Integer.valueOf(number)); values.add(id); sqlCommandBean.setValues(values); int rows = sqlCommandBean.executeUpdate(); if(rows==0){ System.out.println("手机产品表的数量修改失败！"); }else{ System.out.println("手机产品表的数量修改成功！影响行数:"+rows); } }catch(Exception ex){ ex.printStackTrace(); }finally{ try{ if(connection!=null&&(!connection.isClosed())){ connection.close(); } }catch(Exception ex){ ex.printStackTrace(); } } } //根据手机ID查询手机 public GoodsBean selectOneGood(Integer id){ SQLCommandBean sqlCommandBean = new SQLCommandBean(); GoodsBean goodsBean = null; try{ sqlCommandBean.setConnection(connection); sqlCommandBean.setSqlValue(FinalConstants.goods_selectId); List values = new ArrayList(); values.add(id); sqlCommandBean.setValues(values); //执行查询操作，返回结果集 Result rs = sqlCommandBean.executeQuery(); if(rs==null||rs.getRowCount()==0){ System.out.println("根据ID查询手机表失败！"); }else{ for(int i = 0;i<rs.getRowCount();i++){ Map row = rs.getRows()[i]; goodsBean = new GoodsBean(); goodsBean.setId(((Integer)row.get("id")).intValue()); goodsBean.setName((String)row.get("goodsName")); goodsBean.setIntroduce((String)row.get("introduce")); goodsBean.setCreatetime(row.get("creaTime").toString()); goodsBean.setPrice((String)row.get("price")); goodsBean.setNumber(((Integer)row.get("number")).intValue()); goodsBean.setPicture((String)row.get("picture")); } } }catch(Exception ex){ ex.printStackTrace(); }finally{ try{ if(connection!=null&&(!connection.isClosed())){ connection.close(); } }catch(Exception ex){ ex.printStackTrace(); } } return goodsBean; } // 查询全部手机（毕杰） public List selectMobileGoods() { List list = new ArrayList(); GoodsBean member = null; try { String sqlText ="select * from ob_goods order by id DESC"; ps = connection.prepareStatement(sqlText); ResultSet rs = ps.executeQuery(); while (rs.next()) { member = new GoodsBean(); member.setId(Integer.valueOf(rs.getInt("id"))); member.setName(rs.getString("goodsName")); member.setIntroduce(rs.getString("introduce")); member.setCreatetime(rs.getString("creaTime")); member.setPrice(rs.getString("price")); member.setNumber(Integer.valueOf(rs.getString("number"))); member.setPicture(rs.getString("picture")); list.add(member); } } catch (SQLException ex) { } return list; } //以手机ID为条件查询手机信息(毕杰) public GoodsBean selectOne(Integer id) { GoodsBean member = null; try { String sqlText = "select * from ob_goods where id= ? "; ps = connection.prepareStatement(sqlText); ps.setInt(1, id.intValue()); ResultSet rs = ps.executeQuery(); while (rs.next()) { member = new GoodsBean(); member.setId(Integer.valueOf(rs.getString("id"))); member.setName(rs.getString("goodsName")); member.setIntroduce(rs.getString("introduce")); member.setPrice(rs.getString("price")); member.setNumber(Integer.valueOf(rs.getString("number"))); member.setPicture(rs.getString("picture")); } } catch (SQLException ex) { ex.getMessage(); } return member; } //修改手机信息的方法(毕杰) public boolean updateGoods(GoodsBean goods) { int i ; try { String sqlText = "update ob_goods set goodsName=?,introduce=?,creaTime=getDate(),price=?,number=?,picture=? where id=?"; ps = connection.prepareStatement(sqlText); ps.setString(1,goods.getName