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

谁践踏了优雅 2024-03-23 23:59 51阅读 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.List;
>     
>     public class SpringJDBCTest
>     {
>         @Test
>         public void TestInsert()
>         {
>             ApplicationContext applicationContext = new ClassPathXmlApplicationContext("spring.xml");
>             JdbcTemplate jdbcTemplate = applicationContext.getBean("jdbcTemplate", JdbcTemplate.class);
>             String sql = "insert into users(id,real_name,age) values(?,?,?)";
>             //注意在JDBCTemplate中,只要是增删改语句,都是调用Update方法
>             int count = jdbcTemplate.update(sql, 4, "Tim", 35);
>             //update后是可变长度参数,是用来给sql语句传值的
>             System.out.println(count);
>         }
>         @Test
>         public void TestUpdate()
>         {
>             ApplicationContext applicationContext = new ClassPathXmlApplicationContext("spring.xml");
>             JdbcTemplate jdbcTemplate = applicationContext.getBean("jdbcTemplate", JdbcTemplate.class);
>             //根据ID修改某条记录
>             String sql = "update users set real_name = ?,age = ? where id = ?";
>             int count = jdbcTemplate.update(sql, "张三好", 12, 1);
>             System.out.println(count);
>         }
>         @Test
>         public void TestDelete()
>         {
>             ApplicationContext applicationContext = new ClassPathXmlApplicationContext("spring.xml");
>             JdbcTemplate jdbcTemplate = applicationContext.getBean("jdbcTemplate", JdbcTemplate.class);
>             String sql = "delete from users where id = ?";
>             int update = jdbcTemplate.update(sql, 2);
>             System.out.println(update);
>         }
>         @Test
>         public void TestSelect()
>         {
>             ApplicationContext applicationContext = new ClassPathXmlApplicationContext("spring.xml");
>             JdbcTemplate jdbcTemplate = applicationContext.getBean("jdbcTemplate", JdbcTemplate.class);
>             String sql = "select id,real_name,age from users where id = ?";
>             //PropertyRowMapper表示查询的和我们属性和行的一个映射,把这个结果映射成什么对象
>             User user = jdbcTemplate.queryForObject(sql, new BeanPropertyRowMapper<>(User.class), 1);
>             System.out.println(user);
>         }
>         @Test
>         public void TestQueryAll()
>         {
>             ApplicationContext applicationContext = new ClassPathXmlApplicationContext("spring.xml");
>             JdbcTemplate jdbcTemplate = applicationContext.getBean("jdbcTemplate", JdbcTemplate.class);
>             String sql = "select id,real_name,age from users";
>             //query方法结合BeanPropertyRowMapper返回的是一个集合
>             List<User> query = jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(User.class));
>             System.out.println(query);
>         }
>     }
> 
> 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.List;  
>   
> public class SpringJDBCTest  
> \{  
> @Test  
> public void TestInsert()  
> \{  
> ApplicationContext applicationContext = new ClassPathXmlApplicationContext("spring.xml");  
> JdbcTemplate jdbcTemplate = applicationContext.getBean("jdbcTemplate", JdbcTemplate.class);  
> String sql = "insert into users(id,real\_name,age) values(?,?,?)";  
> //注意在JDBCTemplate中,只要是增删改语句,都是调用Update方法  
> int count = jdbcTemplate.update(sql, 4, "Tim", 35);  
> //update后是可变长度参数,是用来给sql语句传值的  
> System.out.println(count);  
> \}  
> @Test  
> public void TestUpdate()  
> \{  
> ApplicationContext applicationContext = new ClassPathXmlApplicationContext("spring.xml");  
> JdbcTemplate jdbcTemplate = applicationContext.getBean("jdbcTemplate", JdbcTemplate.class);  
> //根据ID修改某条记录  
> String sql = "update users set real\_name = ?,age = ? where id = ?";  
> int count = jdbcTemplate.update(sql, "张三好", 12, 1);  
> System.out.println(count);  
> \}  
> @Test  
> public void TestDelete()  
> \{  
> ApplicationContext applicationContext = new ClassPathXmlApplicationContext("spring.xml");  
> JdbcTemplate jdbcTemplate = applicationContext.getBean("jdbcTemplate", JdbcTemplate.class);  
> String sql = "delete from users where id = ?";  
> int update = jdbcTemplate.update(sql, 2);  
> System.out.println(update);  
> \}  
> @Test  
> public void TestSelect()  
> \{  
> ApplicationContext applicationContext = new ClassPathXmlApplicationContext("spring.xml");  
> JdbcTemplate jdbcTemplate = applicationContext.getBean("jdbcTemplate", JdbcTemplate.class);  
> String sql = "select id,real\_name,age from users where id = ?";  
> //PropertyRowMapper表示查询的和我们属性和行的一个映射,把这个结果映射成什么对象  
> User user = jdbcTemplate.queryForObject(sql, new BeanPropertyRowMapper<>(User.class), 1);  
> System.out.println(user);  
> \}  
> @Test  
> public void TestQueryAll()  
> \{  
> ApplicationContext applicationContext = new ClassPathXmlApplicationContext("spring.xml");  
> JdbcTemplate jdbcTemplate = applicationContext.getBean("jdbcTemplate", JdbcTemplate.class);  
> String sql = "select id,real\_name,age from users";  
> //query方法结合BeanPropertyRowMapper返回的是一个集合  
> List<User> query = jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(User.class));  
> System.out.println(query);  
> \}  
> \}