1 package cn.zmh.PingCe; 2 3 import org.junit.Test; 4 import org.springframework.jdbc.core.BeanPropertyRowMapper; 5 import org.springframework.jdbc.core.JdbcTemplate; 6 7 import java.util.List; 8 import java.util.Map; 9 /**10 * Spring框架 JdbcTemplate类11 * */12 public class Demo {13//Junit单元测试，可以让方法独立执行 @Test14// 获取JdbcTemplate对象 连接池15JdbcTemplate temp = new JdbcTemplate(JdbcUtils.getDataSource());16 17//1. 修改1005号数据的 salary 为 1000018@Test19public void Test1(){20 //定义sql语句21 String sql = "update emp set salary=10000 where id=1005";22 // 执行sql语句23 int i = temp.update(sql);24 System.out.println(i);25}26 27//2. 添加一条记录28@Test29public void test2(){30 String sql = "insert into emp (id,ename,salary) values (1015,'码云',200)";31 int i = temp.update(sql);32 System.out.println(i);33}34 35//3. 删除最后一条的记录36@Test37public void test3(){38 String sql = "delete from emp where id=?";39 int i = temp.update(sql, 1015);40 System.out.println(i);41}42 43//4. 查询id为1的记录，将其封装为Map集合44@Test45public void test4(){46 String sql = "select * from emp where id=1001";47 Map<String, Object> map = temp.queryForMap(sql);48 System.out.println(map);49}50 51//5. 查询所有记录，将其封装为List52@Test53public void test5(){54 String sql = "select * from emp";55 List<Map<String, Object>> maps = temp.queryForList(sql);56 for(Map<String ,Object> m:maps){57 System.out.println(m);58 }59}60 61//6. 查询所有记录，将其封装为Emp对象的List集合62@Test63public void test6(){64 String sql = "select * from emp";65 List<Emp> list = temp.query(sql, new BeanPropertyRowMapper<Emp>(Emp.class));66 for(Emp e:list){67 System.out.println(e);68 }69}70 71//7. 查询总记录数72@Test73public void test7(){74 String sql = "select count(id) from emp";75 List<Map<String, Object>> maps = temp.queryForList(sql);76 System.out.println(maps);77}78 79//7_1. 查询总记录数80@Test81public void test7_1(){82 String sql = "select count(id) from emp";83 Long aLong = temp.queryForObject(sql, long.class);84 System.out.println(aLong);85}86 }
