284_Java物流管理系统.rar

package com.wuliu.imp; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.mysql.jdbc.Connection; import com.mysql.jdbc.Statement; import com.wuliu.DB.DBManager; import com.wuliu.bean.Carmassege; import com.wuliu.bean.Cartype; import com.wuliu.logicbusiness.PageDiv; import com.wuliu.manage.Carmassegemanager; public class ImpCarmassege implements Carmassegemanager { java.sql.Connection con = null; java.sql.Statement st = null; public ImpCarmassege() { con = DBManager.getConnection(); try { st = con.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } // 插入一条记录及加入一辆车 public void addCar(Carmassege carmassege) { String tradmark = carmassege.getTrademark(); String brand = carmassege.getBrand(); int style = carmassege.getStyle(); String carload = carmassege.getCarload(); String carstate = carmassege.getCarstate(); String drivername = carmassege.getDrivername(); String drivertime = carmassege.getDrivertime(); String licencenumber = carmassege.getLicencenumber(); String licencetype = carmassege.getLicencetype(); String linkman = carmassege.getLinkman(); String linkphone = carmassege.getLinkphone(); String remark = carmassege.getRemark(); String issuedate = carmassege.getIssuedate(); String username = carmassege.getUsername(); String sql = "insert into db_carmassege(tradmark,brand,style,carload,carstate,drivername,drivertime,licencenumber, licencetype, linkman,linkphone,remark,issuedate,username)values('" + tradmark + "','" + brand + "','" + style + "','" + carload + "','" + carstate + "','" + drivername + "','" + drivertime + "','" + licencenumber + "','" + licencetype + "','" + linkman + "','" + linkphone + "','" + remark + "','" + issuedate + "','" + username + "')"; try { st.execute(sql); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } //System.out.println("插入成功"); } // 根据ID删除一两车 public void deletecar(Carmassege carmassege) { int id = carmassege.getId(); String sql = "delete from db_carmassege where id=" + id; try { st.executeUpdate(sql); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } //System.out.println("删除成功"); } // 根据类型删除车 public void deletecar2(Cartype cartype) { int id = cartype.getId(); String sql = "delete from db_carmassege where style=" + id; try { st.executeUpdate(sql); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } //System.out.println("删除成功"); } // 根据ID取出一辆车 public Carmassege getUniqCar(Carmassege carmassege) { int id = carmassege.getId(); String sql = "select * from db_carmassege where id=" + id; try { java.sql.ResultSet rs = st.executeQuery(sql); while (rs.next()) { carmassege.setId(rs.getInt("id")); carmassege.setTrademark(rs.getString("tradmark")); carmassege.setBrand(rs.getString("brand")); carmassege.setStyle(rs.getInt("style")); carmassege.setCarload(rs.getString("carload")); carmassege.setCarstate(rs.getString("carstate")); carmassege.setDrivername(rs.getString("drivername")); carmassege.setDrivertime(rs.getString("drivertime")); carmassege.setLicencenumber(rs.getString("licencenumber")); carmassege.setLicencetype(rs.getString("licencetype")); carmassege.setLinkman(rs.getString("linkman")); carmassege.setLinkphone(rs.getString("linkphone")); carmassege.setRemark(rs.getString("remark")); carmassege.setIssuedate(rs.getString("issuedate")); carmassege.setUsername(rs.getString("username")); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } //System.out.println("查询成功"); return carmassege; } // 取出所有车辆 public List getcar() { List list = new ArrayList(); String sql = "select * from db_carmassege"; try { java.sql.ResultSet rs = st.executeQuery(sql); while (rs.next()) { Carmassege carmassege = new Carmassege(); carmassege.setId(rs.getInt("id")); carmassege.setTrademark(rs.getString("tradmark")); carmassege.setBrand(rs.getString("brand")); carmassege.setStyle(rs.getInt("style")); carmassege.setCarload(rs.getString("carload")); carmassege.setCarstate(rs.getString("carstate")); carmassege.setDrivername(rs.getString("drivername")); carmassege.setDrivertime(rs.getString("drivertime")); carmassege.setLicencenumber(rs.getString("licencenumber")); carmassege.setLicencetype(rs.getString("licencetype")); carmassege.setLinkman(rs.getString("linkman")); carmassege.setLinkphone(rs.getString("linkphone")); carmassege.setRemark(rs.getString("remark")); carmassege.setIssuedate(rs.getString("issuedate")); carmassege.setUsername(rs.getString("username")); list.add(carmassege); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } //System.out.println("查询成功"); return list; } // 根据类型取出车辆信息并分业 public List getcar2(Cartype cartype, PageDiv pageDiv) { int pageSize = 0;// 每页显示多少条记录 int currentPage = 0;// 当前页 int totalCount = 0;// 总记录条数 需要设置 int totalPage = 0;// 总共有多少页 需要设置 boolean hasNext = false;// 是否有下一页 需要设置 boolean hasPrevious = false;// 是否有上一页 需要设置 int startPage = 0;// 页面起始页 需要设置 int endPage = 0;// 页面终止页 需要设置 int viewPageCount = pageDiv.getViewPageCount(); // 一页几个公页。 List list = new ArrayList(); int id = cartype.getId(); pageSize = pageDiv.getPageSize();// 每页记录数 currentPage = pageDiv.getCurrentPage();// 当前页码 try { java.sql.ResultSet rs = st .executeQuery("select count(id) from db_carmassege where style=" + id); // 将指针移动到最后一行 rs.next(); // 得到总记录数 totalCount = rs.getInt(1); // 得到总页数 totalPage = (totalCount + pageSize - 1) / pageSize; if (totalPage > 0) { startPage = 1; } // 得到是否有后一页 if (currentPage >= 1 && currentPage < totalPage) { hasNext = true; } // 得到是否有前一页 if (currentPage > 1 && currentPage <= totalPage) { hasPrevious = true; } // 设置起始页 if (currentPage - viewPageCount / 2 <= 0) { startPage = 1; } else { startPage = currentPage - viewPageCount / 2; } // 设置终止页 if (totalPage <= currentPage + viewPageCount / 2) { endPage = totalPage; } else { endPage = currentPage + viewPageCount / 2; } pageDiv.setTotalCount(totalCount); pageDiv.setTotalPage(totalPage); pageDiv.setHasPrevious(hasPrevious); pageDiv.setStartPage(startPage); pageDiv.setEndPage(endPage); pageDiv.setHasNext(hasNext); // 得到作废的纪录数 int garbage = (currentPage - 1) * pageSize; // 将指针移动到第一行之前 rs = st.executeQuery("select * from db_carmassege where style=" + id + " order by id desc limit " + garbage + "," + pageSize); // 注意此行代码的格式。 for (int i = 1; i <= pageSize; i++) { while (rs.next()) { Carmassege carmassege = new Carmassege(); carmassege.setId(rs.getInt("id")); carmassege.setTrademark(rs.getString("tradmark")); carmassege.setBrand(rs.getString("brand")); carmassege.setStyle(rs.getInt("style")); carmassege.setCarload(rs.getString("carload")); carmassege.setCarstate(rs.getString("carstate")); carmassege.setDrivern