protected void setUp() {
Resource res = new FileSystemResource("build/classes/beans.xml");
XmlBeanFactory factory = new XmlBeanFactory(res);
DataSource vfbDS = (DataSource) factory.getBean("vfbDataSource");
this.setDataSource(vfbDS);
LOG.debug("data source : " + vfbDS);
}
/**
* Queries the tables to extract salient information (feature structure name, reference details)
* for a transgene query
*/
@SuppressWarnings({"unchecked", "unused"})
public List<Record> getAll() {
String query = "select * from fc_mapping";
LOG.debug("Query : " + query);
long startTime = System.currentTimeMillis();
List<Record> results =
this.jdbcTemplate.query(
query, new Object[] {}, (RowMapper) new FCMappingResultSetExtractor());
return results;
}
private void process() {
List<Record> list = this.getAll();
for (Record curr : list) {
LOG.debug("curr:" + curr);
}
}