创建springboot项目
配置application的设置
关于列表
- 遍历集合
@Autowired
private JdbcTemplate jdbcTemplate;
@RequestMapping("list")
@ResponseBody
public List<Student> slist(){
return jdbcTemplate.query("select * from t_student",new BeanPropertyRowMapper(Student.class));
}
- 增加信息
@RequestMapping("add")
@ResponseBody
public boolean add(){
try {
String sql = "insert into t_student (name,age) values(?,?)";
int count = jdbcTemplate.update(sql, new Object[]{"赵六","12"});
return true;
} catch (Exception e) {
// TODO: handle exception
}
return false;
}
- 修改信息
1 String sql="update user set name=?,deptid=? where id=?";
2 jdbcTemplate.update(sql,new Object[]{"zhh",5,51});
- 删除信息
1 String sql="delete from user where id=?";
2 jdbcTemplate.update(sql,51);
- 批量插入
1 String sql="insert into user (name,deptid) values (?,?)";
2
3 List<Object[]> batchArgs=new ArrayList<Object[]>();
4 batchArgs.add(new Object[]{"caoyc",6});
5 batchArgs.add(new Object[]{"zhh",8});
6 batchArgs.add(new Object[]{"cjx",8});
7
8 jdbcTemplate.batchUpdate(sql, batchArgs);
实际业务中
@Autowired
private JdbcTemplate jdbcTemplate;
应该放在Dao层或者mapper层