Javascript: SQL <==> Java String 互转-优快云博客

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>