reportclear.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;	
	int i=1;	
	String page_code="";	
	String tempstr="";
	
//*****初始化变量	
	page_code=request.getParameter("page_code");	
	
//*****连接数据库
	Connection con = Common.getConnection();	
	Statement s = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 		
	//删除记录
	tempQuery="delete  universal_page_define where code='"+page_code+"'";
	 s.executeUpdate(tempQuery); 	
	tempQuery="delete  universal_pageelement_define where page_code='"+page_code+"'";
	 s.executeUpdate(tempQuery); 	
	out.println("<p><p><center>tableLineNum:   "+page_code+"   deleted!<br><a href='javascript:windows.close()'>关闭</a>");
	con.close();
}
catch(Exception e)
{
	out.println(e.getMessage());
}
%>