Spring注解驱动开发入门

注解驱动入门案例介绍

1.需求：实现保存一条数据到数据库。
2.表结构：

 create table account( 																								
 id int primary key auto_increment, 																			
 name varchar(50),
  money double(7,2) 
  );

3.要求：使用spring框架中的JdbcTemplate和DriverManagerDataSource 使用纯注解配置spring的ioc

提示：若无法看懂注解去看01其余系列

项目结构图

github链接: link.

图片:

pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>ltd.cqut</groupId>
    <artifactId>annoation_demo</artifactId>
    <version>1.0-SNAPSHOT</version>

    <dependencies>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.1.6.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.1.6.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.45</version>
        </dependency>
    </dependencies>
</project>

JdbcConfig

import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.DriverManagerDataSource;

import javax.sql.DataSource;


public class JdbcConfig {

    @Value("${jdbc.driver}")//获取配置文件中属性值
    private String driver;

    @Value("${jdbc.url}")
    private String url;

    @Value("${jdbc.username}")
    private String username;

    @Value("${jdbc.password}")
    private String password;

    /**
     * 创建JdbcTemplate对象，并且存入IOC容器
     * @param dataSource
     * @return
     */
    @Bean("my_jdbcTemplate")//指定id为my_jdbcTemplate
    public JdbcTemplate createJdbcTemplate(DataSource dataSource){
        return new JdbcTemplate(dataSource);
    }
    /*
    创建数据源
     */
    @Bean("dataSource")
    public DataSource createDataSource(){
        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName(driver);
        dataSource.setUrl(url);
        dataSource.setUsername(username);
        dataSource.setPassword(password);
        return dataSource;
    }
}

SpringConfiguration

import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Import;
import org.springframework.context.annotation.PropertySource;


@Configuration
@Import(JdbcConfig.class)
@PropertySource("classpath:jdbc.properties")//读取类路径下资源
public class SpringConfiguration {
}

jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver 
jdbc.url=jdbc:mysql://localhost:3306/db1
jdbc.username=root
jdbc.password=root

SpringAnnotationDrivenTest

import org.springframework.context.ApplicationContext;
import org.springframework.context.annotation.AnnotationConfigApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;

public class SpringAnnotationDrivenTest {
    /*** 测试
     * @param args
     */
    public static void main(String[] args) {
        //1.创建容器（基于注解方式）
        ApplicationContext ac = new AnnotationConfigApplicationContext(SpringConfiguration.class);
        //2.根据bean的id获取对象
        JdbcTemplate jdbcTemplate = ac.getBean("my_jdbcTemplate",JdbcTemplate.class);
        //3.执行操作update可以实现增删改
        jdbcTemplate.update("insert into account(name,money)values(?,?)","my_jdbcTemplate",12345);
    }
}