Javascript: SQL <==> Java String 互转
<html>
<head>
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 ">
<title> Sql <==> Java String 互转</title>
<script>
function tranxSql2JavaString(){
document.getElementById("targetTextArea").value =
"strSql = \" \" \n"+document.getElementById("oriTextArea").value.replace(/.+/g,function(a){return " +\" " +a+" \"" })
;
}
function tranxJavaString2Sql(){
document.getElementById("targetTextArea").value =
document.getElementById("oriTextArea").value
.replace(/\+\s*\"/g,"")
.replace(/\"\s*\+/g,"")
.replace(/\s+\+/g,"")
.replace(/\"\s*;/g,"")
.replace(/\"/g,"")
;
//包含两个之间的空格
//+"
//"+
// +
//";
//"
}
</script>
</head>
<body >
<div align="center">
<textarea id="oriTextArea" style="border: 1px solid #d9d9d9;height: 200px;width: 95%;"></textarea>
<br /><br />
<input type="button" value="SQL -> JavaString" οnclick="tranxSql2JavaString();" />
<input type="button" value="JavaString -> SQL" οnclick="tranxJavaString2Sql();" />
<br /><br />
<textarea id="targetTextArea" style="border: 1px solid #d9d9d9;height: 200px;width: 95%;"></textarea>
</div>
</body>
</html>