ÎļþÃû´Ó sql/ry_20200723.sql ÐÞ¸Ä |
| | |
| | | business_name varchar(30) comment 'çæä¸å¡å',
|
| | | function_name varchar(50) comment 'çæåè½å',
|
| | | function_author varchar(50) comment 'çæåè½ä½è
',
|
| | | gen_type char(1) default '0' comment 'çæä»£ç æ¹å¼ï¼0zipå缩å
1èªå®ä¹è·¯å¾ï¼',
|
| | | gen_path varchar(200) default '/' comment 'çæè·¯å¾ï¼ä¸å¡«é»è®¤é¡¹ç®è·¯å¾ï¼',
|
| | | options varchar(1000) comment 'å
¶å®çæé项',
|
| | | create_by varchar(64) default '' comment 'å建è
',
|
| | | create_time datetime comment 'å建æ¶é´',
|
| | |
| | | *
|
| | | * @author ruoyi
|
| | | */
|
| | | public class FileUtils
|
| | | public class FileUtils extends org.apache.commons.io.FileUtils
|
| | | {
|
| | | public static String FILENAME_PATTERN = "[a-zA-Z0-9_\\-\\|\\.\\u4e00-\\u9fa5]+";
|
| | |
|
| | |
| | | }
|
| | |
|
| | | /**
|
| | | * çæä»£ç
|
| | | * çæä»£ç ï¼ä¸è½½æ¹å¼ï¼
|
| | | */
|
| | | @PreAuthorize("@ss.hasPermi('tool:gen:code')")
|
| | | @Log(title = "代ç çæ", businessType = BusinessType.GENCODE)
|
| | | @GetMapping("/download/{tableName}")
|
| | | public void download(HttpServletResponse response, @PathVariable("tableName") String tableName) throws IOException
|
| | | {
|
| | | byte[] data = genTableService.downloadCode(tableName);
|
| | | genCode(response, data);
|
| | | }
|
| | |
|
| | | /**
|
| | | * çæä»£ç ï¼èªå®ä¹è·¯å¾ï¼
|
| | | */
|
| | | @PreAuthorize("@ss.hasPermi('tool:gen:code')")
|
| | | @Log(title = "代ç çæ", businessType = BusinessType.GENCODE)
|
| | | @GetMapping("/genCode/{tableName}")
|
| | | public void genCode(HttpServletResponse response, @PathVariable("tableName") String tableName) throws IOException
|
| | | public AjaxResult genCode(HttpServletResponse response, @PathVariable("tableName") String tableName)
|
| | | {
|
| | | byte[] data = genTableService.generatorCode(tableName);
|
| | | genCode(response, data);
|
| | | genTableService.generatorCode(tableName);
|
| | | return AjaxResult.success();
|
| | | }
|
| | |
|
| | | /**
|
| | |
| | | public void batchGenCode(HttpServletResponse response, String tables) throws IOException
|
| | | {
|
| | | String[] tableNames = Convert.toStrArray(tables);
|
| | | byte[] data = genTableService.generatorCode(tableNames);
|
| | | byte[] data = genTableService.downloadCode(tableNames);
|
| | | genCode(response, data);
|
| | | }
|
| | |
|
| | |
| | | @NotBlank(message = "ä½è
ä¸è½ä¸ºç©º")
|
| | | private String functionAuthor;
|
| | |
|
| | | /** çæä»£ç æ¹å¼ï¼0zipå缩å
1èªå®ä¹è·¯å¾ï¼ */
|
| | | private String genType;
|
| | |
|
| | | /** çæè·¯å¾ï¼ä¸å¡«é»è®¤é¡¹ç®è·¯å¾ï¼ */
|
| | | private String genPath;
|
| | |
|
| | | /** 主é®ä¿¡æ¯ */
|
| | | private GenTableColumn pkColumn;
|
| | |
|
| | |
| | | this.functionAuthor = functionAuthor;
|
| | | }
|
| | |
|
| | | public String getGenType()
|
| | | {
|
| | | return genType;
|
| | | }
|
| | |
|
| | | public void setGenType(String genType)
|
| | | {
|
| | | this.genType = genType;
|
| | | }
|
| | |
|
| | | public String getGenPath()
|
| | | {
|
| | | return genPath;
|
| | | }
|
| | |
|
| | | public void setGenPath(String genPath)
|
| | | {
|
| | | this.genPath = genPath;
|
| | | }
|
| | |
|
| | | public GenTableColumn getPkColumn()
|
| | | {
|
| | | return pkColumn;
|
| | |
| | | package com.ruoyi.project.tool.gen.service;
|
| | |
|
| | | import java.io.ByteArrayOutputStream;
|
| | | import java.io.File;
|
| | | import java.io.IOException;
|
| | | import java.io.StringWriter;
|
| | | import java.util.LinkedHashMap;
|
| | |
| | | import com.alibaba.fastjson.JSONObject;
|
| | | import com.ruoyi.common.constant.Constants;
|
| | | import com.ruoyi.common.constant.GenConstants;
|
| | | import com.ruoyi.common.core.text.CharsetKit;
|
| | | import com.ruoyi.common.exception.CustomException;
|
| | | import com.ruoyi.common.utils.SecurityUtils;
|
| | | import com.ruoyi.common.utils.StringUtils;
|
| | | import com.ruoyi.common.utils.file.FileUtils;
|
| | | import com.ruoyi.project.tool.gen.domain.GenTable;
|
| | | import com.ruoyi.project.tool.gen.domain.GenTableColumn;
|
| | | import com.ruoyi.project.tool.gen.mapper.GenTableColumnMapper;
|
| | |
| | | }
|
| | |
|
| | | /**
|
| | | * çæä»£ç
|
| | | * çæä»£ç ï¼ä¸è½½æ¹å¼ï¼
|
| | | *
|
| | | * @param tableName 表åç§°
|
| | | * @return æ°æ®
|
| | | */
|
| | | @Override
|
| | | public byte[] generatorCode(String tableName)
|
| | | public byte[] downloadCode(String tableName)
|
| | | {
|
| | | ByteArrayOutputStream outputStream = new ByteArrayOutputStream();
|
| | | ZipOutputStream zip = new ZipOutputStream(outputStream);
|
| | |
| | | }
|
| | |
|
| | | /**
|
| | | * æ¹éçæä»£ç
|
| | | * çæä»£ç ï¼èªå®ä¹è·¯å¾ï¼
|
| | | * |
| | | * @param tableName 表åç§°
|
| | | * @return æ°æ®
|
| | | */
|
| | | @Override
|
| | | public void generatorCode(String tableName)
|
| | | {
|
| | | // æ¥è¯¢è¡¨ä¿¡æ¯
|
| | | GenTable table = genTableMapper.selectGenTableByName(tableName);
|
| | | // æ¥è¯¢åä¿¡æ¯
|
| | | List<GenTableColumn> columns = table.getColumns();
|
| | | setPkColumn(table, columns);
|
| | |
|
| | | VelocityInitializer.initVelocity();
|
| | |
|
| | | VelocityContext context = VelocityUtils.prepareContext(table);
|
| | |
|
| | | // è·å模æ¿å表
|
| | | List<String> templates = VelocityUtils.getTemplateList(table.getTplCategory());
|
| | | for (String template : templates)
|
| | | {
|
| | | if (!StringUtils.containsAny(template, "sql.vm", "api.js.vm", "index.vue.vm", "index-tree.vue.vm"))
|
| | | {
|
| | | // æ¸²ææ¨¡æ¿
|
| | | StringWriter sw = new StringWriter();
|
| | | Template tpl = Velocity.getTemplate(template, Constants.UTF8);
|
| | | tpl.merge(context, sw);
|
| | | try
|
| | | {
|
| | | String path = getGenPath(table, template);
|
| | | FileUtils.writeStringToFile(new File(path), sw.toString(), CharsetKit.UTF_8);
|
| | | }
|
| | | catch (IOException e)
|
| | | {
|
| | | throw new CustomException("æ¸²ææ¨¡æ¿å¤±è´¥ï¼è¡¨åï¼" + table.getTableName());
|
| | | }
|
| | | }
|
| | | }
|
| | | }
|
| | |
|
| | | /**
|
| | | * æ¹éçæä»£ç ï¼ä¸è½½æ¹å¼ï¼
|
| | | *
|
| | | * @param tableNames 表æ°ç»
|
| | | * @return æ°æ®
|
| | | */
|
| | | @Override
|
| | | public byte[] generatorCode(String[] tableNames)
|
| | | public byte[] downloadCode(String[] tableNames)
|
| | | {
|
| | | ByteArrayOutputStream outputStream = new ByteArrayOutputStream();
|
| | | ZipOutputStream zip = new ZipOutputStream(outputStream);
|
| | |
| | | genTable.setParentMenuName(parentMenuName);
|
| | | }
|
| | | }
|
| | |
|
| | | /**
|
| | | * è·å代ç çæå°å
|
| | | * |
| | | * @param table ä¸å¡è¡¨ä¿¡æ¯
|
| | | * @param template æ¨¡æ¿æä»¶è·¯å¾
|
| | | * @return çæå°å
|
| | | */
|
| | | public static String getGenPath(GenTable table, String template)
|
| | | {
|
| | | String genPath = table.getGenPath();
|
| | | if (StringUtils.equals(genPath, "/"))
|
| | | {
|
| | | return System.getProperty("user.dir") + File.separator + "src" + File.separator + VelocityUtils.getFileName(template, table);
|
| | | }
|
| | | return genPath + File.separator + VelocityUtils.getFileName(template, table);
|
| | | }
|
| | | } |
| | |
| | | public Map<String, String> previewCode(Long tableId);
|
| | |
|
| | | /**
|
| | | * çæä»£ç
|
| | | * çæä»£ç ï¼ä¸è½½æ¹å¼ï¼
|
| | | *
|
| | | * @param tableName 表åç§°
|
| | | * @return æ°æ®
|
| | | */
|
| | | public byte[] generatorCode(String tableName);
|
| | | public byte[] downloadCode(String tableName);
|
| | |
|
| | | /**
|
| | | * æ¹éçæä»£ç
|
| | | * çæä»£ç ï¼èªå®ä¹è·¯å¾ï¼
|
| | | * |
| | | * @param tableName 表åç§°
|
| | | * @return æ°æ®
|
| | | */
|
| | | public void generatorCode(String tableName);
|
| | |
|
| | | /**
|
| | | * æ¹éçæä»£ç ï¼ä¸è½½æ¹å¼ï¼
|
| | | *
|
| | | * @param tableNames 表æ°ç»
|
| | | * @return æ°æ®
|
| | | */
|
| | | public byte[] generatorCode(String[] tableNames);
|
| | | public byte[] downloadCode(String[] tableNames);
|
| | |
|
| | | /**
|
| | | * ä¿®æ¹ä¿ååæ°æ ¡éª
|
| | |
| | | <result property="businessName" column="business_name" />
|
| | | <result property="functionName" column="function_name" />
|
| | | <result property="functionAuthor" column="function_author" />
|
| | | <result property="genType" column="gen_type" />
|
| | | <result property="genPath" column="gen_path" />
|
| | | <result property="options" column="options" />
|
| | | <result property="createBy" column="create_by" />
|
| | | <result property="createTime" column="create_time" />
|
| | |
| | | </resultMap>
|
| | |
|
| | | <sql id="selectGenTableVo">
|
| | | select table_id, table_name, table_comment, class_name, tpl_category, package_name, module_name, business_name, function_name, function_author, options, create_by, create_time, update_by, update_time, remark from gen_table
|
| | | select table_id, table_name, table_comment, class_name, tpl_category, package_name, module_name, business_name, function_name, function_author, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark from gen_table
|
| | | </sql>
|
| | |
|
| | | <select id="selectGenTableList" parameterType="GenTable" resultMap="GenTableResult">
|
| | |
| | | </select>
|
| | |
|
| | | <select id="selectGenTableById" parameterType="Long" resultMap="GenTableResult">
|
| | | SELECT t.table_id, t.table_name, t.table_comment, t.class_name, t.tpl_category, t.package_name, t.module_name, t.business_name, t.function_name, t.function_author, t.options, t.remark,
|
| | | SELECT t.table_id, t.table_name, t.table_comment, t.class_name, t.tpl_category, t.package_name, t.module_name, t.business_name, t.function_name, t.function_author, t.gen_type, t.gen_path, t.options, t.remark,
|
| | | c.column_id, c.column_name, c.column_comment, c.column_type, c.java_type, c.java_field, c.is_pk, c.is_increment, c.is_required, c.is_insert, c.is_edit, c.is_list, c.is_query, c.query_type, c.html_type, c.dict_type, c.sort
|
| | | FROM gen_table t
|
| | | LEFT JOIN gen_table_column c ON t.table_id = c.table_id
|
| | |
| | | </select>
|
| | |
|
| | | <select id="selectGenTableByName" parameterType="String" resultMap="GenTableResult">
|
| | | SELECT t.table_id, t.table_name, t.table_comment, t.class_name, t.tpl_category, t.package_name, t.module_name, t.business_name, t.function_name, t.function_author, t.options, t.remark,
|
| | | SELECT t.table_id, t.table_name, t.table_comment, t.class_name, t.tpl_category, t.package_name, t.module_name, t.business_name, t.function_name, t.function_author, t.gen_type, t.gen_path, t.options, t.remark,
|
| | | c.column_id, c.column_name, c.column_comment, c.column_type, c.java_type, c.java_field, c.is_pk, c.is_increment, c.is_required, c.is_insert, c.is_edit, c.is_list, c.is_query, c.query_type, c.html_type, c.dict_type, c.sort
|
| | | FROM gen_table t
|
| | | LEFT JOIN gen_table_column c ON t.table_id = c.table_id
|
| | |
| | | <if test="businessName != null and businessName != ''">business_name,</if>
|
| | | <if test="functionName != null and functionName != ''">function_name,</if>
|
| | | <if test="functionAuthor != null and functionAuthor != ''">function_author,</if>
|
| | | <if test="genType != null and genType != ''">gen_type,</if>
|
| | | <if test="genPath != null and genPath != ''">gen_path,</if>
|
| | | <if test="remark != null and remark != ''">remark,</if>
|
| | | <if test="createBy != null and createBy != ''">create_by,</if>
|
| | | create_time
|
| | |
| | | <if test="businessName != null and businessName != ''">#{businessName},</if>
|
| | | <if test="functionName != null and functionName != ''">#{functionName},</if>
|
| | | <if test="functionAuthor != null and functionAuthor != ''">#{functionAuthor},</if>
|
| | | <if test="genType != null and genType != ''">#{genType},</if>
|
| | | <if test="genPath != null and genPath != ''">#{genPath},</if>
|
| | | <if test="remark != null and remark != ''">#{remark},</if>
|
| | | <if test="createBy != null and createBy != ''">#{createBy},</if>
|
| | | sysdate()
|
| | |
| | | <if test="tableComment != null and tableComment != ''">table_comment = #{tableComment},</if>
|
| | | <if test="className != null and className != ''">class_name = #{className},</if>
|
| | | <if test="functionAuthor != null and functionAuthor != ''">function_author = #{functionAuthor},</if>
|
| | | <if test="genType != null and genType != ''">gen_type = #{genType},</if>
|
| | | <if test="genPath != null and genPath != ''">gen_path = #{genPath},</if>
|
| | | <if test="tplCategory != null and tplCategory != ''">tpl_category = #{tplCategory},</if>
|
| | | <if test="packageName != null and packageName != ''">package_name = #{packageName},</if>
|
| | | <if test="moduleName != null and moduleName != ''">module_name = #{moduleName},</if>
|