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配置

<?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>    <!-- 全局settting根据需求和需要配置 -->       <!-- 配置扫描 -->    <typeAliases>       <!-- 批量扫描 -->       <package name="com.cloud.mapper.pojo"/>    </typeAliases>    <!-- 这里使用spring整合mybatis必须保证mapper.xml和mapper.java文件在相同目录下 --> </configuration>

applicationContext-dao.xml配置

<beans xmlns="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-placeholder location="classpath:db.properties"/>    <!-- 配置数据库连接池 -->    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">       <property name="driverClassName" value="${jdbc.driver}"></property>       <property name="url" value="${jdbc.url}"></property>       <property name="username" value="${jdbc.username}"></property>       <property name="password" value="${jdbc.password}"></property>       <property name="maxActive" value="30"/>       <property name="maxIdle" value="5"/>    </bean>    <!-- 配置sqlSessionFactory -->    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean.class">       <!-- 配置数据库的连接池 -->       <property name="dataSource" ref="dataSource"/>       <!-- 加载mybatis全局配置文件 -->       <property name="configLocation" value="classpath:com/cloud/mybatis/sqlMapConfig.xml"></property>    </bean>    <!-- 配置mapper扫描器 -->    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer.class">       <!-- 扫描路径的包，如果需要扫描多个包，中间使用逗号隔开 -->       <property name="basePackage" value="com.cloud.mapper"></property>       <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>    </bean> </beans>