springboot

以上包含的项目文件

1、mybatis-config.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="mapUnderscoreToCamelCase" value="true"/>        <setting name="defaultEnumTypeHandler" value="org.apache.ibatis.type.EnumOrdinalTypeHandler"/>    </settings></configuration>

application.yaml配置：

spring:  application:    name: log  datasource:    name: dbname    url: jdbc:mysql://IP:3306/dbname    username: user    password: pass    # 使用druid数据源    type: com.alibaba.druid.pool.DruidDataSource    driver-class-name: com.mysql.jdbc.Driver    filters: stat    maxActive: 20    initialSize: 1    maxWait: 60000    minIdle: 1    timeBetweenEvictionRunsMillis: 60000    minEvictableIdleTimeMillis: 300000    validationQuery: select 'x'    testWhileIdle: true    testOnBorrow: false    testOnReturn: false    poolPreparedStatements: true    maxOpenPreparedStatements: 20mybatis:  config-location: classpath:mybatis-config.xml  mapperLocations: classpath:mapper/*.xml

2、加载jar包：缺啥加啥

 <dependency>            <groupId>org.springframework.integration</groupId>            <artifactId>spring-integration-core</artifactId>            <version>4.3.6.RELEASE</version>        </dependency>

  <dependency>            <groupId>org.mybatis.spring.boot</groupId>            <artifactId>mybatis-spring-boot-starter</artifactId>            <version>1.3.1</version>        </dependency>

<dependency>            <groupId>com.alibaba</groupId>            <artifactId>druid</artifactId>            <version>1.1.2</version>        </dependency>        <dependency>            <groupId>mysql</groupId>            <artifactId>mysql-connector-java</artifactId>        </dependency>

<dependency>            <groupId>org.springframework.boot</groupId>            <artifactId>spring-boot-starter-test</artifactId>            <scope>test</scope>        </dependency>

3、LogDao代码编写：

import org.apache.ibatis.annotations.Insert;import org.apache.ibatis.annotations.Mapper;import org.apache.ibatis.annotations.Select;import org.apache.ibatis.annotations.Update;import org.apache.kafka.common.metrics.stats.Count;/** *  */@Mapperpublic interface LogDao {    @Insert("insert into log_ds (id_log_ds,trans_no)" +            "values(#{idLogDs},#{transNo})")    public void insertLogDs(LogDs logDs);        @Update("update _log_ds set id_log_ds=#{idLogDs},ds_int_id=#{dsIntId}," +            "ds_trans_no=#{dsTransNo},start_time=#{startTime},end_time=#{endTime}," +            "request_msg=#{requestMsg},response_msg=#{responseMsg},is_succ=#{isSucc}," +            "ret_code=#{retCode},ret_msg=#{retMsg},server_id=#{serverId},server_name=#{serverName}," +            "server_ip=#{serverIp},create_by=#{createBy},date_ceated=#{dateCeated}," +            "update_by=#{updateBy},date_updated=#{dateUpdated} where trans_no=#{transNo}")    public int updateLogDs(LogDs LogDs);        @Select("select count(1) from _log_int where start_time >= DATE_SUB(NOW(),INTERVAL 5 MINUTE)")    public int countIntNumByRealTime();    }

4、单元测试：

import org.junit.Test;import org.junit.runner.RunWith;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.boot.test.context.SpringBootTest;import org.springframework.test.context.junit4.SpringRunner;/** *  */@RunWith(SpringRunner.class)@SpringBootTestpublic class LogDaoTest {    @Autowired    private LogDao logDao;    @Test    public void contextLoads() {    }    @Test    public void testInsert(){        LogDs LogDs = new LogDs();        LogDs.setIdLogDs("huashuo1");        LogDs.setTransNo("666666");        logDao.insertLogDs(LogDs);    }}