温州外贸网站推广,国内最有趣的网站,促进企业,上海企业网站建设公司目录 1.1、代码编写Demo类User类启动类 APplication 1.2、配置类查询语句的配置 mysql.ymlspringboot的配置 application.yml日志的配置 logback.xml数据库的配置 mybatis-config.xml 1.3、测试#xff1a;1.3.1、测试获取用户数1.3.2、添加用户1.3.3、数据的更新1.3.4、数据的… 目录 1.1、代码编写Demo类User类启动类 APplication 1.2、配置类查询语句的配置 mysql.ymlspringboot的配置 application.yml日志的配置 logback.xml数据库的配置 mybatis-config.xml 1.3、测试1.3.1、测试获取用户数1.3.2、添加用户1.3.3、数据的更新1.3.4、数据的删除 1.1、代码编写 Demo类 import com.course.model.User;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.extern.log4j.Log4j;
import org.mybatis.spring.SqlSessionTemplate;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
Log4j
RestController
Api(value v1,tags 这是我的第一个版本的demo)
RequestMapping(v1)
public class Demo {//首先获取一个执行sql语句的对象Autowiredprivate SqlSessionTemplate template;RequestMapping(value /getUserCount,method RequestMethod.GET)ApiOperation(value 可以获取到用户数,httpMethod GET)public int getUserCount(){return template.selectOne(getUserCount);}RequestMapping(value /addUser,method RequestMethod.POST)public int addUser(RequestBody User user){int result template.insert(addUser,user);return result;}RequestMapping(value /updateUser,method RequestMethod.POST)public int updateUser(RequestBody User user){return template.update(updateUser,user);}RequestMapping(value /deleteUser,method RequestMethod.GET)public int delUser(RequestParam int id){return template.delete(deleteUser,id);}} User类
Data
public class User {private int id;private String name;private String sex;private int age;}启动类 APplication
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.context.ConfigurableApplicationContext;
import org.springframework.scheduling.annotation.EnableScheduling;
import javax.annotation.PreDestroy;EnableScheduling
SpringBootApplication
public class Application {private static ConfigurableApplicationContext context;public static void main(String[] args) {Application.context SpringApplication.run(Application.class,args);}PreDestroypublic void close(){Application.context.close();}}1.2、配置类 查询语句的配置 mysql.yml
?xml version1.0 encodingUTF-8 ?
!DOCTYPE mapperPUBLIC -//mybatis.org//DTD Mapper 3.0//ENhttp://mybatis.org/dtd/mybatis-3-mapper.dtdmapper namespacecom.courseselect idgetUserCount resultTypeIntegerselect count(*) from user;/selectinsert idaddUser parameterTypecom.course.model.Userinsert into user(id,name,age,sex)values(#{id},#{name},#{age},#{sex})/insertupdate idupdateUser parameterTypecom.course.model.Userupdate user set name#{name},age#{age}where id#{id}/updatedelete iddeleteUser parameterTypeIntegerdelete from user where id #{id}/delete/mapperspringboot的配置 application.yml
#服务端口配置
server:port: 8888
#日志配置
logging:path: logsfile: mylog.log#报告和数据库的配置
spring:application:name: reportdatasource:driver-class-name: com.mysql.jdbc.Driver #数据库驱动# 数据库的地址url: jdbc:mysql://localhost:3306/course?useSSLfalseuseUnicodetruecharacterEncodingutf-8servetTimeZoneAsia/Shanghaiusername: rootpassword: 123456mybatis:# 做映射的 com.course.model包下的对象type-aliases-package: com.course.model#加载resources/mapper下的文件mapper-locations:- mapper/* 日志的配置 logback.xml
?xml version1.0 encodingUTF-8?
!--
格式化日式的时间格式路径等
--
configurationinclude resourceorg/springframework/boot/logging/logback/defaults.xml/property nameFILE_LOG_PATTERN value%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{80} - %msg%n/property nameLOG_PATH value${LOG_PATH:-${LOG_TEMP:-${java.io.tmpdir:-/tmp}}}/appender nameFILE classch.qos.logback.core.rolling.RollingFileAppenderfile${LOG_PATH}/${LOG_FILE}/filerollingPolicy classch.qos.logback.core.rolling.TimeBasedRollingPolicyfileNamePattern${LOG_PATH}/${LOG_FILE}.%d{yyyy-MM-dd}/fileNamePattern/rollingPolicyencoder charsetUTF-8pattern${FILE_LOG_PATTERN}/pattern/encoder/appenderappender nameSTDOUT classch.qos.logback.core.ConsoleAppenderencoderpattern${FILE_LOG_PATTERN}/pattern/encoder/appenderappender nameCRAWLER_LOG classch.qos.logback.core.rolling.RollingFileAppenderfile${LOG_PATH}/event.log/filerollingPolicy classch.qos.logback.core.rolling.TimeBasedRollingPolicyfileNamePattern${LOG_PATH}/event.%d{yyyy-MM-dd}.log/fileNamePatternmaxHistory30/maxHistory/rollingPolicyencoder classch.qos.logback.classic.encoder.PatternLayoutEncoderpattern%msg%n/pattern/encoder/appenderlogger namecom.business.intelligence.util.CrawlerLogger levelINFO additivityfalseappender-ref refCRAWLER_LOG//loggerroot levelINFOappender-ref refSTDOUT/appender-ref refFILE//root/configuration数据库的配置 mybatis-config.xml
?xml version1.0 encodingUTF-8 ?
!DOCTYPE configurationPUBLIC -//mybatis.org//DTD Config 3.0//ENhttp://mybatis.org/dtd/mybatis-3-config.dtdconfiguration!-- 映射到哪个包里面--typeAliasespackage namecom.course.model//typeAliases!-- 映射到哪个sql文件里面--mappersmapper resourcemapper/mysql.xml//mappers
/configuration 1.3、测试 1.3.1、测试获取用户数 1.3.2、添加用户 1.3.3、数据的更新 1.3.4、数据的删除
