jsp服装售卖管理系统源码（含数据库脚本）.zip

package dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import bean.Clothes; import bean.Consumption; import util.DBUtil; public class ClothesDao { Statement pstmt=null; Connection conn=null; ResultSet rSet=null; Clothes c; public List<Consumption> selectUserConsumption() { conn=DBUtil.getConnection(); String sql="select * from consumption"; List<Consumption> consumptions=new ArrayList<Consumption>(); try { PreparedStatement ps=conn.prepareStatement(sql); rSet=ps.executeQuery(); while(rSet.next()){ Consumption d=new Consumption(); d.setUser_id(rSet.getInt("user_id")); d.setUser_name(rSet.getNString("user_name")); d.setUser_nickname(rSet.getString("user_nickname")); d.setUser_tel(rSet.getString("user_tel")); d.setConsumption_Time(rSet.getDate("consumption_Time")); d.setClothes_name(rSet.getString("clothes_name")); d.setNumber(rSet.getString("number")); d.setTotal(rSet.getString("total")); consumptions.add(d); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { DBUtil.close(rSet, pstmt, conn); } return consumptions; } public List<Consumption> selectConAllUser_nameLike(Consumption con) { conn=DBUtil.getConnection(); String sql="select * from consumption where user_name like ?"; List<Consumption> consumptions=new ArrayList<Consumption>(); try { PreparedStatement ps=conn.prepareStatement(sql); ps.setString(1, "%".concat(con.getUser_name()).concat("%")); rSet=ps.executeQuery(); while(rSet.next()){ Consumption d=new Consumption(); d.setUser_id(rSet.getInt("user_id")); d.setUser_name(rSet.getNString("user_name")); d.setUser_nickname(rSet.getString("user_nickname")); d.setUser_tel(rSet.getString("user_tel")); d.setConsumption_Time(rSet.getDate("consumption_Time")); d.setClothes_name(rSet.getString("clothes_name")); d.setNumber(rSet.getString("number")); d.setTotal(rSet.getString("total")); consumptions.add(d); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { DBUtil.close(rSet, pstmt, conn); } System.out.println("dao层con:"+con.getUser_name()); System.out.println("consumptions"+consumptions); return consumptions; } public List<Consumption> selectConAllClothes_nameLike(Consumption con) { conn=DBUtil.getConnection(); String sql="select * from consumption where clothes_name like ?"; List<Consumption> consumptions=new ArrayList<Consumption>(); try { PreparedStatement ps=conn.prepareStatement(sql); ps.setString(1, "%".concat(con.getClothes_name()).concat("%")); rSet=ps.executeQuery(); while(rSet.next()){ Consumption d=new Consumption(); d.setUser_id(rSet.getInt("user_id")); d.setUser_name(rSet.getNString("user_name")); d.setUser_nickname(rSet.getString("user_nickname")); d.setUser_tel(rSet.getString("user_tel")); d.setConsumption_Time(rSet.getDate("consumption_Time")); d.setClothes_name(rSet.getString("clothes_name")); d.setNumber(rSet.getString("number")); d.setTotal(rSet.getString("total")); consumptions.add(d); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { DBUtil.close(rSet, pstmt, conn); } return consumptions; } public List<Clothes> selectAllClothes() { List<Clothes> list=new ArrayList<Clothes>(); conn=DBUtil.getConnection(); String sql="select * from clothes"; try { PreparedStatement ps=conn.prepareStatement(sql); rSet=ps.executeQuery(); while(rSet.next()){ Clothes clothes=new Clothes(); clothes.setClothes_id(rSet.getString("clothes_id")); clothes.setClothes_name(rSet.getNString("clothes_name")); clothes.setType(rSet.getString("type")); clothes.setManufacturer_name(rSet.getString("manufacturer_name")); clothes.setPurchasePrice(rSet.getString("purchasePrice")); clothes.setPrice(rSet.getString("price")); clothes.setPicture(rSet.getString("picture")); clothes.setCode(rSet.getString("code")); clothes.setInventory(rSet.getString("inventory")); list.add(clothes); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return list; } public int deleteClothes(Clothes clothes) { int n=0; conn=DBUtil.getConnection(); String sql="delete from clothes where clothes_id=?"; try { PreparedStatement ps=conn.prepareStatement(sql); ps.setString(1, clothes.getClothes_id()); n=ps.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return n; } public int insertClothes(Clothes clothes) { int n=0; conn=DBUtil.getConnection(); String sql="insert into clothes value(?,?,?,?,?,?,?,?,?)"; try { PreparedStatement ps=conn.prepareStatement(sql); ps.setString(1, clothes.getClothes_id()); ps.setString(2, clothes.getClothes_name()); ps.setString(3, clothes.getType()); ps.setString(4, clothes.getManufacturer_name()); ps.setString(5, clothes.getPurchasePrice()); ps.setString(6, clothes.getPrice()); ps.setString(7, clothes.getPicture()); ps.setString(8, clothes.getCode()); ps.setString(9, clothes.getInventory()); n=ps.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return n; } public int deleteClothesAll(String string) { int n=0; conn=DBUtil.getConnection(); String sql="DELETE FROM clothes WHERE clothes_id=?"; try { PreparedStatement ps=conn.prepareStatement(sql); ps.setString(1, string); n=ps.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return n; } public Clothes selectClothesByClothes_id(String clothes_id) { conn=DBUtil.getConnection(); String sql="select * from clothes where clothes_id=?"; try { PreparedStatement ps=conn.prepareStatement(sql); ps.setString(1, clothes_id); rSet=ps.executeQuery(); if (rSet.next()) { c=new Clothes(); c.setClothes_id(rSet.getString("clothes_id")); c.setClothes_name(rSet.getString("clothes_name")); c.setType(rSet.getString("type")); c.setManufacturer_name(rSet.getString("manufacturer_name")); c.setPurchasePrice(rSet.getString("purchasePrice")); c.setPrice(rSet.getString("price")); c.setPicture(rSet.getString("picture")); c.setInventory(rSet.getString("inventory")); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return c; } public Clothes SelectClothesById(Clothes clothes) { conn=DBUtil.getConnection(); String sql="select * from clothes where clothes_id=?"; try { PreparedStatement ps=conn.prepareStatement(sql); ps.setString(1, clothes.getClothes_id()); rSet=ps.executeQuery(); if (rSet.next()) { c=new Clothes(); c.setClothes_id(rSet.getString("clothes_id")); c.setClothes_name(rSet.getString("clothes_name")); c.setType(rSet.getString("type")); c.setManufacturer_name(rSet.getString("manufacturer_name")); c.setPurchasePrice(rSet.getString("purchasePrice")); c.setPrice(rSet.getString("price")); c.setPicture(rSet.getString("picture")); c.setInventory(rSet.getString("inventory")); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return c; } public int updateClothes(Clothes clothes) { int n=0; conn=DBUtil.getConnection(); String sql="update clothes set