jdbc-query(new PreparedStatementCreator(),new RowCallbackHandler())
来源:互联网 发布:自由行 知乎 编辑:程序博客网 时间:2024/06/03 23:41
public List query(){
final String sql="select *from users";
final List result = new ArrayList();
result.clear();
jdbcTemplate.query(new PreparedStatementCreator(){
@Override
public PreparedStatement createPreparedStatement(Connection conn)
throws SQLException {
// TODO Auto-generated method stub
return conn.prepareStatement(sql);
}
},new RowCallbackHandler(){
@Override
public void processRow(ResultSet rs) throws SQLException {
// TODO Auto-generated method stub
while(rs.next()){
Map map=new HashMap();
map.put(rs.getInt("id"), rs.getString("name"));
result.add(map);
}
}
});
return result;
}
final String sql="select *from users";
final List result = new ArrayList();
result.clear();
jdbcTemplate.query(new PreparedStatementCreator(){
@Override
public PreparedStatement createPreparedStatement(Connection conn)
throws SQLException {
// TODO Auto-generated method stub
return conn.prepareStatement(sql);
}
},new RowCallbackHandler(){
@Override
public void processRow(ResultSet rs) throws SQLException {
// TODO Auto-generated method stub
while(rs.next()){
Map map=new HashMap();
map.put(rs.getInt("id"), rs.getString("name"));
result.add(map);
}
}
});
return result;
}
0 0
- jdbc-query(new PreparedStatementCreator(),new RowCallbackHandler())
- jdbc--query( new PreparedStatementCreator(){},new ResultSetExtractor<List>)
- jdbc-query(new PreparedStatementCreator(),new PreparedStatementSetter(),new ResultSetExtractor<Objec
- jdbs--query(new PreparedStatementCreator(),new RowMapper())
- netTiers New Query Builder Classes
- new!
- new
- new
- new
- new
- New
- new
- new
- NEW~!
- new?
- new
- New
- new
- 一个关于SQL注入的简单例子
- 2016.09.20回顾
- IDEA重复代码提示
- BarrageView 自定义弹幕 view
- 解决omniauth-wordpress出现的错误
- jdbc-query(new PreparedStatementCreator(),new RowCallbackHandler())
- BZOJ2093: [Poi2010]Frog
- 提高代码质量:如何编写函数
- 记一下金山云实习生面试经历
- 实用SQL语句大全
- win8系统恢复经典---开始菜单
- 关于MVC的一些小心得
- Zabbix 3.0 基础介绍 [一]
- iOS app上架流程