check.jsp

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

<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="com.gs.util.*"%>
<%@page import="java.sql.*"%>
<h4><%
try
{
//*****变量声明			
	String mode="";
	String tempQuery = null;	
	String cat2="";
	ResultSet rs=null;	
	int i=0;					
	String code,explain,rowcolSign,class1,class2,class3,mark;
	mode=request.getParameter("mode");
	code=request.getParameter("page_code");
	explain=request.getParameter("explain");
	rowcolSign=request.getParameter("rowcolSign");
	mark=request.getParameter("mark");	
	class1=request.getParameter("class1");
	class2=request.getParameter("class2");
	class3=request.getParameter("class3");

//*****连接数据库
	Connection con = Common.getConnection();	
	Statement s = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 				
//*****检查数据
	//插入
	if(mode.equals("1")){
		tempQuery="select code,explain,rowcolSign,class1,class2,class3,mark from universal_page_define where code='"+code+"'";
		rs=s.executeQuery(tempQuery);
		if(!rs.next()){
			rs.close();
			tempQuery="insert into universal_page_define (code,explain,rowcolSign,class1,class2,class3,mark)values('"+code+"','"+PubFunc.encodeGB(explain)+"','"+rowcolSign+"','"+class1+"','"+class2+"','"+class3+"','"+mark+"')";
			s.executeUpdate(tempQuery);
			response.sendRedirect("main.jsp?page_code="+code+"&explain="+explain);		
		}
		out.println("该表已经存在！");
	}
	//删除
	if(mode.equals("2")){
		tempQuery="delete universal_page_define where code='"+code+"'";
		s.executeUpdate(tempQuery);		
		tempQuery="delete  universal_pageelement_define where page_code='"+code+"'";
	 	s.executeUpdate(tempQuery);
		out.println("<p><p><center>tableLineNum:   "+code+"   deleted!");
	}
	//修改
	if(mode.equals("3")){		
		response.sendRedirect("main.jsp?page_code="+code+"&explain="+explain);
	}
	con.close();
}
catch(Exception e)
{
	out.println(e.getMessage());
}
%>