Spring整合Junit4和JdbcTemplate实现查询添加

叁歲伎倆 2024-04-06 10:57 83阅读 0赞

#### Spring整合Junit4和JdbcTemplate实现查询添加 ####

Spring框架对JDBC进行封装，使用JdbcTemplate方便实现对数据库操作

要做的准备工作有加入依赖、创建jdbc.properties、配置Spring的配置文件

###### 1.加入依赖 ######

<packaging>jar</packaging>
    
        <dependencies>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>5.3.1</version>
            </dependency>
            
            
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-orm</artifactId>
                <version>5.3.1</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-test</artifactId>
                <version>5.3.1</version>
            </dependency>
            
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.12</version>
                <scope>test</scope>
            </dependency>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.25</version>
            </dependency>
            
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.0.31</version>
            </dependency>
        </dependencies>
        
        <properties>
            <maven.compiler.source>1.8</maven.compiler.source>
            <maven.compiler.target>1.8</maven.compiler.target>
        </properties>

###### 2.创建jdbc.properties ######

jdbc.driver=com.mysql.cj.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/ssm?serverTimezone=UTC
    jdbc.username=root
    jdbc.password=123456

###### 3.配置Spring的配置文件 ######

<context:property-placeholder location="jdbc.properties"></context:property-placeholder>
        <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
            <property name="driverClassName" value="${jdbc.driver}"></property>
            <property name="url" value="${jdbc.url}"></property>
            <property name="username" value="${jdbc.username}"></property>
            <property name="password" value="${jdbc.password}"></property>
        </bean>
    
        <bean class="org.springframework.jdbc.core.JdbcTemplate">
            <property name="dataSource" ref="dataSource"></property>
        </bean>

最后基于User表创建User类可以实现测试

//指定当前测试类在Spring的测试环境中执行，此时就可以通过注入的方式直接获取IOC容器中bean
    @RunWith(SpringJUnit4ClassRunner.class)
    //设置Spring测试环境的配置文件
    @ContextConfiguration("classpath:spring-jdbc.xml")
    public class JdbcTemplateTest {
        
    
        @Autowired
        private JdbcTemplate jdbcTemplate;
    
        @Test
        public void testInsert(){
        
            String sql = "insert into t_user values(null,?,?,?,?,?)";
            jdbcTemplate.update(sql,"root","123",21,"女","4153@qq.com");
        }
    
        @Test
        public void testGetUserById(){
        
            String sql = "select * from t_user where id = ?";
            User user = jdbcTemplate.queryForObject(sql, new BeanPropertyRowMapper<>(User.class), 1);
    
            System.out.println("user = " + user);
        }
    
        @Test
        public void testGetAllUser(){
        
            String sql = "select * from t_user";
            List<User> list = jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(User.class));
    
            list.forEach(System.out::println);
        }
    
        @Test
        public void testGetCount(){
        
            String sql = "select count(*) from t_user";
            Integer count = jdbcTemplate.queryForObject(sql, Integer.class);
    
            System.out.println(count);
        }
    }