spring boot mybatis 简单整合使用

使用工具：IntellJ IDEA
数据库表：triggerIncidentStatitics_tbl

目录结构：

application.properties配置：

#MySql 数据库配置
spring.jpa.database=mysql
spring.datasource.url=jdbc:mysql:localhost:3306/dataname?useUnicode=true&characterEncoding=utf8&useSSL=false&requireSSL=false
spring.datasource.username=xxxx
spring.datasource.password=xxxxx
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.min-idle=5
spring.datasource.max-idle=50
spring.datasource.tomcat.max-wait=10000
spring.datasource.tomcat.max-active=50
spring.datasource.tomcat.test-on-borrow=true
#mybatis
mybatis.mapperLocations=classpath*:**/mapper/sg_*.xml

dao :

package com.seengenearcontent.db.statitics;

import com.seengenearcontent.entity.statitics.TriggerIncidentStatitics;
import org.apache.ibatis.annotations.*;

import java.util.List;

/**
 * Created by a123 on 17/2/14.
 *
 * 事件记录数据库操作MAPPER接口
 */

@Mapper
public interface TriggerIncidentStatiticsMapper {

    public int add(TriggerIncidentStatitics triggerIncidentStatitics);

    public int delete(int id);

    public int update(TriggerIncidentStatitics triggerIncidentStatitics);

    public TriggerIncidentStatitics findById(int id);

    public int findCountByCondition(TriggerIncidentStatitics triggerIncidentStatitics);

    public List<TriggerIncidentStatitics> findByCondition(TriggerIncidentStatitics triggerIncidentStatitics);
}

mapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC
        "-//mybatis.org//DTD com.example.Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace = "com.seengenearcontent.db.statitics.TriggerIncidentStatiticsMapper">
    <resultMap id = "result" type = "com.seengenearcontent.entity.statitics.TriggerIncidentStatitics">
        <result property = "id" column = "id"/>
        <result property = "seengene_id" column = "seengene_id"/>
        <result property = "startTime" column = "startTime"/>
        <result property = "endTime" column = "endTime"/>
        <result property = "incidentType" column = "incidentType"/>
        <result property = "endType" column = "endType"/>
        <result property = "triggerObject_id" column = "triggerObject_id"/>
        <result property = "resultType" column = "resultType"/>
        <result property = "scenic_id" column = "scenic_id"/>
    </resultMap>
    <select id = "findById" resultMap = "result">
        SELECT * FROM triggerIncidentStatitics_tbl where id = #{id};
    </select>
    <insert id="add">
        INSERT INTO triggerIncidentStatitics_tbl(seengene_id, startTime, endTime, incidentType, endType, triggerObject_id, resultType, scenic_id)
        values(#{seengene_id}, #{startTime}, #{endTime}, #{incidentType}, #{endType}, #{triggerObject_id}, #{resultType}, #{scenic_id});
    </insert>
    <delete id="delete">
        DELETE FROM triggerIncidentStatitics_tbl WHERE id=#{id};
    </delete>
    <update id="update">
        UPDATE triggerIncidentStatitics_tbl SET seengene_id=#{seengene_id}, startTime=#{startTime}, endTime=#{endTime}, incidentType=#{incidentType},
        endType=#{endType}, triggerObject_id=#{triggerObject_id}, resultType=#{resultType}, scenic_id=#{scenic_id} WHERE id=#{id};
    </update>
    <select id="findCountByCondition" resultType="int">
        SELECT COUNT(*) FROM triggerIncidentStatitics_tbl WHERE 1 = 1
        <if test="seengene_id != 0">
           AND seengene_id = #{seengene_id}
        </if>
        <if test="startTime != 0">
            AND startTime = #{startTime}
        </if>
        <if test="endTime != 0">
            AND endTime = #{endTime}
        </if>
        <if test="incidentType != 0">
            AND inclidentType = #{incidentType}
        </if>
        <if test="endType != 0">
            AND endType = #{endType}
        </if>
        <if test="triggerObject_id != 0">
            AND triggerObject_id = #{triggerObject_id}
        </if>
        <if test="resultType != 0">
            AND resultType = #{resultType}
        </if>
        <if test="scenic_id != 0">
            AND scenic_id = #{scenic_id}
        </if>
    </select>
    <select id="findByCondition" resultMap="result">
        SELECT * FROM triggerIncidentStatitics_tbl WHERE 1 = 1
        <if test="seengene_id != 0">
            AND seengene_id = #{seengene_id}
        </if>
        <if test="startTime != 0">
            AND startTime = #{startTime}
        </if>
        <if test="endTime != 0">
            AND endTime = #{endTime}
        </if>
        <if test="incidentType != 0">
            AND inclidentType = #{incidentType}
        </if>
        <if test="endType != 0">
            AND endType = #{endType}
        </if>
        <if test="triggerObject_id != 0">
            AND triggerObject_id = #{triggerObject_id}
        </if>
        <if test="resultType != 0">
            AND resultType = #{resultType}
        </if>
        <if test="scenic_id != 0">
            AND scenic_id = #{scenic_id}
        </if>
    </select>
</mapper>

Server :

package com.seengenearcontent.server.statitics;

import com.seengenearcontent.db.statitics.TriggerIncidentStatiticsMapper;
import com.seengenearcontent.entity.statitics.TriggerIncidentStatitics;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * Created by a123 on 17/2/14.
 */

@Service
public class TriggerIncidentStatiticsServer {

    @Autowired
    private TriggerIncidentStatiticsMapper triggerIncidentStatiticsMapper;

    public int add(TriggerIncidentStatitics triggerIncidentStatitics){
        return triggerIncidentStatiticsMapper.add(triggerIncidentStatitics);
    }

    public int insert(List<TriggerIncidentStatitics> triggerIncidentStatiticses){
        for(TriggerIncidentStatitics triggerIncidentStatitics : triggerIncidentStatiticses){
            add(triggerIncidentStatitics);
        }
        return triggerIncidentStatiticses.size();
    }

    public int delete(int id){
        return triggerIncidentStatiticsMapper.delete(id);
    }

    public int update(TriggerIncidentStatitics triggerIncidentStatitics){
        return triggerIncidentStatiticsMapper.update(triggerIncidentStatitics);
    }


    public TriggerIncidentStatitics findById(int id){
        return triggerIncidentStatiticsMapper.findById(id);
    }

    public int findCountByCondition(TriggerIncidentStatitics triggerIncidentStatitics){
        return triggerIncidentStatiticsMapper.findCountByCondition(triggerIncidentStatitics);
    }

    public List<TriggerIncidentStatitics> findByCondition(TriggerIncidentStatitics triggerIncidentStatitics){
        return triggerIncidentStatiticsMapper.findByCondition(triggerIncidentStatitics);
    }
}

Test :

@Autowired
    private TriggerIncidentStatiticsServer triggerIncidentStatiticsServer;
    @Test
    public void mybatisTest(){
        TriggerIncidentStatitics triggerIncidentStatitics = new TriggerIncidentStatitics();
        triggerIncidentStatitics.setScenic_id(1);
        System.out.println(triggerIncidentStatiticsServer.findByCondition(triggerIncidentStatitics));
//        TriggerIncidentStatitics triggerIncidentStatitics = triggerIncidentStatiticsServer.findById(1);
//        System.out.println(triggerIncidentStatiticsServer.add(triggerIncidentStatitics));
    }