开始
mybatis代码自动生成:
package com.fms.demo1.util;
import com.baomidou.mybatisplus.generator.AutoGenerator;
import com.baomidou.mybatisplus.generator.config.DataSourceConfig;
import com.baomidou.mybatisplus.generator.config.GlobalConfig;
import com.baomidou.mybatisplus.generator.config.PackageConfig;
import com.baomidou.mybatisplus.generator.config.StrategyConfig;
import com.baomidou.mybatisplus.generator.config.TemplateConfig;
import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;
import com.baomidou.mybatisplus.generator.engine.FreemarkerTemplateEngine;
public class MyBatisPlusGenerater {
static String packageName = "com.example.demo"; // 当前包名
static String author = "MyBatisPlusGenerater"; // 作者
static String sqlUrl = "mysql://localhost/"; // 数据库类型及地址
static String sqlDb = "fms"; // 数据库名
static String sqlUser = "root";
static String sqlPassword = "root";
static String table = "gc_orders,rbac_admin"; // 表,用逗号隔开
public static void main(String[] args) {
// 代码生成器
AutoGenerator mpg = new AutoGenerator();
// 全局配置
GlobalConfig gc = new GlobalConfig();
gc.setOutputDir(System.getProperty("user.dir") + "/src/main/java/com/fms/demo1/entity");
//src\main\java\com\fms\demo1
gc.setAuthor(author);
gc.setOpen(false);
gc.setServiceName("%sService");
mpg.setGlobalConfig(gc);
// 数据源配置
DataSourceConfig dsc = new DataSourceConfig();
dsc.setUrl("jdbc:" + sqlUrl + sqlDb + "?useUnicode=true&useSSL=false&characterEncoding=utf8");
dsc.setDriverName("com.mysql.cj.jdbc.Driver");
dsc.setUsername(sqlUser);
dsc.setPassword(sqlPassword);
mpg.setDataSource(dsc);
// 包配置
PackageConfig pc = new PackageConfig();
pc.setParent(packageName);
pc.setEntity("model");
mpg.setPackageInfo(pc);
// 配置模板
TemplateConfig templateConfig = new TemplateConfig();
templateConfig.setXml(null); // 不生成MapperXML
mpg.setTemplate(templateConfig);
// 策略配置
StrategyConfig strategy = new StrategyConfig();
strategy.setNaming(NamingStrategy.underline_to_camel);
strategy.setColumnNaming(NamingStrategy.underline_to_camel);
strategy.setRestControllerStyle(true);
strategy.setEntityTableFieldAnnotationEnable(true);
strategy.setInclude(table.split(","));
strategy.setControllerMappingHyphenStyle(true);
// strategy.setTablePrefix("t_"); // 表前缀,如t_user,没有就注释掉此行
mpg.setStrategy(strategy);
mpg.setTemplateEngine(new FreemarkerTemplateEngine());
mpg.execute();
}
}
@MapperScan(basePackages = "com.qf.first.springboot.mapper")
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql:///fms?serverTimezone=UTC
username: root
password: root
type: com.alibaba.druid.pool.DruidDataSource
测试:
注解方式整合mybatis
logging:
level:
com.fms.demo1.mapper: DEBUG
springboot分页:
jsp
<h1>jsp ${name}</h1>