物资借用管理信息系统源代码

package iLend.reback.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.Arrays; import java.util.Comparator; import java.util.List; import iLend.reback.bean.*; import iLend.util.DBUtil1; public class BorrowDao { //更新 表数据 public int updateRs(int id,String backtime,String picname) { Connection conn = DBUtil1.getConnectDb(); String sql = "update ilend_borrow set realBackTime='"+backtime+"'" + " ,oPic='"+picname+"', rs=0 where oNumber="+id; PreparedStatement stm = null; int f=0; System.out.println(sql); try { stm=conn.prepareStatement(sql); f=stm.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return f; } public int updateRS(int id) { // TODO Auto-generated method stub Connection conn = DBUtil1.getConnectDb(); String sql = "update ilend_borrow set rs=1 where oNumber="+id; PreparedStatement stm = null; int f=0; System.out.println(sql); try { stm=conn.prepareStatement(sql); f=stm.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return f; } public GoodsBean detailGoods(String gNumber) { // TODO Auto-generated method stub Connection conn = DBUtil1.getConnectDb(); String sql = "select * from iLend_goods where gNumber="+gNumber; PreparedStatement stm = null; ResultSet rs = null; GoodsBean tag = null; try { stm = conn.prepareStatement(sql); rs = stm.executeQuery(); if(rs.next()){ tag = new GoodsBean(); tag.setgNumber(rs.getString("gNumber")); tag.setgType(rs.getString("gType")); tag.setgCondition(rs.getString("gCondition")); tag.setgState(rs.getString("gState")); tag.setgIn(rs.getString("gDepartment")); tag.setgPic(rs.getString("gPic")); tag.setgRemark(rs.getString("gRemark")); tag.setPc(rs.getString("gDepartment")); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ DBUtil1.CloseDB(rs, stm, conn); } return tag; } public List<GoodsBean> getGoods() { // TODO Auto-generated method stub List<GoodsBean> ls=new ArrayList<GoodsBean>(); Connection conn = DBUtil1.getConnectDb(); String sql = "select * from iLend_goods"; PreparedStatement stm = null; ResultSet rs = null; GoodsBean tag = null; try { stm = conn.prepareStatement(sql); rs = stm.executeQuery(); while(rs.next()){ tag = new GoodsBean(); tag.setgNumber(rs.getString("gNumber")); tag.setgType(rs.getString("gType")); tag.setgCondition(rs.getString("gCondition")); tag.setgState(rs.getString("gState")); tag.setgIn(rs.getString("gDepartment")); tag.setgPic(rs.getString("gPic")); tag.setgRemark(rs.getString("gRemark")); tag.setPc(rs.getString("gDepartment")); ls.add(tag); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ DBUtil1.CloseDB(rs, stm, conn); } return ls; } //获得top public List<Top> getTop(String ustu){ List<Top> ls=new ArrayList<>(); List<Borrow> ab = this.getAllBorrows(); Top t=null; Borrow b=null; List<GoodsBean> GS = getGoods(); //先找出所有的good for(int i=0;i<GS.size();i++) { t=new Top(); int fs=0; GoodsBean s= GS.get(i); for(int j=0;j<ab.size();j++) { b=ab.get(j); if(s.getgNumber().equals(b.getgNumber())) { fs++; } } t.setName(s.getgType()); t.setOut(s.getPc()); t.setCs(fs); ls.add(t); } //然后一个一个匹配 //对数字进行排列 Integer[] af=new Integer[ls.size()]; for(int ii=0;ii<ls.size();ii++) { af[ii]=ls.get(ii).getCs(); } Comparator<Integer> cmp = new Comparator<Integer>() { public int compare(Integer i1, Integer i2) { return i2-i1; } }; Arrays.sort(af, cmp); int[] gd=new int[ls.size()]; int d=0; ArrayList<Integer> rd=new ArrayList<>(); for(int i=0;i<af.length;i++) { int s=af[i]; //都要找到这个对应的值 boolean w=true; for(int f=0;f<ls.size();f++) { w=true; for(int e=0;e<rd.size();e++) { if(f==rd.get(e)) { w=false; } } if(w) { int g=ls.get(f).getCs(); if(s==g) { gd[d]=f; rd.add(f); break; } } } d++; } List<Top> lss=new ArrayList<>(); for(int fg=0;fg<ls.size();fg++) { Top t2 = ls.get(af[fg]); t2.setCs(ls.get(gd[fg]).getCs()); lss.add(fg, t2); } /* HashSet<String> f=new HashSet<String>(); //借用 List<Borrow> a = this.getAllBorrowsBystuNumber(ustu); for(int i=0;i<a.size();i++) { b=a.get(i); String n = b.getgNumber(); f.add(n); } for (String obj: f) { t=new Top(); int fs=0; for(int i=0;i<a.size();i++) { String n = b.getgNumber(); if(obj.equals(n)) { fs++; } } //查看good GoodsBean d = detailGoods(obj); t.setName(d.getgType()); t.setOut(d.getPc()); t.setCs(fs); ls.add(t); }*/ return lss; } //查找所有的 public List<Borrow> getAllBorrows(){ List<Borrow> ls=new ArrayList<>(); Borrow b=null; Connection conn = DBUtil1.getConnectDb(); String sql = "select * from ilend_borrow "; PreparedStatement stm = null; ResultSet rs = null; try { stm = conn.prepareStatement(sql); rs = stm.executeQuery(); while(rs.next()){ int oNumber = rs.getInt(1); String stuNumber = rs.getString(2); int int1 = rs.getInt(3); String string = rs.getString(4); String string2 = rs.getString(5); String string3 = rs.getString(6); String string4 = rs.getString(7); String string5 = rs.getString(8); String string6 = rs.getString(9); String string7 = rs.getString(10); String string8 = rs.getString(11); int int2 = rs.getInt(12); String string9 = rs.getString(13); String pic = rs.getString(14); //是否超时 g 为归还时间2018-10-09 j为借还时间2018-10-09 //j=string6 g=string7 int d=Utils.getOdate(string7, string6); boolean a =true; if(d==0) { a=false; } String rs2 = rs.getString(16); b=new Borrow(oNumber+"",stuNumber,int1+"", string,string2,string3,string4 ,string5,string6,string7,string8,int2+"", string9,pic,d,a,rs2 ); ls.add(b); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ DBUtil1.CloseDB(rs, stm, conn); } return ls; } /** * 管理员使用 */ //查找未归还的订单 public List<Borrow> getAllBorrowing(){ List<Borrow> a = this.getAllBorrows(); List<Borrow> ls=new ArrayList<>(); for(int i=0;i<a.size();i++) { Borrow b =a.get(i); if(b.getRealBackTime()==null) { //没有归还时间说明还没有还，那么就是在借状态中 //搜索对应的name属性 ls.add(b); } } return ls; } /** * 管理员中心 */ public AdminBorrow getAdminBorrow() { List<Borrow> a = this.getAllBorrows(); AdminBorrow u =new AdminBorrow(); u.setAbNumber(a.size());//统计多少件 //统计归还了多少件 int abing=0; int ad=0;//统计正在申请归还的物品件数 for(int i=0;i<a.size();i++) { Borrow b =a.get(i); if(b.getRealBackTime()!=null) { //没有归还时间说明还没有还，那么就是在借状态中 abing++; if("0".equals(b.getRs())) { //申请归还状态 ad++; } } } u.setRNumber(abing); u.setSRNumber(ad); return u; } //获