52,782
社区成员
发帖
与我相关
我的任务
分享
function submitdeleteAllRow()
{
if(!confirm("确定要全表删除吗?")){
return;
}
var tableName = "<c:out value='${result.crudMeta.beanName}'/>";
var sql = "delete from "+tableName;
//alert(sql);
//return;
var url = "<c:url value='/servlet/Ajax4Update'/>";
processQry4(url, sql);
}
function processQry4(iUrl,iSql){
createXMLHttpRequest();
var url = iUrl;
var sql = iSql;
var queryStr = encodeURI("sql="+sql);
this.eventSrc = window.event.srcElement;
//获取数据错误,中止操作
if(sql == "" || sql==null){
//alert("请输入查询条件");
return false;
}
xmlHttp.open("POST",url,true);
xmlHttp.onreadystatechange = handleStateChange4;
xmlHttp.setRequestHeader("Content-Type","application/x-www-form-urlencoded;");
xmlHttp.send(queryStr);
}
function handleStateChange4(){
if(xmlHttp.readyState == 4){
if(xmlHttp.status == 200){
doParse4();
} else {
alert("server error:"+xmlHttp.status);
}
}
}
function doParse4(){
var result = xmlHttp.responseXML;
var rs = result.getElementsByTagName("ResultSet")[0];
var returnVal = rs.text;
return callBack4(this.eventSrc,returnVal);
}
function callBack4(eventobj,retVal){
if(retVal != null && retVal != "" && retVal == "1"){
alert("删除成功!");
}
}
package com.icbc.fidb.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.Hashtable;
import java.util.List;
import java.util.StringTokenizer;
import javax.servlet.Servlet;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.icbc.param.util.DbService;
/**
* @version 1.0
* @author <a href="mailto:yangfh@neusoft.com">yangfh</a>
*/
public class Ajax4UpdateServlet extends HttpServlet implements Servlet {
/**
* @see javax.servlet.http.HttpServlet#void (javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
*/
public void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
doPost(req, resp);
}
/**
* @see javax.servlet.http.HttpServlet#void (javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
*/
public void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
StringBuffer retXml = new StringBuffer();
PrintWriter outWriter = resp.getWriter();
try {
resp.setContentType("text/xml");
resp.setHeader("Cache-Control", "no-cache");
req.setCharacterEncoding("ISO-8859-1");
//获取传进来的sql语句
String sqlStr =
new String(
req.getParameter("sql").getBytes("ISO-8859-1"),
"UTF8");
DbService.executeUpdate("ORACLEJDBC", sqlStr);
retXml.append("<ResultSet>");
retXml.append("1");
retXml.append("</ResultSet>");
outWriter.print(new String(retXml));
} catch (Exception e) {
retXml.append("<ResultSet>");
retXml.append("0");
retXml.append("</ResultSet>");
outWriter.print(new String(retXml));
}
}
}