1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
|
public List queryDBWorkListBean(String query, Object param, String schema) {
connectDB(schema);
QueryRunner qRunner = new QueryRunner();
QueryLoader qLoad = QueryLoader.instance();
Map mapQuery = new HashMap();
try {
mapQuery = qLoad.load("/resources/properties/queries.properties");
System.out.println("map loaded");
} catch (IOException e) {
e.printStackTrace();
}
List lBeans= new ArrayList();
try {
lBeans =
(List) qRunner.query(
conn,
(String) mapQuery.get(query),
new BeanListHandler(WorkListBean.class));
} catch (SQLException e4) {
e4.printStackTrace();
}
System.out.println("requete avec Bean");
for (int i = 0; i < lBeans.size(); i++) {
WorkListBean wlb = (WorkListBean) lBeans.get(i);
System.out.println("\t"+wlb.getName()+" "+wlb.getId());
}
DbUtils.closeQuietly(conn);
return lBeans;
} |
Partager