Spring之Spring-jdbc-Template实现对数据库进行批量进行的增删改查-----Spring框架

悠悠 2024-03-23 23:59 10阅读 0赞

>     package com.powernode.spring6.test;
>     
>     import com.powernode.spring6.bean.User;
>     import org.junit.Test;
>     import org.springframework.context.ApplicationContext;
>     import org.springframework.context.support.ClassPathXmlApplicationContext;
>     import org.springframework.jdbc.core.BeanPropertyRowMapper;
>     import org.springframework.jdbc.core.JdbcTemplate;
>     
>     import java.util.ArrayList;
>     import java.util.Arrays;
>     import java.util.List;
>     
>     public class SpringJDBCTest
>     {
>         @Test
>         public void TestOneValue()
>         {
>             ApplicationContext applicationContext = new ClassPathXmlApplicationContext("spring.xml");
>             JdbcTemplate jdbcTemplate = applicationContext.getBean("jdbcTemplate", JdbcTemplate.class);
>             //count(内写字段就是count这个字段不为空的元素总数),如果是count(数字)也视为count(*)
>             String sql = "select count(1) from users";
>             //返回对象写法jdbcTemplate.queryForObject(sql,new BeanPropertyRowMapper(写入要映射的类),传的值(可不写))
>             Long count = jdbcTemplate.queryForObject(sql, long.class);
>             System.out.println(count);
>         }
>         @Test
>         public void TestBatchInsert()
>         {
>             ApplicationContext applicationContext = new ClassPathXmlApplicationContext("spring.xml");
>             JdbcTemplate jdbcTemplate = applicationContext.getBean("jdbcTemplate", JdbcTemplate.class);
>             String sql = "insert into users(real_name,age) values(?,?)";
>             //准备数据并添加到List集合
>             Object[] objects1 = {"小花",30};
>             Object[] objects2 = {"小叶",30};
>             Object[] objects3 = {"小瑞",30};
>             //添加到List集合
>             List lists = new ArrayList();
>             lists.add(objects1);
>             lists.add(objects2);
>             lists.add(objects3);
>             int[] ints = jdbcTemplate.batchUpdate(sql, lists);
>             System.out.println(Arrays.toString(ints));
>         }
>         @Test
>         public void TestBatchUpdate()
>         {
>             ApplicationContext applicationContext = new ClassPathXmlApplicationContext("spring.xml");
>             JdbcTemplate jdbcTemplate = applicationContext.getBean("jdbcTemplate", JdbcTemplate.class);
>             String sql = "update users set real_name = ?,age = ? where id = ?";
>             //准备数据
>             Object[] objects = {"占",35,3};
>             Object[] objects1 = {"OP",35,4};
>             Object[] objects2 = {"SB",35,5};
>             //添加到List集合
>             List<Object[]> list = new ArrayList<>();
>             list.add(objects);
>             list.add(objects1);
>             list.add(objects2);
>             //执行SQL语句
>             int[] ints = jdbcTemplate.batchUpdate(sql, list);
>             System.out.println(Arrays.toString(ints));
>         }
>         @Test
>         public void TestBatchDelete()
>         {
>             ApplicationContext applicationContext = new ClassPathXmlApplicationContext("spring.xml");
>             JdbcTemplate jdbcTemplate = applicationContext.getBean("jdbcTemplate", JdbcTemplate.class);
>             String sql = "delete from users where id = ?";
>             //准备数据
>             Object[] objects = {9};
>             Object[] objects1 = {10};
>             //添加到List集合
>             List<Object[]> list = new ArrayList<>();
>             list.add(objects);
>             list.add(objects1);
>             int[] ints = jdbcTemplate.batchUpdate(sql, list);
>             System.out.println(Arrays.toString(ints));
>         }
>     }
> 
> package com.powernode.spring6.test;  
>   
> import com.powernode.spring6.bean.User;  
> import org.junit.Test;  
> import org.springframework.context.ApplicationContext;  
> import org.springframework.context.support.ClassPathXmlApplicationContext;  
> import org.springframework.jdbc.core.BeanPropertyRowMapper;  
> import org.springframework.jdbc.core.JdbcTemplate;  
>   
> import java.util.ArrayList;  
> import java.util.Arrays;  
> import java.util.List;  
>   
> public class SpringJDBCTest  
> \{  
> @Test  
> public void TestOneValue()  
> \{  
> ApplicationContext applicationContext = new ClassPathXmlApplicationContext("spring.xml");  
> JdbcTemplate jdbcTemplate = applicationContext.getBean("jdbcTemplate", JdbcTemplate.class);  
> //count(内写字段就是count这个字段不为空的元素总数),如果是count(数字)也视为count(\*)  
> String sql = "select count(1) from users";  
> //返回对象写法jdbcTemplate.queryForObject(sql,new BeanPropertyRowMapper(写入要映射的类),传的值(可不写))  
> Long count = jdbcTemplate.queryForObject(sql, long.class);  
> System.out.println(count);  
> \}  
> @Test  
> public void TestBatchInsert()  
> \{  
> ApplicationContext applicationContext = new ClassPathXmlApplicationContext("spring.xml");  
> JdbcTemplate jdbcTemplate = applicationContext.getBean("jdbcTemplate", JdbcTemplate.class);  
> String sql = "insert into users(real\_name,age) values(?,?)";  
> //准备数据并添加到List集合  
> Object\[\] objects1 = \{"小花",30\};  
> Object\[\] objects2 = \{"小叶",30\};  
> Object\[\] objects3 = \{"小瑞",30\};  
> //添加到List集合  
> List lists = new ArrayList();  
> lists.add(objects1);  
> lists.add(objects2);  
> lists.add(objects3);  
> int\[\] ints = jdbcTemplate.batchUpdate(sql, lists);  
> System.out.println(Arrays.toString(ints));  
> \}  
> @Test  
> public void TestBatchUpdate()  
> \{  
> ApplicationContext applicationContext = new ClassPathXmlApplicationContext("spring.xml");  
> JdbcTemplate jdbcTemplate = applicationContext.getBean("jdbcTemplate", JdbcTemplate.class);  
> String sql = "update users set real\_name = ?,age = ? where id = ?";  
> //准备数据  
> Object\[\] objects = \{"占",35,3\};  
> Object\[\] objects1 = \{"OP",35,4\};  
> Object\[\] objects2 = \{"SB",35,5\};  
> //添加到List集合  
> List<Object\[\]> list = new ArrayList<>();  
> list.add(objects);  
> list.add(objects1);  
> list.add(objects2);  
> //执行SQL语句  
> int\[\] ints = jdbcTemplate.batchUpdate(sql, list);  
> System.out.println(Arrays.toString(ints));  
> \}  
> @Test  
> public void TestBatchDelete()  
> \{  
> ApplicationContext applicationContext = new ClassPathXmlApplicationContext("spring.xml");  
> JdbcTemplate jdbcTemplate = applicationContext.getBean("jdbcTemplate", JdbcTemplate.class);  
> String sql = "delete from users where id = ?";  
> //准备数据  
> Object\[\] objects = \{9\};  
> Object\[\] objects1 = \{10\};  
> //添加到List集合  
> List<Object\[\]> list = new ArrayList<>();  
> list.add(objects);  
> list.add(objects1);  
> int\[\] ints = jdbcTemplate.batchUpdate(sql, list);  
> System.out.println(Arrays.toString(ints));  
> \}  
> \}