JAVA汽车租赁管理系统源码含设计书

// Decompiled by Jad v1.5.8e2. Copyright 2001 Pavel Kouznetsov. // Jad home page: http://kpdus.tripod.com/jad.html // Decompiler options: packimports(3) fieldsfirst ansi space // Source File Name: OperatorManagerDaoImpl.java package com.bluedot.persist.impl; import com.bluedot.common.JdbcUtil; import com.bluedot.common.Tools; import com.bluedot.domain.Car; import com.bluedot.domain.CheckTable; import com.bluedot.domain.Customers; import com.bluedot.domain.Page; import com.bluedot.domain.Renttable; import com.bluedot.domain.User; import com.bluedot.exception.ApplicationException; import com.bluedot.exception.DataAccessException; import com.bluedot.persist.OperatorManagerDao; import java.sql.CallableStatement; import java.sql.Connection; import java.sql.Date; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; public class OperatorManagerDaoImpl implements OperatorManagerDao { public OperatorManagerDaoImpl() { } public Customers finCustomersByIdentity(String identity) { Connection conn; Customers cust; conn = null; cust = null; try { conn = JdbcUtil.getConnection(); PreparedStatement ps = conn.prepareStatement("select c.identity from customers c where c.identity = ?"); ps.setString(1, identity); for (ResultSet rs = ps.executeQuery(); rs.next(); cust.setIdentity(rs.getString("identity"))) cust = new Customers(); } catch (SQLException e) { e.printStackTrace(); throw new DataAccessException("操作失败，请重试！"); } catch (Exception e) { e.printStackTrace(); throw new ApplicationException(); } break MISSING_BLOCK_LABEL_114; Exception exception; exception; JdbcUtil.closeConn(conn); throw exception; JdbcUtil.closeConn(conn); return cust; } public List findAllCarByIsRenting() { Connection conn; List list; conn = null; list = new ArrayList(); try { conn = JdbcUtil.getConnection(); PreparedStatement ps = conn.prepareStatement("select c.carnumber,c.price from cars c where c.isrenting = '0'"); Car car; for (ResultSet rs = ps.executeQuery(); rs.next(); list.add(car)) { car = new Car(); car.setCarNumber(rs.getString("carnumber")); car.setPrice(rs.getDouble("price")); } } catch (SQLException e) { e.printStackTrace(); throw new DataAccessException("操作失败，请重试！"); } catch (Exception e) { e.printStackTrace(); throw new ApplicationException(); } break MISSING_BLOCK_LABEL_130; Exception exception; exception; JdbcUtil.closeConn(conn); throw exception; JdbcUtil.closeConn(conn); return list; } public void createRenttable(Renttable rent) { Connection conn = null; try { conn = JdbcUtil.getConnection(); conn.setAutoCommit(false); PreparedStatement ps = conn.prepareStatement("insert into renttable(tableid,imprest, shouldpayprice,price,begindate,shouldreturndate,rentflag,custid,carid,userid) values(?,?,?,?,?,?,?,?,?,?)"); ps.setLong(1, rent.getTableId()); ps.setDouble(2, rent.getImprest()); ps.setDouble(3, rent.getShouldPayPrice()); ps.setDouble(4, rent.getPrice()); ps.setDate(5, new Date(rent.getBeginDate().getTime())); ps.setDate(6, new Date(rent.getShouldReturnDate().getTime())); ps.setInt(7, rent.getRentFlag()); ps.setString(8, rent.getCust().getIdentity()); ps.setString(9, rent.getCar().getCarNumber()); ps.setString(10, rent.getUser().getUserName()); ps.execute(); PreparedStatement ps2 = conn.prepareStatement("update cars c set c.isrenting = 1 where c.carnumber = ?"); ps2.setString(1, rent.getCar().getCarNumber()); ps2.execute(); conn.commit(); } catch (SQLException e) { e.printStackTrace(); throw new DataAccessException("操作失败，请重试！"); } catch (Exception e) { e.printStackTrace(); throw new ApplicationException(); } break MISSING_BLOCK_LABEL_252; Exception exception; exception; JdbcUtil.closeConn(conn); throw exception; JdbcUtil.closeConn(conn); return; } public Renttable findRenttableByTableId(long tableId) { Connection conn; Renttable rent; conn = null; rent = null; try { conn = JdbcUtil.getConnection(); PreparedStatement ps = conn.prepareStatement("select u.username,r.tableid,r.imprest,r.shouldpayprice,r.price,r.begindate,r.shouldreturndate,r.returndate,r.rentflag ,c.carnumber,c.cartype,c.color,c.price as carprice,c.rentprice,c.deposit,c.isrenting,c.cardesc,cust.identity,cust.custname,cust.sex,cust.address,cust.phone,cust.career,cust.custpwd from users u,renttable r,cars c,customers cust where u.username = r.userid and r.carid = c.carnumber and r.custid = cust.identity and r.tableid = ? "); ps.setLong(1, tableId); Car car; for (ResultSet rs = ps.executeQuery(); rs.next(); rent.setCar(car)) { rent = new Renttable(); User user = new User(); user.setUserName(rs.getString("username")); rent.setUser(user); rent.setTableId(rs.getLong("tableid")); rent.setImprest(rs.getDouble("imprest")); rent.setShouldPayPrice(rs.getDouble("shouldpayprice")); rent.setPrice(rs.getDouble("price")); rent.setBeginDate(new java.util.Date(rs.getDate("begindate").getTime())); rent.setShouldReturnDate(new java.util.Date(rs.getDate("shouldreturndate").getTime())); rent.setRentFlag(rs.getInt("rentflag")); if (rs.getDate("returndate") != null) rent.setReturnDate(new java.util.Date(rs.getDate("returndate").getTime())); Customers cust = new Customers(); cust.setIdentity(rs.getString("identity")); cust.setCustName(rs.getString("custname")); cust.setSex(rs.getString("sex")); cust.setAddress(rs.getString("address")); cust.setPhone(rs.getString("phone")); cust.setCareer(rs.getString("career")); rent.setCust(cust); car = new Car(); car.setCarNumber(rs.getString("carnumber")); car.setCarType(rs.getString("cartype")); car.setColor(rs.getString("color")); car.setPrice(rs.getDouble("carprice")); car.setRentPrice(rs.getDouble("rentprice")); car.setDeposit(rs.getDouble("deposit")); car.setIsRenting(rs.getString("isrenting")); car.setCardesc(rs.getString("cardesc")); } } catch (SQLException e) { e.printStackTrace(); throw new DataAccessException("操作失败，请重试！"); } catch (Exception e) { e.printStackTrace(); throw new ApplicationException(); } break MISSING_BLOCK_LABEL_534; Exception exception; exception; JdbcUtil.closeConn(conn); throw exception; JdbcUtil.closeConn(conn); return rent; } public void createCheckTable(CheckTable ct) { Connection conn = null; try { conn = JdbcUtil.getConnection(); conn.setAutoCommit(false); PreparedStatement ps = conn.prepareStatement("insert into checktable values(?,?,?,?,?,?,?)"); ps.setLong(1, ct.getCheckId()); ps.setDate(2, new Date(ct.getCheckDate().getTime())); ps.setString(3, ct.getField()); ps.setString(4, ct.getProblem()); ps.setDouble(5, ct.getPaying()); ps.setString(6, ct.getUser().getUserName()); ps.setLong(7, ct.getRentTable().getTableId()); ps.execute(); PreparedStatement ps2 = conn.prepareStatement("update cars c set c.isrenting = 0 where c.carnumber = ?"); ps2.setString(1, ct.getRentTable().getCar().getCarNumber()); ps2.execute(); PreparedStatement ps3 = conn.prepareStatement("update renttable r set r.rentflag = 1 ,r.returndate = ? where r.tableid = ?"); ps3.setDate(1, new Date(ct.getCheckDate().getTime())); ps3.setLong(2, ct.getRentTable().getTableId()); ps3.execute(); conn.commit(); } catch (SQLException e) { e.printStackTrace(); throw new DataAccessException("操作失败，请重试！")