Mybatis SQL日志准换为可执行sql

最新推荐文章于 2023-07-06 18:40:03 发布

nacrt

最新推荐文章于 2023-07-06 18:40:03 发布

阅读量2.7k

点赞数 4

分类专栏： JavaScript HTML 文章标签： html mybatis

本文链接：https://blog.csdn.net/qq_31975227/article/details/110470229

版权

HTML 同时被 2 个专栏收录

7 篇文章 0 订阅

订阅专栏

JavaScript

2 篇文章 0 订阅

订阅专栏

mybatis log --> sql

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title></title>
    <script type="text/javascript">
        function f(obj) {
			getSql(obj.value);
        }
		
        function getSql(textVa) {
            // 获取带问号的SQL语句
            var statementStartIndex = textVa.indexOf('Preparing: ');
			if (statementStartIndex < 0) return;
            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);
            console.log(statementStr);
            //获取参数
            var parametersStartIndex = textVa.indexOf('Parameters: ');
            var parametersEndIndex = textVa.length - 1;
            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);
            parametersStr = parametersStr.split(",");
            console.log(parametersStr);
            for (var i = 0; i < parametersStr.length; i++) {
                // 如果数据中带括号将使用其他逻辑
                tempStr = parametersStr[i].substring(0, parametersStr[i].indexOf("("));
                // 获取括号中内容
                typeStr = parametersStr[i].substring(parametersStr[i].indexOf("(") + 1, parametersStr[i].indexOf(")"));
                // 如果为字符类型或时间 加''
                if (typeStr == "String" || typeStr == "Timestamp") {
                    statementStr = statementStr.replace("?", "'" + tempStr.trim() + "'");
                } else {
                    // 数值类型
                    statementStr = statementStr.replace("?", tempStr.trim());
                }
            }
            console.log(statementStr);
            document.getElementById("d1").innerHTML += statementStr + "\n-- ---------------------------------------------------------------------------------------------------------------------\n";
			var newText = textVa.substring(parametersStartIndex + parametersStr.length);
			if (newText <= 0) return;
			getSql(newText);
        }

        function copySQL() {
            var SQL = document.getElementById("d1");
            SQL.select(); // 选择对象
            document.execCommand("Copy"); // 执行浏览器复制命令
            var msg = document.getElementById("msg");
            msg.innerHTML = "已复制到剪切板";
            setTimeout(function () {
                msg.innerHTML = "";
            }, 3000);

        }

        function clearLog(obj) {
            obj.select();
            obj.value = "";
        }
        function clearOut(obj) {
			obj.innerHTML = "";
        }

    </script>
</head>
<body>

<h2><font color="#00bfff"> 输入Mybatis SQL日志：</font></h2>

<textarea id="sqlLog" rows="13" cols="140" style="font-size:20px"></textarea>


<div style="border:0px deepskyblue solid;width:1425px;height:50px;text-align:right">
    <button style="color:mediumblue;width:100px;height:60px" type="button"
            onclick="clearLog(document.getElementById('sqlLog'))">
        清空输入
    </button>
    <button style="color:mediumblue;width:100px;height:60px" type="button"
            onclick="clearOut(document.getElementById('d1'))">
        清空输出
    </button>
    <button style="color:mediumblue;width:100px;height:60px" type="submit"
            onclick="f(document.getElementById('sqlLog'))">
        解析SQL
    </button>
</div>

<h2><font color="#32cd32">解析为可执行SQL：</font></h2>

<textarea id="d1" rows="13" cols="140" style="font-size:20px" readonly></textarea>
<div style="border:0px deepskyblue solid;width:1425px;height:50px;text-align:right">
    <button style="color:mediumblue;width:100px;height:60px" type="button" onclick="copySQL()">复制SQL</button>
</div>

<div id="msg"
     style="color:cornflowerblue;border:0px black solid;width:800px;height:20px;text-align:right;font-style: initial;font-size: large">
</div>

</body>
</html>

效果如图：
mybatis sql日志转换

nacrt

关注

4
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
Mybatis SQL日志准换为可执行sql

mybatis log --> sql<!DOCTYPE html><html><head> <meta charset="utf-8"> <title></title> <script type="text/javascript"> function f(obj) { getSql(obj.value); } function
复制链接

扫一扫