Code example for ResultSet

Methods: getDouble, getInt, getString, getTimestamp

0
 
	@Override 
	public CustomerObj extractData(ResultSet rs) throws SQLException, DataAccessException
	{ 
		CustomerObj customer = new CustomerObj();
		customer.setBillType(rs.getString("BillType"));
		customer.setCampaignCycleType(rs.getString("ProductGroupCycleType"));
		customer.setCreatedDate(rs.getTimestamp("CreatedDate"));
		customer.setCustomerPK(rs.getInt("CustomerPK"));
		customer.setCycleInDays(rs.getInt("CycleInDays"));
		customer.setEditedDate(rs.getTimestamp("EditedDate"));
		customer.setName(rs.getString("Name"));
		customer.setTotalTargetCycleBudget(rs.getDouble("TotalTargetCycleBudget"));
		 
		return customer;
		 
	} 
 
}