javaweb服装仓库管理系统

package com.Dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.bean.ClothesBean; import com.bean.input; import com.bean.input_information; import com.bean.output; import com.bean.output_information; import com.bean.warehouseManager; import com.mysql.jdbc.ResultSet; import com.mysql.jdbc.Statement; public class DBoperate { //////////////////////////////////////////////用户/////////////////////////////////////////// //查找用户名和密码是否存在，且状态为no public boolean FindUser(String username,String password){ Connection conn = null; Statement stmt = null; ResultSet rs = null; boolean flag = false; try{ conn = DBConnection.initDB(); stmt = (Statement) conn.createStatement(); String sql = ("select * from warehouseManager where username="+"'"+username+"'"+" and password="+"'"+password+"' and status='no'"); rs = (ResultSet) stmt.executeQuery(sql); if(rs.next()){ //System.out.println("进入查找if"); flag= true; //System.out.println(flag); } else { //System.out.println("进入查找else"); flag= false; } } catch(Exception e ){ e.printStackTrace(); } //System.out.println("最终的flag为："+flag); return flag; } //查找用户名是否存在（包括被删除的） public boolean FindUserName(String username){ Connection conn = null; Statement stmt = null; ResultSet rs = null; boolean flag=false; try{ conn = DBConnection.initDB(); stmt = (Statement) conn.createStatement(); String sql = ("select * from warehouseManager where username="+"'"+username+"'"); rs = (ResultSet) stmt.executeQuery(sql); if(rs.next()){ //System.out.println("进入if"); flag = true; } else { //System.out.println("进入else"); flag=false; } } catch(Exception e ){ e.printStackTrace(); } //System.out.println("最终的flag为："+flag); return flag; } public int AddUser(String username,String password,String phone,String status){ //增加用户 Connection conn = null; Statement stmt = null; ResultSet rs = null; try{ conn = DBConnection.initDB(); stmt = (Statement) conn.createStatement(); if(FindUserName(username)==true){ //System.out.println("user exist"); } else{ String sql="insert into warehouseManager(username,password,phone,status) " + "values('"+username+"','"+password+"','"+phone+"','"+status+"')"; stmt.executeUpdate(sql); } }catch(Exception e){ e.printStackTrace(); } return 0; } public int deleteUser(String username) {//删除用户 Connection conn = null; Statement stmt = null; ResultSet rs = null; try{ conn = DBConnection.initDB(); stmt = (Statement) conn.createStatement(); //软删除，将用户表中的状态status改为yes String sql=("update warehouseManager set status = 'yes' where username="+"'"+username+"'"); stmt.executeUpdate(sql); }catch(Exception e){ e.printStackTrace(); } return 0; } //修改用户 public int updateUser(String username, String password, String phone, String status) { Connection conn = null; Statement stmt = null; ResultSet rs = null; try{ conn = DBConnection.initDB(); stmt = (Statement) conn.createStatement(); //更新除了书籍号和上架时间之外的书籍表中的其他所有属性 String sql=("update warehouseManager set " + "password="+"'"+password+"'" + ",phone="+"'"+phone+"'" + ",status="+"'"+status+"'"+" where username="+"'"+username+"'"); stmt.executeUpdate(sql); // rs.close(); // stmt.close(); // conn.close(); }catch(Exception e){ e.printStackTrace(); } return 0; } public List<warehouseManager> findUser() { List<warehouseManager> list = new ArrayList<>(); //创建List try{ Connection conn = DBConnection.initDB(); Statement stmt = (Statement) conn.createStatement(); String sql = ("select * from warehouseManager"); ResultSet rs = (ResultSet) stmt.executeQuery(sql); //List<warehouseManager> list = new ArrayList<>(); while(rs.next()){ warehouseManager user = new warehouseManager(); //实例化user对象 user.setUsername(rs.getString("username")); //对用户号赋值 user.setPassword(rs.getString("password")); //对密码赋值 user.setPhone(rs.getString("phone")); //对电话号码赋值 user.setStatus(rs.getString("status")); //对状态赋值 list.add(user); } rs.close(); stmt.close(); conn.close(); } catch(Exception e ){ e.printStackTrace(); } //请求转发到timeOFupload.jsp //request.getRequestDispatcher("selectUser.jsp").forward(request, response); return list; } /*public boolean FindUserStatus(String username){ //根据用户名查询用户状态 boolean flag= false; try{ Connection conn = DBConnection.initDB(); Statement stmt = (Statement) conn.createStatement(); String sql = ("select status from warehouseManager where username="+"'"+username+"'"); ResultSet rs = (ResultSet) stmt.executeQuery(sql); while(rs.next()){ String status = rs.getString(1); //System.out.println(status); if(status.equals("no")) { flag = false; } else {flag = true;} } // rs.close(); // stmt.close(); // conn.close(); } catch(Exception e ){ e.printStackTrace(); } return flag; } */ //////////////////////////////////////////////服装/////////////////////////////////////////// public boolean findclothes(String clothes_number){ //查找服装号是否存在 boolean flag=false; try{ Connection conn = null; Statement stmt = null; ResultSet rs = null; conn=DBConnection.initDB(); stmt = (Statement) conn.createStatement(); String sql = ("select * from clothes where clothes_number="+"'"+clothes_number+"'"); rs = (ResultSet) stmt.executeQuery(sql); while(rs.next()){ flag = true; } rs.close(); conn.close(); stmt.close(); } catch(Exception e ){ e.printStackTrace(); } return flag; } public boolean ClothesStatus(String clothes_number) { boolean flag=false; Connection conn = null; Statement stmt = null; ResultSet rs = null; try { conn=DBConnection.initDB(); stmt = (Statement) conn.createStatement(); String sql = ("select status from clothes where clothes_number="+"'"+clothes_number+"'"); rs = (ResultSet) stmt.executeQuery(sql); while(rs.next()) { String status=rs.getString("status"); if(status.equals("yes")) { flag=true; } } //System.out.println(rs.getString("status")); }catch(Exception e) { e.printStackTrace(); } return flag; } public void AddClothes(ClothesBean clothes) { try{ Connection conn = null; Statement stmt = null; conn=DBConnection.initDB(); stmt = (Statement) conn.createStatement(); // String clothes_number=clothes.getClothes_numbe