spring学习笔记02-spring x mybatis 整合配置

项目结构

spring.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:util="http://www.springframework.org/schema/util"
    xmlns:aop="http://www.springframework.org/schema/aop" 
    xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:context="http://www.springframework.org/schema/context"
    xmlns:mvc="http://www.springframework.org/schema/mvc"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/util 
        http://www.springframework.org/schema/util/spring-util.xsd
        http://www.springframework.org/schema/aop
        http://www.springframework.org/schema/aop/spring-aop.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc.xsd">

    <!-- 注解方式， 指定bean可能出现的位置 -->
    <context:component-scan base-package="com.yc.spring" />
    <!-- 引入外部属性文件 -->
    <context:property-placeholder location="classpath:db.properties"/>
    <!-- 使用dbcp2连接池 -->
    <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource">
        <property name="driverClassName" value="${jdbc.driverClassName}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
        <property name="initialSize" value="${jdbc.initialSize}"/>
        <property name="maxTotal" value="${jdbc.maxTotal}"/>
        <property name="minIdle" value="${jdbc.minIdle}"/>
        <property name="validationQuery" value="${jdbc.validationQuery}"/>
    </bean>
    <!-- 会话工厂Bean -->
    <bean id="SqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="typeAliasesPackage" value="com.yc.spring.entity"/>
        <property name="mapperLocations" value="classpath:mapper/*Mapper.xml"/>
    </bean>
    <!-- mapper路径配置 -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.yc.spring.mapper"/>
        <property name="sqlSessionFactoryBeanName" value="SqlSessionFactory"/>
    </bean>
</beans>

数据库连接配置db.properties

jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@localhost:1521:orcl
jdbc.username=mybatis26
jdbc.password=a
jdbc.initialSize=10
jdbc.minIdle=5
jdbc.maxTotal=100
jdbc.validationQuery=select 1 from dual

实体类User

package com.yc.spring.entity;

public class User {
    private Integer id;
    private String uname;
    private String upwd;
    public User() {}
    public User(String uname, String upwd) {
        this.uname = uname;
        this.upwd = upwd;
    }
    public Integer getId() {
        return id;
    }
    public void setId(Integer id) {
        this.id = id;
    }
    public String getUname() {
        return uname;
    }
    public void setUname(String uname) {
        this.uname = uname;
    }
    public String getUpwd() {
        return upwd;
    }
    public void setUpwd(String upwd) {
        this.upwd = upwd;
    }
    @Override
    public String toString() {
        return "\nUser [id=" + id + ", uname=" + uname + ", upwd=" + upwd + "]";
    }

}

UserMapper接口

package com.yc.spring.mapper;

import java.util.List;

import com.yc.spring.entity.User;

public interface UserMapper {
    public User getUserById(Integer id);
    public int insertUser(User user);
    public int updateUser(User user);
    public int deleteUserById(Integer id);
    public List<User> getAllUsers();
}

UserMapper.xml

<?xml version="1.0" encoding="UTF-8" ?> 
<!DOCTYPE mapper  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"  
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!-- 命名空间与映射接口的全类名一致 -->
<mapper namespace="com.yc.spring.mapper.UserMapper">
    <!-- id与方法名一致 -->
    <select id="getUserById" parameterType="int" resultType="User">
        select * from users where id = #{id}
    </select>
    <insert id="insertUser" parameterType="User">
        insert into users values(seq_users.nextval,#{uname},#{upwd})
    </insert>
    <update id="updateUser" parameterType="User">
        update users set uname=#{uname},upwd=#{upwd} where id = #{id}
    </update>
    <delete id="deleteUserById" parameterType="int">
        delete users where id = #{id}
    </delete>

    <!-- resultType返回一个对象 -->
    <select id="getAllUsers" resultType="User">
        select * from users
    </select>
</mapper>

测试连接

public class ConnTest {
    @Test
    public void testConn() throws SQLException{
        ApplicationContext cxt = new ClassPathXmlApplicationContext("spring.xml");
        DataSource dataSource = (DataSource)cxt.getBean("dataSource");
        Connection connection = dataSource.getConnection();
        assertNotNull(connection);
    }
}

测试功能

package com.yc.spring;

import static org.junit.Assert.*;

import java.util.List;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import com.yc.spring.entity.User;
import com.yc.spring.mapper.UserMapper;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:spring.xml")
public class UserMapperTest2 {
    @Autowired
    private UserMapper userMapper;
    @Test
    public void testGetUserById() {
        User user = userMapper.getUserById(10001);
        System.out.println(user);
        assertNotNull(user);
    }

    @Test
    public void testInsertUser() {
        User user = new User("小明","111");
        int result = userMapper.insertUser(user);
        assertEquals(1, result);
    }

    @Test
    public void testUpdateUser() {
        User user = new User("小明", "222");
        user.setId(10001);
        int result = userMapper.updateUser(user);
        assertEquals(1, result);
    }

    @Test
    public void testDeleteUserById() {
        int result = userMapper.deleteUserById(10001);
        assertEquals(1, result);
    }

    @Test
    public void testGetAllUsers() {
        List<User> users = userMapper.getAllUsers();
        System.out.println(users);
        assertNotNull(users);
    }

}