• idea中dataBase模板生成

     controller.java.vm

    1. ##定义初始变量
    2. #set($tableName = $tool.append($tableInfo.name, "Controller"))
    3. ##设置回调
    4. $!callback.setFileName($tool.append($tableName, ".java"))
    5. $!callback.setSavePath($tool.append($tableInfo.savePath, "/controller"))
    6. ##拿到主键
    7. #if(!$tableInfo.pkColumn.isEmpty())
    8.     #set($pk = $tableInfo.pkColumn.get(0))
    9. #end
    10.  
    11. #if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}controller;
    12.  
    13. import $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};
    14. import $!{tableInfo.savePackageName}.service.$!{tableInfo.name}Service;
    15. import org.springframework.data.domain.Page;
    16. import org.springframework.data.domain.PageRequest;
    17. import org.springframework.http.ResponseEntity;
    18. import org.springframework.web.bind.annotation.*;
    19.  
    20. import javax.annotation.Resource;
    21.  
    22. /**
    23.  * $!{tableInfo.comment}($!{tableInfo.name})表控制层
    24.  *
    25.  * @author $!author
    26.  * @since $!time.currTime()
    27.  */
    28. @RestController
    29. @RequestMapping("$!tool.firstLowerCase($tableInfo.name)")
    30. public class $!{tableName} {
    31.     /**
    32.      * 服务对象
    33.      */
    34.     @Resource
    35.     private $!{tableInfo.name}Service $!tool.firstLowerCase($tableInfo.name)Service;
    36.  
    37.     /**
    38.      * 分页查询
    39.      *
    40.      * @param $!{tool.firstLowerCase($tableInfo.name)} 筛选条件
    41.      * @param pageRequest      分页对象
    42.      * @return 查询结果
    43.      */
    44.     @GetMapping
    45.     public ResponseEntity> queryByPage($!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)}, PageRequest pageRequest) {
    46.         return ResponseEntity.ok(this.$!{tool.firstLowerCase($tableInfo.name)}Service.queryByPage($!{tool.firstLowerCase($tableInfo.name)}, pageRequest));
    47.     }
    48.  
    49.     /**
    50.      * 通过主键查询单条数据
    51.      *
    52.      * @param id 主键
    53.      * @return 单条数据
    54.      */
    55.     @GetMapping("{id}")
    56.     public ResponseEntity<$!{tableInfo.name}> queryById(@PathVariable("id") $!pk.shortType id) {
    57.         return ResponseEntity.ok(this.$!{tool.firstLowerCase($tableInfo.name)}Service.queryById(id));
    58.     }
    59.  
    60.     /**
    61.      * 新增数据
    62.      *
    63.      * @param $!{tool.firstLowerCase($tableInfo.name)} 实体
    64.      * @return 新增结果
    65.      */
    66.     @PostMapping
    67.     public ResponseEntity<$!{tableInfo.name}> add($!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)}) {
    68.         return ResponseEntity.ok(this.$!{tool.firstLowerCase($tableInfo.name)}Service.insert($!{tool.firstLowerCase($tableInfo.name)}));
    69.     }
    70.  
    71.     /**
    72.      * 编辑数据
    73.      *
    74.      * @param $!{tool.firstLowerCase($tableInfo.name)} 实体
    75.      * @return 编辑结果
    76.      */
    77.     @PutMapping
    78.     public ResponseEntity<$!{tableInfo.name}> edit($!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)}) {
    79.         return ResponseEntity.ok(this.$!{tool.firstLowerCase($tableInfo.name)}Service.update($!{tool.firstLowerCase($tableInfo.name)}));
    80.     }
    81.  
    82.     /**
    83.      * 删除数据
    84.      *
    85.      * @param id 主键
    86.      * @return 删除是否成功
    87.      */
    88.     @DeleteMapping
    89.     public ResponseEntity deleteById($!pk.shortType id) {
    90.         return ResponseEntity.ok(this.$!{tool.firstLowerCase($tableInfo.name)}Service.deleteById(id));
    91.     }
    92.  
    93. }

    entity.java.vm

    1. ##引入宏定义
    2. $!{define.vm}
    3.  
    4. ##使用宏定义设置回调（保存位置与文件后缀）
    5. #save("/model", ".java")
    6.  
    7. ##使用宏定义设置包后缀
    8. #setPackageSuffix("model")
    9.  
    10. ##使用全局变量实现默认包导入
    11. $!{autoImport.vm}
    12.  
    13. import javax.persistence.*;
    14. import io.swagger.annotations.ApiModelProperty;
    15.  
    16. import lombok.*;
    17. ##使用宏定义实现类注释信息
    18. #tableComment("$!{tableInfo.comment}")
    19. @Data
    20. @Builder
    21. @AllArgsConstructor
    22. @NoArgsConstructor
    23. @Table(name = "$!{tableInfo.obj.name}")
    24. public class $!{tableInfo.name}  {
    25.  
    26.  
    27. #if(${tableInfo.pkColumn})
    28.      @Id
    29.      #end
    30. #foreach($column in $tableInfo.fullColumn)
    31.     #if(${column.comment})/**
    32.      * ${column.comment}
    33.      */#end
    34.      
    35.     @Column(name = "$!column.obj.name")
    36. 	@ApiModelProperty(value ="${column.comment}")
    37.     private $!{tool.getClsNameByFullName($column.type)} $!{column.name};
    38.  
    39. #end
    40.  
    41.  
    42.  
    43. }

     dao.java.vm 

    1. ##引入mybatis支持
    2. $!{mybatisSupport.vm}
    3.  
    4. ##设置保存名称与保存位置
    5. $!callback.setFileName($tool.append($!{tableInfo.name}, "Dao.xml"))
    6. $!callback.setSavePath($tool.append($modulePath, "/src/main/resources/mapper"))
    7.  
    8. ##拿到主键
    9. #if(!$tableInfo.pkColumn.isEmpty())
    10.     #set($pk = $tableInfo.pkColumn.get(0))
    11. #end
    12.  
    13. "1.0" encoding="UTF-8"?>
    14. mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    15. <mapper namespace="$!{tableInfo.savePackageName}.dao.$!{tableInfo.name}Dao">
    16.  
    17.     <resultMap type="$!{tableInfo.savePackageName}.entity.$!{tableInfo.name}" id="$!{tableInfo.name}Map">
    18. #foreach($column in $tableInfo.fullColumn)
    19.         <result property="$!column.name" column="$!column.obj.name" jdbcType="$!column.ext.jdbcType"/>
    20. #end
    21.     resultMap>
    22.  
    23.     
    24.     <select id="queryById" resultMap="$!{tableInfo.name}Map">
    25.         select
    26.           #allSqlColumn()
    27.  
    28.         from $!tableInfo.obj.name
    29.         where $!pk.obj.name = #{$!pk.name}
    30.     select>
    31.  
    32.     
    33.     <select id="queryAllByLimit" resultMap="$!{tableInfo.name}Map">
    34.         select
    35.           #allSqlColumn()
    36.  
    37.         from $!tableInfo.obj.name
    38.         <where>
    39. #foreach($column in $tableInfo.fullColumn)
    40.             <if test="$!column.name != null#if($column.type.equals("java.lang.String")) and $!column.name != ''#end">
    41.                 and $!column.obj.name = #{$!column.name}
    42.             if>
    43. #end
    44.         where>
    45.         limit #{pageable.offset}, #{pageable.pageSize}
    46.     select>
    47.  
    48.     
    49.     <select id="count" resultType="java.lang.Long">
    50.         select count(1)
    51.         from $!tableInfo.obj.name
    52.         <where>
    53. #foreach($column in $tableInfo.fullColumn)
    54.             <if test="$!column.name != null#if($column.type.equals("java.lang.String")) and $!column.name != ''#end">
    55.                 and $!column.obj.name = #{$!column.name}
    56.             if>
    57. #end
    58.         where>
    59.     select>
    60.  
    61.     
    62.     <insert id="insert" keyProperty="$!pk.name" useGeneratedKeys="true">
    63.         insert into $!{tableInfo.obj.name}(#foreach($column in $tableInfo.otherColumn)$!column.obj.name#if($velocityHasNext), #end#end)
    64.         values (#foreach($column in $tableInfo.otherColumn)#{$!{column.name}}#if($velocityHasNext), #end#end)
    65.     insert>
    66.  
    67.     <insert id="insertBatch" keyProperty="$!pk.name" useGeneratedKeys="true">
    68.         insert into $!{tableInfo.obj.name}(#foreach($column in $tableInfo.otherColumn)$!column.obj.name#if($velocityHasNext), #end#end)
    69.         values
    70.         <foreach collection="entities" item="entity" separator=",">
    71.         (#foreach($column in $tableInfo.otherColumn)#{entity.$!{column.name}}#if($velocityHasNext), #end#end)
    72.         foreach>
    73.     insert>
    74.  
    75.     <insert id="insertOrUpdateBatch" keyProperty="$!pk.name" useGeneratedKeys="true">
    76.         insert into $!{tableInfo.obj.name}(#foreach($column in $tableInfo.otherColumn)$!column.obj.name#if($velocityHasNext), #end#end)
    77.         values
    78.         <foreach collection="entities" item="entity" separator=",">
    79.             (#foreach($column in $tableInfo.otherColumn)#{entity.$!{column.name}}#if($velocityHasNext), #end#end)
    80.         foreach>
    81.         on duplicate key update
    82.         #foreach($column in $tableInfo.otherColumn)$!column.obj.name = values($!column.obj.name)#if($velocityHasNext),
    83.         #end#end
    84.  
    85.     insert>
    86.  
    87.     
    88.     <update id="update">
    89.         update $!{tableInfo.obj.name}
    90.         <set>
    91. #foreach($column in $tableInfo.otherColumn)
    92.             <if test="$!column.name != null#if($column.type.equals("java.lang.String")) and $!column.name != ''#end">
    93.                 $!column.obj.name = #{$!column.name},
    94.             if>
    95. #end
    96.         set>
    97.         where $!pk.obj.name = #{$!pk.name}
    98.     update>
    99.  
    100.     
    101.     <delete id="deleteById">
    102.         delete from $!{tableInfo.obj.name} where $!pk.obj.name = #{$!pk.name}
    103.     delete>
    104.  
    105. mapper>

      service.java.vm

    1. ##定义初始变量
    2. #set($tableName = $tool.append($tableInfo.name, "Service"))
    3. ##设置回调
    4. $!callback.setFileName($tool.append($tableName, ".java"))
    5. $!callback.setSavePath($tool.append($tableInfo.savePath, "/service"))
    6.  
    7. ##拿到主键
    8. #if(!$tableInfo.pkColumn.isEmpty())
    9.     #set($pk = $tableInfo.pkColumn.get(0))
    10. #end
    11.  
    12. #if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}service;
    13.  
    14. import $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};
    15. import org.springframework.data.domain.Page;
    16. import org.springframework.data.domain.PageRequest;
    17.  
    18. /**
    19.  * $!{tableInfo.comment}($!{tableInfo.name})表服务接口
    20.  *
    21.  * @author $!author
    22.  * @since $!time.currTime()
    23.  */
    24. public interface $!{tableName} {
    25.  
    26.     /**
    27.      * 通过ID查询单条数据
    28.      *
    29.      * @param $!pk.name 主键
    30.      * @return 实例对象
    31.      */
    32.     $!{tableInfo.name} queryById($!pk.shortType $!pk.name);
    33.  
    34.     /**
    35.      * 分页查询
    36.      *
    37.      * @param $!tool.firstLowerCase($!{tableInfo.name}) 筛选条件
    38.      * @param pageRequest      分页对象
    39.      * @return 查询结果
    40.      */
    41.     Page<$!{tableInfo.name}> queryByPage($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}), PageRequest pageRequest);
    42.  
    43.     /**
    44.      * 新增数据
    45.      *
    46.      * @param $!tool.firstLowerCase($!{tableInfo.name}) 实例对象
    47.      * @return 实例对象
    48.      */
    49.     $!{tableInfo.name} insert($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));
    50.  
    51.     /**
    52.      * 修改数据
    53.      *
    54.      * @param $!tool.firstLowerCase($!{tableInfo.name}) 实例对象
    55.      * @return 实例对象
    56.      */
    57.     $!{tableInfo.name} update($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));
    58.  
    59.     /**
    60.      * 通过主键删除数据
    61.      *
    62.      * @param $!pk.name 主键
    63.      * @return 是否成功
    64.      */
    65.     boolean deleteById($!pk.shortType $!pk.name);
    66.  
    67. }

     serviceImpl.java.vm

    1. ##定义初始变量
    2. #set($tableName = $tool.append($tableInfo.name, "ServiceImpl"))
    3. ##设置回调
    4. $!callback.setFileName($tool.append($tableName, ".java"))
    5. $!callback.setSavePath($tool.append($tableInfo.savePath, "/service/impl"))
    6.  
    7. ##拿到主键
    8. #if(!$tableInfo.pkColumn.isEmpty())
    9.     #set($pk = $tableInfo.pkColumn.get(0))
    10. #end
    11.  
    12. #if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}service.impl;
    13.  
    14. import $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};
    15. import $!{tableInfo.savePackageName}.dao.$!{tableInfo.name}Dao;
    16. import $!{tableInfo.savePackageName}.service.$!{tableInfo.name}Service;
    17. import org.springframework.stereotype.Service;
    18. import org.springframework.data.domain.Page;
    19. import org.springframework.data.domain.PageImpl;
    20. import org.springframework.data.domain.PageRequest;
    21.  
    22. import javax.annotation.Resource;
    23.  
    24. /**
    25.  * $!{tableInfo.comment}($!{tableInfo.name})表服务实现类
    26.  *
    27.  * @author $!author
    28.  * @since $!time.currTime()
    29.  */
    30. @Service("$!tool.firstLowerCase($!{tableInfo.name})Service")
    31. public class $!{tableName} implements $!{tableInfo.name}Service {
    32.     @Resource
    33.     private $!{tableInfo.name}Dao $!tool.firstLowerCase($!{tableInfo.name})Dao;
    34.  
    35.     
    36. }

     mapper.xml.vm

    1. ##定义初始变量
    2. #set($tableName = $tool.append($tableInfo.name, "Dao"))
    3. ##设置回调
    4. $!callback.setFileName($tool.append($tableName, ".java"))
    5. $!callback.setSavePath($tool.append($tableInfo.savePath, "/dao"))
    6.  
    7. ##拿到主键
    8. #if(!$tableInfo.pkColumn.isEmpty())
    9.     #set($pk = $tableInfo.pkColumn.get(0))
    10. #end
    11.  
    12. #if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}dao;
    13.  
    14. import $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};
    15. import org.apache.ibatis.annotations.Param;
    16. import org.springframework.data.domain.Pageable;
    17. import java.util.List;
    18.  
    19. /**
    20.  * $!{tableInfo.comment}($!{tableInfo.name})表数据库访问层
    21.  *
    22.  * @author $!author
    23.  * @since $!time.currTime()
    24.  */
    25. public interface $!{tableName} {
    26.  
    27.     /**
    28.      * 通过ID查询单条数据
    29.      *
    30.      * @param $!pk.name 主键
    31.      * @return 实例对象
    32.      */
    33.     $!{tableInfo.name} queryById($!pk.shortType $!pk.name);
    34.  
    35.     /**
    36.      * 查询指定行数据
    37.      *
    38.      * @param $!tool.firstLowerCase($!{tableInfo.name}) 查询条件
    39.      * @param pageable         分页对象
    40.      * @return 对象列表
    41.      */
    42.     List<$!{tableInfo.name}> queryAllByLimit($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}), @Param("pageable") Pageable pageable);
    43.  
    44.     /**
    45.      * 统计总行数
    46.      *
    47.      * @param $!tool.firstLowerCase($!{tableInfo.name}) 查询条件
    48.      * @return 总行数
    49.      */
    50.     long count($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));
    51.  
    52.     /**
    53.      * 新增数据
    54.      *
    55.      * @param $!tool.firstLowerCase($!{tableInfo.name}) 实例对象
    56.      * @return 影响行数
    57.      */
    58.     int insert($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));
    59.  
    60.     /**
    61.      * 批量新增数据（MyBatis原生foreach方法）
    62.      *
    63.      * @param entities List<$!{tableInfo.name}> 实例对象列表
    64.      * @return 影响行数
    65.      */
    66.     int insertBatch(@Param("entities") List<$!{tableInfo.name}> entities);
    67.  
    68.     /**
    69.      * 批量新增或按主键更新数据（MyBatis原生foreach方法）
    70.      *
    71.      * @param entities List<$!{tableInfo.name}> 实例对象列表
    72.      * @return 影响行数
    73.      * @throws org.springframework.jdbc.BadSqlGrammarException 入参是空List的时候会抛SQL语句错误的异常，请自行校验入参
    74.      */
    75.     int insertOrUpdateBatch(@Param("entities") List<$!{tableInfo.name}> entities);
    76.  
    77.     /**
    78.      * 修改数据
    79.      *
    80.      * @param $!tool.firstLowerCase($!{tableInfo.name}) 实例对象
    81.      * @return 影响行数
    82.      */
    83.     int update($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));
    84.  
    85.     /**
    86.      * 通过主键删除数据
    87.      *
    88.      * @param $!pk.name 主键
    89.      * @return 影响行数
    90.      */
    91.     int deleteById($!pk.shortType $!pk.name);
    92.  
    93. }

  • 相关阅读:
    2022-07-20 mysql-hashJoin说明
    【LeetCode-中等题】15. 三数之和
    uniapp实现App弹窗更新升级（完整版）热更新
    PE文件-C++-SetCurrentDirectory当前工作文件夹编辑-GetCommandLine函数获取当前命令行参数
    C++:计算两个二维/三维向量间夹角
    ip组成及解决
    Session攻击
    4、Kafka 消费者
    Kafka第一讲：应用场景及架构设计详解
    SpringMVC获得请求数据
  • 原文地址：https://blog.csdn.net/xnian_/article/details/132857250