spring boot mybatis 简单整合使用

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

目录结构：

application.properties配置：

#MySql 数据库配置spring.jpa.database=mysqlspring.datasource.url=jdbc:mysql:localhost:3306/dataname?useUnicode=true&characterEncoding=utf8&useSSL=false&requireSSL=falsespring.datasource.username=xxxxspring.datasource.password=xxxxxspring.datasource.driver-class-name=com.mysql.jdbc.Driverspring.datasource.min-idle=5spring.datasource.max-idle=50spring.datasource.tomcat.max-wait=10000spring.datasource.tomcat.max-active=50spring.datasource.tomcat.test-on-borrow=true#mybatismybatis.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接口 */@Mapperpublic 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. */@Servicepublic 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));    }