@RestControllerpublicclassJdbcController{@AutowiredJdbcTemplate jdbcTemplate;@GetMapping("/s1")publicList<Map<String,Object>>selectUser(){// 查询数据库所有信息String sql ="select * from user ";List<Map<String,Object>> mapList = jdbcTemplate.queryForList(sql);return mapList;}}
删改查操作
/* 增加User*/@GetMapping("/a1")publicStringaddUser(){// 查询数据库所有信息String sql ="insert into mybatis.user(id,name,pwd) values(8,'李华','666')";
jdbcTemplate.execute(sql);return"添加成功";}/* 修改User*/@GetMapping("/u1")publicStringupdateUser(){// 查询数据库所有信息String sql ="update mybatis.user set pwd='000' where id = 1";
jdbcTemplate.update(sql);return"更新成功";}/* 删除User*/@GetMapping("/d1")publicStringdeleteUser(){// 查询数据库所有信息String sql ="delete from mybatis.user where id=6";
jdbcTemplate.execute(sql);return"删除成功";}