Skip to content

Instantly share code, notes, and snippets.

@brent-hoover
Created January 20, 2014 15:19
Show Gist options
  • Select an option

  • Save brent-hoover/8521761 to your computer and use it in GitHub Desktop.

Select an option

Save brent-hoover/8521761 to your computer and use it in GitHub Desktop.
Dynamic Mapping
private void loadRules(Map<String, Object> rules, ResultSet results) throws SQLException {
// create map to hold results
while(results.next()) {
DataType dataType
= new ReferenceTableEntryFactory<DataType>().createFromCode(results.getInt(4), DataType.values());
switch (dataType) {
case Boolean:
rules.put(results.getString(3), results.getBoolean(6));
break;
case TinyInt:
case SmallInt:
case Int:
rules.put(results.getString(3), results.getInt(6));
break;
case BigInt:
rules.put(results.getString(3), results.getLong(6));
break;
case VarChar:
rules.put(results.getString(3), results.getString(6));
break;
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment