【MyBatis】MyBatis 整合 Spring

项目结构图

整合

1.导入MyBatis框架

导入三个jar包： mybatis-3.2.2.jar mybatis-spring-1.1.1.jar mysql-connector-java-5.1.18-bin.jar

2.myeclipse导入Spring框架

3.编写实体类

com.domain.Goods.java

package com.domain;
public class Goods {
    private Integer goodsId;
    private String goodsName;
    private Double goodsPrice;
    private Integer goodsNum;
    private Integer goodsType;

    public Goods() {
    }

    public Goods(Integer goodsId, String goodsName, Double goodsPrice,
                 Integer goodsNum, Integer goodsType) {
        this.goodsId = goodsId;
        this.goodsName = goodsName;
        this.goodsPrice = goodsPrice;
        this.goodsNum = goodsNum;
        this.goodsType = goodsType;
    }

    public Goods(String goodsName, Double goodsPrice,
                 Integer goodsNum, Integer goodsType) {
        this.goodsName = goodsName;
        this.goodsPrice = goodsPrice;
        this.goodsNum = goodsNum;
        this.goodsType = goodsType;
    }

    public Integer getGoodsId() {
        return goodsId;
    }

    public void setGoodsId(Integer goodsId) {
        this.goodsId = goodsId;
    }

    public String getGoodsName() {
        return goodsName;
    }

    public void setGoodsName(String goodsName) {
        this.goodsName = goodsName;
    }

    public Double getGoodsPrice() {
        return goodsPrice;
    }

    public void setGoodsPrice(Double goodsPrice) {
        this.goodsPrice = goodsPrice;
    }

    public Integer getGoodsNum() {
        return goodsNum;
    }

    public void setGoodsNum(Integer goodsNum) {
        this.goodsNum = goodsNum;
    }

    public Integer getGoodsType() {
        return goodsType;
    }

    public void setGoodsType(Integer goodsType) {
        this.goodsType = goodsType;
    }

    @Override
    public String toString() {
        return "Goods [goodsId=" + goodsId + ", goodsName=" + goodsName
                + ", goodsPrice=" + goodsPrice + ", goodsNum=" + goodsNum
                + ", goodsType=" + goodsType + "]";
    }

}

4.配置spring环境文件

重要！！！

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:p="http://www.springframework.org/schema/p"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.1.xsd
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.1.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.1.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.1.xsd">

<!– 设置Spring注册 –>
<context:annotation-config/>
<!– Spring扫描路径 –>
<context:component-scan base-package="com.service"/>
<!– 引入jdbc配置文件 –>
<context:property-placeholder location="classpath:jdbc.properties" />
<!–创建jdbc数据源 –>
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
  <property name="driverClassName" value="${db.driverClassName}" />
  <property name="username" value="${db.username}" />
  <property name="password" value="${db.password}" />
  <property name="url" value="${db.url}" />
</bean>
<!– 配置MyBatis的sqlSession –>
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  <property name="configLocation" value="classpath:mybatis.xml"></property>
  <property name="dataSource" ref="dataSource" />
</bean>
<!– 映射Mapper目录 –>
<!– Mapper接口所在包名，Spring会自动查找其下的Mapper –>
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  <property name="basePackage" value="com.mapper" />
</bean>

<!– 可通过注解控制事务 –>
<tx:annotation-driven transaction-manager="transactionManager" />
  <bean id="transactionManager"
  class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSource" />
  </bean>
</beans>

jdbc.properties

db.driverClassName=com.mysql.jdbc.Driver
db.url=jdbc\:mysql\://127.0.0.1\:3306/spring?useUnicode\=true&characterEncoding\=utf8
db.username=root
db.password=123456

mybatis.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>

</configuration>

5.编写mapper接口

GoodsMapper.java

package com.mapper;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.domain.Goods;

@Repository("GoodsMapper")
public interface GoodsMapper {
    public List<Goods> findAll();
    public void save(Goods goods);
}

GoodsMapper.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.mapper.GoodsMapper">
<select id="findAll" resultMap="resultGoods">
  select * from goods
</select>
  <insert id="save" parameterType="com.domain.Goods">
  insert into goods(goods_id,goods_name,goods_price,goods_num,goods_type)
  value(#{goodsId},#{goodsName},#{goodsPrice},#{goodsNum},#{goodsType})
</insert>
<resultMap type="com.domain.Goods" id="resultGoods">
  <id property="goodsId" column="goods_id" javaType="int" />
  <result property="goodsName" column="goods_name" javaType="java.lang.String" />
  <result property="goodsPrice" column="goods_price" javaType="double" />
  <result property="goodsNum" column="goods_num" javaType="int" />
  <result property="goodsType" column="goods_type" javaType="int" />
</resultMap>
</mapper>

6.编写业务层

GoodsService.java

import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;

import com.domain.Goods;
import com.mapper.GoodsMapper;

@Service("GoodsService")
public class GoodsService {
    @Autowired
    @Qualifier("GoodsMapper")
    private GoodsMapper goodsMapper;

    public GoodsMapper getGoodsMapper() {
        return goodsMapper;
    }
    public void setGoodsMapper(GoodsMapper goodsMapper) {
        this.goodsMapper = goodsMapper;
    }

    //readOnly只读，不需要回滚
    @Transactional(propagation = Propagation.REQUIRED, readOnly = true)
    public List<Goods> findAll(){
        try{
            return this.goodsMapper.findAll();
        }catch(Exception e){
            e.printStackTrace();
            throw new RuntimeException(e);
        }
    }

    //rollbackFor 如果错误就回滚
    @Transactional(propagation = Propagation.REQUIRED, rollbackFor = { Exception.class })
    public void save(Goods goods){
        try{
            this.goodsMapper.save(goods);
            System.out.println("数据插入成功！");
        }catch(Exception e){
            e.printStackTrace();
            throw new RuntimeException(e);
        }
    }
}

7.编写测试类

有一个测试注释掉了，两个是有冲突的。

test.java

package com.test;

import java.util.List;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.domain.Goods;
import com.service.GoodsService;

public class test {

    public static void main(String[] args) {
        @SuppressWarnings("resource")
        ApplicationContext context
                = new ClassPathXmlApplicationContext("/applicationContext.xml");
        GoodsService goodsService = (GoodsService) context.getBean("GoodsService");

// List<Goods> goodsList = goodsService.findAll();
// for (Goods goods : goodsList) {
// System.out.println(goods);
// }

        goodsService.save(new Goods("桌球",1d,5,1));

    }
}

资源下载

mybatis-3.2.2.jar：本地下载

mybatis-spring-1.1.1.jar：本地下载

mysql-connector-java-5.1.18-bin.jar：本地下载

项目源代码：本地下载