添加功能
jdbcTemplate.update(sql,Object[] parameters)
删除功能
jdbcTemplate.update(sql,Object[] parameters)
查询功能
查询一个字段或统计功能:
jdbcTemplate.queryForObject(sql,class<T> type);
type是返回值的类的类型,比如:
String sql = "select count(*) from admin"
Integer count = jdbcTemplate.queryForObject(sql,Integer.class);
查询一个实体类:
public Admin getAdminById(int id) {
String sql = "select * from admin where id = ?";
return jdbcTemplate.queryForObject(sql, new RowMapper<Admin>() {
@Override
public Admin mapRow(ResultSet resultSet, int i) throws SQLException {
Admin admin = new Admin();
admin.setId(resultSet.getInt("id"));
admin.setName(resultSet.getString("name"));
admin.setPassword(resultSet.getString("password"));
return admin;
}
},id);
}
查询多个实体类的数组:
public List<Admin> getAdmins() {
String sql = "select * from admin";
return jdbcTemplate.query(sql, new RowMapper<Admin>() {
@Override
public Admin mapRow(ResultSet resultSet, int i) throws SQLException {
Admin admin = new Admin();
admin.setId(resultSet.getInt("id"));
admin.setName(resultSet.getString("name"));
admin.setPassword(resultSet.getString("password"));
return admin;
}
});
}
修改功能
jdbcTemplate.update(sql,Object[] parameters)