Spring框架学习笔记3-JdbcTemplate

以你之姓@ 2022-11-13 05:25 214阅读 0赞

## 一、JdbcTemplate概述 ##

> 为了使JDBC更加易于使用，Spring在JDBC API上定义了一个抽象层，以此建立一个JDBC存取框架。  
> 作为Spring JDBC框架的核心，JDBC模板的设计目的是为不同类型的JDBC操作提供模板方法，通过这种方式，可以在尽可能保留灵活性的情况下，将数据库存取的工作量降到最低。  
> 可以将Spring的JdbcTemplate看作是一个小型的轻量级持久化层框架，和我们之前使用过的DBUtils风格非常接近。

## 二、JdbcTemplate的使用 ##

**1、环境准备**  
相关jar包：  
![在这里插入图片描述][2021032521502653.png]  
![在这里插入图片描述][2021032521510273.png]  
**2、编写xml配置文件**

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
           xmlns:context="http://www.springframework.org/schema/context"
           xmlns:aop="http://www.springframework.org/schema/aop"
           xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
           http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
           http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
    
        <context:component-scan base-package="com.atguigu"></context:component-scan>
    
        <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
              destroy-method="close">
            <property name="url" value="jdbc:mysql://localhost:3306/day_3_14?serverTimezone=UTC"/>
            <property name="username" value="root" />
            <property name="password" value="password" />
            <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        </bean>
    
        
        <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
            
            <property name="dataSource" ref="dataSource"></property>
        </bean>
    </beans>

**3、JdbcTemplate的增删查改**

//实体类
    @Component
    public class Student {
        
        String id;
        String name;
        String address;
        String phone;
    
        public void setName(String name) {
        
            this.name = name;
        }
    
        public void setId(String id) {
        
            this.id = id;
        }
    
        public void setAddress(String address) {
        
            this.address = address;
        }
    
        public void setPhone(String phone) {
        
            this.phone = phone;
        }
    }

//Dao接口
    public interface StudentDao {
        
        public void add(Student student);
        public void update(Student student);
        public void delete(String id);
        public List<Student> quertAll();
    }

//接口实现类
    @Repository
    public class StudentDaoImpl implements StudentDao{
        
        @Autowired
        JdbcTemplate jdbcTemplate;
        @Override
    
        public void add(Student student){
        
            String sql = "insert into student values(?,?,?,?)";
            jdbcTemplate.update(sql,student.id,student.name,student.address,student.phone);
        }
    
        @Override
        public void update(Student student){
        
            String sql = "update student set name=?,address=?, phone=? where id=?";
            jdbcTemplate.update(sql,student.name,student.address,student.phone,student.id);
        }
    
        @Override
        public void delete(String id){
        
            String sql="delete  from student where id=?";
            jdbcTemplate.update(sql,id);
        }
    
      	@Override
        public List<Student> quertAll(){
        
            String sql="select * from student";
            return jdbcTemplate.query(sql,new BeanPropertyRowMapper<Student>(Student.class));
        }
    }

//Service实现类
    @Service
    public class StudentService {
        
        @Autowired
        StudentDaoImpl studentDao;
        @Autowired
        Student student;
        public void add(){
        
            student.setId("5");
            student.setName("test");
            student.setAddress("testaddress");
            student.setPhone("testphone");
            studentDao.add(student);
        }
    
        public void update(){
        
            student.setId("5");
            student.setName("update");
            student.setAddress("updateaddress");
            student.setPhone("updatephone");
            studentDao.update(student);
        }
    
        public void delete(){
        
            String id="5";
            studentDao.delete(id);
        }
        public List<Student> query(){
        
            return studentDao.quertAll();
        }
    }

public class testspring5 {
        
    //测试类
        @Test
        public void Test(){
        
            ApplicationContext context=new ClassPathXmlApplicationContext("com/atguigu/spring/bean1.xml");
            StudentService studentService=context.getBean("studentService",StudentService.class);
        //    studentService.add();
        //    studentService.update();
       //     studentService.delete();
             System.out.println(studentService.query());
        }
    }

[2021032521502653.png]: /images/20221022/7414b89ac51840e18e9efc2b2202276a.png
[2021032521510273.png]: /images/20221022/70076bdf7a9146f4b0f0a7429ae29e56.png