Java Web课程设计之网上花店系统.zip

package kechengsheji.com.dh.db; import kechengsheji.com.dh.db.DBOper; import kechengsheji.com.dh.entity.Flower; import java.sql.ResultSet; import java.sql.SQLException; import java.util.*; public class FlowerDao extends DBOper { public List<Flower> getAllFlower() { List<Flower> flowerList=new ArrayList<Flower>(); String sql="SELECT * FROM flowers"; try { ResultSet rs=this.executeQuery(sql, null); while (rs.next()) { Flower flower = new Flower(); flower.setIsbn(rs.getString("isbn")); flower.setGoodsName(rs.getString("goodsName")); flower.setGoodsFrom(rs.getString("goodsFrom")); flower.setNowprice(rs.getDouble("nowprice")); flower.setNumber(rs.getInt("number")); flower.setIntroduce(rs.getString("introduce")); flowerList.add(flower); } } catch (SQLException e) { e.printStackTrace(); } finally { this.closeAll(); } return flowerList; } public Flower getFlowerByIsbn(String isbn) { Flower flower=null; String sql="SELECT * FROM flowers WHERE isbn=?"; try { ResultSet rs=this.executeQuery(sql, new String[] { isbn }); if (rs.next()) { flower=new Flower(); flower.setIsbn(rs.getString("isbn")); flower.setGoodsName(rs.getString("goodsName")); flower.setGoodsFrom(rs.getString("goodsFrom")); flower.setNowprice(rs.getDouble("nowprice")); flower.setNumber(rs.getInt("number")); flower.setIntroduce(rs.getString("introduce")); } } catch (SQLException e) { e.printStackTrace(); } finally { this.closeAll(); } return flower; } public List<Flower> getFlowerByGoodsName(String goodsName) { List<Flower> flowerList = new ArrayList<Flower>(); String sql = "SELECT * FROM flowers WHERE goodsName LIKE '%" + goodsName + "%'"; try { ResultSet rs = this.executeQuery(sql, null); while (rs.next()) { Flower flower = new Flower(); flower.setIsbn(rs.getString("isbn")); flower.setGoodsName(rs.getString("goodsName")); flower.setGoodsFrom(rs.getString("goodsFrom")); flower.setNowprice(rs.getDouble("nowprice")); flower.setNumber(rs.getInt("number")); flower.setIntroduce(rs.getString("introduce")); flowerList.add(flower); } } catch (SQLException e) { e.printStackTrace(); } finally { this.closeAll(); } return flowerList; } public List<Flower> getFlowerByGoodsFrom(int pid) { List<Flower> flowerList = new ArrayList<Flower>(); String sql = "SELECT * FROM flowers WHERE goodsFrom=" + pid; try { ResultSet rs = this.executeQuery(sql, null); while (rs.next()) { Flower flower = new Flower(); flower.setIsbn(rs.getString("isbn")); flower.setGoodsName(rs.getString("goodsName")); flower.setGoodsFrom(rs.getString("goodsFrom")); flower.setNowprice(rs.getDouble("nowprice")); flower.setNumber(rs.getInt("number")); flower.setIntroduce(rs.getString("introduce")); flowerList.add(flower); } } catch (SQLException e) { e.printStackTrace(); } finally { this.closeAll(); } return flowerList; } public List<Flower> getFlowerByGoodsNameAndGoodsFrom(String goodsName,int pid) { List<Flower> flowerList = new ArrayList<Flower>(); String sql = "SELECT * FROM flowers " + "WHERE goodsName LIKE '%" + goodsName + "%' AND goodsFrom="+pid; try { ResultSet rs = this.executeQuery(sql, null); while (rs.next()) { Flower flower = new Flower(); flower.setIsbn(rs.getString("isbn")); flower.setGoodsName(rs.getString("goodsName")); flower.setGoodsFrom(rs.getString("goodsFrom")); flower.setNowprice(rs.getDouble("nowprice")); flower.setNumber(rs.getInt("number")); flower.setIntroduce(rs.getString("introduce")); flowerList.add(flower); } } catch (SQLException e) { e.printStackTrace(); } finally { this.closeAll(); } return flowerList; } public boolean addFlower(Flower flower) { boolean r = false; try { String sql = "INSERT INTO flowers(isbn,goodsName,goodsFrom,nowprice,number,introduce)VALUES(?,?,?,?,?,?)"; int rs = this.executeUpdate(sql, new String[] { flower.getIsbn(), flower.getGoodsName(), "" + flower.getGoodsFrom(), "" + flower.getNowprice(), "" + flower.getNumber(), flower.getIntroduce() }); if (rs > 0) {// 插入成功 r = true; } } catch (Exception e) { e.printStackTrace(); } finally { this.closeAll(); } return r; } public boolean editFlower(Flower flower) { boolean r=false; try { String sql="UPDATE flowers SET goodsName=?,goodsFrom=?,nowprice=?,number=?,introduce=?" + "WHERE isbn=?"; int rs=this.executeUpdate(sql, new String[] { flower.getGoodsName(), "" + flower.getGoodsFrom(), "" + flower.getNowprice(), "" + flower.getNumber(),flower.getIntroduce() ,flower.getIsbn()}); if(rs>0) { r=true; } } catch (Exception e) { e.printStackTrace(); } finally { this.closeAll(); } return r; } public boolean delFlowerByIsbn(String isbn) { boolean r=false; try { String sql="DELECT FROM flowers WHERE isbn=?"; int rs=this.executeUpdate(sql,new String[] {isbn}); if(rs>0) { r=true; } }catch(Exception e) { e.printStackTrace(); }return r; } }