spring-jdbc简单配置和使用

Spring-jdbc的配置使用

1.pom配置

<?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">
    <parent>
        <artifactId>shj-learn</artifactId>
        <groupId>shj-learn-total</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>shj-data-learn</artifactId>
    <properties>
        <spring_version>5.3.3</spring_version>
        <mysql-connector-java.version>8.0.23</mysql-connector-java.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>${spring_version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>${spring_version}</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>${mysql-connector-java.version}</version>
        </dependency>
    </dependencies>

</project>

2.配置数据源

package springjdbc.config;

import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.PropertySource;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.SimpleDriverDataSource;

import javax.sql.DataSource;
import java.sql.Driver;

/**
 * 1.添加数据源
 * 2.创建 JdbcTemplate
 * 依赖 spring-jdbc
 * @author cuicaicha
 */
@Configuration
@PropertySource(value = {"classpath:data-source.properties"})
public class DatabaseConfig {


    @Value("${spring-datasource-driveClassName}")
    private String driverClassName;

    @Value("${spring-datasource-jdbcUrl}")
    private String dataSourceUrl;

    @Value("${spring-datasource-userName}")
    private String userName;

    @Value("${spring-datasource-pwd}")
    private String password;


    /**
     * 1.创建数据源
     * @return
     */
    @Bean(name = "dataSource")
    public DataSource getDataSource() throws ClassNotFoundException {
        SimpleDriverDataSource simpleDriverDataSource = new SimpleDriverDataSource();
        simpleDriverDataSource.setDriverClass((Class<? extends Driver>) Class.forName(driverClassName));
        simpleDriverDataSource.setUrl(dataSourceUrl);
        simpleDriverDataSource.setUsername(userName);
        simpleDriverDataSource.setPassword(password);
        return simpleDriverDataSource;
    }

    /**
     * 2.创建jdbcTemplate
     * @param dataSource
     * @return
     */
    @Bean(name = "jdbcTemplate")
    public JdbcTemplate getSqlSessionFactory(@Qualifier(value = "dataSource") DataSource dataSource) throws Exception {
        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
        return jdbcTemplate;
    }


}

3.添加配置文件data-source.properties

spring-datasource-jdbcUrl=jdbc:mysql://ip/springlearning
spring-datasource-userName=root
spring-datasource-pwd=root
spring-datasource-driveClassName=com.mysql.cj.jdbc.Driver

4.demo演示

package springjdbc;


import org.springframework.context.annotation.AnnotationConfigApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;
import springjdbc.config.DatabaseConfig;

public class BootDemo {

    public static void main(String[] args) {
        AnnotationConfigApplicationContext applicationContext = new AnnotationConfigApplicationContext();
        applicationContext.register(DatabaseConfig.class);
        applicationContext.refresh();
        JdbcTemplate jdbcTemplate = (JdbcTemplate)applicationContext.getBean("jdbcTemplate");
        int o = jdbcTemplate.update("update ps_sys_dic set dic_name = '6' where  id = 2  ");
        System.out.println(o);
    }

}