idea 生成jpa的mvc三层

embedded/2025/3/16 0:27:30/

一、连上数据库
在这里插入图片描述
二、选择 Go to Scripts Directory
在这里插入图片描述
三、修改内容为：

import com.intellij.database.model.DasTable
import com.intellij.database.model.ObjectKind
import com.intellij.database.util.Case
import com.intellij.database.util.DasUtilimport java.text.SimpleDateFormatconfig = [impSerializable  : true,extendBaseEntity : false,extendBaseService: false,useLombok        : true, // 不使用会生成get、set方法// 不生成哪个就注释哪个generateItem     : ["Entity","Service","Controller",//第一步"Repository",
//                "RepositoryCustom",
//                "RepositoryImpl",
//                "ServiceImpl",]
]baseEntityPackage = "com.dz.demo.framework.base.BaseEntity"
baseServicePackage = "com.dz.demo.framework.base.BaseService"
baseEntityProperties = ["id", "createDate", "lastModifiedDate", "version"]typeMapping = [(~/(?i)bool|boolean|tinyint/)     : "Boolean",(~/(?i)bigint/)                   : "Long",(~/int/)                          : "Integer",(~/(?i)float|double|decimal|real/): "Double",(~/(?i)datetime|timestamp/)       : "java.util.Date",(~/(?i)date/)                     : "java.sql.Date",(~/(?i)time/)                     : "java.sql.Time",(~/(?i)/)                         : "String"
]FILES.chooseDirectoryAndSave("Choose directory", "Choose where to store generated files") { dir ->SELECTION.filter {it instanceof DasTable && it.getKind() == ObjectKind.TABLE}.each {generate(it, dir)}
}// 生成对应的文件              开始起飞
def generate(table, dir) {def entityPath = "${dir.toString()}\\entity",servicePath = "${dir.toString()}\\service",repPath = "${dir.toString()}\\repository",
//      repImpPath = "${dir.toString()}\\repository\\impl",serviceImplPath = "${dir.toString()}\\service\\impl",controllerPath = "${dir.toString()}\\controller"mkdirs([entityPath, servicePath, repPath, serviceImplPath, controllerPath])System.out.println(table.getName())def entityName = javaName(table.getName(), true)def fields = calcFields(table)def basePackage = clacBasePackage(dir)if (isGenerate("Entity")) {genUTF8File(entityPath, "${entityName}.java").withPrintWriter { out -> genEntity(out, table, entityName, fields, basePackage) }}if (isGenerate("Service")) {genUTF8File(servicePath, "${entityName}Service.java").withPrintWriter { out -> genService(out, table, entityName, fields, basePackage) }}//第二步 记得改后面的方法if (isGenerate("Controller")) {genUTF8File(controllerPath, "${entityName}Controller.java").withPrintWriter { out -> genController(out, table, entityName, fields, basePackage) }}if (isGenerate("Repository")) {genUTF8File(repPath, "${entityName}Repository.java").withPrintWriter { out -> genRepository(out, table, entityName, fields, basePackage) }}if (isGenerate("RepositoryCustom")) {genUTF8File(repPath, "${entityName}RepositoryCustom.java").withPrintWriter { out -> genRepositoryCustom(out, entityName, basePackage) }}if (isGenerate("RepositoryImpl")) {genUTF8File(repImpPath, "${entityName}RepositoryImpl.java").withPrintWriter { out -> genRepositoryImpl(out, table, entityName, fields, basePackage) }}if (isGenerate("ServiceImpl")) {genUTF8File(serviceImplPath, "${entityName}ServiceImpl.java").withPrintWriter { out -> genServiceImpl(out, table, entityName, fields, basePackage) }}}// 判断是否需要被生成
def isGenerate(itemName) {config.generateItem.contains(itemName)
}// 首字母小写转换
def theFirstToLowerCase(str) {StringBuilder sb = new StringBuilder();sb.append(str.substring(0, 1).toLowerCase())sb.append(str.substring(1))return sb.toString();
}// 指定文件编码方式，防止中文注释乱码
def genUTF8File(dir, fileName) {new PrintWriter(new OutputStreamWriter(new FileOutputStream(new File(dir, fileName)), "utf-8"))
}// 生成每个字段
def genProperty(out, field) {out.println ""out.println "\t/**"out.println "\t * ${field.comment.toString()}"
//  out.println "\t * default value: ${field.default}"out.println "\t */"// 默认表的第一个字段为主键if (field.position == 1) {out.println "\t@Id"//自增主键需要out.println "\t@GeneratedValue(strategy = GenerationType.IDENTITY)"}// 枚举不需要长度
//  out.println "\t@Column(name = \"${field.colum}\", nullable = ${!field.isNotNull}${field.dataType == "enum" ? "" : ", length = $field.len"})"out.println "\t@Column(name = \"${field.colum}\", nullable = ${!field.isNotNull}${field.dataType == "enum" ? "" : ""})"out.println "\tprivate ${field.type} ${field.name};"
}// 生成get、get方法
def genGetSet(out, field) {// getout.println "\t"out.println "\tpublic ${field.type} get${field.name.substring(0, 1).toUpperCase()}${field.name.substring(1)}() {"out.println "\t\treturn this.${field.name};"out.println "\t}"// setout.println "\t"out.println "\tpublic void set${field.name.substring(0, 1).toUpperCase()}${field.name.substring(1)}(${field.type} ${field.name}) {"out.println "\t\tthis.${field.name} = ${field.name};"out.println "\t}"
}// 生成实体类
def genEntity(out, table, entityName, fields, basePackage) {out.println "package ${basePackage}.entity;"out.println ""if (config.extendBaseEntity) {
//    out.println "import $baseEntityPackage;"}if (config.useLombok) {out.println "import lombok.Data;"}if (config.impSerializable) {out.println "import java.io.Serializable;"}out.println "import javax.persistence.*;"out.println ""out.println "/**\n" +" * @Description  \n" +" * @Author  xwd\n" + //1. 修改idea为自己名字" * @Date " + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()) + " \n" +" */"if (config.useLombok) {out.println "@Data"}out.println "@Entity"out.println "@Table(name = \"${table.getName()}\")"out.println "public class $entityName${config.extendBaseEntity ? " extends BaseEntity" : ""}${config.impSerializable ? " implements Serializable" : ""} {"if (config.extendBaseEntity) {fields = fields.findAll { it ->!baseEntityProperties.any { it1 -> it1 == it.name }}}fields.each() {genProperty(out, it)}if (!config.useLombok) {fields.each() {genGetSet(out, it)}}out.println "}"
}// 生成Service
def genService(out, table, entityName, fields, basePackage) {out.println "package ${basePackage}.service;"out.println ""out.println "import ${basePackage}.repository.${entityName}Repository;"if (config.extendBaseService) {
//    out.println "import $baseServicePackage;"out.println "import ${basePackage}.entity.$entityName;"}out.println "import org.springframework.stereotype.Service;"out.println "import javax.annotation.Resource;"out.println ""out.println "@Service"out.println "public class ${entityName}Service${config.extendBaseService ? " extends BaseService<$entityName, ${fields[0].type}>" : ""}  {"out.println ""out.println "\t@Resource"out.println "\tprivate ${entityName}Repository repository;"out.println "}"
}// 生成Controller 第三步
def genController(out, table, entityName, fields, basePackage) {out.println "package ${basePackage}.controller;"out.println ""
//  out.println "import ${basePackage}.repository.${entityName}Repository;"if (config.extendBaseService) {
//    out.println "import $baseServicePackage;"out.println "import ${basePackage}.entity.$entityName;"}out.println "import lombok.extern.slf4j.Slf4j;"out.println "import org.springframework.web.bind.annotation.RequestMapping;"out.println "import org.springframework.web.bind.annotation.RestController;"out.println "import ${basePackage}.service.${entityName}Service;"out.println "import javax.annotation.Resource;"out.println ""out.println "@Slf4j"out.println "@RestController"out.println "@RequestMapping(\"/${entityName.substring(0,1).toLowerCase()}${entityName.substring(1)}\")"//首字母小写out.println "public class ${entityName}Controller${config.extendBaseService ? " extends BaseService<$entityName, ${fields[0].type}>" : ""}  {"out.println ""out.println "\t@Resource"out.println "\tprivate ${entityName}Service "+theFirstToLowerCase("${entityName}")+"Service;"out.println "}"
}// 生成Repository
def genRepository(out, table, entityName, fields, basePackage) {out.println "package ${basePackage}.repository;"out.println ""out.println "import ${basePackage}.entity.$entityName;"out.println "import org.springframework.data.jpa.repository.JpaRepository;"out.println "import org.springframework.data.jpa.repository.JpaSpecificationExecutor;"out.println ""out.println "public interface ${entityName}Repository extends JpaRepository<$entityName, ${fields[0].type}>, JpaSpecificationExecutor<$entityName>{"out.println ""out.println "}"
}// 生成RepositoryCustom
def genRepositoryCustom(out, entityName, basePackage) {out.println "package ${basePackage}.repository;"out.println ""out.println "public interface ${entityName}RepositoryCustom {"out.println ""out.println "}"
}// 生成RepositoryImpl
def genRepositoryImpl(out, table, entityName, fields, basePackage) {out.println "package ${basePackage}.repository.impl;"out.println ""out.println "import ${basePackage}.repository.${entityName}RepositoryCustom;"out.println "import org.springframework.stereotype.Repository;"out.println ""out.println "import javax.persistence.EntityManager;"out.println "import javax.persistence.PersistenceContext;"out.println ""out.println "@Repository"out.println "public class ${entityName}RepositoryImpl implements ${entityName}RepositoryCustom {"out.println ""out.println "\t@PersistenceContext"out.println "\tprivate EntityManager em;"out.println "}"
}
// 生成ServiceImpl
def genServiceImpl(out, table, entityName, fields, basePackage) {out.println "package ${basePackage}.service.impl;"out.println ""out.println "import ${basePackage}.service.${entityName}Service;"out.println "import ${basePackage}.repository.${entityName}Repository;"out.println "import javax.annotation.Resource;"
//  out.println "import ${basePackage}.repository.${entityName}RepositoryCustom;"out.println "import org.springframework.stereotype.Service;"out.println ""
//  out.println "import javax.persistence.EntityManager;"
//  out.println "import javax.persistence.PersistenceContext;"out.println ""out.println "@Service"out.println "public class ${entityName}ServiceImpl implements ${entityName}Service {"out.println ""out.println "\t@Resource"out.println "\tprivate ${entityName}Repository repository;"
//  out.println "\t@PersistenceContext"
//  out.println "\tprivate EntityManager em;"out.println "}"
}// 生成文件夹
def mkdirs(dirs) {dirs.forEach {def f = new File(it)if (!f.exists()) {f.mkdirs()}}
}def clacBasePackage(dir) {dir.toString().replaceAll("^.+\\\\src\\\\main\\\\java\\\\", "").replaceAll("\\\\", ".")
}def isBaseEntityProperty(property) {baseEntityProperties.find { it == property } != null
}// 转换类型
def calcFields(table) {DasUtil.getColumns(table).reduce([]) { fields, col ->def spec = Case.LOWER.apply(col.getDataType().getSpecification())def typeStr = typeMapping.find { p, t -> p.matcher(spec).find() }.valuefields += [[name     : javaName(col.getName(), false),colum    : col.getName(),type     : typeStr,dataType : col.getDataType().toString().replaceAll(/\(.*\)/, "").toLowerCase(),len      : col.getDataType().toString().replaceAll(/[^\d]/, ""),default  : col.getDefault(),comment  : col.getComment(),isNotNull: col.isNotNull(),position : col.getPosition(),
//                           getDefault            : col.getDefault(),
//                           getParent             : col.getParent(),
//                           getTable              : col.getTable(),
//                           getDataType           : col.getDataType(),
//                           isNotNull             : col.isNotNull(),
//                           getWeight             : col.getWeight(),
//                           getDocumentation      : col.getDocumentation(),
//                           getTableName          : col.getTableName(),
//                           getName               : col.getName(),
//                           getLanguage           : col.getLanguage(),
//                           getTypeName           : col.getTypeName(),
//                           isDirectory           : col.isDirectory(),
//                           isValid               : col.isValid(),
//                           getComment            : col.getComment(),
//                           getText               : col.getText(),
//                           getDeclaration        : col.getDeclaration(),
//                           getPosition           : col.getPosition(),
//                           canNavigate           : col.canNavigate(),
//                           isWritable            : col.isWritable(),
//                           getIcon               : col.getIcon(),
//                           getManager            : col.getManager(),
//                           getDelegate           : col.getDelegate(),
//                           getChildren           : col.getChildren(),
//                           getKind               : col.getKind(),
//                           isCaseSensitive       : col.isCaseSensitive(),
//                           getProject            : col.getProject(),
//                           getDataSource         : col.getDataSource(),
//                           getVirtualFile        : col.getVirtualFile(),
//                           getMetaData           : col.getMetaData(),
//                           canNavigateToSource   : col.canNavigateToSource(),
//                           getDisplayOrder       : col.getDisplayOrder(),
//                           getDasParent          : col.getDasParent(),
//                           getLocationString     : col.getLocationString(),
//                           getDependences        : col.getDependences(),
//                           getBaseIcon           : col.getBaseIcon(),
//                           getNode               : col.getNode(),
//                           getTextLength         : col.getTextLength(),
//                           getFirstChild         : col.getFirstChild(),
//                           getLastChild          : col.getLastChild(),
//                           getNextSibling        : col.getNextSibling(),
//                           getTextOffset         : col.getTextOffset(),
//                           getPrevSibling        : col.getPrevSibling(),
//                           getPresentation       : col.getPresentation(),
//                           isPhysical            : col.isPhysical(),
//                           getTextRange          : col.getTextRange(),
//                           getPresentableText    : col.getPresentableText(),
//                           textToCharArray       : col.textToCharArray(),
//                           getStartOffsetInParent: col.getStartOffsetInParent(),
//                           getContext            : col.getContext(),
//                           getUseScope           : col.getUseScope(),
//                           getResolveScope       : col.getResolveScope(),
//                           getReferences         : col.getReferences(),
//                           getReference          : col.getReference(),
//                           getContainingFile     : col.getContainingFile(),
//                           getOriginalElement    : col.getOriginalElement(),
//                           getNavigationElement  : col.getNavigationElement(),
//                           getUserDataString     : col.getUserDataString(),
//                           isUserDataEmpty       : col.isUserDataEmpty(),
//                           getDbParent           : col.getDbParent(),]]}
}def javaName(str, capitalize) {def s = str.split(/(?<=[^\p{IsLetter}])/).collect { Case.LOWER.apply(it).capitalize() }.join("").replaceAll(/[^\p{javaJavaIdentifierPart}]/, "_").replaceAll(/_/, "")capitalize || s.length() == 1 ? s : Case.LOWER.apply(s[0]) + s[1..-1]
}

四、进行生成操作
在这里插入图片描述


http://www.ppmy.cn/embedded/172914.html

相关文章

TCP为什么可靠？

TCP为什么可靠？

TCP&#xff08;传输控制协议&#xff09;通过多种机制来确保可靠的数据传输。可靠传输意味着确保数据在从源到目标的过程中&#xff0c;不仅要完整无误地到达&#xff0c;还要按照正确的顺序到达&#xff0c;而且如果在传输过程中出现丢失或错误的情况&#xff0c;TCP会进行修…
阅读更多...
【实战ES】实战 Elasticsearch：快速上手与深度实践-7.3.2使用GraphQL封装查询接口

【实战ES】实战 Elasticsearch：快速上手与深度实践-7.3.2使用GraphQL封装查询接口

&#x1f449; 点击关注不迷路 &#x1f449; 点击关注不迷路 &#x1f449; 点击关注不迷路 文章大纲 使用GraphQL封装Elasticsearch查询接口的深度实践指南1. 为什么选择GraphQL作为ES查询封装层&#xff1f;1.1 传统REST接口的局限性1.2 GraphQL的核心优势矩阵功能特性对比 …
阅读更多...
VUE的脚手架搭建引入类库

VUE的脚手架搭建引入类库

VUE的小白脚手架搭建 真的好久好久自己没有发布自己博客了,对于一直在做后端开发的我 ,由于社会卷啊卷只好学习下怎么搭建前端,一起学习成长吧~哈哈哈(最终目的,能够懂并简易开发) 文章目录 VUE的小白脚手架搭建1.下载node.js2.安装vue脚手架3.创建一个项目4.代码规范约束配置(…
阅读更多...
用Deepseek写一个五子棋微信小程序

用Deepseek写一个五子棋微信小程序

在当今快节奏的生活中&#xff0c;休闲小游戏成为了许多人放松心情的好选择。五子棋作为一款经典的策略游戏&#xff0c;不仅规则简单&#xff0c;还能锻炼思维。最近&#xff0c;我借助 DeepSeek 的帮助&#xff0c;开发了一款五子棋微信小程序。在这篇文章中&#xff0c;我将…
阅读更多...
批量删除或替换 Excel 的 Sheet 工作表

批量删除或替换 Excel 的 Sheet 工作表

在一个 Excel 文档中通常会包含一个或者多个 Sheet 工作表。我们通常也可以自定义的添加或者删除某些工作表。比如我们想要将某个 Excel 的第一个工作表删除&#xff0c;那我们就需要先通过工具打开 Excel 文档&#xff0c;然后再进行删除操作。单个文件我们这样处理是没有问题…
阅读更多...
LSTM方法实践——基于LSTM的汽车销量时序建模与预测分析

LSTM方法实践——基于LSTM的汽车销量时序建模与预测分析

Hi&#xff0c;大家好&#xff0c;我是半亩花海。本实验基于汽车销量时序数据&#xff0c;使用LSTM网络&#xff08;长短期记忆网络&#xff09;构建时间序列预测模型。通过数据预处理、模型训练与评估等完整流程&#xff0c;验证LSTM在短期时序预测中的有效性。 目录 一、实验…
阅读更多...
tcpdump剖析：入门网络流量分析实战指南

tcpdump剖析：入门网络流量分析实战指南

“每一个优秀的工程师&#xff0c;都应该能在黑暗中&#xff08;命令行下&#xff09;仅凭字符跳动诊断问题。” 1 tcpdump简介 tcpdump是一个基于命令行的网络抓包工具&#xff0c;支持捕获和分析网络接口上的数据包。它可以捕获TCP、UDP、ICMP等多种协议的数据包&#xff0c;…
阅读更多...
linux 时间同步(阿里云ntp服务器)

linux 时间同步(阿里云ntp服务器)

1、安装ntp服务 rootlocalhost ~]# yum -y install ntp 已加载插件&#xff1a;fastestmirror, langpacks Loading mirror speeds from cached hostfile* base: mirrors.nju.edu.cn* centos-sclo-rh: mirrors.nju.edu.cn* centos-sclo-sclo: mirrors.huaweicloud.com* epel: m…
阅读更多...
最新文章

Copyright @ 2022~2023