public Customer getRecord(String custId) {
		Customer cust = null;
		
		String sql = "SELECT * from Customer WHERE id=?";

		if(conn == null){
			boolean result = openConnection();
			if(result != true){
				logger.error("Unable to connect to the DB ");
				return cust;
			}
		}
		
		try {

			preparedStmt = conn.prepareStatement(sql);
			preparedStmt.setString(1, custId.trim());

			rs = preparedStmt.executeQuery();

			while (rs.next()) {
				cust = new Customer();
				cust.setId(rs.getString("id"));
				Name name = new Name();
				name.setFirst(rs.getString("first_name"));
				name.setLast(rs.getString("last_name"));
				cust.setName(name);
				cust.setEmail(rs.getString("email_id"));
				cust.setPhoneNumber(rs.getString("phone_number"));
			}

		} catch (SQLException e) {
			logger.error("SQLException: " + e.getMessage());
			logger.error("SQLState: " + e.getSQLState());
			logger.error("VendorError: " + e.getErrorCode());
		} finally {
			if(preparedStmt != null){
				try {
					preparedStmt.close();
				} catch (SQLException e) {
					logger.error("Error: Unable to close preparedStatement ");
					logger.error("SQLException: " + e.getMessage());
				}
			}
			if(rs != null){
				try {
					rs.close();
				} catch (SQLException e) {
					logger.error("Error: Unable to close ResultSet ");
					logger.error("SQLException: " + e.getMessage());
				}
			}
			
		}

		return cust;
	}