groupdell.jsp

一套完整的工商12315的源程序jsp部分在12315里,后台JAVA部分在gs12315src里,没有打包数据库.

<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="com.gs.util.*"%>
<%@page import="java.sql.*"%>
<%
try
{
//*****变量声明			
	String tempQuery = null;	
	String page_code="";		
	ResultSet rs=null;
	int i=0;				
	String logic_mark="";//组逻辑： 对应单元格编号		
	page_code=request.getParameter("page_code");	
	logic_mark=request.getParameter("logic_mark");		
	
//*****连接数据库
	Connection con = Common.getConnection();
	Statement s = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
	//删除数据			
	tempQuery="delete  universal_pageelement_define where page_code='"+page_code+"' and (  unit_code>='70000000' and unit_code<'80000000') and logic_mark='"+logic_mark+"'";	
	Debug.println(tempQuery);
	
	s.executeUpdate(tempQuery);
	
	out.println("<script>location='groupList.jsp?page_code="+page_code+"'</script>");
	con.close();
}
catch(Exception e)
{	
	out.println("<center>您的操作失败了！<br><br>错误原因:"+e.getMessage());
}
finally{
	try{
		//if(con != null) con.close();
	 }
	catch(Exception sqle){}
}
%>