rentdao.java

设备租赁系统

package dal;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import common.JdbcUtil;
import domain.Rent;

public class RentDao {
	private Connection conn = null;
	private Log log = LogFactory.getLog(RentDao.class);
	public RentDao(){
		conn = JdbcUtil.getConnection();
	}
	/**
	 * 鎻掑叆鏁版嵁
	 * @param r
	 * @return
	 */
	public boolean insertDb(Rent r){
		boolean flag = false;
		PreparedStatement stat = null;
		try {
			conn.setAutoCommit(false);
			String insertsql = "insert rent(devicename,deviceId,rentuserId,rentuserName,rentphone,leaseuserId,leaseuserName,leasephone,renttime,backtime,shouldbacktime,renthire,rentdeposit,rentDesc,rentflag,RentCode,allprice)" +
					" values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
			stat = conn.prepareStatement(insertsql);
			stat.setString(1, r.getDevicename());
			stat.setInt(2, r.getDeviceId());
			stat.setInt(3, r.getRentuserId());
			stat.setString(4, r.getRentuserName());
			stat.setString(5, r.getRentphone());
			stat.setInt(6, r.getLeaseuserId());
			stat.setString(7, r.getLeaseuserName());
			stat.setString(8, r.getLeasephone());
			stat.setTimestamp(9, r.getRenttime());
			stat.setTimestamp(10, r.getBacktime());
			stat.setTimestamp(11, r.getShouldbacktime());
			stat.setDouble(12, r.getRenthire());
			stat.setDouble(13, r.getRentdeposit());
			stat.setString(14, r.getRentDesc());
			stat.setInt(15, r.getRentflag());
			stat.setString(16, r.getRentCode());
			stat.setDouble(17, r.getAllprice());
			
			int i = stat.executeUpdate();
			if (i == 1) {
				conn.commit();
				flag = true;
			} else {
				JdbcUtil.BackDb(conn);
			}
		} catch (SQLException e) {
			log.error(e);
			JdbcUtil.BackDb(conn);
			e.printStackTrace();

		} catch (Exception e) {
			log.fatal(e);
			e.printStackTrace();
		} finally {
			JdbcUtil.ShutDownDB(conn);
		}
		return flag;
	}
	/**
	 * 鍒犻櫎浠ｇ爜
	 * @param r
	 * @return
	 */
	public boolean deleteDB(Rent r){
		PreparedStatement stat = null;
		boolean flag = false;
		String sql = "delete from rent where rentId=" + r.getRentId();
		try {
			conn.setAutoCommit(false);
			stat = conn.prepareStatement(sql);
			int m = stat.executeUpdate();
			if (m == 1) {
				conn.commit();
				flag = true;
			} else {
				JdbcUtil.BackDb(conn);
			}
		} catch (SQLException e) {
			log.error(e);
			JdbcUtil.BackDb(conn);
			e.printStackTrace();
		} catch (Exception e) {
			log.fatal(e);
			e.printStackTrace();
		} finally {
			JdbcUtil.ShutDownDB(conn);
		}
		return flag;
		
	}
	public Rent SelectRent(int id){
		Rent r=new Rent();
		PreparedStatement stat = null;
		ResultSet set = null;
		String sql = "select rentid,devicename," +
				"deviceId,rentuserId,rentuserName," +
				"rentphone,leaseuserId,leaseuserName," +
				"leasephone,renttime,backtime," +
				"shouldbacktime,renthire," +
				"rentdeposit,rentDesc,rentflag," +
				"RentCode,allprice from rent where rentId=" + id;
		try {
			stat = conn.prepareStatement(sql);
			set = stat.executeQuery();
			while (set.next()) {
				r.setRentId(set.getInt("rentid"));
				r.setDeviceId(set.getInt("deviceId"));
				r.setDevicename(set.getString("devicename"));
				r.setRentuserId(set.getInt("rentuserId"));
				r.setRentuserName(set.getString("rentuserName"));
				r.setRentphone(set.getString("rentphone"));
				r.setLeaseuserId(set.getInt("leaseuserId"));
				r.setLeaseuserName(set.getString("leaseuserName"));
				r.setLeasephone(set.getString("leasephone"));
				r.setRenttime(set.getTimestamp("renttime"));
				r.setBacktime(set.getTimestamp("backtime"));
				r.setShouldbacktime(set.getTimestamp("shouldbacktime"));
				r.setRenthire(set.getDouble("renthire"));
				r.setRentdeposit(set.getDouble("rentdeposit"));
				r.setRentDesc(set.getString("rentDesc"));
				r.setRentflag(set.getInt("rentflag"));
				r.setRentCode(set.getString("RentCode"));
				r.setAllprice(set.getDouble("allprice"));
			}
		} catch (SQLException e) {
			log.error(e);
			e.printStackTrace();
		} catch (Exception e) {
			log.fatal(e);
			e.printStackTrace();
		} finally {
			JdbcUtil.ShutDownDB(conn);
		}
		return r;
	}
	public List<Rent> SelectRent(String condiction){
		List<Rent> rl=new ArrayList<Rent>();
		PreparedStatement stat = null;
		ResultSet set = null;
		String sql = "select rentid,devicename," +
				"deviceId,rentuserId,rentuserName," +
				"rentphone,leaseuserId,leaseuserName," +
				"leasephone,renttime,backtime," +
				"shouldbacktime,renthire," +
				"rentdeposit,rentDesc,rentflag," +
				"RentCode,allprice from rent where 1=1";
		if(condiction!=null&&!"".equals(condiction)){
			sql=sql+condiction;
		}
		try {
			stat = conn.prepareStatement(sql);
			set = stat.executeQuery();
			while (set.next()) {
				Rent r=new Rent();
				r.setRentId(set.getInt("rentid"));
				r.setDeviceId(set.getInt("deviceId"));
				r.setDevicename(set.getString("devicename"));
				r.setRentuserId(set.getInt("rentuserId"));
				r.setRentuserName(set.getString("rentuserName"));
				r.setRentphone(set.getString("rentphone"));
				r.setLeaseuserId(set.getInt("leaseuserId"));
				r.setLeaseuserName(set.getString("leaseuserName"));
				r.setLeasephone(set.getString("leasephone"));
				r.setRenttime(set.getTimestamp("renttime"));
				r.setBacktime(set.getTimestamp("backtime"));
				r.setShouldbacktime(set.getTimestamp("shouldbacktime"));
				r.setRenthire(set.getDouble("renthire"));
				r.setRentdeposit(set.getDouble("rentdeposit"));
				r.setRentDesc(set.getString("rentDesc"));
				r.setRentflag(set.getInt("rentflag"));
				r.setRentCode(set.getString("RentCode"));
				r.setAllprice(set.getDouble("allprice"));
				
				rl.add(r);
			}
		} catch (SQLException e) {
			log.error(e);
			e.printStackTrace();
		} catch (Exception e) {
			log.fatal(e);
			e.printStackTrace();
		} finally {
			JdbcUtil.ShutDownDB(conn);
		}
		return rl;
	}
	public boolean updataFlag(Rent r){
		boolean flag = false;
		PreparedStatement stat = null;
		try {
			conn.setAutoCommit(false);
			String insertsql = "update rent set rentflag=?,backtime=?,allprice=? where rentId=?";
			stat = conn.prepareStatement(insertsql);
			stat.setInt(1, 1);
			stat.setTimestamp(2, r.getBacktime());
			stat.setDouble(3, r.getAllprice());
			stat.setInt(4, r.getRentId());
			int i = stat.executeUpdate();
			if (i == 1) {
				conn.commit();
				flag = true;
			} else {
				JdbcUtil.BackDb(conn);
			}
		} catch (SQLException e) {
			log.error(e);
			JdbcUtil.BackDb(conn);
			e.printStackTrace();

		} catch (Exception e) {
			log.fatal(e);
			e.printStackTrace();
		} finally {
			JdbcUtil.ShutDownDB(conn);
		}
		return flag;
	}
	public boolean updataDB(Rent r){
		boolean flag = false;
		PreparedStatement stat = null;
		try {
			conn.setAutoCommit(false);
			String insertsql = "update rent set devicename=?,deviceId=?,rentuserId=?," +
					"rentuserName=?,rentphone=?,leaseuserId=?,leaseuserName=?," +
					"leasephone=?,renttime=?,backtime=?,shouldbacktime=?,renthire=?,rentdeposit=?," +
					"rentDesc=?,rentflag=?,RentCode=?,allprice=? where rentId=?";
			stat = conn.prepareStatement(insertsql);
			stat.setString(1, r.getDevicename());
			stat.setInt(2, r.getDeviceId());
			stat.setInt(3, r.getRentuserId());
			stat.setString(4, r.getRentuserName());
			stat.setString(5, r.getRentphone());
			stat.setInt(6, r.getLeaseuserId());
			stat.setString(7, r.getLeaseuserName());
			stat.setString(8, r.getLeasephone());
			stat.setTimestamp(9, r.getRenttime());
			stat.setTimestamp(10, r.getBacktime());
			stat.setTimestamp(11, r.getShouldbacktime());
			stat.setDouble(12, r.getRenthire());
			stat.setDouble(13, r.getRentdeposit());
			stat.setString(14, r.getRentDesc());
			stat.setInt(15, r.getRentflag());
			stat.setString(16, r.getRentCode());
			stat.setDouble(17, r.getAllprice());
			stat.setInt(18, r.getRentId());
			int i = stat.executeUpdate();
			if (i == 1) {
				conn.commit();
				flag = true;
			} else {
				JdbcUtil.BackDb(conn);
			}
		} catch (SQLException e) {
			log.error(e);
			JdbcUtil.BackDb(conn);
			e.printStackTrace();

		} catch (Exception e) {
			log.fatal(e);
			e.printStackTrace();
		} finally {
			JdbcUtil.ShutDownDB(conn);
		}
		return flag;
	}
	
}