Spring 集成Mybatis

        MyBatis 是一款优秀的持久层框架，它支持定制化 SQL、存储过程以及高级映射。MyBatis 避免了几乎所有的 JDBC 代码和手动设置参数以及获取结果集。MyBatis 可以使用简单的 XML 或注解来配置和映射原生信息，将接口和 Java 的 POJOs(Plain Ordinary Java Object,普通的 Java对象)映射成数据库中的记录。贴代码：

一、引用的jar包

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>4.2.6.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.1</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.3.0</version>
        </dependency>
        <dependency>
            <groupId>commons-dbcp</groupId>
            <artifactId>commons-dbcp</artifactId>
            <version>1.4</version>
        </dependency>

二、pom文件还需新增

    <build> 
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>
    </build>

二、Dao层、Service层、mapper文件、Controller层

package OThinker.H3.seedland.dao;

import OThinker.H3.seedland.pojo.Test;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

@Repository
public interface IUserInfoDao {
    public Test getUserById(@Param("id") String id);
}

package OThinker.H3.seedland.service;

import OThinker.H3.seedland.pojo.Test;

public interface IUserInfoService {
    public Test getById();
}

package OThinker.H3.seedland.service.impl;

import OThinker.H3.seedland.dao.IUserInfoDao;
import OThinker.H3.seedland.pojo.Test;
import OThinker.H3.seedland.service.IUserInfoService;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;

/**
 * @Author laixh
 * @Description //TODO 
 * @Date  2019
 **/
@Service("userServie")
public class UserInfoServiceImpl implements IUserInfoService {

    @Resource
    IUserInfoDao userInfoDao;
    @Override
    public Test getById() {
        return userInfoDao.getUserById("");
    }
}

TestMapper.xml，这个文件是声明Dao之间的联系。 

<?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="OThinker.H3.seedland.dao.IUserInfoDao">
    <select id="getUserById" resultType="OThinker.H3.seedland.pojo.Test" parameterType="String">
       SELECT COUNT(*) cnt FROM ot_user;
    </select>
</mapper>

package OThinker.H3.Controller.Seedland.Controllers;

import OThinker.H3.seedland.pojo.Test;
import OThinker.H3.seedland.service.IUserInfoService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

/**
 * @Author laixh
 * @Description //TODO 
 * @Date  2019
 **/
@RequestMapping("/Portal/test")
@RestController
public class SeedlandTestController {
    @Autowired
    IUserInfoService userServie;
    @RequestMapping("/say")
    public String getUser(){
        Test test=userServie.getById();
        return test.getCnt()+"";
    }
}

 

三、配置文件

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"
	xsi:schemaLocation="http://www.springframework.org/schema/beans  
        http://www.springframework.org/schema/beans/spring-beans.xsd 
        http://www.springframework.org/schema/util 
        http://www.springframework.org/schema/util/spring-util-3.1.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context.xsd"
	xmlns:util="http://www.springframework.org/schema/util" xmlns:p="http://www.springframework.org/schema/p"
	xmlns:context="http://www.springframework.org/schema/context"
	default-lazy-init="false">

	<!-- 引入mybatis配置文件-->
	<import resource="classpath:config/mybatis-config.xml"/>
	<context:annotation-config />
    <!-- 扫描包-->
	<context:component-scan base-package="OThinker.H3.seedland.*">
		<context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller" />
	</context:component-scan>

	<bean id="messageSource" class="org.springframework.context.support.ResourceBundleMessageSource">
		<property name="basenames" value="config/messages/message"/>
		<property name="defaultEncoding" value="UTF-8"/>
	</bean>

	<bean id="propertyConfigurer" class="com.h3bpm.base.spring.PropertyConfigurer">
		<property name="location">
			<value>classpath:/config/h3bpm_portal_app.properties</value>
		</property>
		<property name="fileEncoding" value="UTF-8"/>
	</bean>
</beans>

mybatis-config.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"
       xsi:schemaLocation="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.xsd">
    <!-- 引入占位符-->
    <context:property-placeholder location="classpath*:/config/datasource.properties" />
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="${url}"/>
        <property name="username" value="${username}"/>
        <property name="password" value="${password}"/>
        <property name="testOnBorrow" value="true" />
        <property name="testOnReturn" value="true" />
        <property name="testWhileIdle" value="true" />
        <property name="maxIdle" value="30" />
        <property name="maxActive" value="50" />
        <property name="removeAbandoned" value="true"/>
        <property name="removeAbandonedTimeout" value="60"/>
        <property name="logAbandoned" value="true"/>
    </bean>

    <!--扫描加载mapper文件 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="mapperLocations" value="classpath*:OThinker/H3/seedland/mapping/*Mapper.xml"/>
    </bean>
     <!--扫描加载mapper文件与之对应的接口dao -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
        <property name="basePackage" value="OThinker.H3.seedland.dao"/>
    </bean>
</beans>

 数据库连接配置文件datasource.properties

url=jdbc:mysql://127.0.0.1:3306/h3bpm?characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&noAccessToProcedureBodies=true
username=root
password=123456