stringbuffer mysql_javascript制作sql转换为stringBuffer的小工具

sql转换为stringBuffer的小工具，dao层拼接sql很麻烦，用这个小工具可以快速拼接，把写好的sql在sql工具中格式化好，然后复制进去就可以了

代码

change SQL

var ie = !-[1,];

function changeSQL(){

var srcSQL = document.getElementById("srcSQL");

var srcInner = srcSQL.value;

var sqlBuf = "sqlBuf"

var BufObj = "StringBuffer sqlBuf = new StringBuffer();"

var newSrc = "";

if(ie){

var newSrc = srcInner.split("\r\n");

}else{

var patt = new RegExp(/.+/g);

var newSrc = srcInner.match(patt);

}

var len = newSrc.length;

for(var i=0;i

var temp=newSrc[i];

if(i < len-1){

sqlBuf += ".append(\" " + temp + " \")" + "\r\n";

}

if(i == len-1){

sqlBuf += ".append(\" " + temp + " \");";

}

}

var showSQL = document.getElementById("showSQL");

showSQL.innerText = BufObj + "\n" + sqlBuf;

}

转换

以上所述就是本文的全部内容了，希望大家能够喜欢。