addreportdatalogicframetop.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;
	Statement stmt = null;
	
	String page_code="";	
	page_code=request.getParameter("page_code");
	
	String logic_mark="";
	logic_mark=request.getParameter("logic_mark");
	
	String logicstr="";;
	
	ResultSet rs=null;
	int i=0;			
	
//*****连接数据库
	Connection con = Common.getConnection();
	//Statement s = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
	stmt = con.createStatement();
	
	tempQuery="select * from universal_pageelement_define where page_code='"+page_code+"' and logic_mark='"+logic_mark+"'";
	//out.println(tempQuery);
	rs = stmt.executeQuery(tempQuery);	
	if(rs.next()){
		logicstr=rs.getString("typelogic");
	}
%>
<form method="POST" action="addreportDatalogicFrameInput.jsp" name=form1 target="footnotes">
<input type="hidden" name="page_code" size="20" value="<%=page_code%>">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
  <tr>
    <td width="100%" align="left">
    所属单元格：<input type="text" name=code value="<%=logic_mark%>" size=15></td>
    </tr>
  <td width="100%" align="left">
    行逻辑：</td>
    </tr>
  <tr>
    <td width="100%" align="center">
<textarea rows='3' name='logicstr' cols='110'><%=logicstr%></textarea></td>
  </tr>
</table>
</form>
<%
	rs.close();
	stmt=null;
	con.close();
}
catch(Exception e)
{	
	out.println("<center>您的操作失败了！<br><br>错误原因:"+e.getMessage());
}
finally{
	try{
		//if(con != null) con.close();
	 }
	catch(Exception sqle){}
}
%>