public static void testFind() { DataSource dataSource = getDataSource(); JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource); String sql = "select * from (select * from qpf_data_source) where 1=0"; List<KeyValue<String, String>> list = jdbcTemplate.query(sql, new ResultSetExtractor<List<KeyValue<String, String>>>() { @Override public List<KeyValue<String, String>> extractData( ResultSet rs) throws SQLException, DataAccessException { ResultSetMetaData metaData = rs.getMetaData(); int count = metaData.getColumnCount(); List<KeyValue<String, String>> l = new ArrayList<KeyValue<String, String>>(); for (int i = 0; i < count; i++) { String fieldName = metaData.getColumnName(i + 1).toLowerCase(); int type = metaData.getColumnType(i + 1); String typeName = metaData.getColumnTypeName(i + 1).toLowerCase(); System.out.println(fieldName + " : " + type + " : " + typeName); l.add(new KeyValue<String, String>(fieldName, typeName)); } return l; } }); for (KeyValue<String, String> obj : list) { System.out.println(obj); } }
?输出:
?
id : 2 : number
data_source_name : 12 : varchar2
data_source_text : 12 : varchar2
driver_class_name : 12 : varchar2
url : 12 : varchar2
user_name : 12 : varchar2
user_password : 12 : varchar2
validation_query : 12 : varchar2
create_time : 93 : date
KeyValue [key=id, value=number]
KeyValue [key=data_source_name, value=varchar2]
KeyValue [key=data_source_text, value=varchar2]
KeyValue [key=driver_class_name, value=varchar2]
KeyValue [key=url, value=varchar2]
KeyValue [key=user_name, value=varchar2]
KeyValue [key=user_password, value=varchar2]
KeyValue [key=validation_query, value=varchar2]
KeyValue [key=create_time, value=date]