Spring整合mybatis简单配置

Spring整合mybatis环境

项目截图

使用的jar包

下载地址：

日志文件配置

# Debug model

log4j.rootLogger=DEBUG,stdout

# Console output...

log4j.appender.stdout=org.apache.log4j.ConsoleAppender

log4j.appender.stdout.layout=org.apache.log4j.PatternLayout

log4j.appender.stdout.layout.ConversionPattern=%5p[%t] - %m%n

数据库连接池

jdbc.driver=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://localhost:3306/mybatis

jdbc.username=root

jdbc.password=123

sqlMapConfig.xml配置

<?xmlversion="1.0"encoding="UTF-8"?>

<!DOCTYPEconfiguration

PUBLIC"-//mybatis.org//DTD Config 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>

   <!-- 全局settting根据需求和需要配置 -->

  

   <!-- 配置扫描 -->

   <typeAliases>

      <!--批量扫描 -->

      <packagename="com.cloud.mapper.pojo"/>

   </typeAliases>

   <!-- 这里使用spring整合mybatis必须保证mapper.xml和mapper.java文件在相同目录下 -->

</configuration>

applicationContext-dao.xml配置

<beansxmlns="http://www.springframework.org/schema/beans"

   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:mvc="http://www.springframework.org/schema/mvc"

   xmlns:context="http://www.springframework.org/schema/context"

   xmlns:aop="http://www.springframework.org/schema/aop"xmlns:tx="http://www.springframework.org/schema/tx"

   xsi:schemaLocation="http://www.springframework.org/schema/beans

      http://www.springframework.org/schema/beans/spring-beans-3.2.xsd

      http://www.springframework.org/schema/mvc

      http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd

      http://www.springframework.org/schema/context

      http://www.springframework.org/schema/context/spring-context-3.2.xsd

      http://www.springframework.org/schema/aop

      http://www.springframework.org/schema/aop/spring-aop-3.2.xsd

      http://www.springframework.org/schema/tx

      http://www.springframework.org/schema/tx/spring-tx-3.2.xsd ">

   <!-- 加载配置文件 -->

   <context:property-placeholderlocation="classpath:db.properties"/>

   <!-- 配置数据库连接池 -->

   <beanid="dataSource"class="org.apache.commons.dbcp.BasicDataSource"destroy-method="close">

      <propertyname="driverClassName"value="${jdbc.driver}"></property>

      <propertyname="url"value="${jdbc.url}"></property>

      <propertyname="username"value="${jdbc.username}"></property>

      <propertyname="password"value="${jdbc.password}"></property>

      <propertyname="maxActive"value="30"/>

      <propertyname="maxIdle"value="5"/>

   </bean>

   <!-- 配置sqlSessionFactory -->

   <beanid="sqlSessionFactory"class="org.mybatis.spring.SqlSessionFactoryBean.class">

      <!--配置数据库的连接池 -->

      <propertyname="dataSource"ref="dataSource"/>

      <!--加载mybatis全局配置文件 -->

      <propertyname="configLocation"value="classpath:com/cloud/mybatis/sqlMapConfig.xml"></property>

   </bean>

   <!-- 配置mapper扫描器 -->

   <beanclass="org.mybatis.spring.mapper.MapperScannerConfigurer.class">

      <!--扫描路径的包，如果需要扫描多个包，中间使用逗号隔开 -->

      <propertyname="basePackage"value="com.cloud.mapper"></property>

      <propertyname="sqlSessionFactoryBeanName"value="sqlSessionFactory"></property>

   </bean>

</beans>