[javascript] JSP_query 변환

2. JS

자르르 2016. 12. 15. 10:43

쿼리 변환

상단에 변환할 쿼리입력

하단에 변환할 StringBuffer 변수 넣어서 변환

소스

------------------------------------------------------------------------------------------

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<HTML>

<HEAD>

</HEAD>

// String replace

function replace(replace_string, str1, str2) {

var pos;

while (replace_string.indexOf(str1)>-1) {

pos = replace_string.indexOf(str1);

replace_string = "" + (replace_string.substring(0, pos) + str2 + replace_string.substring((pos + str1.length), replace_string.length));

}

return replace_string;

}

function F_outQuery(){

var DF = document.frmForm;

var inQuery = DF.inQuery.value;

var frontQuery = DF.frontQuery.value;

// var resultQuery = 'String strNewLineSql = logSqlNewLine ? "\\n" : "";\n';

var resultQuery = 'StringBuffer query=new StringBuffer();\n';

arrylineQuery = inQuery.split("\n");

// resultQuery = "String strNewLineSql = logSqlNewLine ? \"\n\" : "";";

for(i=0; i<arrylineQuery.length; i++){

arrylineQuery[i] = replace(arrylineQuery[i],"\r","");

arrylineQuery[i] = replace(arrylineQuery[i],"\n","");

resultQuery += frontQuery+'(" '+ arrylineQuery[i] +' ");\n';

}

DF.outQuery.value = resultQuery;

}

</script>

<BODY>

</form>

</BODY>

</HTML>