jsp.rar

package project.dao.imp; import project.dao.DeviceDao; import project.db.Dbconn; import project.entity.Device; import project.entity.Lend; import java.sql.ResultSet; import java.sql.SQLException; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import java.util.List; public class DeviceDaoImp implements DeviceDao { @Override public Device searchone(String id) { Device device = new Device(); try { Dbconn.init(); ResultSet rs = Dbconn.selectSql("select * from electric where tid="+id); while (rs.next()){ device.setTid(id); device.setT_num(rs.getString("t_num")); device.setLends(rs.getString("lends")); device.setName(rs.getString("name")); device.setIsimg(rs.getString("isimg")); } Dbconn.closeConn(); return device; }catch (SQLException e ){ e.printStackTrace(); } return null; } @Override public List<Device> searchall() { List<Device> list = new ArrayList<>(); try { Dbconn.init(); ResultSet rs = Dbconn.selectSql("select * from electric"); while (rs.next()){ Device device = new Device(); device.setTid(rs.getString("tid")); device.setName(rs.getString("name")); device.setT_num(rs.getString("t_num")); device.setLends(rs.getString("lends")); device.setIsimg(rs.getString("isimg")); list.add(device); } Dbconn.closeConn(); return list; }catch (SQLException e){ e.printStackTrace(); } return null; } @Override public boolean updateDe(String tid, String name, String t_num, String lends) { boolean flag = false; Dbconn.init(); String sql= "update electric set name='"+name +"' , t_num='"+t_num +"' , lends='"+lends +"' where tid="+tid; int i = Dbconn.addUpdDel(sql); if(i>0){ flag = true; } Dbconn.closeConn(); return flag; } @Override public boolean borrow(String tid, String id) { boolean flag = false; Dbconn.init(); SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//设置日期格式 String date = df.format(new Date()); int i = Dbconn.addUpdDel("insert into lend(sid,tid,create_time) "+ "values('"+id+"','"+tid+"','"+date+"')"); if (i>0){ Device device = new Device(); device = searchone(tid); int lends = Integer.parseInt(device.getLends()); lends++; boolean j = lend(tid,lends); if (j){ flag = true; } } Dbconn.closeConn(); return flag; } @Override public boolean lend(String tid, int lends) { Dbconn.init(); boolean flag= false; int i = Dbconn.addUpdDel("update electric set lends='"+Integer.toString(lends) +"' where tid="+tid); if (i>0){ flag = true; } Dbconn.closeConn(); return flag; } @Override public List<Lend> searchlend(String sid) { List<Lend> list = new ArrayList<>(); try { Dbconn.init(); ResultSet rs = Dbconn.selectSql("select * from lend where sid="+sid); while (rs.next()){ Lend lend = new Lend(); lend.setId(rs.getInt("id")); lend.setTid(rs.getString("tid")); lend.setSid(sid); lend.setType(rs.getString("type")); lend.setCreate_time(rs.getTimestamp("create_time")); lend.setUpdate_time(rs.getTimestamp("update_time")); list.add(lend); } Dbconn.closeConn(); return list; }catch (SQLException e){ e.printStackTrace(); } return null; } @Override public boolean add(Device device) { boolean flag= false; Dbconn.init(); int i = Dbconn.addUpdDel("insert into electric(tid,name,t_num) " + "values ('"+device.getTid()+"','"+device.getName()+"','"+device.getT_num()+"')"); if (i>0){ flag = true; } return flag; } @Override public boolean repay(int id,String tid) { boolean flag = false; Dbconn.init(); String sql = "update lend set type = '1' where id="+id; int i = Dbconn.addUpdDel(sql); if (i>0){ Device device = new Device(); device = searchone(tid); int lends = Integer.parseInt(device.getLends()); lends--; boolean j = lend(tid,lends); if (j){ flag = true; } } Dbconn.closeConn(); return flag; } @Override public List<Lend> searchalllend() { List<Lend> list = new ArrayList<>(); try { Dbconn.init(); ResultSet rs = Dbconn.selectSql("select * from lend "); while (rs.next()){ Lend lend = new Lend(); lend.setId(rs.getInt("id")); lend.setTid(rs.getString("tid")); lend.setSid(rs.getString("sid")); lend.setType(rs.getString("type")); lend.setCreate_time(rs.getTimestamp("create_time")); lend.setUpdate_time(rs.getTimestamp("update_time")); list.add(lend); } Dbconn.closeConn(); return list; }catch (SQLException e){ e.printStackTrace(); } return null; } @Override public boolean delete(String tid) { boolean flag=false; Dbconn.init(); int i = Dbconn.addUpdDel("delete from electric where tid="+tid); Dbconn.closeConn(); if(i>0){ flag=true; } return flag; } @Override public Lend searchonelend(String sid, String tid) { Lend lend = new Lend(); try { Dbconn.init(); ResultSet rs = Dbconn.selectSql("select * from lend where sid="+sid+" and tid="+tid+" and type='0'"); while (rs.next()){ lend.setId(rs.getInt("id")); lend.setTid(tid); lend.setSid(sid); lend.setType(rs.getString("type")); lend.setCreate_time(rs.getTimestamp("create_time")); lend.setUpdate_time(rs.getTimestamp("update_time")); } Dbconn.closeConn(); return lend; }catch (SQLException e){ e.printStackTrace(); } return null; } @Override public boolean updateisimg(String id) { boolean flag = false; Dbconn.init(); String sql= "update electric set isimg='1' where tid="+id; int i = Dbconn.addUpdDel(sql); if(i>0){ flag = true; } Dbconn.closeConn(); return flag; } }