将Spring内置数据源XML方式改为注解

深藏阁楼爱情的钟 2024-04-01 10:13 41阅读 0赞

#### 文章目录 ####

*  一、使用内置数据源xml方式
 *  二、使用注解

--------------------

## 一、使用内置数据源xml方式 ##

#### **首先**引入pom.xml中的依赖（这是我项目中使用的pom依赖） ####

<dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>5.3.22</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-test</artifactId>
                <version>5.3.22</version>
            </dependency>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.12</version>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>log4j</groupId>
                <artifactId>log4j</artifactId>
                <version>1.2.17</version>
            </dependency>
            <dependency>
                <groupId>org.slf4j</groupId>
                <artifactId>slf4j-log4j12</artifactId>
                <version>1.7.32</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jdbc</artifactId>
                <version>5.3.22</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.16</version>
            </dependency>
            <dependency>
                <groupId>org.aspectj</groupId>
                <artifactId>aspectjrt</artifactId>
                <version>1.9.9.1</version>
            </dependency>
            <dependency>
                <groupId>org.aspectj</groupId>
                <artifactId>aspectjweaver</artifactId>
                <version>1.9.9.1</version>
            </dependency>

##  ##

#### **spring的配置文件applicationContext.xml** ####

代码如下：

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
            <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/>
            <property name="url"
                      value="jdbc:mysql://localhost:3306/mySpring?useUnicode=true&characterEncoding=utf-8&useSSL=FALSE&
                        serverTimezone=UTC"/>
            <property name="username" value="root"/>
            <property name="password" value="root"/>
        </bean>
     
        <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
            <property name="dataSource" ref="dataSource"/>
        </bean>

#### 日志的配置log4j.properties ####

代码如下：

# Global logging configuration
    log4j.rootLogger=error, stdout
    # Console output...
    log4j.appender.stdout=org.apache.log4j.ConsoleAppender
    log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
    log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n
    log4j.category.org.springframework.beans.factory=DEBUG

## 测试类 ##

代码如下：

package com.demo.test;
    
    import org.junit.Test;
    import org.junit.runner.RunWith;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.jdbc.core.JdbcTemplate;
    import org.springframework.test.context.ContextConfiguration;
    import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
    
    
    @RunWith(SpringJUnit4ClassRunner.class)
    @ContextConfiguration("classpath:applicationContext.xml")
    public class SpringDataSourceTest {
        @Autowired
        private JdbcTemplate jdbcTemplate;
        @Test
        public void test1(){
            jdbcTemplate.execute("create table t_user2(code varchar(10),name varchar(11))");
        }
    }

## 二、使用注解 ##

### 使用配置类 ###

代码如下：

package com.demo;
    
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    import org.springframework.jdbc.core.JdbcTemplate;
    import org.springframework.jdbc.datasource.DriverManagerDataSource;
    
    
    @Configuration
    public class AppConfig {
        @Bean
        public DriverManagerDataSource dataSource() {
            DriverManagerDataSource driverManagerDataSource = new DriverManagerDataSource();
            driverManagerDataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
            driverManagerDataSource.setUrl("jdbc:mysql://localhost:3306/mySpring?useUnicode=true&characterEncoding=utf-8&useSSL=FALSE&serverTimezone=UTC");
            driverManagerDataSource.setUsername("root");
            driverManagerDataSource.setPassword("root");
            return driverManagerDataSource;
        }
    
        @Bean
        public JdbcTemplate jdbcTemplate(){
            JdbcTemplate jdbcTemplate = new JdbcTemplate();
            jdbcTemplate.setDataSource(dataSource());
            return jdbcTemplate;
        }
    }

###  ###

#### 测试类 ####

package com.demo.test;
    
    import com.demo.AppConfig;
    import org.junit.Test;
    import org.junit.runner.RunWith;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.jdbc.core.JdbcTemplate;
    import org.springframework.test.context.ContextConfiguration;
    import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
    
    
    @RunWith(SpringJUnit4ClassRunner.class)
    @ContextConfiguration(classes = AppConfig.class)
    public class SpringDataSourceTest2 {
        @Autowired
        private JdbcTemplate jdbcTemplate;
        @Test
        public void test1(){
            jdbcTemplate.execute("insert into t_user2(code,name) value ('10002','小花')");
            System.out.println("成功");
        }
    }

--------------------

## 总结 ##

以上就是今天要讲的内容，本文仅仅简单介绍了数据源的使用，供学习使用。