sql转java代码小工具_把调试好的SQL语句转换为JAVA代码小工具

StringsrcSQL=request.getParameter("srcSQL");

StringBuffer targetSQL= newStringBuffer();if(!ObjectUtil.isNull(srcSQL)){

srcSQL= new String(srcSQL.getBytes("8859_1"),"UTF-8");String[] lineArr=srcSQL.split("[\\n]+");for(inti= 0; i

Pattern p=Pattern.compile("\t|\r|\n");

Matcher m=p.matcher(lineArr[i]);StringstrNoN=m.replaceAll(" ");intspaceLength=strNoN.indexOf(strNoN.trim());if(i != 0){

targetSQL.append("+").append(StringUtil.repeat(" ", spaceLength));

}

targetSQL.append("\"").append(strNoN.trim()).append(" \"");if(i !=(lineArr.length- 1)){

targetSQL.append("\n");

}

}

}else{

srcSQL= "";

}%>

sql代码格式化

varclip= null;function$(id) {returndocument.getElementById(id); }functioninit() {

clip= newZeroClipboard.Client();

clip.setHandCursor(true);

clip.addEventListener('mouseOver', my_mouse_over);

clip.addEventListener('complete', my_complete);

clip.glue('d_clip_button');

}functionmy_mouse_over(client) {

clip.setText( $('fe_text').value );

}functionmy_complete(client, text) {

$('tip').innerHTML="复制成功";

}