1、创建 application.properties 文件配置 MyBatisPlus
代码(注意修改数据库的名称,数据库用户名和数据库密码,以及mysql的版本,mysql5版本使用com.mysql.jdbc.Driver否则为com.mysql.cj.jdbc.Driver)
#??JSP?????????
spring.mvc.view.prefix=/
#??JSP?????????
spring.mvc.view.suffix=.jsp
#spring.mvc.static-path-pattern=/docs/**
### ?????
#?????URL??
spring.datasource.url=jdbc:mysql://localhost:3306/stock_control?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC
#???????????????????
spring.datasource.username=xx
#?????????????????
spring.datasource.password=xx
#?????????? mysql ???? 5.x ????? com.mysql.jdbc.Driver?
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
### mybatisPlus??
#??????????
mybatis-plus.type-aliases-package=com.example.model
#??SQL?????????
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
#????????
mybatis-plus.configuration.map-underscore-to-camel-case=true
spring.mvc.format.date=yyyy-MM-dd hh:mm
2、编写启动类
代码示例
package com.example;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
@MapperScan("com.example.mapper")
public class stockControlApplication {
public static void main(String[] args) {
SpringApplication.run(stockControlApplication.class, args);
}
}
3、编写mapper接口(其中有小鸟的是mybatisplus里面的方法不够用,自己创建的接口)