Fluent Mybatis让你摆脱Xml文件的技巧

drop table if exists `t_user`;

create table `t_user`

(

     id bigint auto_increment comment '主键id' primary key,

     name varchar( 30 ) charset utf8 null comment '姓名' ,

     age int null comment '年龄' ,

     email varchar( 50 ) charset utf8 null comment '邮箱' ,

     gmt_create datetime null comment '记录创建时间' ,

     gmt_modified datetime null comment '记录最后修改时间' ,

     is_deleted tinyint( 2 ) default 0 null comment '逻辑删除标识'

);

<?xml version= "1.0" encoding= "utf-8" ?>

<project xmlns= "http://maven.apache.org/pom/4.0.0" xmlns:xsi= "http://HdhCmsTestw3.org/2001/xmlschema-instance"

          xsi:schemalocation= "http://maven.apache.org/pom/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd" >

     <modelversion> 4.0 . 0 </modelversion>

     <parent>

         <groupid>org.springframework.boot</groupid>

         <artifactid>spring-boot-starter-parent</artifactid>

         <version> 2.3 . 1 .release</version>

         <relativepath/> <!-- lookup parent from repository -->

     </parent>

     <groupid>com.mybatis.fluent</groupid>

     <artifactid>fluent_mybatis</artifactid>

     <version> 0.0 . 1 -snapshot</version>

     <name>fluent_mybatis</name>

     <description>demo project for spring boot</description>

     <properties>

         <java.version> 1.8 </java.version>

         <fluent.mybatis.version> 1.5 . 6 </fluent.mybatis.version>

     </properties>

     <dependencies>

         <dependency>

             <groupid>org.springframework.boot</groupid>

             <artifactid>spring-boot-starter</artifactid>

         </dependency>

         <!--jdbc驱动-->

         <dependency>

             <groupid>mysql</groupid>

             <artifactid>mysql-connector-java</artifactid>

             <scope>runtime</scope>

         </dependency>

         <!--mybatis-->

         <dependency>

             <groupid>org.mybatis.spring.boot</groupid>

             <artifactid>mybatis-spring-boot-starter</artifactid>

             <version> 2.0 . 1 </version>

         </dependency>

         <!-- fluent mybatis依赖-->

         <dependency>

             <groupid>com.github.atool</groupid>

             <artifactid>fluent-mybatis</artifactid>

             <version>${fluent.mybatis.version}</version>

         </dependency>

         <dependency>

             <groupid>com.github.atool</groupid>

             <artifactid>fluent-mybatis-processor</artifactid>

             <version>${fluent.mybatis.version}</version>

             <scope>provided</scope>

         </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>

     </dependencies>

     <build>

         <plugins>

             <plugin>

                 <groupid>org.springframework.boot</groupid>

                 <artifactid>spring-boot-maven-plugin</artifactid>

                 <configuration>

                     <excludes>

                         <exclude>

                             <groupid>org.projectlombok</groupid>

                             <artifactid>lombok</artifactid>

                         </exclude>

                     </excludes>

                 </configuration>

             </plugin>

         </plugins>

     </build>

</project>

import cn.org.atool.generator.filegenerator;

import cn.org.atool.generator.annotation.table;

import cn.org.atool.generator.annotation.tables;

public class appentitygenerator {

     public static void main(string[] args) {

         filegenerator.build(abc. class );

     }

     @tables (

             /** 数据库连接信息 **/

             url = "jdbc:mysql://ip:3306/test?usessl=false&useunicode=true&characterencoding=utf-8&servertimezone=asia/shanghai" ,

             username = "xxxxxx" ,

             password = "xxxxxx" ,

             /** entity类parent package路径 **/

             basepack = "com.mybatis.fluent.fluent_mybatis" ,

             /** entity代码源目录 **/

             srcdir = "/src/main/java" ,

             /** dao代码源目录 **/

             daodir = "/src/main/java" ,

             /** 如果表定义记录创建，记录修改，逻辑删除字段 **/

             gmtcreated = "gmt_create" , gmtmodified = "gmt_modified" , logicdeleted = "is_deleted" ,

             /** 需要生成文件的表 **/

             tables = @table (value = { "t_user" })

     )

     static class abc {

     }

}

import cn.org.atool.generator.filegenerator;

import cn.org.atool.generator.annotation.table;

import cn.org.atool.generator.annotation.tables;

import cn.org.atool.generator.database.dbtype;

public class appentitygenerator {

     public static void main(string[] args) {

         filegenerator.build(abc. class );

     }

     @tables (

             /** 数据库连接信息 **/

             dbtype= dbtype.oracle,

             driver= "oracle.jdbc.oracledriver" ,

             url = "jdbc:oracle:thin:@ip:1521:orcl" ,

             username = "xxxxxx" ,

             password = "xxxxxx" ,

             /** entity类parent package路径 **/

             basepack = "com.mybatis.fluent.fluent_mybatis" ,

             /** entity代码源目录 **/

             srcdir = "/src/main/java" ,

             /** dao代码源目录 **/

             daodir = "/src/main/java" ,

             /** 如果表定义记录创建，记录修改，逻辑删除字段 **/

             gmtcreated = "insert_date_time" ,

             /** 需要生成文件的表 **/

             tables = @table (value = { "table_name" })

     )

     static class abc {

     }

}

import cn.org.atool.fluent.mybatis.model.ipagedlist;

import cn.org.atool.fluent.mybatis.model.stdpagedlist;

import com.mybatis.fluent.fluent_mybatis.dao.impl.hospitalinfodaoimpl;

import com.mybatis.fluent.fluent_mybatis.dao.impl.tuserdaoimpl;

import com.mybatis.fluent.fluent_mybatis.entity.hospitalinfoentity;

import com.mybatis.fluent.fluent_mybatis.entity.tuserentity;

import com.mybatis.fluent.fluent_mybatis.helper.tuserwrapperhelper;

import com.mybatis.fluent.fluent_mybatis.wrapper.hospitalinfoquery;

import com.mybatis.fluent.fluent_mybatis.wrapper.tuserquery;

import org.junit.jupiter.api.test;

import org.springframework.boot.test.context.springboottest;

import javax.annotation.resource;

import java.io.serializable;

import java.util.list;

@springboottest

class fluentmybatisapplicationtests {

     @resource

     private tuserdaoimpl dao;

     @test

     void add() {

         tuserentity entity = new tuserentity().setage( 20 ).setemail( "122@163测试数据" ).setname( "lisi" ).setisdeleted( false );

         serializable id = dao.save(entity);

         system.out.println( "插入后返回的主键id为：" + id);

     }

     @test

     void select(){

         /**

          * 分页查询构造条件

          */

         tuserquery query = tuserquery.query().limit( 0 , 1 );

         list<tuserentity> list = dao.listentity(query);

         system.out.println(list);

     }

     @test

     void updata(){

         tuserentity entity = dao.selectbyid(1l);

         system.out.println(entity);

         entity.setage( 2000 ).setemail( "120098922@qq测试数据" ).setname( "lisi111" ).setisdeleted( true );

         system.out.println(entity);

         boolean b = dao.updatebyid(entity);

         system.out.println(b);

     }

     @test

     void delete(){

         boolean b = dao.deletebyid(1l);

         system.out.println(b);

         tuserquery query = tuserquery.query();

         list<tuserentity> list = dao.listentity(query);

         system.out.println(list);

     }

}