Javascript: SQL <==> Java String 互转

最新推荐文章于 2025-11-25 08:44:41 发布

最新推荐文章于 2025-11-25 08:44:41 发布 · 215 阅读

文章标签：

#Javascript #正则表达式 #SQL java string #ViewUI

JavaScript 专栏收录该内容

5 篇文章

订阅专栏

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" onclick="tranxSql2JavaString();" />
		<input type="button" value="JavaString -> SQL" onclick="tranxJavaString2Sql();" />
		
		<br /><br />
		<textarea id="targetTextArea" style="border: 1px solid #d9d9d9;height: 200px;width: 95%;"></textarea>
		
	</div>

	</body> 
</html>