JSP实现网上购物网站

package com; import java.util.ArrayList; import java.util.Collection; import java.sql.*; public class GoodsBean { private Connection con; PageNumber pageNumber=new PageNumber(); int rowCount=1; //总的记录数 int showPage=16;//设置欲显示的页码数 int pageCount=1;//分页之后的总页数 //构造函数中建立数据库连接 public GoodsBean(){ try{ con=DBConnection.getConnection(); }catch(Exception e){ e.printStackTrace(); } } public int getRowCount(){ return rowCount; } //定义获得全部查询商品信息的方法 public int getAllPage(){ try{ Statement statement=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); ResultSet resultset=statement.executeQuery("select * from Goods"); resultset.last(); rowCount=resultset.getRow(); pageNumber.setPageCount(rowCount, showPage); pageCount=pageNumber.getPageCount(); }catch(Exception e){ e.printStackTrace(); } return pageCount; } //定义根据商品类型获得商品信息的方法 public int getAllPageBySort(String s){ try{ Statement statement=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); ResultSet resultset=statement.executeQuery("select * from Goods where sortName='"+s+"'"); resultset.last(); rowCount=resultset.getRow(); pageNumber.setPageCount(rowCount,showPage); pageCount=pageNumber.getPageCount(); }catch(Exception e){ e.printStackTrace(); } return pageCount; } //定义根据商品价格获得商品信息的方法 public int getAllPageByPrice(String s){ int a=s.indexOf("-"); float one=Float.parseFloat(s.substring(0,a)); float two=Float.parseFloat(s.substring(a+1)); try{ Statement stm=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); ResultSet resultset=stm.executeQuery("select * from Goods where goodsPrice between "+one+" and "+two); resultset.last(); rowCount=resultset.getRow(); pageNumber.setPageCount(rowCount,showPage); pageCount=pageNumber.getPageCount(); }catch(Exception e){ e.printStackTrace(); } return pageCount; } //定义分页显示所有商品信息的方法 public Collection getAllGoods(int s){ GoodsClass goods; ArrayList arraylist=new ArrayList(); try{ Statement stm=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); ResultSet resultset=stm.executeQuery("select * from Goods"); int count=0; if(s!=0){ resultset.absolute(s*16); } while(resultset.next()) { goods = new GoodsClass(); int i=resultset.getInt(1); String s1=resultset.getString(2); String s2=resultset.getString(3); float f=resultset.getFloat(4); String s5=resultset.getString(5); String s6=resultset.getString(6); goods.setGoodsId(i); goods.setGoodsName(s1); goods.setGoodsLanguage(s2); goods.setGoodsPrice(f); goods.setGoodsCent(s5); goods.setSortName(s6); arraylist.add(goods); count++; if(count==16) { break; } } con.close(); }catch(Exception e){ e.printStackTrace(); } return arraylist; } //定义分页显示根据商品类型获得商品信息的方法 public Collection getGoodsBySort(String s,int pageCount){ GoodsClass goods; ArrayList arraylist=new ArrayList(); try{ Statement stm=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); ResultSet resultset=stm.executeQuery("select * from Goods where sortName='"+s+"'"); int count=0; if(pageCount!=0){ resultset.absolute(pageCount*16); } while(resultset.next()) { goods = new GoodsClass(); int i=resultset.getInt(1); String s1=resultset.getString(2); String s2=resultset.getString(3); float f=resultset.getFloat(4); String s5=resultset.getString(5); String s6=resultset.getString(6); goods.setGoodsId(i); goods.setGoodsName(s1); goods.setGoodsLanguage(s2); goods.setGoodsPrice(f); goods.setGoodsCent(s5); goods.setSortName(s6); arraylist.add(goods); count++; if(count==16) { break; } } stm.close(); con.close(); }catch(Exception e){ e.printStackTrace(); } return arraylist; } //定义分页显示根据商品价格获得商品信息的方法 public Collection getGoodsByPrice(String s,int pageCount){ int a=s.indexOf("-"); float one=Float.parseFloat(s.substring(0,a)); float two=Float.parseFloat(s.substring(a+1)); GoodsClass goods; ArrayList arraylist=new ArrayList(); try{ Statement stm=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); ResultSet resultset=stm.executeQuery("select * from Goods where goodsPrice between "+one+" and "+two); int count=0; if(pageCount!=0){ resultset.absolute(pageCount*16); } while(resultset.next()) { goods = new GoodsClass(); int i=resultset.getInt(1); String s1=resultset.getString(2); String s2=resultset.getString(3); float f=resultset.getFloat(4); String s5=resultset.getString(5); String s6=resultset.getString(6); goods.setGoodsId(i); goods.setGoodsName(s1); goods.setGoodsLanguage(s2); goods.setGoodsPrice(f); goods.setGoodsCent(s5); goods.setSortName(s6); arraylist.add(goods); count++; if(count==16) { break; } } stm.close(); con.close(); }catch(Exception e){ e.printStackTrace(); } return arraylist; } //定义根据商品ID获得商品信息的方法 public Collection getGoodsByGoodsId(String s){ int i1=Integer.parseInt(s); GoodsClass goods; ArrayList arraylist=new ArrayList(); try{ Statement stm=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); ResultSet resultset=stm.executeQuery("select * from Goods where goodsId='"+i1+"'"); while(resultset.next()) { goods = new GoodsClass(); int i=resultset.getInt(1); String s1=resultset.getString(2); String s2=resultset.getString(3); float f=resultset.getFloat(4); String s5=resultset.getString(5); String s6=resultset.getString(6); goods.setGoodsId(i); goods.setGoodsName(s1); goods.setGoodsLanguage(s2); goods.setGoodsPrice(f); goods.setGoodsCent(s5); goods.setSortName(s6); arraylist.add(goods); } stm.close(); con.close(); }catch(Exception e){ e.printStackTrace(); } return arraylist; } //定义根据商品名称获得商品信息的方法 public Collection getGoodsByGoodsName(String s){ GoodsClass goods; ArrayList arraylist=new ArrayList(); try{ Statement stm=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); ResultSet resultset=stm.executeQuery("select * from Goods where goodsName like'%"+s+"%'"); while(resultset.next()) { goods = new GoodsClass(); int i=resultset.getInt(1); String s1=resultset.getString(2); String s2=resultset.getString(3); float f=resultset.getFloat(4); String s5=resultset.getString(5); String s6=resultset.getString(6); goods.setGoodsId(i)