网上售花系统（含源代码）

package dao; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import entity.FatherTeMplate; import entity.goods; public class goodsDao extends BaseDao { //查询所有花 public List<goods> SelectGoodsAll(){ String sql="select * from goods"; ResultSet rs= super.select(sql); List<goods> list=new ArrayList<goods>(); try { while(rs!=null&&rs.next()){ goods g=new goods(); g.setGoodsId(rs.getInt("goodsid")); g.setGoodsName(rs.getString("goodsName")); g.setGoodsmaterial(rs.getString("goodsmaterial")); g.setGoodsPackage(rs.getString("goodsPackage")); g.setGoodsLanguage(rs.getString("goodsLanguage")); g.setGoodsPrice(rs.getFloat("goodsPrice")); g.setGoodsPlace(rs.getString("goodsPlace")); g.setGoodsHabitus(rs.getString("goodsHabitus")); g.setSortName(rs.getString("sortName")); g.setGoodsimage(rs.getString("goodsimage")); list.add(g); } } catch (SQLException e) { super.closeCon(); e.printStackTrace(); return null; } super.closeCon(); return list; } //按花编号查询单个花 public goods SelectGoodsOnId(int goodsid){ String sql="select * from goods where goodsid=?"; ResultSet rs= super.select(sql,goodsid); goods g=new goods(); try { if(rs!=null&&rs.next()){ g.setGoodsId(rs.getInt("goodsid")); g.setGoodsName(rs.getString("goodsName")); g.setGoodsmaterial(rs.getString("goodsmaterial")); g.setGoodsPackage(rs.getString("goodsPackage")); g.setGoodsLanguage(rs.getString("goodsLanguage")); g.setGoodsPrice(rs.getFloat("goodsPrice")); g.setGoodsPlace(rs.getString("goodsPlace")); g.setGoodsHabitus(rs.getString("goodsHabitus")); g.setSortName(rs.getString("sortName")); g.setGoodsimage(rs.getString("goodsimage")); } } catch (SQLException e) { super.closeCon(); e.printStackTrace(); return null; } super.closeCon(); return g; } //按花的类型名称查询花 public List<goods> SelectGoodsOnsortName(String sortName){ String sql="select * from goods where sortName=?"; ResultSet rs= super.select(sql,sortName); List<goods> list=new ArrayList<goods>(); try { while(rs!=null&&rs.next()){ goods g=new goods(); g.setGoodsId(rs.getInt("goodsid")); g.setGoodsName(rs.getString("goodsName")); g.setGoodsmaterial(rs.getString("goodsmaterial")); g.setGoodsPackage(rs.getString("goodsPackage")); g.setGoodsLanguage(rs.getString("goodsLanguage")); g.setGoodsPrice(rs.getFloat("goodsPrice")); g.setGoodsPlace(rs.getString("goodsPlace")); g.setGoodsHabitus(rs.getString("goodsHabitus")); g.setSortName(rs.getString("sortName")); g.setGoodsimage(rs.getString("goodsimage")); list.add(g); } } catch (SQLException e) { super.closeCon(); e.printStackTrace(); } super.closeCon(); return list; } //按花的编号修改花的信息 public int UpdateGoods(goods gds){ String sql="update goods set goodsName=?,goodsmaterial=?,goodsPackage=?,goodsLanguage=?,goodsPrice=?,goodsPlace=?,goodsHabitus=?,sortName=?,goodsimage=? where goodsId=?"; int num= super.zsg(sql,gds.getGoodsName(),gds.getGoodsmaterial(),gds.getGoodsPackage(),gds.getGoodsLanguage(),gds.getGoodsPrice(),gds.getGoodsPlace(),gds.getGoodsHabitus(),gds.getSortName(),gds.getGoodsimage(),gds.getGoodsId()); super.closeCon(); return num; } //按花的编号删除相关花的记录 public int DeleteGoodsOnId(int goodsid){ String sql="delete goods where goodsid=?"; super.closeCon(); return super.zsg(sql, goodsid); } //添加新花 public int InsertGoods(goods gds){ String sql="insert into goods values(?,?,?,?,?,?,?,?,?,?)"; int num= super.zsg(sql,gds.getGoodsName(), gds.getGoodsmaterial(), gds.getGoodsPackage(), gds.getGoodsLanguage(), gds.getGoodsPrice(), gds.getGoodsPlace(), gds.getGoodsHabitus(), gds.getSortName(), gds.getGoodsimage()); super.closeCon(); return num; } public List<goods> SelectOnTiaoJian(float goodsPricemax,float goodsPricemain,String sortName,String t,String t2){ StringBuffer sql=new StringBuffer("select * from goods where 1=1 "); if(sortName!=null &&sortName.trim().length()>0) { sql.append(" and sortName like '%").append(sortName).append("%'"); } if(goodsPricemax>0) { sql.append(" and goodsPrice<='").append(goodsPricemax).append("'"); } if(goodsPricemain>0) { sql.append(" and goodsPrice>='").append(goodsPricemain).append("'"); } if(t!=null) { sql.append(" order by goodsprice desc"); } if(t2!=null) { sql.append(" order by goodsprice"); } System.out.println(sql); ResultSet rs= super.select(sql.toString()); List<goods> list=new ArrayList<goods>(); goods g=null; try { while(rs!=null && rs.next()) { g=new goods(); g.setGoodsId(rs.getInt("goodsid")); g.setGoodsName(rs.getString("goodsName")); g.setGoodsmaterial(rs.getString("goodsmaterial")); g.setGoodsPackage(rs.getString("goodsPackage")); g.setGoodsLanguage(rs.getString("goodsLanguage")); g.setGoodsPrice(rs.getFloat("goodsPrice")); g.setGoodsPlace(rs.getString("goodsPlace")); g.setGoodsHabitus(rs.getString("goodsHabitus")); g.setSortName(rs.getString("sortName")); g.setGoodsimage(rs.getString("goodsimage")); list.add(g); } } catch (SQLException e) { e.printStackTrace(); } super.closeCon(); return list; } public List<goods> KSSelectGoods(String Templatename,String sortName,int goodsPrice){ StringBuffer sql=new StringBuffer("select * from goods where 1=1 "); if(sortName!=null&&sortName.trim().length()>0) { sql.append(" and sortName like'").append(sortName).append("%' "); } if(goodsPrice>0) { switch (goodsPrice) { case 1: sql.append(" and goodsPrice<=100"); break; case 2: sql.append(" and goodsPrice>100 and goodsPrice<=150"); break; case 3: sql.append(" and goodsPrice>150 and goodsPrice<=200"); break; case 4: sql.append(" and goodsPrice>200 and goodsPrice<=300"); break; case 5: sql.append(" and goodsPrice>300 and goodsPrice<=500"); break; case 6: sql.append(" and goodsPrice>500"); break; default: break; } } if(Templatename!=null&&Templatename.trim().length()>0) { sql.append(" and goodsid in(select distinct(t.goodsid) from FatherTeMplate t where t.Templatename='").append(Templatename).append("')"); } ResultSet rs=super.select(sql.toString()); List<goods> list=new ArrayList<goods>(); goods g=null; try { while(rs!=null && rs.next()) { g=new goods(); g.setGoodsId(rs.getInt("goodsid")); g.setGoodsName(rs.getString("goodsName")); g.setGoodsmaterial(rs.getString("goodsmaterial")); g.setGoodsPackage(rs.getString("goodsPackage")); g.setGoodsLanguage(rs.getString("goodsLanguage")); g.setGoodsPrice(rs.getFloat("goodsPrice")); g.setGoodsPlace(rs.getString("goodsPlace")); g.setGoodsHabitus(rs.getString("goodsHabitus")); g.setSortName(rs.getString("sortName")); g.setGoodsimage(rs.getString("goodsimage")); list.add(g); } } catch (SQLException e) { e.printStackTrace(); } super.closeCon(); return list; } public Map pageQuery(int page,int size) { String sql = "select * from goods"; Map mm = new HashMap(); try { Map map = super.page(sql, page, size); ResultSet rs = (ResultSet) map.get("rs"); int pageCount = (Integer) map.get("pageCount"); List lst = new ArrayList(); while (rs.next()){ goods g=new goods(); g.setGoodsId(rs.getInt("goodsid")); g.setGoodsName(rs.getString("goodsName")); g.setGoodsmaterial(rs.getString("goodsmaterial")); g.setGoodsPackage(rs.getString