如果你有阅读我之前的文章,那么恭喜你,mybatis你应该已经熟悉使用了
整合spring虽然有些不同,但是基础应该已经打好了
/**
* Spring整合mybatis
* 1、加入spring和mybatis的相关包
* 2、加入mybatis-spring-x.x.x.jar 用于整合
* 3、配置spring的applicationContext.xml文件
* 4、用SqlSessionFactoryBean代替mybatis用的SqlSessionFactory
* 4.1SqlSessionFactoryBean配置如下属性
* 数据源: <property name="dataSource" ref="dataSource"></property>
* 别名包:用于mybatis的mapper.xml中的resulttype/parametertype 与类名对应 <property name="typeAliasesPackage" value="com.spring.vo"></property>
* 5、配置mybatis的mapper.xml的路径
* 方法1:加入标签 <mybatis-spring:scan base-package="com.spring.service" />
* 方法2:配置MapperScannerConfigurer的bean
* <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
* <property name="basePackage" value="com.spring.service"></property>
* 需要注意sqlSessionFactoryBeanName 填的时value,对应的时上面的sqlsessionfactorybean的id
* <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
* </bean>
* 6、(参考userservice.java/userservice.xml)
* 6.0、java类只需要写接口就行,spring会管理根据mybatis做实现类
* 6.1、java类名要与mapper文件同名
* 6.2、java类写接口,mybatis的namespace要与java类全类名相同
* 6.3、接口里面的方法跟mybatis的方法要对应
*
* 7、实现中只需声明java接口,然后通过spring的ioc获得实例调用方法即可
*
*
*
*
* @param args
*/
测试类:
package com.spring.test;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import com.spring.service.UserService;
import com.spring.vo.User;
public class Test {
/**
* Spring整合mybatis
* 1、加入spring和mybatis的相关包
* 2、加入mybatis-spring-x.x.x.jar 用于整合
* 3、配置spring的applicationContext.xml文件
* 4、用SqlSessionFactoryBean代替mybatis用的SqlSessionFactory
* 4.1SqlSessionFactoryBean配置如下属性
* 数据源: <property name="dataSource" ref="dataSource"></property>
* 别名包:用于mybatis的mapper.xml中的resulttype/parametertype 与类名对应 <property name="typeAliasesPackage" value="com.spring.vo"></property>
* 5、配置mybatis的mapper.xml的路径
* 方法1:加入标签 <mybatis-spring:scan base-package="com.spring.service" />
* 方法2:配置MapperScannerConfigurer的bean
* <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
* <property name="basePackage" value="com.spring.service"></property>
* 需要注意sqlSessionFactoryBeanName 填的时value,对应的时上面的sqlsessionfactorybean的id
* <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
* </bean>
* 6、(参考userservice.java/userservice.xml)
* 6.0、java类只需要写接口就行,spring会管理根据mybatis做实现类
* 6.1、java类名要与mapper文件同名
* 6.2、java类写接口,mybatis的namespace要与java类全类名相同
* 6.3、接口里面的方法跟mybatis的方法要对应
*
* 7、实现中只需声明java接口,然后通过spring的ioc获得实例调用方法即可
*
*
*
*
* @param args
*/
public static void main(String[] args) {
ApplicationContext ctx = new ClassPathXmlApplicationContext("applicationContext.xml");
UserService userService = ctx.getBean(UserService.class);
User user = userService.getUserById(1);
System.out.println("user == "+user);
Map<String,Object> condition = new HashMap<>();
condition.put("userName", "Flash");
List<User> users = userService.getUsers(condition);
System.out.println("users == "+users);
}
}
UserService接口:
package com.spring.service;
import java.util.List;
import java.util.Map;
import org.springframework.stereotype.Service;
import com.spring.vo.User;
@Service
public interface UserService {
int saveUser(User user);
int updateUser(User user);
int deleteUser(int id);
User getUserById(int id);
List<User> getUsers(Map<String,Object> condition);
int getUserCount();
}
UserServiceMapper.xml
<?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">
<!-- 这里namespace必须于接口类名一致 -->
<mapper namespace="com.spring.service.UserService">
<select id="getUserById" parameterType="int" resultType="User">
select * from User where id = #{id}
</select>
<select id="getUsers" parameterType="java.util.Map" resultType="User">
select * from User where 1=1
<if test="userName!=null and userName != '' ">
and userName like '%${userName}%'
</if>
</select>
</mapper>
user类:
package com.spring.vo;
import org.springframework.stereotype.Component;
@Component
public class User {
private int id;
private String userName;
private int sex;
public User() {
super();
// TODO Auto-generated constructor stub
}
public User(int id, String userName, int sex) {
super();
this.id = id;
this.userName = userName;
this.sex = sex;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public int getSex() {
return sex;
}
public void setSex(int sex) {
this.sex = sex;
}
@Override
public String toString() {
return "User [id=" + id + ", userName=" + userName + ", sex=" + sex + "]";
}
}
applicationcontext.xml
<?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:tx="http://www.springframework.org/schema/tx"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring"
xsi:schemaLocation="http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring.xsd
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">
<!-- scan annotation 包 -->
<context:component-scan base-package="com.spring"></context:component-scan>
<!-- 自动 sacn aop包 -->
<aop:aspectj-autoproxy></aop:aspectj-autoproxy>
<context:property-placeholder location="classpath:db.properties"/>
<!-- 配置数据源 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.DriverManagerDataSource">
<property name="driverClass" value="${driverClass}"></property>
<property name="jdbcUrl" value="${url}"></property>
<property name="user" value="${userName}"></property>
<property name="password" value="${password}"></property>
</bean>
<!-- 配置sqlsessionfactorybean,需要使用mybatis-spring.jar的包 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<property name="typeAliasesPackage" value="com.spring.vo"></property>
</bean>
<!-- 配置mybatis 扫描mapper的包 -->
<!-- <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.spring.service"></property>
需要注意sqlSessionFactoryBeanName 填的时value,对应的时上面的sqlsessionfactorybean的id
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
</bean> -->
<!-- 配置mybatis 扫描mapper的包2 -->
<mybatis-spring:scan base-package="com.spring.service" />
<!-- 配置事务 -->
<bean id="transactionManageer" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
<tx:annotation-driven transaction-manager="transactionManager"/>
</beans>
db.properties
driverClass=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/Test
userName=root
password=root
<?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>
<!-- 整合spring这里不用配置了 -->
</configuration>