MyBatis日志转换工具 HTML源码
源码来自网络，自己优化了一下
新版 移除了第三方样式包 加速页面加载，增加未找到SQL提示
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>MyBatis日志转换工具</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<style>
:root {
--primary-color: #4361ee;
--secondary-color: #3f37c9;
--accent-color: #4895ef;
--success-color: #4cc9f0;
--warning-color: #f72585;
--text-color: #333;
--light-gray: #f8f9fa;
--medium-gray: #e9ecef;
--dark-gray: #adb5bd;
--border-radius: 6px;
--box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);
--transition: all 0.3s ease;
}
body {
font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
margin: 0;
padding: 20px;
background-color: var(--light-gray);
color: var(--text-color);
line-height: 1.6;
}
.container {
max-width: 1000px;
margin: 0 auto;
padding: 20px;
background-color: white;
border-radius: var(--border-radius);
box-shadow: var(--box-shadow);
}
h1 {
color: var(--primary-color);
margin-bottom: 20px;
font-weight: 600;
display: flex;
align-items: center;
gap: 10px;
}
h1::before {
content: "";
display: inline-block;
width: 24px;
height: 24px;
background-color: var(--primary-color);
mask: url("data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24' fill='none' stroke='currentColor' stroke-width='2' stroke-linecap='round' stroke-linejoin='round'%3E%3Cpath d='M13 2H6a2 2 0 0 0-2 2v16a2 2 0 0 0 2 2h12a2 2 0 0 0 2-2V9z'%3E%3C/path%3E%3Cpolyline points='13 2 13 9 20 9'%3E%3C/polyline%3E%3C/svg%3E") no-repeat center;
-webkit-mask: url("data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24' fill='none' stroke='currentColor' stroke-width='2' stroke-linecap='round' stroke-linejoin='round'%3E%3Cpath d='M13 2H6a2 2 0 0 0-2 2v16a2 2 0 0 0 2 2h12a2 2 0 0 0 2-2V9z'%3E%3C/path%3E%3Cpolyline points='13 2 13 9 20 9'%3E%3C/polyline%3E%3C/svg%3E") no-repeat center;
}
.form-group {
margin-bottom: 25px;
}
.form-label {
display: block;
margin-bottom: 8px;
font-weight: 500;
font-size: 16px;
color: var(--text-color);
}
.form-control {
width: 100%;
padding: 12px 15px;
border: 1px solid var(--medium-gray);
border-radius: var(--border-radius);
box-sizing: border-box;
font-family: inherit;
font-size: 15px;
transition: var(--transition);
background-color: white;
}
.form-control:focus {
outline: none;
border-color: var(--accent-color);
box-shadow: 0 0 0 3px rgba(72, 149, 239, 0.2);
}
textarea.form-control {
min-height: 150px;
resize: vertical;
}
.btn {
padding: 12px 24px;
background-color: var(--primary-color);
color: white;
border: none;
border-radius: var(--border-radius);
cursor: pointer;
font-size: 16px;
font-weight: 500;
transition: var(--transition);
display: inline-flex;
align-items: center;
gap: 8px;
}
.btn:hover {
background-color: var(--secondary-color);
transform: translateY(-2px);
}
.btn:active {
transform: translateY(0);
}
.btn::before {
content: "";
display: inline-block;
width: 18px;
height: 18px;
background-color: white;
mask: url("data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24' fill='none' stroke='currentColor' stroke-width='2' stroke-linecap='round' stroke-linejoin='round'%3E%3Cpath d='M8 17h8m-8-4h8m-8-4h8M6 4h12a2 2 0 0 1 2 2v12a2 2 0 0 1-2 2H6a2 2 0 0 1-2-2V6a2 2 0 0 1 2-2z'%3E%3C/path%3E%3C/svg%3E") no-repeat center;
-webkit-mask: url("data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24' fill='none' stroke='currentColor' stroke-width='2' stroke-linecap='round' stroke-linejoin='round'%3E%3Cpath d='M8 17h8m-8-4h8m-8-4h8M6 4h12a2 2 0 0 1 2 2v12a2 2 0 0 1-2 2H6a2 2 0 0 1-2-2V6a2 2 0 0 1 2-2z'%3E%3C/path%3E%3C/svg%3E") no-repeat center;
}
.result-container {
padding: 15px;
border: 1px solid var(--medium-gray);
border-radius: var(--border-radius);
min-height: 100px;
background-color: white;
font-family: 'Courier New', Courier, monospace;
white-space: pre-wrap;
word-break: break-all;
position: relative;
}
.result-container::before {
content: "SQL 结果";
position: absolute;
top: -10px;
left: 10px;
background-color: white;
padding: 0 10px;
font-size: 14px;
color: var(--dark-gray);
font-family: inherit;
}
.toast {
position: fixed;
top: 30px;
left: 50%;
transform: translateX(-50%);
padding: 12px 24px;
background-color: var(--primary-color);
color: white;
border-radius: var(--border-radius);
box-shadow: var(--box-shadow);
z-index: 1000;
display: flex;
align-items: center;
gap: 10px;
opacity: 0;
transition: var(--transition);
}
.toast.visible {
opacity: 1;
top: 20px;
}
.toast::before {
content: "";
display: inline-block;
width: 18px;
height: 18px;
background-color: white;
mask: url("data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24' fill='none' stroke='currentColor' stroke-width='2' stroke-linecap='round' stroke-linejoin='round'%3E%3Cpath d='M22 11.08V12a10 10 0 1 1-5.93-9.14'%3E%3C/path%3E%3Cpolyline points='22 4 12 14.01 9 11.01'%3E%3C/polyline%3E%3C/svg%3E") no-repeat center;
-webkit-mask: url("data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24' fill='none' stroke='currentColor' stroke-width='2' stroke-linecap='round' stroke-linejoin='round'%3E%3Cpath d='M22 11.08V12a10 10 0 1 1-5.93-9.14'%3E%3C/path%3E%3Cpolyline points='22 4 12 14.01 9 11.01'%3E%3C/polyline%3E%3C/svg%3E") no-repeat center;
}
.footer {
margin-top: 30px;
text-align: center;
color: var(--dark-gray);
font-size: 14px;
}
@media (max-width: 768px) {
.container {
padding: 15px;
}
h1 {
font-size: 24px;
}
.btn {
width: 100%;
justify-content: center;
}
}
</style>
</head>
<body>
<div class="container">
<h1>MyBatis 日志转换工具</h1>
<div class="form-group">
<label for="log" class="form-label">日志内容</label>
<textarea id="log" class="form-control" placeholder="在此粘贴 MyBatis 日志内容，例如：
Preparing: SELECT * FROM users WHERE id = ? AND status = ?
Parameters: 1(Integer), active(String)"></textarea>
</div>
<div class="form-group">
<button type="button" class="btn" onclick="transLog()">转换并复制</button>
</div>
<div class="form-group">
<label for="sql" class="form-label">转换结果</label>
<div id="sql" class="result-container"></div>
</div>
<div class="footer">
<p>将 MyBatis 日志中的预处理语句和参数转换为可直接执行的 SQL 语句</p>
</div>
</div>
<div id="toast" class="toast"></div>
<script>
function transLog() {
const logText = document.getElementById("log").value.trim();
if (!logText) {
showToast("请先输入日志内容");
return;
}
try {
// 提取预处理语句
const preparingMatch = logText.match(/Preparing:\s*(.+?)(?=\n|$)/);
if (!preparingMatch) {
showToast("未找到 Preparing 语句");
return;
}
let statementStr = preparingMatch[1].trim();
// 提取参数部分
const parametersMatch = logText.match(/Parameters:\s*(.+?)(?=\n|$)/);
if (!parametersMatch) {
document.getElementById("sql").textContent = statementStr;
copyToClip(statementStr);
return;
}
// 参数分割，正确处理带括号的参数
const parametersStr = parametersMatch[1].trim();
const parameters = parametersStr.split(/,\s*(?=(?:[^']*'[^']*')*[^']*$)/);
// 参数类型处理配置
const stringTypes = new Set(["String", "Timestamp", "LocalDateTime", "LocalDate", "LocalTime", "Date"]);
const booleanTypes = new Set(["Boolean"]);
parameters.forEach(param => {
param = param.trim();
// 处理null值
if (param === 'null') {
statementStr = statementStr.replace("?", "NULL");
return;
}
// 分离参数值和类型
let value, type;
const parenIndex = param.indexOf('(');
if (parenIndex > 0 && param.endsWith(')')) {
value = param.substring(0, parenIndex).trim();
type = param.substring(parenIndex + 1, param.length - 1).trim();
} else {
value = param;
type = '';
}
// 根据类型处理值
if (stringTypes.has(type)) {
// 处理字符串值，转义单引号
value = value.replace(/'/g, "''");
// 如果值没有被引号包围，加上引号
if (!/^'.*'$/.test(value)) {
value = `'${value}'`;
}
} else if (booleanTypes.has(type)) {
// 布尔值转换为1/0
value = value === 'true' ? '1' : '0';
}
// 只替换第一个问号
statementStr = statementStr.replace("?", value);
});
document.getElementById("sql").textContent = statementStr;
copyToClip(statementStr);
showToast("SQL 已复制到剪贴板");
} catch (error) {
console.error("转换错误:", error);
showToast(`转换失败: ${error.message}`);
}
}
// 复制到剪贴板
function copyToClip(content) {
if (!content) return;
navigator.clipboard.writeText(content).then(() => {
console.log("复制成功");
}).catch(err => {
console.error("复制失败:", err);
// 降级方案
var textarea = document.createElement("textarea");
textarea.value = content;
textarea.style.position = "fixed";
document.body.appendChild(textarea);
textarea.select();
document.execCommand("copy");
document.body.removeChild(textarea);
});
}
// 显示提示消息
function showToast(message) {
var toast = document.getElementById("toast");
toast.textContent = message;
toast.classList.add("visible");
setTimeout(function() {
toast.classList.remove("visible");
}, 3000);
}
</script>
</body>
</html>
旧版
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>MyBatis日志转换</title>
<meta name="renderer" content="webkit">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
<!-- <link rel="stylesheet" href="layui/css/layui.css" media="all"> -->
<link rel="stylesheet" type="text/css" href="https://www.layuicdn.com/layui/css/layui.css"/>
</head>
<body>
<fieldset class="layui-elem-field layui-field-title" style="margin-top: 50px;">
<legend style="margin-left:2px">
<span class="layui-badge-dot"></span> MyBatis 日志转换
</legend>
</fieldset>
<div class="layui-form-item layui-form-text">
<label class="layui-form-label"><a style="font-size: 18px">日志内容</a></label>
<div class="layui-input-block">
<textarea style="height: 100px;" placeholder="在此处粘贴日志内容" id="log" name="log"
class="layui-textarea"></textarea>
</div>
</div>
<div style="margin-left: 110px;">
<button type="button" class="layui-btn layui-btn-warm" onclick="transLog()">转换并复制</button>
</div>
<br>
<br>
<div class="layui-form-item layui-form-text">
<label class="layui-form-label"><a style="font-size: 18px">SQL语句</a></label>
<div class="layui-input-block">
<div style="border:red; solid: 2px;" id="sql"></div>
</div>
</div>
<script src="https://www.layuicdn.com/layui/layui.js" charset="utf-8"></script>
<script>
function transLog() {
var textVa = document.getElementById("log").value;
// 获取带问号的SQL语句
var statementStartIndex = textVa.indexOf('Preparing: ');
var statementEndIndex = textVa.length - 1;
for (var i = statementStartIndex; i < textVa.length; i++) {
if (textVa[i] == "\n") {
statementEndIndex = i;
break;
}
}
var statementStr = textVa.substring(statementStartIndex + "Preparing: ".length, statementEndIndex);
//获取参数
var parametersStartIndex = textVa.indexOf('Parameters: ');
var parametersEndIndex = textVa.length;
for (var i = parametersStartIndex; i < textVa.length; i++) {
if (textVa[i] == "\n") {
parametersEndIndex = i;
break;
} else {
// console.log(textVa[i]);
}
}
var parametersStr = textVa.substring(parametersStartIndex + "Parameters: ".length, parametersEndIndex);
// 参数列表
var parametersStrArr = parametersStr.split(",");
for (var i = 0; i < parametersStrArr.length; i++) {
tempStr = parametersStrArr[i].substring(0, parametersStrArr[i].indexOf("("));
// 不含"("是null
if (tempStr == '') {
tempStr = "null";
}
// 如果数据中带括号需要判断参数类型
typeStr = parametersStrArr[i].substring(parametersStrArr[i].indexOf("(") + 1, parametersStrArr[i].indexOf(")"));
if (typeStr == "String" || typeStr == "Timestamp") {
statementStr = statementStr.replace("?", "'" + tempStr.trim() + "'");
} else {
statementStr = statementStr.replace("?", tempStr.trim());
}
}
document.getElementById("sql").innerHTML = statementStr;
copyToClip(statementStr);
}
//复制到剪贴板
function copyToClip(content) {
var aux = document.createElement("input");
aux.setAttribute("value", content);
document.body.appendChild(aux);
aux.select();
document.execCommand("copy");
document.body.removeChild(aux);
if ("" != content) {
layer.msg("复制成功，直接粘贴即可");
} else {
layer.msg("请先输入日志内容");
}
}
</script>
</body>
</html>
本文来自博客园，作者：Micky233，转载请注明原文链接：https://www.cnblogs.com/geek233/p/17902861.html
浙公网安备 33010602011771号