最新Spring集成MyBatis详细教程(一)–ccw

小五游侠 2015/7/22 16:34:02

1. 如果你还没有spring的jar包,请先前往spring官网下载spring,附上下载地址 http://maven.springframework.org/release/org/springframework/spring/

在前往Mybatis的github地址下载MyBatis,下载地址为:https://github.com/mybatis/mybatis-3/releases
有需要也可以下载源代码,集成之后的jar包大致如下(别忘了 mybatis-spring.jar这个包):

由于这个项目在之前已经集成struts2,所以下面均已struts2开发方式来测试使用MyBatis.

2. 在spring配置文件中配置mybatis,在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:jee="http://www.springframework.org/schema/jee"
xmlns:tx="http://www.springframework.org/schema/tx" xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">

<!-- define the SqlSessionFactory  -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    <property name="dataSource" ref="dataSource" />
    <property name="configLocation" value="classpath:mappings.xml" />
</bean>
 <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
  <constructor-arg index="0" ref="sqlSessionFactory" />
 </bean>

 <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    <property name="basePackage" value="com.immortal.**.mybatis.dao" />
    <property name="sqlSessionFactory" ref="sqlSessionFactory"></property>  
</bean>

<!-- 事务管理器配置,单数据源事务 -->
<bean id="transactionManager_mybatis" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">  
    <property name="dataSource" ref="dataSource" />  
</bean>

<aop:config>
    <aop:pointcut expression="execution(* com.immortal..service.*.*(..))" id="txAop_mybatis" />
    <aop:advisor advice-ref="txAdvice_mybatis" pointcut-ref="txAop_mybatis" />
</aop:config>
<tx:advice id="txAdvice_mybatis" transaction-manager="transactionManager_mybatis">
    <tx:attributes>
        <!-- 让所有的方法都加入事务管理，为了提高效率，可以把一些查询之类的方法设置为只读的事务 -->
        <tx:method name="*" propagation="REQUIRED" read-only="true"/>
        <!-- 添加  -->
        <tx:method name="save*" propagation="REQUIRED" />
        <tx:method name="add*" propagation="REQUIRED" />
        <tx:method name="insert*" propagation="REQUIRED" />
        <tx:method name="submit*" propagation="REQUIRED" />
        <!-- 更新 -->
        <tx:method name="change*" propagation="REQUIRED" />
        <tx:method name="update*" propagation="REQUIRED" />
        <!-- 删除 -->
        <tx:method name="delete*" propagation="REQUIRED" />
        <tx:method name="del*" propagation="REQUIRED" />
        <!-- 移动 -->
        <tx:method name="move*" propagation="REQUIRED" />
        <!-- 复制 -->
        <tx:method name="copy*" propagation="REQUIRED" />
        <!-- 导入 -->
        <tx:method name="import*" propagation="REQUIRED" />
        <!-- 停止与激活 -->
        <tx:method name="stop*" propagation="REQUIRED" />
        <tx:method name="active*" propagation="REQUIRED" />
        <!-- 执行 -->
        <tx:method name="db*" propagation="REQUIRED" />
        <tx:method name="execute*" propagation="REQUIRED" />
        <!-- 发布 -->
        <tx:method name="deploy*" propagation="REQUIRED" />
        <!-- 取消 -->
        <tx:method name="cancel*" propagation="REQUIRED" />
        <!-- 批量操作 -->
        <tx:method name="batch*" propagation="REQUIRED" />
        <!-- 初始化操作 -->
        <tx:method name="init*" propagation="REQUIRED" />
        <!-- 同步操作 -->
        <tx:method name="sync*" propagation="REQUIRED" />
        <!-- 开始操作 -->
        <tx:method name="start*" propagation="REQUIRED" />
        <!-- 结束操作 -->
        <tx:method name="end*" propagation="REQUIRED" />
        <!-- 处理操作 -->
        <tx:method name="process*" propagation="REQUIRED" />
        <!-- 往下流转操作 -->
        <tx:method name="next*" propagation="REQUIRED" />
        <!-- 发送消息操作 -->
        <tx:method name="send*" propagation="REQUIRED" />
        <tx:method name="notify*" propagation="REQUIRED" />
    </tx:attributes>
</tx:advice>

</beans>

如果你项目集成有hibernate,需配置两个数据源(需要注意mybatis貌似不能再properties文件读取数据,需要重新修改):

<!-- 加载数据库属性配置文件 -->
    <context:property-placeholder location="classpath:db.properties" />

<!-- 数据库连接池c3p0配置 hibernate -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
    destroy-method="close">
    <property name="jdbcUrl" value="${db.url}"></property>
    <property name="driverClass" value="${db.driverClassName}"></property>
    <property name="user" value="${db.username}"></property>
    <property name="password" value="${db.password}"></property>
    <property name="maxPoolSize" value="40"></property>
    <property name="minPoolSize" value="1"></property>
    <property name="initialPoolSize" value="1"></property>
    <property name="maxIdleTime" value="20"></property>
</bean>

<!-- 数据库连接池c3p0配置 mybatis -->
<bean id="dataSource1" class="com.mchange.v2.c3p0.ComboPooledDataSource"
    destroy-method="close">
    <property name="jdbcUrl" value="jdbc:mysql://172.16.143.75:3306/test?seUnicode=tru;characterEncoding=UTF-8;zeroDateTimeBehavior=convertToNull"></property>
    <property name="driverClass" value="com.mysql.jdbc.Driver"></property>
    <property name="user" value="root"></property>
    <property name="password" value="951489"></property>
    <property name="maxPoolSize" value="40"></property>
    <property name="minPoolSize" value="1"></property>
    <property name="initialPoolSize" value="1"></property>
    <property name="maxIdleTime" value="20"></property>
</bean>

在配置mybatis的配置文件,mappings.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> 
<settings>
    <setting name="lazyLoadingEnabled" value="true" />
    <setting name="cacheEnabled" value="false"/>
</settings>


<mappers>  
    <mapper resource="com/immortal/mybatis/dao/AdminDao.xml"/>  
</mappers>  
</configuration>

3. 基本环境到目前为止就搭建好了,剩下就写相关的代码了,首先是实体类:

/**
 * Copyright (c) 2015
 *
 * Licensed under the CCW License, Version 1.0 (the "License");
 */
package com.immortal.main.admin.entity;

import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.ForeignKey;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Table;

import org.hibernate.annotations.NotFound;
import org.hibernate.annotations.NotFoundAction;

import com.immortal.entity.Volunteerinfo;
import com.immortal.framework.entity.MyAdminEntity;
import com.immortal.framework.entity.MyUserEntity;

/**
 * description :
 *
 * @version 1.0
 * @author chencw
 * @createtime : 2015年7月1日 下午2:37:30
 * 
 * 修改历史:
 * 修改人  修改时间 修改内容
 * --------------- ------------------- -----------------------------------
 * chencw2015年7月1日 下午2:37:30 
 *
 */
@Entity
@Table(name="fr_admin")
public class AdminEntity extends MyAdminEntity implements Serializable{

 /** 
  * serialVersionUID
  */
private static final long serialVersionUID = 2015536289382768255L;
private String name;
private String password;
/**
 * 是否锁定 0没有 1已锁定
 */
private Integer isLock;
/**
 * 权限
 */
private String authority;



@Column(name="name",length=25,nullable=true)
public String getName() {
    return name;
}
public void setName(String name) {
    this.name = name;
}
@Column(name="password",length=55,nullable=true)
public String getPassword() {
    return password;
}
public void setPassword(String password) {
    this.password = password;
}
@Column(name="isLock",length=2,nullable=true)
public Integer getIsLock() {
    return isLock;
}
public void setIsLock(Integer isLock) {
    this.isLock = isLock;
}

@Column(name="authority",length=5,nullable=true)
public String getAuthority() {
    return authority;
}
public void setAuthority(String authority) {
    this.authority = authority;
}


}

接口文件,AdminDao.java:

/**
 * Copyright (c) 2015
 *
 * Licensed under the CCW License, Version 1.0 (the "License");
 */
package com.immortal.mybatis.dao;

import com.immortal.main.admin.entity.AdminEntity;

/**
 * description :
 *
 * @version 1.0
 * @author chencw
 * @createtime : 2015年7月22日 下午5:37:04
 * 
 * 修改历史: 修改人 修改时间 修改内容 --------------- -------------------
 * ----------------------------------- chencw 2015年7月22日 下午5:37:04
 *
 */
public interface AdminDao {

public AdminEntity getUser(AdminEntity a);

public void addAdminEntity(AdminEntity a);

public void updateAdminEntity(AdminEntity a);

public void deleteAdminEntity(int aid);

}

相对应上Dao的mybatis的xml文件,AdminDao.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">  
<mapper namespace="com.immortal.mybatis.dao">  
<select id="getAdminEntity" parameterType="com.immortal.main.admin.entity.AdminEntity" resultType="com.immortal.main.admin.entity.AdminEntity">  
SELECT * FROM fr_admin WHERE name=#{name} AND password=#{password}  
</select>  
<insert id="addAdminEntity" parameterType="com.immortal.main.admin.entity.AdminEntity" flushCache="true">  
   INSERT INTO fr_admin (name,password) VALUES (#{name},#{password})  
</insert>  
<update id="updateAdminEntity" parameterType="com.immortal.main.admin.entity.AdminEntity">  
UPDATE fr_admin SET name=#{name} WHERE name=#{name}  
</update>  
<delete id="deleteAdminEntity" parameterType="int">  
DELETE FROM fr_admin WHERE name=#{name}  
</delete>  
</mapper>

编写测试代码(部分):

@Resource
AdminDao adminDao;

public String testMybatis() {

    AdminEntity adminEntity = new AdminEntity();
    adminEntity.setName("ccw");
    adminEntity.setPassword("ccw");

    adminDao.addAdminEntity(adminEntity);

    System.out.println("添加成功");

    AdminEntity adminEntity2 = adminDao.getAdminEntityByName("ccw");

    System.out.println("查找:"+adminEntity2.getName()+"  成功");

    return SUCCESS;
}

最后部署运行: