Java|Java SpringBoot实现带界面的代码生成器详解 JavaSpringBoot实现带界面的代码生

1.项目gitthub地址链接: https://github.com/baisul/generateCode.git切换到master分支
2.环境
2.1 springboot+freemarker+mysql
2.2 要装node.js,vue文件运行依赖node.js
3.以下就只拿生成java实体类来作为例子
4.application.xml
5.pom.xml
6.Utils
7.生成模板
8.Controller
9.Model
10.index.html(数据库连接生成代码的界面)
11.接口
12.图形化界面
总结

1.项目gitthub地址链接: https://github.com/baisul/generateCode.git切换到master分支
2.环境
2.1 springboot+freemarker+mysql

2.2 要装node.js,vue文件运行依赖node.js
3.以下就只拿生成java实体类来作为例子
4.application.xml

server.port=8080spring.datasource.url=jdbc:mysql://localhost:3306/demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghaispring.datasource.username=rootspring.datasource.password=root

5.pom.xml

4.0.0org.springframework.bootspring-boot-starter-parent2.5.4 com.ylgenerate_code0.0.1-SNAPSHOTgenerate_codeDemo project for Spring Boot1.8org.springframework.bootspring-boot-starter-freemarkerorg.springframework.bootspring-boot-starter-webmysqlmysql-connector-javaruntimeorg.springframework.bootspring-boot-starter-testtestcom.google.guavaguava30.1-jreorg.springframework.bootspring-boot-maven-plugin

6.Utils

package com.yl.generate_code.utils; import org.springframework.web.servlet.config.annotation.CorsRegistry; import org.springframework.web.servlet.config.annotation.WebMvcConfigurerAdapter; public class CORFSConfiguration extends WebMvcConfigurerAdapter {@Overridepublic void addCorsMappings(CorsRegistry registry) {//所有请求都允许跨域registry.addMapping("/**").allowedOrigins("*").allowedMethods("*").allowedHeaders("*"); }}

package com.yl.generate_code.utils; import com.yl.generate_code.model.Db; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class DBUtils {private static Connection connection; public static Connection getConnection() {return connection; }public static Connection init(Db db) {if (connection == null) {try {Class.forName("com.mysql.cj.jdbc.Driver"); connection = DriverManager.getConnection( db.getUrl(),db.getUsername(), db.getPassword()); } catch (ClassNotFoundException e) {e.printStackTrace(); } catch (SQLException e) {e.printStackTrace(); }}return connection; }}

7.生成模板

package ${packetName}.model; import java.util.Date; /*** @Description: ${modelName}实体类* @Author: wfj* @CreateDate ${createDate}* @Version: 1.0V*/public class ${modelName} {<#if columns??><#list columns as column><#if column.type='VARCHAR' || column.type='TEXT' || column.type='CHAR'>/*** ${column.remark}*/private String ${column.propertyName?uncap_first}; <#if column.type='INT'>/*** ${column.remark}*/private Integer ${column.propertyName?uncap_first}; <#if column.type='DATETIME'>/*** ${column.remark}*/private Date ${column.propertyName?uncap_first}; <#if column.type='BIGINT'>/*** ${column.remark}*/private Long ${column.propertyName?uncap_first}; <#if column.type='DOUBLE'>/*** ${column.remark}*/private Double ${column.propertyName?uncap_first}; <#if column.type='BIT'>/*** ${column.remark}*/private Boolean ${column.propertyName?uncap_first}; <#list columns as column><#if column.type='VARCHAR' || column.type='TEXT' || column.type='CHAR'>public String get${column.propertyName}() {return ${column.propertyName?uncap_first}; }public void set${column.propertyName}(String ${column.propertyName?uncap_first}) {this.${column.propertyName?uncap_first} = ${column.propertyName?uncap_first}; }<#if column.type='INT'>public Integer get${column.propertyName}() {return ${column.propertyName?uncap_first}; }public void set${column.propertyName}(Integer ${column.propertyName?uncap_first}) {this.${column.propertyName?uncap_first} = ${column.propertyName?uncap_first}; }<#if column.type='DATETIME'>public Date get${column.propertyName}() {return ${column.propertyName?uncap_first}; }public void set${column.propertyName}(Date ${column.propertyName?uncap_first}) {this.${column.propertyName?uncap_first} = ${column.propertyName?uncap_first}; }<#if column.type='BIGINT'>public Long get${column.propertyName}() {return ${column.propertyName?uncap_first}; }public void set${column.propertyName}(Long ${column.propertyName?uncap_first}) {this.${column.propertyName?uncap_first} = ${column.propertyName?uncap_first}; }<#if column.type='DOUBLE'>public Double get${column.propertyName}() {return ${column.propertyName?uncap_first}; }public void set${column.propertyName}(Double ${column.propertyName?uncap_first}) {this.${column.propertyName?uncap_first} = ${column.propertyName?uncap_first}; }<#if column.type='BIT'>public Boolean get${column.propertyName}() {return ${column.propertyName?uncap_first}; }public void set${column.propertyName}(Boolean ${column.propertyName?uncap_first}) {this.${column.propertyName?uncap_first} = ${column.propertyName?uncap_first}; }}

8.Controller

package com.yl.generate_code.controller; import com.google.common.base.CaseFormat; import com.yl.generate_code.model.Db; import com.yl.generate_code.model.ResultModel; import com.yl.generate_code.model.TableClass; import com.yl.generate_code.utils.DBUtils; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RestController; import java.sql.Connection; import java.sql.DatabaseMetaData; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import java.util.Map; @RestControllerpublic class DBController {@PostMapping("/connect")public ResultModel connect(@RequestBody Db db) {Connection connection = DBUtils.init(db); if (connection == null) {return ResultModel.fail("数据库连接失败"); } else {return ResultModel.success("数据库连接成功"); }}@PostMapping("/config")public ResultModel config(@RequestBody Map map) {String packetName = (String)map.get("packetName"); try {//获取数据库连接Connection connection = DBUtils.getConnection(); //获取数据库元数据DatabaseMetaData metaData = https://www.it610.com/article/connection.getMetaData(); //获取数据库所有的表ResultSet rs = metaData.getTables(connection.getCatalog(), null, null, null); List list = new ArrayList<>(); while (rs.next()) {TableClass tableClass = new TableClass(); tableClass.setPacketName(packetName); //获取表名String tableName = rs.getString("TABLE_NAME"); //数据库表下划线的字段转成驼峰，且首字母大写String modelName = CaseFormat.LOWER_UNDERSCORE.to(CaseFormat.UPPER_CAMEL, tableName); tableClass.setTableName(tableName); tableClass.setModelName(modelName); tableClass.setServiceName(modelName + "Service"); tableClass.setMapperName(modelName + "Mapper"); tableClass.setControllerName(modelName + "Controller"); list.add(tableClass); }return ResultModel.success("数据库信息读取成功",list); } catch (SQLException e) {e.printStackTrace(); return ResultModel.fail("数据库信息读取失败"); }}}

package com.yl.generate_code.controller; import com.yl.generate_code.model.ResultModel; import com.yl.generate_code.model.TableClass; import com.yl.generate_code.service.GenerateCodeService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import javax.servlet.http.HttpServletRequest; import java.util.List; @RestControllerpublic class GenerateCodeController {@Autowiredprivate GenerateCodeService generateCodeService; @PostMapping("/generateCode")public ResultModel generateCode(@RequestBody List list, HttpServletRequest request) {return generateCodeService.generateCode(list,request.getServletContext().getRealPath("/")); }}

9.Model

package com.yl.generate_code.model; import java.io.Serializable; public class ColumnClass implements Serializable {//实体类属性名private String propertyName; //实体类属性名对应的表的字段名private String columnName; //字段类型private String type; //备注private String remark; //该字段是否为主键private Boolean isPrimary; public String getPropertyName() {return propertyName; }public void setPropertyName(String propertyName) {this.propertyName = propertyName; }public String getColumnName() {return columnName; }public void setColumnName(String columnName) {this.columnName = columnName; }public String getType() {return type; }public void setType(String type) {this.type = type; }public String getRemark() {return remark; }public void setRemark(String remark) {this.remark = remark; }public Boolean getPrimary() {return isPrimary; }public void setPrimary(Boolean primary) {isPrimary = primary; }@Overridepublic String toString() {return "ColumnClass{" +"propertyName='" + propertyName + '\'' +", columnName='" + columnName + '\'' +", type='" + type + '\'' +", remark='" + remark + '\'' +", isPrimary=" + isPrimary +'}'; }}

package com.yl.generate_code.model; import java.io.Serializable; public class Db implements Serializable {private String username; private String password; private String url; public String getUsername() {return username; }public void setUsername(String username) {this.username = username; }public String getPassword() {return password; }public void setPassword(String password) {this.password = password; }public String getUrl() {return url; }public void setUrl(String url) {this.url = url; }}

package com.yl.generate_code.model; import java.io.Serializable; public class ResultModel implements Serializable {private Integer code; private String msg; private Object obj; public static ResultModel success(String msg,Object obj) {return new ResultModel(200,msg,obj); }public static ResultModel success(String msg) {return new ResultModel(200,msg,null); }public static ResultModel fail(String msg,Object obj) {return new ResultModel(500,msg,obj); }public static ResultModel fail(String msg) {return new ResultModel(500,msg,null); }private ResultModel() {}public ResultModel(Integer code, String msg, Object obj) {this.code = code; this.msg = msg; this.obj = obj; }public Integer getCode() {return code; }public void setCode(Integer code) {this.code = code; }public String getMsg() {return msg; }public void setMsg(String msg) {this.msg = msg; }public Object getObj() {return obj; }public void setObj(Object obj) {this.obj = obj; }}

package com.yl.generate_code.model; import java.io.Serializable; import java.util.ArrayList; import java.util.Date; import java.util.List; public class TableClass implements Serializable {private String tableName; private String modelName; private String serviceName; private String mapperName; private String controllerName; private String packetName; private String createDate; private List columns = new ArrayList<>(); public String getTableName() {return tableName; }public void setTableName(String tableName) {this.tableName = tableName; }public String getModelName() {return modelName; }public void setModelName(String modelName) {this.modelName = modelName; }public String getServiceName() {return serviceName; }public void setServiceName(String serviceName) {this.serviceName = serviceName; }public String getMapperName() {return mapperName; }public void setMapperName(String mapperName) {this.mapperName = mapperName; }public String getControllerName() {return controllerName; }public void setControllerName(String controllerName) {this.controllerName = controllerName; }public String getPacketName() {return packetName; }public void setPacketName(String packetName) {this.packetName = packetName; }public List getColumns() {return columns; }public void setColumns(List columns) {this.columns = columns; }public String getCreateDate() {return createDate; }public void setCreateDate(String createDate) {this.createDate = createDate; }}

10.index.html(数据库连接生成代码的界面)

Title - 锐客网
数据库用户名:
数据库密码:
数据库连接地址:
连接数据库{{msg}}配置生成代码{{result}}{{codePath}}

11.接口

package com.yl.generate_code.service; import com.yl.generate_code.model.ResultModel; import com.yl.generate_code.model.TableClass; import javax.servlet.http.HttpServletRequest; import java.util.List; public interface GenerateCodeService {ResultModel generateCode(List list, String realpath); }

package com.yl.generate_code.service.impl; import com.google.common.base.CaseFormat; import com.yl.generate_code.model.ColumnClass; import com.yl.generate_code.model.ResultModel; import com.yl.generate_code.model.TableClass; import com.yl.generate_code.service.GenerateCodeService; import com.yl.generate_code.utils.DBUtils; import freemarker.cache.ClassTemplateLoader; import freemarker.template.Configuration; import freemarker.template.Template; import freemarker.template.TemplateException; import org.springframework.stereotype.Service; import javax.servlet.http.HttpServletRequest; import java.io.*; import java.sql.Connection; import java.sql.DatabaseMetaData; import java.sql.ResultSet; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import java.util.List; @Servicepublic class GenerateCodeServiceImpl implements GenerateCodeService {Configuration cfg = null; {cfg = new Configuration(Configuration.VERSION_2_3_31); cfg.setTemplateLoader(new ClassTemplateLoader(GenerateCodeServiceImpl.class,"/templates")); cfg.setDefaultEncoding("utf-8"); }@Overridepublic ResultModel generateCode(List list, String realpath) {try {Template modelTemplate = cfg.getTemplate("Model.java.ftl"); Template serviceTemplate = cfg.getTemplate("Service.java.ftl"); Template serviceImplTemplate = cfg.getTemplate("ServiceImpl.java.ftl"); Template mapperTemplate = cfg.getTemplate("Mapper.java.ftl"); Template mapperXmlTemplate = cfg.getTemplate("Mapper.xml.java.ftl"); Template controllerTemplate = cfg.getTemplate("Controller.java.ftl"); Connection connection = DBUtils.getConnection(); DatabaseMetaData metaData = https://www.it610.com/article/connection.getMetaData(); for (TableClass tableClass : list) {//根据表名获取该表的所有字段ResultSet columns = metaData.getColumns(connection.getCatalog(), null, tableClass.getTableName(), null); //获取该表的所有主键ResultSet primaryKeys = metaData.getPrimaryKeys(connection.getCatalog(), null, tableClass.getTableName()); List columnClasses = new ArrayList<>(); while (columns.next()) {//获取字段名String column_name = columns.getString("COLUMN_NAME"); //获取字段类型String type_name = columns.getString("TYPE_NAME"); //获取字段注释String remark = columns.getString("REMARKS"); ColumnClass columnClass = new ColumnClass(); columnClass.setColumnName(column_name); columnClass.setType(type_name); columnClass.setRemark(remark); columnClass.setPropertyName(CaseFormat.LOWER_UNDERSCORE.to(CaseFormat.UPPER_CAMEL,column_name)); //指标挪到第一primaryKeys.first(); while (primaryKeys.next()) {String primaryKey = primaryKeys.getString("COLUMN_NAME"); if (column_name.equals(primaryKey)) {columnClass.setPrimary(true); }}columnClasses.add(columnClass); }tableClass.setColumns(columnClasses); SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); tableClass.setCreateDate(sdf.format(new Date())); String path = realpath + "/" + tableClass.getPacketName().replace(".","/"); generate(modelTemplate,tableClass,path+"/model/",1); generate(serviceTemplate,tableClass,path+"/service/",1); generate(serviceImplTemplate,tableClass,path+"/service/impl",1); generate(mapperTemplate,tableClass,path+"/mapper/",1); generate(mapperXmlTemplate,tableClass,path+"/mapper/",2); generate(controllerTemplate,tableClass,path+"/controller/",1); }return ResultModel.success("代码已生成",realpath); } catch (Exception e) {e.printStackTrace(); return ResultModel.fail("代码生成失败"); }}private void generate(Template template,TableClass tableClass,String path,Integer flag) throws IOException, TemplateException {File file = new File(path); if (!file.exists()) {file.mkdirs(); }String fileName; if (flag == 1) {fileName = path + "/" + tableClass.getModelName() + template.getName().replace(".ftl","").replace("Model",""); } else {fileName = path + "/" + tableClass.getModelName() + template.getName().replace(".ftl","").replace(".java",""); }FileOutputStream fos = new FileOutputStream(fileName); OutputStreamWriterout = new OutputStreamWriter(fos); template.process(tableClass,out); fos.close(); out.close(); }}

12.图形化界面