Spring - 12、整合Mybatis - 《Java 框架学习》

1. 回忆mybatis
2. Mybatis-Spring

1. 回忆mybatis

实体类pojo

package cn.edu.jxust.pojo;
import lombok.Data;
import java.sql.Date;
@Data
public class User {
    private int id;
    private String stuName;
    private String age;
    private Date brithday;
}

数据访问层mapper

package cn.edu.jxust.mapper;
import cn.edu.jxust.pojo.User;
import java.util.List;
public interface UserMapper {
    public List<User> selectUser();
}

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.edu.jxust.mapper.UserMapper">
  <select id="selectUser" resultType="user">
    select * from t_stu;
  </select>
</mapper>

XML

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <settings>
        <setting name="mapUnderscoreToCamelCase" value="true"/>
    </settings>
    <typeAliases>
        <package name="cn.edu.jxust.pojo"/>
    </typeAliases>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/test?useUnicode=true&amp;characterEncoding=utf8&amp;useSSL=false"/>
                <property name="username" value="root"/>
                <property name="password" value="abc@123"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper class="cn.edu.jxust.mapper.UserMapper"/>
    </mappers>
</configuration>

测试Test

import cn.edu.jxust.mapper.UserMapper;
import cn.edu.jxust.pojo.User;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
public class Test {
    @org.junit.Test
        public void test() throws IOException {
        String resources  = "mybatis-config.xml";
        InputStream in = Resources.getResourceAsStream(resources);
        System.out.println(in);
        SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(in);
        SqlSession sqlSession = sessionFactory.openSession(true);
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        List<User> userList = mapper.selectUser();
        for(User user : userList){
            System.out.println(user);
        }
    }
}

2. Mybatis-Spring

编写数据源配置
sqlSessionFactory
sqlSessionTemplate
需要给接口加实现类【】
将自己写的实现类，注入到spring中

1）实体类pojo

package cn.edu.jxust.pojo;
import lombok.Data;
import java.sql.Date;
@Data
public class User {
    private int id;
    private String stuName;
    private String age;
    private Date brithday;
}

2）数据访问层mapper

package cn.edu.jxust.mapper;
import cn.edu.jxust.pojo.User;
import java.util.List;
public interface UserMapper {
    public List<User> selectUser();
}

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.edu.jxust.mapper.UserMapper">
  <select id="selectUser" resultType="user">
    select * from t_stu;
  </select>
</mapper>

3）资源类resources

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <settings>
        <setting name="mapUnderscoreToCamelCase" value="true"/>
    </settings>
    <typeAliases>
        <package name="cn.edu.jxust.pojo"/>
    </typeAliases>
</configuration>

<?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:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
                           https://www.springframework.org/schema/beans/spring-beans.xsd
                           http://www.springframework.org/schema/context
                           https://www.springframework.org/schema/context/spring-context.xsd
                           http://www.springframework.org/schema/aop
                           https://www.springframework.org/schema/aop/spring-aop.xsd">
    <!--DataSource:使用Spring的数据源替换Mybatis的配置 c3p0 ddbcp druidi
       我们这里使用Spring提供的JDBC：org.springframwork.jdbc.datasource
    -->
    <bean id="datasource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/test?useUnicode=true&amp;characterEncoding=utf8&amp;useSSL=false"/>
        <property name="username" value="root"/>
        <property name="password" value="abc@123"/>
    </bean>
    <!--sqlSessionFactory-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="datasource" />
        <!--绑定myabtis配置文件-->
        <property name="configLocation" value="classpath:mybatis-config.xml"/>
        <property name="mapperLocations" value="classpath:cn/edu/jxust/mapper/*.xml"/>
    </bean>
    <!--SqlSessionTemplate：就是我们使用的sqlSession-->
    <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
        <!--只能使用构造器注入sqlSessionFactory，因为它没有set方法-->
        <constructor-arg index="0" ref="sqlSessionFactory"/>
    </bean>
    <bean id="userMapper" class="cn.edu.jxust.mapper.UserMapperImpl">
        <property name="sqlSession" ref="sqlSession"/>
    </bean>
</beans>

4）测试类Test

import cn.edu.jxust.mapper.UserMapper;
import cn.edu.jxust.pojo.User;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import java.io.IOException;
public class Test {
    @org.junit.Test
        public void test() throws IOException {
        ApplicationContext context = new ClassPathXmlApplicationContext("spirngdao.xml");
        UserMapper userMapper = context.getBean("userMapper",UserMapper.class);
        for (User user:userMapper.selectUser()){
            System.out.println(user);
        }
    }
}