汽车租赁管理系统/carRentalSystem/src/com/bluedot/persist/impl/CustomerManagerDaoImpl.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.bluedot.persist.impl;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;
import java.util.ArrayList;
import java.util.List;

import oracle.jdbc.driver.OracleTypes;

import com.bluedot.common.Constants;
import com.bluedot.common.JdbcUtil;
import com.bluedot.domain.Customers;
import com.bluedot.domain.Page;
import com.bluedot.domain.Role;
import com.bluedot.domain.User;
import com.bluedot.exception.ApplicationException;
import com.bluedot.exception.DataAccessException;
import com.bluedot.persist.CustomerManagerDao;

public class CustomerManagerDaoImpl implements CustomerManagerDao {

	@Override
	public void addCustomer(Customers cust) {
		Connection conn = null;
		try{
			conn = JdbcUtil.getConnection();
			conn.setAutoCommit(false);
			PreparedStatement ps = conn.prepareStatement("insert into customers values(?,?,?,?,?,?,?)");
			ps.setString(1, cust.getIdentity());
			ps.setString(2, cust.getCustName());
			ps.setString(3, cust.getSex());
			ps.setString(4, cust.getAddress());
			ps.setString(5, cust.getPhone());
			ps.setString(6, cust.getCareer());
			ps.setString(7, cust.getCustPwd());
			ps.execute();
			conn.commit();
		}catch(SQLException e){
			e.printStackTrace();
			throw  new DataAccessException("用户已存在，请重新输入。");
		}catch(Exception e){
			e.printStackTrace();
			throw new ApplicationException();
		}finally{
			JdbcUtil.closeConn(conn);
		}

	}

	@Override
	public Page findCustomer(Customers cust, int pageIndex) {
		Connection conn = null;
		Page page  = new Page();
		List<Customers> list = new ArrayList<Customers>();
		try{
			conn = JdbcUtil.getConnection();