spring-mybatis 配装记录

<?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:aop="http://www.springframework.org/schema/aop"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/aop https://www.springframework.org/schema/aop/spring-aop.xsd">
<!--    DateSource:使用spring数据源替换mybatis的配置c3p0 dbcp druid
        这里使用spring提供的JDBC
        -->
 <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
  <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/>
  <property name="url" value="jdbc:mysql:///mybatisdb?useSSL=true&amp;characterEncoding=UTF-8&amp;useUnicode=ture"/>
  <property name="username" value="root"/>
  <property name="password" value="121314"/>

 </bean>
 <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  <property name="dataSource" ref="dataSource"/>
  <property name="configuration" value="classpath:mybatis-config.xml"/>
  <property name="mapperLocations" value="classpath:mappers/*.xml"/>
 </bean>
 <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
  <constructor-arg index="0" ref="sqlSessionFactory"/>
 </bean>
 </beans>

替代了mybatis-config里面的

 <environments default="development">-->
<!--        <environment id="development">-->
<!--            <transactionManager type="JDBC"/>-->
<!--            <dataSource type="POOLED">-->
<!--                <property name="driver" value="${driver}"/>-->
<!--                <property name="url" value="${url}"/>-->
<!--                <property name="username" value="${username}"/>-->
<!--                <property name="password" value="${password}"/>-->
<!--            </dataSource>-->
<!--        </environment>-->
<!--    </environments>-->

在test类里面代码更换

前：

public void selectUser() throws IOException {
        String resource="mybatis-config.xml";
        InputStream inputStream=
                 Resources.getResourceAsStream(resource);
        SqlSessionFactory sessionFactory=
                new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession sqlSession=
                sessionFactory.openSession(true);
        UserMapper mapper=sqlSession.getMapper(UserMapper.class);
        List<User> users=mapper.selectUser();
        for (User u:users
             ) {
            System.out.println(u.toString());
        }
        sqlSession.close();
    }
}后：

 public void smTest(){
        ApplicationContext applicationContext=
                new ClassPathXmlApplicationContext("spring-dao.xml");
        UserMapper userMapper=
                (UserMapper) applicationContext.getBean("userMapper");
        List<User> users= userMapper.selectUser();
        for (User u:users
             ) {
            System.out.println(u.toString());
        }
    }
}