原创转载请注明出处:https://www.cnblogs.com/agilestyle/p/15030904.html
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>org.fool</groupId> <artifactId>hellomybatisplus</artifactId> <version>1.0-SNAPSHOT</version> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.3.12.RELEASE</version> <relativePath/> </parent> <properties> <maven.compiler.source>8</maven.compiler.source> <maven.compiler.target>8</maven.compiler.target> </properties> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid-spring-boot-starter</artifactId> <version>1.2.6</version> </dependency> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-boot-starter</artifactId> <version>3.4.3.1</version> </dependency> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-generator</artifactId> <version>3.4.1</version> </dependency> <dependency> <groupId>org.freemarker</groupId> <artifactId>freemarker</artifactId> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> </plugin> </plugins> </build> </project>
schema.sql
CREATE TABLE `tb_user` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(30) DEFAULT NULL, `password` varchar(30) DEFAULT NULL, `age` int(10) unsigned DEFAULT NULL, `create_by` varchar(30) NOT NULL, `update_by` varchar(30) NOT NULL, `create_time` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `update_time` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3), PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CodeGenerator.java
package org.fool.mybatisplus.generator; import com.baomidou.mybatisplus.annotation.DbType; import com.baomidou.mybatisplus.annotation.IdType; import com.baomidou.mybatisplus.core.toolkit.StringPool; import com.baomidou.mybatisplus.generator.AutoGenerator; import com.baomidou.mybatisplus.generator.InjectionConfig; import com.baomidou.mybatisplus.generator.config.DataSourceConfig; import com.baomidou.mybatisplus.generator.config.FileOutConfig; 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.po.TableInfo; import com.baomidou.mybatisplus.generator.config.rules.DateType; import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy; import com.baomidou.mybatisplus.generator.engine.FreemarkerTemplateEngine; import java.util.ArrayList; import java.util.List; public class CodeGenerator { public static void main(String[] args) { // 代码生成器 AutoGenerator mpg = new AutoGenerator(); // 全局配置 GlobalConfig gc = new GlobalConfig(); String projectPath = System.getProperty("user.dir"); gc.setOutputDir(projectPath + "/src/main/java"); gc.setAuthor("admin"); gc.setOpen(false); gc.setFileOverride(true); gc.setIdType(IdType.AUTO); gc.setDateType(DateType.ONLY_DATE); mpg.setGlobalConfig(gc); // 数据源配置 DataSourceConfig dsc = new DataSourceConfig(); dsc.setUrl("jdbc:mysql://localhost:3306/test?useUnicode=true&useSSL=false&characterEncoding=utf8"); dsc.setDriverName("com.mysql.cj.jdbc.Driver"); dsc.setUsername("root"); dsc.setPassword("123456"); dsc.setDbType(DbType.MYSQL); mpg.setDataSource(dsc); // 包配置 PackageConfig pc = new PackageConfig(); pc.setParent("org.fool.mybatisplus"); pc.setEntity("entity"); pc.setMapper("mapper"); mpg.setPackageInfo(pc); // 自定义配置 InjectionConfig cfg = new InjectionConfig() { @Override public void initMap() { // to do nothing } }; // 如果模板引擎是 freemarker String templatePath = "/templates/mapper.xml.ftl"; // 自定义输出配置 List<FileOutConfig> focList = new ArrayList<>(); // 自定义配置会被优先输出 focList.add(new FileOutConfig(templatePath) { @Override public String outputFile(TableInfo tableInfo) { // 自定义输出文件名 , 如果你 Entity 设置了前后缀、此处注意 xml 的名称会跟着发生变化!! return projectPath + "/src/main/resources/mapper/" + pc.getModuleName() + "/" + tableInfo.getEntityName() + "Mapper" + StringPool.DOT_XML; } }); /* cfg.setFileCreate(new IFileCreate() { @Override public boolean isCreate(ConfigBuilder configBuilder, FileType fileType, String filePath) { // 判断自定义文件夹是否需要创建 checkDir("调用默认方法创建的目录,自定义目录用"); if (fileType == FileType.MAPPER) { // 已经生成 mapper 文件判断存在,不想重新生成返回 false return !new File(filePath).exists(); } // 允许生成模板文件 return true; } }); */ cfg.setFileOutConfigList(focList); mpg.setCfg(cfg); // 配置模板 TemplateConfig templateConfig = new TemplateConfig(); templateConfig.setService(null); templateConfig.setServiceImpl(null); templateConfig.setController(null); templateConfig.setXml(null); mpg.setTemplate(templateConfig); // 策略配置 StrategyConfig strategy = new StrategyConfig(); strategy.setNaming(NamingStrategy.underline_to_camel); strategy.setColumnNaming(NamingStrategy.underline_to_camel); strategy.setEntityLombokModel(true); strategy.setEntitySerialVersionUID(false); strategy.setInclude("tb_user"); strategy.setTablePrefix("tb_"); mpg.setStrategy(strategy); mpg.setTemplateEngine(new FreemarkerTemplateEngine()); mpg.execute(); } }
UserMapper.xml
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="org.fool.mybatisplus.mapper.UserMapper"> </mapper>
User.java
package org.fool.mybatisplus.entity; import com.baomidou.mybatisplus.annotation.TableName; import com.baomidou.mybatisplus.annotation.IdType; import java.util.Date; import com.baomidou.mybatisplus.annotation.TableId; import java.io.Serializable; import lombok.Data; import lombok.EqualsAndHashCode; /** * <p> * * </p> * * @author admin * @since 2021-07-19 */ @Data @EqualsAndHashCode(callSuper = false) @TableName("tb_user") public class User implements Serializable { @TableId(value = "id", type = IdType.AUTO) private Long id; private String username; private String password; private Integer age; private String createBy; private String updateBy; private Date createTime; private Date updateTime; }
UserMapper.java
package org.fool.mybatisplus.mapper; import org.fool.mybatisplus.entity.User; import com.baomidou.mybatisplus.core.mapper.BaseMapper; /** * <p> * Mapper 接口 * </p> * * @author admin * @since 2021-07-19 */ public interface UserMapper extends BaseMapper<User> { }
application.properties
server.port=8080 logging.level.org.fool.mybatisplus=debug mybatis.mapper-locations=classpath:mapper/**/*.xml spring.datasource.url=jdbc:mysql://localhost:3306/test?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai spring.datasource.username=root spring.datasource.password=123456 spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver spring.datasource.type=com.alibaba.druid.pool.DruidDataSource spring.datasource.druid.initial-size=5 spring.datasource.druid.max-active=50 spring.datasource.druid.min-idle=5 spring.datasource.druid.max-wait=60000 spring.datasource.druid.min-evictable-idle-time-millis=300000 spring.datasource.druid.validation-query=SELECT 1 FROM DUAL spring.datasource.druid.test-while-idle=true spring.datasource.druid.test-on-borrow=false spring.datasource.druid.test-on-return=false spring.datasource.druid.filters=stat,wall spring.datasource.druid.connection-properties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500 spring.datasource.druid.use-global-data-source-stat=true
Application.java
package org.fool.mybatisplus; import org.mybatis.spring.annotation.MapperScan; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; @SpringBootApplication @MapperScan("org.fool.mybatisplus.mapper") public class Application { public static void main(String[] args) { SpringApplication.run(Application.class, args); } }
UserService.java
package org.fool.mybatisplus.service; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import lombok.extern.slf4j.Slf4j; import org.fool.mybatisplus.entity.User; import org.fool.mybatisplus.mapper.UserMapper; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import java.util.List; @Service @Slf4j public class UserService { @Autowired private UserMapper userMapper; @Transactional(rollbackFor = Exception.class) public int addUser(User user) { user.setCreateBy("admin"); user.setUpdateBy("admin"); log.info("user: {}", user); return userMapper.insert(user); } @Transactional(rollbackFor = Exception.class) public int updateUser(User user) { log.info("user: {}", user); return userMapper.updateById(user); } @Transactional(rollbackFor = Exception.class) public int deleteUser(long id) { return userMapper.deleteById(id); } public User getUserById(long id) { return userMapper.selectById(id); } public List<User> getAllUsers() { return userMapper.selectList(Wrappers.lambdaQuery()); } }
UserController.java
package org.fool.mybatisplus.controller; import lombok.extern.slf4j.Slf4j; import org.fool.mybatisplus.entity.User; import org.fool.mybatisplus.service.UserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.DeleteMapping; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.PutMapping; import org.springframework.web.bind.annotation.RestController; import java.util.List; import java.util.Random; @RestController @Slf4j public class UserController { @Autowired private UserService userService; @GetMapping("/get") public List<User> get() { return userService.getAllUsers(); } @GetMapping("/get/{id}") public User getById(@PathVariable long id) { return userService.getUserById(id); } @PostMapping("/add/{count}") public String add(@PathVariable int count) { int result = 0; for (int i = 0; i < count; i++) { User user = new User(); user.setUsername("username" + i); user.setPassword("password" + i); user.setAge(new Random().nextInt(100)); result += userService.addUser(user); } return result == count ? "SUCCESS" : "FAILURE"; } @PutMapping("/update/{id}") public String update(@PathVariable long id) { User user = new User(); user.setId(id); String temp = "update" + id; user.setUsername(temp); user.setPassword(temp); int result = userService.updateUser(user); return result == 1 ? "SUCCESS" : "FAILURE"; } @DeleteMapping("/delete/{id}") public String delete(@PathVariable long id) { int result = userService.deleteUser(id); return result == 1 ? "SUCCESS" : "FAILURE"; } }
create
curl --location --request POST 'http://localhost:8080/add/100' \ --header 'Content-Type: application/json' \ --data-raw ''
getAll
curl --location --request GET 'http://localhost:8080/get' \ --header 'Content-Type: application/json' \ --data-raw ''
getById
curl --location --request GET 'http://localhost:8080/get/10' \ --header 'Content-Type: application/json' \ --data-raw ''
update
curl --location --request PUT 'http://localhost:8080/update/2' \ --header 'Content-Type: application/json' \ --data-raw ''
delete
curl --location --request DELETE 'http://localhost:8080/delete/3' \ --header 'Content-Type: application/json' \ --data-raw ''
https://baomidou.com/guide/generator.html
欢迎点赞关注和转发