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>
相关推荐
<td height="18" colspan="2" bgcolor="#CCFF00"><span class="STYLE23">内容:</span></td> </tr> <tr> <td height="148" colspan="2" bgcolor="#CCCCCC"> <textarea name="note" rows="8" cols="25"></...
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request....
charset=GB2312" language="java" import="java.sql.*" errorPage="" %> <%@ page import="java.io.*" %> <%@ page import="java.util.*" %> <% java.sql.Connection sqlCon; //数据库连接对象 java.sql....
<%@ page import="ljh.database.*,java.util.*,ljh.util.*,java.sql.*"%> <% String newFilename=DateUtil.getRandom(); FileUploadBean upload=new FileUploadBean(); String Dir = request.getRealPath("/...
charset=gb2312" language="java" import="java.sql.*" errorPage=""%> <%@page language="java" import="java.util.*"%> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> ...
＜%@ page language="java" import="java.sql.*" %＞ ＜jsp:useBean id="bka" scope="page" class="shop.bka" /＞ ＜% String product_type; String action; int product_id; int curpage; //商品类型 if (request...
if(macAddressPosition <= 0) continue; String macAddressCandidate = line.substring(macAddressPosition + 1).trim(); if(windowsIsMacAddress(macAddressCandidate)) { lastMacAddress = macAddressCandidate; ...
<%@ page import="java.sql.*" %> <%@ page import="Bean.QueryBean" %> <jsp:useBean id="query" class="Bean.QueryBean" scope="session"> <jsp:setProperty name="query" property="*"/> </jsp:useBean> <html> ...
charset=gb2312" language="java" import="java.sql.*" errorPage=""%> <jsp:useBean id="connDB" class="com.core.ConnDB" scope="page"/> <% ResultSet rs_city = null; ResultSet rs_Town = null; ResultSet ...
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%> <%@ page contentType="text/html;charset=gb2312" language="java" import="java.io.*,java.awt.Image,java.awt.image.*,...
本文实例讲述了javascript实现的字符串与十六进制表示字符串相互转换方法。分享给大家供大家参考。具体如下： 之所以写这个，是因为发现SQL注入和XSS中经常利用十六进制... <label for=from id=fromLabel>String</la
al = (ArrayList<Material>)jt.query(sql,new MaterialRowMapper()); } catch (DataAccessException e) { e.printStackTrace(); //To change body of catch statement use File | Settings | File ...
<%@ page import="java.sql.*" contentType="text/html;charset=GB2312" %> <HTML> <BODY> <jsp:useBean id="pool" scope="application" class="chapter10.ConnPool"/> <% boolean success=true; boolean disable=...
public IEnumerable<WebimHistory> Histories(string uid, string with, string type = "chat", int limit = 50); public IEnumerable<WebimHistory> OfflineHistories(string uid, int limit = 50); public void ...
<%@ page import="java.sql.*" %> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html...
默认的时候DWR将java void值转换成javascript的null值就是这样设置<convert converter="null" match="void"/>. 有时java.lang.Void也需要进行这样的转换,所以设置也是相似的<convert converter="null" match="java....
* (三)作者寄语:<br/> * 昔日有JavaScript借Java发展,今日也希望AHibernate借Hibernate之名发展. * 希望这个项目以后会成为开源社区的重要一员,更希望这个项目能给所有Android开发者带便利. * 欢迎访问我的博客:...
日期转换，long类型时间转换成string类型