根据mysql建表语句生成Java实体类可选带swagger注解自用的可能只符合我目前项目的规范各位使用要前核对看一下代码我放下面了自取哦。!DOCTYPE html html langzh-CN head meta charsetUTF-8 meta nameviewport contentwidthdevice-width, initial-scale1.0 titleMySQL转Java实体类工具/title link relstylesheet hrefhttps://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css style * { box-sizing: border-box; margin: 0; padding: 0; } body { font-family: Segoe UI, Tahoma, Geneva, Verdana, sans-serif; line-height: 1.6; color: #333; background: linear-gradient(135deg, #f5f7fa 0%, #c3cfe2 100%); min-height: 100vh; padding: 20px; } .container { max-width: 1200px; margin: 0 auto; } header { text-align: center; margin-bottom: 30px; padding: 20px; background: rgba(255, 255, 255, 0.9); border-radius: 10px; box-shadow: 0 4px 15px rgba(0, 0, 0, 0.1); } header h1 { color: #2c3e50; margin-bottom: 10px; font-size: 2.5rem; } header p { color: #7f8c8d; font-size: 1.1rem; } .controls { display: flex; flex-wrap: wrap; gap: 20px; margin-bottom: 25px; background: rgba(255, 255, 255, 0.9); padding: 20px; border-radius: 10px; box-shadow: 0 4px 15px rgba(0, 0, 0, 0.1); } .control-group { flex: 1; min-width: 250px; } .control-group label { display: block; margin-bottom: 8px; font-weight: 600; color: #2c3e50; } .control-group input[typetext] { width: 100%; padding: 12px 15px; border: 2px solid #ddd; border-radius: 6px; font-size: 16px; transition: border-color 0.3s; } .control-group input[typetext]:focus { border-color: #3498db; outline: none; } .checkbox-group { display: flex; align-items: center; margin-top: 15px; } .checkbox-group input { margin-right: 10px; width: 18px; height: 18px; } button { background: #3498db; color: white; border: none; padding: 12px 25px; border-radius: 6px; cursor: pointer; font-size: 16px; font-weight: 600; transition: background 0.3s; margin-top: 10px; } button:hover { background: #2980b9; } .card-container { display: grid; grid-template-columns: 1fr 1fr; gap: 25px; margin-bottom: 30px; } media (max-width: 900px) { .card-container { grid-template-columns: 1fr; } } .card { background: rgba(255, 255, 255, 0.95); border-radius: 10px; overflow: hidden; box-shadow: 0 4px 15px rgba(0, 0, 0, 0.1); } .card-header { background: #2c3e50; color: white; padding: 15px 20px; } .card-header h2 { font-size: 1.4rem; } .card-body { padding: 20px; height: 400px; display: flex; flex-direction: column; } textarea { width: 100%; height: 100%; padding: 15px; border: 2px solid #ddd; border-radius: 6px; font-family: Courier New, Courier, monospace; font-size: 14px; resize: none; } pre { flex: 1; padding: 15px; border: 2px solid #ddd; border-radius: 6px; background: #f8f9fa; overflow: auto; font-family: Courier New, Courier, monospace; font-size: 14px; white-space: pre-wrap; } .copy { margin-top: 15px; align-self: flex-end; background: #27ae60; } .copy:hover { background: #219653; } .field-info { background: rgba(255, 255, 255, 0.9); border-radius: 10px; padding: 25px; margin-bottom: 30px; box-shadow: 0 4px 15px rgba(0, 0, 0, 0.1); } .field-info h3 { margin-bottom: 20px; color: #2c3e50; font-size: 1.5rem; } .info-grid { display: grid; grid-template-columns: repeat(auto-fit, minmax(250px, 1fr)); gap: 20px; } .info-item { background: #f8f9fa; padding: 15px; border-radius: 8px; border-left: 4px solid #3498db; } .info-item h4 { margin-bottom: 10px; color: #2c3e50; } footer { text-align: center; padding: 20px; color: #7f8c8d; background: rgba(255, 255, 255, 0.9); border-radius: 10px; box-shadow: 0 4px 15px rgba(0, 0, 0, 0.1); } .fa-database, .fa-file-code, .fa-table, .fa-copy, .fa-bolt, .fa-folder, .fa-cube { margin-right: 8px; } .highlight { color: #e74c3c; font-weight: bold; } /style /head body div classcontainer header h1i classfas fa-database/i MySQL转Java实体类工具/h1 p将MySQL建表语句自动转换为Java实体类代码支持Lombok、Swagger注解/p /header div classcontrols div classcontrol-group label forpackageNamei classfas fa-folder/i 包名 (Package Name)/label input typetext idpackageName valuecn.yiyuan.iot.model placeholder例如com.example.model /div div classcontrol-group label forclassNamei classfas fa-cube/i 类名 (Class Name)/label input typetext idclassName placeholder自动从表名生成 /div div classcontrol-group div classcheckbox-group input typecheckbox idaddApiModelProperty checked label foraddApiModelProperty添加 ApiModelProperty 注解/label /div button idgenerateBtni classfas fa-bolt/i 生成实体类/button /div /div div classcard-container div classcard div classcard-header h2i classfas fa-table/i MySQL 建表语句/h2 /div div classcard-body textarea idsqlInput placeholder在此粘贴您的MySQL建表语句...CREATE TABLE course_category ( id bigint NOT NULL, user_name varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 创建用户名称, user_id bigint DEFAULT NULL COMMENT 创建用户id, status tinyint(1) DEFAULT 0 COMMENT 是否可用0可用1不可用, create_time datetime DEFAULT NULL COMMENT 创建时间, update_time datetime DEFAULT NULL COMMENT 修改时间, name varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 分类名称, sort int DEFAULT 0 COMMENT 排序, parent_id bigint DEFAULT NULL COMMENT 上级分类id, PRIMARY KEY (id) USING BTREE ) ENGINEInnoDB DEFAULT CHARSETutf8mb4 COLLATEutf8mb4_0900_ai_ci ROW_FORMATDYNAMIC COMMENT课程分类表;/textarea /div /div div classcard div classcard-header h2i classfas fa-file-code/i Java 实体类/h2 /div div classcard-body pre idjavaOutput// 输入建表语句后点击生成按钮/pre button classcopy idcopyBtni classfas fa-copy/i 复制到剪贴板/button /div /div /div div classfield-info h3i classfas fa-lightbulb/i 使用说明/h3 div classinfo-grid div classinfo-item h4命名转换/h4 p表名/字段名自动转换为驼峰命名法例如user_name → userName/p /div div classinfo-item h4类型映射/h4 pMySQL类型 → Java类型brbigint → Longbrvarchar → Stringbrdatetime → Date/p /div div classinfo-item h4自动注解/h4 p主键自动添加 Id 注解br所有字段添加 ApiModelProperty/p /div div classinfo-item h4支持特性/h4 p表注释 → 类注释br字段注释 → 属性注释br支持Lombok Data注解/p /div /div /div footer p© 2023 MySQL转Java实体类工具 | 开发者工具/p /footer /div script document.addEventListener(DOMContentLoaded, function() { const sqlInput document.getElementById(sqlInput); const javaOutput document.getElementById(javaOutput); const generateBtn document.getElementById(generateBtn); const copyBtn document.getElementById(copyBtn); const packageNameInput document.getElementById(packageName); const classNameInput document.getElementById(className); const addApiModelPropertyCheckbox document.getElementById(addApiModelProperty); // 类型映射关系 const typeMap { bigint: Long, int: Integer, tinyint: Integer, smallint: Integer, mediumint: Integer, integer: Integer, float: Float, double: Double, decimal: BigDecimal, numeric: BigDecimal, char: String, varchar: String, text: String, mediumtext: String, longtext: String, date: Date, datetime: Date, timestamp: Date, time: Date, boolean: Boolean, bit: Boolean, blob: byte[] }; // 生成实体类 generateBtn.addEventListener(click, generateEntityClass); // 复制功能 copyBtn.addEventListener(click, copyToClipboard); // 自动提取表名 sqlInput.addEventListener(input, extractTableName); function generateEntityClass() { const sql sqlInput.value.trim(); if (!sql) { javaOutput.textContent // 请输入MySQL建表语句; return; } const packageName packageNameInput.value.trim() || com.example.model; let className classNameInput.value.trim(); const addApiModelProperty addApiModelPropertyCheckbox.checked; // 解析建表语句 const tableMatch sql.match(/CREATE\sTABLE\s(?:IF\sNOT\sEXISTS\s)??(\w)?/i); if (!tableMatch) { javaOutput.textContent // 无法识别建表语句请检查格式; return; } const tableName tableMatch[1]; if (!className) { className toCamelCase(tableName, true, true); } // 解析表注释 let tableComment ; const commentMatch sql.match(/COMMENT\s*\s*([^])/i); if (commentMatch) { tableComment commentMatch[1]; } // 解析字段 const fieldRegex /(\w)\s(\w)(?:\((\d|\d,\d|\d\s\w)\))?\s*(?:unsigned\s)?(?:CHARACTER\sSET\s\w)?\s*(?:COLLATE\s\w)?\s*(NOT\sNULL|NULL)?\s*(?:DEFAULT\s([^\s,]))?\s*(?:AUTO_INCREMENT)?\s*(?:ON\sUPDATE\sCURRENT_TIMESTAMP)?\s*(?:COMMENT\s(.*?))?/gi; const lines sql.split(\n); let fieldMatch; const fields []; const primaryKeys []; // 查找主键 const pkMatch sql.match(/PRIMARY\sKEY\s*\(([^)])\)/i); if (pkMatch) { const pkFields pkMatch[1].replace(//g, ).split(,).map(f f.trim()); primaryKeys.push(...pkFields); } // 逐行解析字段避免匹配到约束 for (const line of lines) { const trimmedLine line.trim(); if (/^(CONSTRAINT|KEY|INDEX|UNIQUE|FOREIGN)/i.test(trimmedLine)) continue; fieldRegex.lastIndex 0; // 每次重置 const match fieldRegex.exec(trimmedLine); if (match) { const fieldName match[1]; const sqlType match[2].toLowerCase(); const defaultValue match[5]; // 这里是默认值 let fieldComment match[6] || ; // 这里才是注释 if (fieldComment) { fieldComment fieldComment.replace(/\\/g, ); } const isRequired /NOT NULL/i.test(trimmedLine); const javaType typeMap[sqlType] || Object; const javaFieldName toCamelCase(fieldName, false, false); fields.push({ sqlName: fieldName, javaName: javaFieldName, sqlType, javaType, comment: fieldComment, isPrimary: primaryKeys.includes(fieldName), isRequired }); } } if (fields.length 0) { javaOutput.textContent // 未找到有效字段定义\n// 原始SQL:\n sql; return; } // 生成实体类代码 let code package ${packageName};\n\n; // 动态导入需要的类型 const imports new Set(); imports.add(import javax.persistence.Id;); imports.add(import javax.persistence.Table;); imports.add(import lombok.Data;); imports.add(import java.io.Serializable;); // 检查是否需要导入Swagger if (addApiModelProperty) { imports.add(import io.swagger.annotations.ApiModel;); imports.add(import io.swagger.annotations.ApiModelProperty;); } // 检查需要导入的类型 fields.forEach(field { if (field.javaType Date) { imports.add(import java.util.Date;); } else if (field.javaType BigDecimal) { imports.add(import java.math.BigDecimal;); } }); // 添加import语句 Array.from(imports).sort().forEach(imp { code imp \n; }); code \n; if (tableComment) { code /**\n * ${tableComment}\n */\n; } // 添加类注解 code Data\n; code Table(name ${tableName})\n; if (addApiModelProperty) { code ApiModel(value ${className}, description ${tableComment || className})\n; } code public class ${className} implements Serializable {\n\n; // 添加字段 fields.forEach(field { if (field.comment) { code /**\n * ${field.comment}\n */\n; } if (field.isPrimary) { code Id\n; } if (addApiModelProperty) { const apiValue field.comment ? field.comment : field.javaName; code ApiModelProperty(value ${apiValue}, name ${field.javaName}, example ${getExampleValue(field.javaType)}, required ${field.isRequired})\n; } code private ${field.javaType} ${field.javaName};\n\n; }); code }; javaOutput.textContent code; } // 获取示例值 function getExampleValue(javaType) { switch(javaType) { case Long: return 1; case Integer: return 1; case String: return example; case Date: return 2023-01-01 12:00:00; case BigDecimal: return 100.00; case Boolean: return true; default: return ; } } function toCamelCase(str, capitalizeFirst, isClassName) { let cleanedStr str; if (isClassName) { cleanedStr cleanedStr .replace(/^t_?b?_?/, ) .replace(/^table_?/, ); } return cleanedStr.split(_) .map((word, index) { if (index 0 !capitalizeFirst) { return word; } return word.charAt(0).toUpperCase() word.slice(1); }) .join(); } function extractTableName() { const sql sqlInput.value.trim(); if (!classNameInput.value) { const tableMatch sql.match(/CREATE\sTABLE\s(?:IF\sNOT\sEXISTS\s)??(\w)?/i); if (tableMatch) { const tableName tableMatch[1]; classNameInput.value toCamelCase(tableName, true, true); } } } function copyToClipboard() { const text javaOutput.innerText; navigator.clipboard.writeText(text) .then(() { const originalText copyBtn.innerHTML; copyBtn.innerHTML i classfas fa-check/i 已复制!; setTimeout(() { copyBtn.innerHTML originalText; }, 2000); }) .catch(err { console.error(复制失败:, err); alert(复制失败请手动复制代码); }); } // 页面加载时自动生成一次 setTimeout(generateEntityClass, 500); }); /script /body /html