526互联

一个小插件，将控制台的sql打印出来

发布时间 2023-05-26 19:47:36作者: 素净

 

将下面的源码保存成一个.html文件，然后用浏览器打开，最后将它保存到浏览器标签里，就能方便下次打开啦：

 

源码如下：

<!DOCTYPE html>
<html lang="ch-zn">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

    <title>Mybatis SQL 格式化工具</title>
    <meta name="viewport" content="width=device-width,initial-scale=1">
    <meta content="coder-lzh/JS-mybatis-log-plugin" itemprop="name" property="og:title">
    <meta name="description" content="" property="og:description">
    <link href="./Mybatis SQL 格式化工具_files/bootstrap.min.css" rel="stylesheet">
    <style>
        .btn-parent {
            display: flex;
            justify-content: center;
            align-items: center;
            padding-bottom: 7px;
        }

        .leftMain {
            margin: 4px 20px;
        }
    </style>
</head>
<body>

<div class="leftMain">

    <div>
        <textarea style="width:100%;" name="logBefore" id="logBeforeId" rows="10" placeholder="转换前的log

2021-08-13 22:33:32.666 DEBUG 15984 --- [nio-8080-exec-8] c.g.b.mapper.TbUserMapper.selectPage     : ==>  Preparing: SELECT COUNT(1) FROM tb_user
2021-08-13 22:33:32.666 DEBUG 15984 --- [nio-8080-exec-8] c.g.b.mapper.TbUserMapper.selectPage     : ==> Parameters:
2021-08-13 22:33:32.667 DEBUG 15984 --- [nio-8080-exec-8] c.g.b.mapper.TbUserMapper.selectPage     : ==>  Preparing: SELECT id,username,password,state,phone,email,createtime,updatetime,last_login_time FROM tb_user LIMIT ?,?
2021-08-13 22:33:32.667 DEBUG 15984 --- [nio-8080-exec-8] c.g.b.mapper.TbUserMapper.selectPage     : ==> Parameters: 0(Long), 10(Long)
2021-08-13 22:33:32.668 DEBUG 15984 --- [nio-8080-exec-8] c.g.b.mapper.TbUserMapper.selectPage     : <==      Total: 1

"></textarea>
    </div>
    <div class="btn-parent">
        <div class="btn-child">
            <button type="button" onclick="multiTransefer(document.getElementById('logBeforeId').value)"
                    class="btn btn-success">转换
            </button>
            <button type="button" onclick="clearContent()" class="btn btn-danger">清除</button>
        </div>
    </div>
    <div>
        <textarea style="width:100%;" name="logAfter" id="logAfterId" rows="20" placeholder="转换后的SQL;

SELECT COUNT(1) FROM tb_user ;

SELECT id,username,password,state,phone,email,createtime,updatetime,last_login_time FROM tb_user LIMIT 0,10 ;
"></textarea>
    </div>
</div>

</script>
<script type="text/javascript">

  function multiTransefer(inputText) {
    document.getElementById('logAfterId').value = ''
    // 将传入的字符串根据MyBatis的标识拆分成数组
    var mybatisSQLTexts = []

    while (inputText.lastIndexOf('Preparing: ') > -1) {
      // 因为是从尾部截取，所以需要从数组的头部添加
      mybatisSQLTexts.unshift(inputText.substring(inputText.lastIndexOf('Preparing: ')))

      inputText = inputText.substring(0, inputText.lastIndexOf('Preparing: '))
    }
    console.log(mybatisSQLTexts)

    // 将数组中的字符串挨个处理，以数组形式返回
    for (var i = 0; i < mybatisSQLTexts.length; i++) {
      parseSql(mybatisSQLTexts[i])
    }
  }

  // 单句的问号生成SQL
  function parseSql(textVa) {
    // 获取带问号的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)
    // 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
      }
    }
    var parametersStr = textVa.substring(parametersStartIndex + 'Parameters: '.length, parametersEndIndex + 1)
    parametersStr = parametersStr.split(',')

    for (var i = 0; i < parametersStr.length; i++) {
      // 如果数据中带括号将使用其他逻辑
      tempStr = parametersStr[i].substring(0, parametersStr[i].lastIndexOf('('))
      // 获取括号中内容
      typeStr = parametersStr[i].substring(parametersStr[i].lastIndexOf('(') + 1, parametersStr[i].lastIndexOf(')'))
      // 如果为字符类型
      if (typeStr === 'String' || typeStr === 'Timestamp' || typeStr === 'Date') {
        statementStr = statementStr.replace('?', '\'' + tempStr.trim() + '\'')
      } else {
        // 数值类型
        statementStr = statementStr.replace('?', tempStr.trim())
      }
    }
    // console.log(statementStr);
    document.getElementById('logAfterId').value += '\n\n\n'
    document.getElementById('logAfterId').value += statementStr + ';'
    return textVa
  }

  function clearContent() {
    document.getElementById('logBeforeId').value = ''
    document.getElementById('logAfterId').value = ''
  }
</script>

</body>
</html>