spring与mybatis的整合

简单使用java项目进行整合

1.导入spring和mybatis所需要的jar包和依赖包

2.创建用户实体类User

package com.liu.www.entity;import java.util.Date;public class User {private int id;private String name;private Date birthday;private double salary;public int getId() {return id;}public void setId(int id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public Date getBirthday() {return birthday;}public void setBirthday(Date birthday) {this.birthday = birthday;}public double getSalary() {return salary;}public void setSalary(double salary) {this.salary = salary;}@Overridepublic String toString() {return "User [id=" + id + ", name=" + name + ", birthday=" + birthday + ", salary=" + salary + "]";}public User(int id, String name, Date birthday, double salary) {super();this.id = id;this.name = name;this.birthday = birthday;this.salary = salary;}public User() {super();}}

对于数据库中s-user内容

3.编写dao接口UserDao

package com.liu.www.dao;import java.util.List;import com.liu.www.entity.User;public interface UserDao {//查询数据List<User> findAll();
}

4.配置userMapper.xml

为了方便管理在项目下建了一个Source Folder名为config，在config下建Package名为mapper包专门用来放置各mapper配置

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><!-- 指向接口 --><mapper namespace="com.liu.www.dao.UserDao"> 	<select id="findAll" resultMap="getUserMap">select * from s_user;</select><!-- 配置resulMap --><resultMap type="User" id="getUserMap"><id column="user_id" property="id"/><result column="user_name" property="name"/><result column="user_birthday" property="birthday"/><result column="user_salary" property="salary"/></resultMap></mapper>

5.在config下创建一个spring.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:aop="http://www.springframework.org/schema/aop"xmlns:tx="http://www.springframework.org/schema/tx"xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans.xsdhttp://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context.xsdhttp://www.springframework.org/schema/aophttp://www.springframework.org/schema/aop/spring-aop.xsdhttp://www.springframework.org/schema/txhttp://www.springframework.org/schema/tx/spring-tx.xsd"><!-- 引入db.properties -->    <context:property-placeholder location="classpath:db.properties"/>   <!-- 配置扫描 --><context:component-scan base-package="com.liu.www"></context:component-scan><!-- 数据库连接池 --><bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"><property name="driverClass" value="${driver}"></property><property name="jdbcUrl" value="${url}"></property><property name="user" value="${user}"></property><property name="password" value="${password}"></property></bean><!-- 创建mybatis的sqlsessionFactory对象 --><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource"></property><property name="mapperLocations" value="classpath:mapper/*.xml"></property><!-- 配置取简单类名路径 --><property name="typeAliasesPackage" value="com.liu.www.entity"></property></bean><!-- 配置mapperScannerConfigurer --><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="basePackage" value="com.liu.www.dao"></property><property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property></bean><!-- 创建事务管理器 --><bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource"></property></bean><!-- 配置事务的属性 --><tx:advice id="txAdvice" transaction-manager="transactionManager"><tx:attributes><tx:method name="get" read-only="true"/><tx:method name="find" read-only="true"/><tx:method name="*"/></tx:attributes></tx:advice><!-- 配置AOP切入点 --><aop:config><aop:pointcut expression="execution(* com.liu.www.service*.*(..))" id="pointcut"/><aop:advisor advice-ref="txAdvice" pointcut-ref="pointcut"/></aop:config></beans>

6.在config下建db.properties用于设置连接数据库

7.在service下建一个testUserDao测试类

package com.liu.www.service;import java.util.List;import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;import com.liu.www.dao.UserDao;
import com.liu.www.entity.User;@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:spring.xml")
public class TestUserDao {@Autowiredprivate UserDao userDao;@Testpublic void testFind() {List<User> findAll = userDao.findAll();System.out.println(findAll);}
}

运行结果：

已查询出结果，表示spring整合mybatis做查询成功！