源碼：
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title></title>
<script type="text/javascript">
function multiTransefer(inputText) {
// 將傳入的字符串根據(jù)MyBatis的標(biāo)識拆分成數(shù)組
var mybatisSQLTexts = new Array();
while (inputText.lastIndexOf('Preparing: ') > -1) {
// 因?yàn)槭菑奈膊拷厝。孕枰獜臄?shù)組的頭部添加
mybatisSQLTexts.unshift(inputText.substring(inputText.lastIndexOf('Preparing: ')));
// console.log('lastIndexOf:'+inputText.lastIndexOf('Preparing: '));
// console.log('substring 0:'+inputText.substring(0, inputText.lastIndexOf('Preparing: ')));
// console.log('substring 1:'+inputText.substring(inputText.lastIndexOf('Preparing: ')));
inputText = inputText.substring(0, inputText.lastIndexOf('Preparing: '));
}
// console.log(mybatisSQLTexts);
var radio = document.getElementById("flag");
var selectvalue = radio.checked; // selectvalue為radio中選中的值
// 將數(shù)組中的字符串挨個處理，以數(shù)組形式返回
var retStr = null;
var tmpSQL = "";
for (var i = 0; i < mybatisSQLTexts.length; i++) {
retStr = f(mybatisSQLTexts[i]);
if (retStr != null && retStr != "") {
tmpSQL += retStr + '\n\n';
}
}
if (selectvalue) {
if (tmpSQL != null && tmpSQL != "") {
document.getElementById("d1").value += tmpSQL;
}
} else {
document.getElementById("d1").value = '\n' + tmpSQL;
}
}
// 單句的問號生成SQL
function f(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);
//獲取參數(shù)
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++) {
// 如果數(shù)據(jù)中帶括號將使用其他邏輯
tempStr = parametersStr[i].substring(0, parametersStr[i].indexOf("("));
// 獲取括號中內(nèi)容
typeStr = parametersStr[i].substring(parametersStr[i].indexOf("(")+1,parametersStr[i].indexOf(")"));
// 如果為字符類型
if (typeStr == "String" || typeStr == "Timestamp") {
statementStr = statementStr.replace("?", "'"+tempStr.trim()+"'");
}else{
// 數(shù)值類型
statementStr = statementStr.replace("?", tempStr.trim());
}
}
// console.log(statementStr);
if(statementStr != null && statementStr != "") {
return statementStr;
}
return null;
}
</script>
</head>
<body>
<div>
<label>
<input type="checkbox" id="flag" />
繼續(xù)疊加
</label>
</div>
<div>
<textarea name="getStr" id="1" oninput="multiTransefer(document.getElementById('1').value)" rows="40" style="width: 49%" ></textarea>
<textarea name="getStr" id="d1" rows="40" style="width: 49%" ></textarea>
</div>
</body>
</html>
