groupframetitle.jsp
来自「一套完整的工商12315的源程序jsp部分在12315里,后台JAVA部分在gs」· JSP 代码 · 共 163 行
JSP
163 行
<%@ 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");
}
%>
<html>
<body topmargin="0" leftmargin="0">
<LINK href="style/webstyle.css" type=text/css rel=stylesheet>
<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">
所属单元格：
</td>
<td align="left">
<input type="text" name=code value="<%=logic_mark%>" size=15 >
</td>
</tr>
<tr>
<td width="100" align="left">
行逻辑[sql]：
</td>
<td align="left">
<textarea rows="1" name="logicstr" cols="20" style="width:100%"><%=logicstr%></textarea>
</td>
</tr>
</table>
<table border="1" cellspacing="0" style="border-collapse: collapse" bordercolor="#86C2FF" width="1000" id="AutoNumber14" name="table1" height="31" cellpadding="0" >
<tr>
<td bgcolor="#E6F2FF" width="6" height="18"></td>
<td width="111" height="18" bgcolor="#CEE7FF" align="center">编号</td>
<td width="126" height="18" bgcolor="#CEE7FF" align="center">类型</td>
<td width="111" height="18" bgcolor="#CEE7FF" align="center">内容</td>
<td width="124" height="18" bgcolor="#CEE7FF" align="center">属性</td>
<td width="76" height="18" bgcolor="#CEE7FF" align="center">跨行</td>
<td width="76" height="18" bgcolor="#CEE7FF" align="center" >跨列</td>
<td width="38" height="18" bgcolor="#CEE7FF" align="center">行尾</td>
<td width="54" height="18" bgcolor="#CEE7FF" align="center">对齐</td>
<td width="76" height="18" bgcolor="#CEE7FF" align="center">宽度</td>
<td width="111" height="18" bgcolor="#CEE7FF" align="center">高度</td>
<td width="111" height="18" bgcolor="#CEE7FF" align="center">字体</td>
<td width="111" height="18" bgcolor="#CEE7FF" align="center">文字<br>大小</td>
<td width="111" height="18" bgcolor="#CEE7FF" align="center">文字<br>样式</td>
<td width="111" height="18" bgcolor="#CEE7FF" align="center">文字<br>颜色</td>
<td width="111" height="18" bgcolor="#CEE7FF" align="center" >可改</td>
<td width="111" height="18" bgcolor="#CEE7FF" align="center" >class</td>
<td width="111" height="18" bgcolor="#CEE7FF" align="center" >元素<br>输出</td>
<td width="200" height="17" colspan="4" align="center" bgcolor="#CEE7FF" >
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#86C2FF" width="100%" id="AutoNumber16" height="100%">
<tr>
<td width="100%" colspan="4" height="16">
<p align="center">边线</td>
</tr>
<tr>
<td width="25%" height="20">左</td>
<td width="25%" height="20">右</td>
<td width="25%" height="20">上</td>
<td width="25%" height="20">下</td>
</tr>
</table>
</td>
<td width="111" height="18" bgcolor="#CEE7FF" align="center" >输出格式</td>
<td width="111" height="18" bgcolor="#CEE7FF" align="center" >输出<br>样式</td>
</tr>
<tr>
<td width="6" height="12" ><input type='hidden' name='T00' size='15' value="">
</td>
<td width="111" height="12" ><!--编号--><input type='text' name='T02' size='8' >
</td>
<td width="126" height="12" ><!--类型--><select size="1" name='T03' style="width:60"><option>基本标签</option></select>
</td>
<td width="111" height="12" ><!--内容--><input type='text' name='T04' size='22' >
</td>
<td width="124" height="12" ><!--属性--><select size="1" name="T05" style="width:50" ><option value="1" >标签签</option></select>
</td>
<td width="76" height="12" ><!--跨行--><input type='text' name='T06' size='2' >
</td>
<td width="76" height="12" ><!--跨列--><input type='text' name='T07' size='2' >
</td>
<td width="38" height="12" ><!--行结束--><input type="checkbox" name="T08" value="1" >
</td>
<td width="54" height="12" ><!--对齐--><select size="1" name="T09" style="width:50"><option value="center" >居中</option></select>
</td>
<td width="76" height="12" ><!--宽度--><input type='text' name='T10' size='4' >
</td>
<td width="111" height="12" ><!--高度--><input type='text' name='T11' size='4' >
</td>
<td width="111" height="12" ><!--字体--><input type='text' name='T12' size='4' >
</td>
<td width="111" height="12" ><!--字体大小--><input type='text' name='T13' size='4' >
</td>
<td width="111" height="12" ><!--文字样式--><input type='text' name='T14' size='4' >
</td>
<td width="111" height="12" ><!--文字颜色--><input type='text' name='T15' size='4' >
</td>
<td width="111" height="12" ><!--可修改项--><input type='checkbox' name='T16' value='1' >
</td>
<td width="111" height="12" ><!--边线--><input type='text' name='T18' size='4'>
</td>
<td width="111" height="12" ><!--元素输出值--><input type='text' name='T19' size='4' >
</td>
<td width="80" height="12" ><!--左边线--><input type="checkbox" name="T20" value="1" >
</td>
<td width="40" height="12" ><!--右边线--><input type="checkbox" name="T21" value="1" >
</td>
<td width="39" height="12" ><!--上边线--><input type="checkbox" name="T22" value="1" >
</td>
<td width="41" height="12" ><!--下边线--><input type="checkbox" name="T23" value="1" >
</td>
<td width="41" height="12" ><!--元素输出格式-->
<select size='1' name='T24' style="width:60"><option value=''>请选择</option><option value="7">日期转换</option></select>
</td>
<td width="111" height="12" ><!--边线--><input type='text' name='T18' size='4'>
</tr>
</table>
</form>
</body>
</html>
<%
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){}
}
%>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?