JavaScript
发布时间:2022-04-16 发布网站:大佬教程 code.js-code.com
大佬教程收集整理的这篇文章主要介绍了javascript制作sql转换为stringBuffer的小工具,大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
sql转换为StringBuffer的小工具,dao层拼接sql很麻烦,用这个小工具可以快速拼接,把写好的sql在sql工具中格式化好,然后复制进去就可以了
演示地址:http://runjs.cn/detail/fj14tpyu">http://runjs.cn/detail/fj14tpyu 有点丑,建议全屏查看,不过你下载下来可以自己修改
代码
change SQL
var ie = !-[1,];
function changeSQL()
{
var srcSQL = document.getElementById("srcSQL"
);
var srcInner = srcSQ
l.value;
var sqlBuf = "sqlBuf"
var BufObj = "
StringBuffer sqlBuf =
new StringBuffer(
);"
var newSrc = "";
if(i
E){
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;
}
cursor:hand;">转换
</td>
<td width="45%"><textarea id="showSQL" rows="40" cols="85" ></textarea></td>
</tr>
</table>