public List<Map<String, Object>> queryForListMap(final String sql)
throws Exception {
/*new Thread(){
@Override
public void run() {
//使用当前的 transaction
List<Map<String, Object>> list=jdbcTemplate.queryForList(sql);
System.out.println(list.size());
}
}.start();*/
/*new Thread(){
@Override
public void run() {
List<Map<String, Object>> list=null;
try {
//使用当前的 transaction
list = queryForListMap2(sql);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println(list.size());
}
}.start();*/
/*new Thread(){
@Override
public void run() {
//Creating new transaction with name
serviceUtil.queryTasks();
}
}.start();*/
/*for(int i=0;i<8;i++){
executorService.execute(new Runnable() {
@Override
public void run() {
//使用当前的 transaction
List<Map<String, Object>> list=jdbcTemplate.queryForList(sql);
System.out.println(list.size());
System.out.println("ThreadId==="+Thread.currentThread().getId());
//Creating new transaction with name
//每一次Creating new transaction
serviceUtil.queryTasks();
}
});
}*/
/*for(int i=0;i<8;i++){
executorService.submit(new Callable<String>() {
public String call() throws Exception {
//使用当前的 transaction
List<Map<String, Object>> list=jdbcTemplate.queryForList(sql);
System.out.println(list.size());
System.out.println("ThreadId==="+Thread.currentThread().getId());
//Creating new transaction with name
//每一次Creating new transaction
serviceUtil.queryTasks();
return sql;
};
});
}*/
for(int i=0;i<8;i++){
//使用当前的 transaction
serviceUtil.queryTasks();
}
return jdbcTemplate.queryForList(sql);
}