#修改端口号
server.port=8888
#定义项目的访问目录
server.servlet.context-path=/springboot
####MyBatis配置
#数据库驱动
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
#数据库连接地址
spring.datasource.url=jdbc:mysql://localhost:3306/mall?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai
#数据库用户名
spring.datasource.username=root
#数据库用户密码
spring.datasource.password=123456
#映射文件的位置
mybatis.mapper-locations=classpath:com/mall/dao/*Dao.xml
#类型别名
mybatis.type-aliases-package=com.mall.entity
#####分页插件配置
#方言
pagehelper.helperDialect=mysql
#合理化
pagehelper.reasonable=true
pagehelper.supportMethodsArguments=true
pagehelper.params=count=countSql
#####Thymeleaf配置文件
spring.thymeleaf.cache=false
spring.thymeleaf.mode=HTML
#编码
spring.thymeleaf.encoding=UTF-8
spring.thymeleaf.check-template=true
#类型
spring.thymeleaf.servlet.content-type=text/html
#前缀
spring.thymeleaf.prefix=classpath:/templates/
#后缀
spring.thymeleaf.suffix=.html
#springboot启动画面配置指定文件
spring.banner.location=banner.txt
#配置sql打印(其中com.springboot.dao表示 dao层的接口位置)
logging.level.com.springboot.dao=debug
假如一个项目中有.yml .yaml .properties文件
优先级为properties>yaml>yml,也就是properties里配置的内容会覆盖另外两个的配置
package com.mall.dao;
import org.junit.runner.RunWith;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;
import javax.annotation.Resource;
@RunWith(SpringRunner.class)
@SpringBootTest
public class UserDaoTest {
@Resource
private UserDao userDao;
@org.junit.Test
public void findAll() {
System.out.println(userDao.findAll());
}
}
package com.mall.vo;
import lombok.Data;
@Data
public class Result<T> {
private Integer code;
private String msg;
private T data;
public static Result<Object> success(Object object) {
Result<Object> result = new Result<>();
result.setCode(1);
result.setMsg("成功");
result.setData(object);
return result;
}
public static Result<Object> success() {
return success(null);
}
public static Result<Object> fail(String msg) {
Result<Object> result = new Result<>();
result.setCode(0);
result.setMsg(msg);
return result;
}
public static Result<Object> fail(Integer code, String msg, Object object) {
Result<Object> result = new Result<>();
result.setCode(0);
result.setMsg(msg);
result.setData(object);
return result;
}
}
${AnsiColor.BRIGHT_YELLOW}
// _ooOoo_ //
// o8888888o //
// 88" . "88 //
// (| ^_^ |) //
// O\ = /O //
// ____/`---'\____ //
// .' \\| |// `. //
// / \\||| : |||// \ //
// / _||||| -:- |||||- \ //
// | | \\\ - /// | | //
// | \_| ''\---/'' | | //
// \ .-\__ `-` ___/-. / //
// ___`. .' /--.--\ `. . ___ //
// ."" '< `.___\_<|>_/___.' >'"". //
// | | : `- \`.;`\ _ /`;.`/ - ` : | | //
// \ \ `-. \_ __\ /__ _/ .-` / / //
// ========`-.____`-.___\_____/___.-`____.-'======== //
// `=---=' //
// ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ //
// 佛祖保佑 永不宕机 永无BUG //
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.2</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
<exclusions>
<exclusion>
<groupId>org.junit.vintage</groupId>
<artifactId>junit-vintage-engine</artifactId>
</exclusion>
</exclusions>
</dependency>
<!--连接mysql-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
<!--mybatis-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.6</version>
</dependency>
<!--分页插件-->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.5</version>
</dependency>
<!--sql 解析工具-->
<dependency>
<groupId>com.github.jsqlparser</groupId>
<artifactId>jsqlparser</artifactId>
<version>1.2</version>
</dependency>
<!--单元测试-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>compile</scope>
</dependency>
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
</dependencies>
#debug->info->warn->error->fatal
#log4j.rootLogger=debug, A1
log4j.appender.A1=org.apache.log4j.ConsoleAppender
log4j.appender.A1.layout=org.apache.log4j.PatternLayout
log4j.appender.A1.layout.ConversionPattern=[%-5p]:(%t)%m %n
### 把日志信息输出到文件:log.html ###
log4j.appender.f1=org.apache.log4j.FileAppender
log4j.appender.f1.File=log.html
log4j.appender.f1.layout=org.apache.log4j.HTMLLayout
### 把日志信息输出到数据库 ###
log4j.appender.sql=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.sql.Driver=com.mysql.jdbc.Driver
log4j.appender.sql.URL=jdbc:mysql://127.0.0.1:3306/db9?useUnicode=true&characterEncoding=utf8
log4j.appender.sql.User=root
log4j.appender.sql.Password=123456
log4j.appender.sql.Sql=insert into `log4j`(`time`,`level`,`message`, `thread`) values(now(),'%p','%m','%t')
### 根记录器:设置优先级别、以及输出源 ###
log4j.rootLogger=debug,A1