基于jsp的网上商城项目

//这是model类，完成对货物表的处理 package com.zhang.model; import java.sql.*; import java.util.*; public class GoodsBeanBo { //定义一些变量 private ResultSet rs = null; private Connection ct = null; private PreparedStatement ps = null; public int getTypeCount(int pageSize,int smallId){ int pageCount = 0; int rowCount = 0; try{ ct = new ConDB().getConnection(); ps = ct.prepareStatement("select count(*) from goods where smallId=?"); ps.setInt(1, smallId); rs = ps.executeQuery(); if(rs.next()){ rowCount = rs.getInt(1); } if(rowCount%pageSize == 0){ pageCount = rowCount/pageSize; }else{ pageCount = rowCount/pageSize+1; } }catch(Exception e){ e.printStackTrace(); }finally{ this.close(); } // System.out.print("pagecount ="+pageCount); return pageCount; } public int getPageCount(int pageSize){ int pageCount = 0; int rowCount = 0; try{ ct = new ConDB().getConnection(); ps = ct.prepareStatement("select count(*) from goods"); rs = ps.executeQuery(); if(rs.next()){ rowCount = rs.getInt(1); } if(rowCount%pageSize == 0){ pageCount = rowCount/pageSize; }else{ pageCount = rowCount/pageSize+1; } }catch(Exception e){ e.printStackTrace(); }finally{ this.close(); } return pageCount; } //分页显示功能 public ArrayList getGoodsByPage(int pageSize,int pageNow){ ArrayList a1 = new ArrayList(); try{ ct = new ConDB().getConnection(); ps = ct.prepareStatement("select *from goods order by goodsId limit "+(pageNow-1)*6+","+pageNow*pageSize+""); rs = ps.executeQuery(); while(rs.next()){ GoodsBean gb = new GoodsBean(); gb.setGoodsId(rs.getInt(1)); gb.setSmallId(rs.getInt(2)); gb.setGoodName(rs.getString(3)); gb.setIntroduce(rs.getString(4)); gb.setCreateTime(rs.getString(5)); gb.setNowPrice(rs.getFloat(6)); gb.setStore(rs.getInt(7)); gb.setDiscount(rs.getFloat(8)); gb.setNumber(rs.getInt(9)); gb.setPicName(rs.getString(10)); a1.add(gb); } }catch(Exception e){ e.printStackTrace(); }finally{ this.close(); } return a1; } public ArrayList getGoodsByType(int pageSize,int pageNow,int smallId){ System.out.print(smallId); ArrayList a1 = new ArrayList(); try{ ct = new ConDB().getConnection(); ps = ct.prepareStatement("select *from goods where smallId = "+smallId+" order by goodsId limit "+(pageNow-1)*6+","+pageNow*pageSize+""); rs = ps.executeQuery(); boolean b=rs.next(); while(b){ GoodsBean gb = new GoodsBean(); gb.setGoodsId(rs.getInt(1)); gb.setSmallId(rs.getInt(2)); gb.setGoodName(rs.getString(3)); gb.setIntroduce(rs.getString(4)); gb.setCreateTime(rs.getString(5)); gb.setNowPrice(rs.getFloat(6)); gb.setStore(rs.getInt(7)); gb.setDiscount(rs.getFloat(8)); gb.setNumber(rs.getInt(9)); gb.setPicName(rs.getString(10)); a1.add(gb); } }catch(Exception e){ e.printStackTrace(); }finally{ this.close(); } /* System.out.print(smallId); System.out.print(" "); System.out.print(a1.size());*/ return a1; } //根据商品的货物ID，得到商品的具体的信息 public GoodsBean getGoodsBean(String id){ GoodsBean gb = new GoodsBean(); try{ ct = new ConDB().getConnection(); ps = ct.prepareStatement("select * from goods where goodsId = ? "); ps.setString(1, id); rs = ps.executeQuery(); if(rs.next()){ gb.setGoodsId(rs.getInt(1)); gb.setSmallId(rs.getInt(2)); gb.setGoodName(rs.getString(3)); gb.setIntroduce(rs.getString(4)); gb.setCreateTime(rs.getString(5)); gb.setNowPrice(rs.getFloat(6)); gb.setStore(rs.getInt(7)); gb.setDiscount(rs.getFloat(8)); gb.setNumber(rs.getInt(9)); gb.setPicName(rs.getString(10)); //放入GoodBean } }catch(Exception e){ e.printStackTrace(); }finally{ this.close(); } return gb; } //得到所有商品信息 public ArrayList getGoods(){ ArrayList a1=new ArrayList(); try{ ct = new ConDB().getConnection(); ps = ct.prepareStatement("select * from goods"); rs = ps.executeQuery(); while(rs.next()){ GoodsBean gb = new GoodsBean(); gb.setGoodsId(rs.getInt(1)); gb.setSmallId(rs.getInt(2)); gb.setGoodName(rs.getString(3)); gb.setIntroduce(rs.getString(4)); gb.setCreateTime(rs.getString(5)); gb.setNowPrice(rs.getFloat(6)); gb.setStore(rs.getInt(7)); gb.setDiscount(rs.getFloat(8)); gb.setNumber(rs.getInt(9)); gb.setPicName(rs.getString(10)); a1.add(gb); //放入GoodBean } }catch(Exception e){ e.printStackTrace(); }finally{ this.close(); } System.out.print("first="+a1.size()); return a1; } //删除单个商品 public boolean delOneGood(int goodsId){ boolean b = false; try{ ct = new ConDB().getConnection(); ps = ct.prepareStatement("delete from goods where goodsId=?"); ps.setInt(1, goodsId); int k = ps.executeUpdate(); if(k==1){ b=true; } }catch(Exception e){ e.printStackTrace(); }finally{ this.close(); } return b; } //添加商品 public boolean add(String smallName,String goodsName,String introduce,float price,String picName ){ boolean b=false; int smallId; try{ ct = new ConDB().getConnection(); ps=ct.prepareStatement("select smallId from smallType where smallName=?"); ps.setString(1, smallName); rs=ps.executeQuery(); if(rs.next()){ smallId =rs.getInt(1); ps = ct.prepareStatement("insert into goods(smallId,goodName,introduce,nowPrice,picName)values (?,?,?,?,?)"); ps.setInt(1, smallId); ps.setString(2, goodsName); ps.setString(3, introduce); ps.setFloat(4, price); ps.setString(5, picName); int k =ps.executeUpdate(); if(k==1){ b=true; } } }catch(Exception e){ e.printStackTrace(); }finally{ this.close(); } return b; } //关闭函数 public void close(){ try{ if(rs!=null){ rs.close(); rs = null; } if(ps !=null){ ps.close(); ps = null; } if(ct.isClosed()){ ct.close(); } }catch(Exception e){ e.printStackTrace(); } } }