spring整合mybatis

1.创建maven项目

省略

项目架构图

2.导入所需jar包

以下jar包是新加入的

3创建 properties文件

config.driverLocation=C://Users//admin//.m2//repository//mysql//mysql-connector-java//3.1.13//mysql-connector-java-3.1.13.jar 
config.username=root
config.password=187901
config.driver=com.mysql.jdbc.Driver
config.url=jdbc:mysql://localhost:3306/smbms

4创建mybatis-config文件

<?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>


<mappers>

    <mapper resource="mapper/SmbmsBillMapper.xml"></mapper>
</mappers>
</configuration>

5创建mybatis小配置

<?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="cn.happy.dao.SmbmsBillMapper" >
  <select id="selectAllSmbmsBill" resultType="cn.happy.model.SmbmsBill">
    SELECT  <include refid="Base_Column_List"></include> FROM  Smbms_bill
  </select>

</mapper>

6配置spring文件

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:tx="http://www.springframework.org/schema/tx"

       xmlns:aop="http://www.springframework.org/schema/aop"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/beans/spring-tx.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/beans/spring-aop.xsd
">
    <!--引用properties文件-->
    <bean id="configBean" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="location"><value>config.properties</value></property>
    </bean>
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName"><value>${config.driver}</value></property>
        <property name="url"><value>${config.url}</value></property>
        <property name="username"><value>${config.username}</value></property>
        <property name="password"><value>${config.password}</value></property>
    </bean>

<!--配置sqlSessionFactory用于连接mybatis-config-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
            <property name="configLocation" value="classpath:mybatis-config.xml"></property>
         </bean>
    
    
    
     <bean id="smbmsBill" class="org.mybatis.spring.mapper.MapperFactoryBean">
        <property name="mapperInterface" value="cn.happy.dao.SmbmsBillMapper"></property>
        <property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
     </bean>
</beans>

7接口方法

public interface SmbmsBillMapper {
    List<SmbmsBill> selectAllSmbmsBill();

}

8测试

public class Test1 {
@Test
public void m(){
    ApplicationContext applicationContext=null;
    applicationContext=new ClassPathXmlApplicationContext("ApplicationContext-mybatis.xml");
    SmbmsBillMapper smbmsBill = (SmbmsBillMapper) applicationContext.getBean("smbmsBill");
    List<SmbmsBill> smbmsBills = smbmsBill.selectAllSmbmsBill();
    for (SmbmsBill item:smbmsBills
         ) {
        System.out.println(item);
    }
}
}

测试结果