customerdao.java

中国移动管理系统

package com.chinamobile.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.chinamobile.bean.CustomerBean;

public class CustomerDAO {

	String find = "select * from TCustomer where ID_Type=? and ID_Number=?";

	public CustomerBean findCustomerByIdNumer(String ID_Type, String ID_Number) {
		CustomerBean customer = null;
		SQLServerDAOFactory dao = new SQLServerDAOFactory();
		Connection conn = dao.getConnection();
		ResultSet res = null;
		PreparedStatement pstmt = null;

		try {
			pstmt = conn.prepareStatement(find);
			pstmt.setString(1, ID_Type);
			pstmt.setString(2, ID_Number);
			res = pstmt.executeQuery();
			if (res.next()) {
				customer = new CustomerBean();
				customer.setCustomer_ID(res.getString(1));
				customer.setID_Type(res.getString(2));
				customer.setID_Number(res.getString(3));
				customer.setCustomer_Name(res.getString(4));
				customer.setCustomer_Birthday(res.getDate(5));
				customer.setCustomer_Sex(res.getString(6));
				customer.setCustomer_Address(res.getString(7));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			dao.closeConnection(conn);
			dao.closeResultSet(res);
			dao.closeStatement(pstmt);
		}

		return customer;
	}

}