📄 querybiaodashiindex.jsp
字号:
<%@ page contentType="text/html; charset=GBK"%>
<%@ page language="java"%>
<%@ page import="java.util.*"%>
<%@ page import="com.gs.control.event.*"%>
<%@ page import="com.gs.util.*"%>
<%
String nextPageType=(String)request.getAttribute("type");
//字段列表
ArrayList queryFieldList = GetCodingTable.getCodingQueryFieldList();
String htmlSelectQueryFieldList = GetCodingTable.getHtmlSelect(queryFieldList);
ArrayList orerator = GetCodingTable.getCodingOrerator();
String htmlSelectOrerator = GetCodingTable.getHtmlSelect(orerator);
%>
<html>
<head>
<title>表达式查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="<%=request.getContextPath()%>/include/style/style01/style.css" rel="stylesheet" type="text/css">
<script language="javascript1.2" src="<%=request.getContextPath()%>/include/js/function.js"></script>
<script language="javascript1.2" src="<%=request.getContextPath()%>/include/js/querybiaodashi.js"></script>
</head>
<body class="businessBody01" >
<center>
<form name="form" method="POST" action="<%=request.getContextPath()%>/pageBuilderAction.do?action=<%=PageBuilderEvent.query_biaodashi%>&nextAction=<%=PageBuilderEvent.query_biaodashiIndex%>&nextPageType=<%=nextPageType%>">
<input type="hidden" name="aa" value="biaodashi">
<input type="hidden" name="hstrsql_basis1" value="">
<input type="hidden" name="hstrsql_basis2" value="">
<input type="hidden" name="hbasisorsub" value="basis">
<!--
<input type="hidden" name="hstrsql_basis_sub" value="">
<input type="hidden" name="strsql_basis_sub" value="">
-->
<table border="0" width="90%">
<tr>
<td><img src="<%=request.getContextPath()%>/images/bg3.gif" border="0" > <font class="textBusinessTitle">表达式查询</font></td>
</tr>
<br>
<table border="1" width="640" class="businessTable00">
<tr>
<td class="formTd01">字段列表</td>
<td class="formTd01">条件</td>
<td class="formTd01">请输入：</td>
<td class="formTd01">请输入：</td>
<td class="formTd01"></td>
</tr>
<tr>
<td class="formTd01Left">
<select style="POSITION: relative" size="1" name="fieldlist_basis" class="textWarnInputPrompt">
<%=htmlSelectQueryFieldList%>
</select>
</td>
<td class="formTd01Left">
<select style="POSITION: relative" size="1" name="orerator_basis" class="textWarnInputPrompt" onchange="youxiao(1);">
<%=htmlSelectOrerator%>
</select>
</td>
<td class="businessTd01"><input type="text" name="fieldvalue_basis1" size="16" disabled><IMG alt="" id=IMG1 src="<%=request.getContextPath()%>/images/datetime.gif" title=点击这儿输入日期 style="cursor:hand" LANGUAGE=javascript onclick="return showDateDialog(fieldvalue_basis1)" disabled></td>
<td class="businessTd01"><input type="text" name="fieldvalue_basis2" size="16" disabled><IMG alt="" id=IMG2 src="<%=request.getContextPath()%>/images/datetime.gif" title=点击这儿输入日期 style="cursor:hand" LANGUAGE=javascript onclick="return showDateDialog(fieldvalue_basis2)" disabled></td>
<td class="businessTd01">
<!--<input type="button" value="添 加" name="B1" class="button" onmouseover="this.className='mouseover'" onmouseout="this.className='button'" onclick="tianjia_basis(1);"> <input type="button" value="清 除" name="B8" class="button" onclick="qingchu(1);"><br>(将条件填加到<font class="textWarnPrompt">查询条件</font>框)</td> -->
</tr>
<tr>
<td class="formTd01">步骤一：<br><font class="textWarnPrompt">查询条件</font></td>
<td class="formTd01Left" colspan="3" ><textarea cols="60" rows="5" name="strsql_basis1" value="" readonly></textarea><br>
<input type="radio" name="r1" checked >并且
<input type="radio" name="r1" >或者
</td>
<td class="businessTd01" ><input type="button" value="添 加" name="B2" class="button" onmouseover="this.className='mouseover'" onmouseout="this.className='button'" onclick="tianjia_basis(1);check(1);"> <input type="button" value="清 除" name="B8" class="button" onclick="qingchu(2);"><br>(将查询条件填加到<font class="textWarnPrompt">查询条件</font>框)</td>
</tr>
<tr>
<td class="formTd01">步骤二：<br><font class="textWarnPrompt">条件组合</font></td>
<td class="formTd01Left" colspan="3" ><textarea cols="60" rows="5" name="strsql_basis2" value="" readonly></textarea><br>
<input type="radio" name="r2" checked >并且
<input type="radio" name="r2" >或者
</td>
<td class="businessTd01" ><input type="button" value="添 加" name="B3" class="button" onmouseover="this.className='mouseover'" onmouseout="this.className='button'" onclick="tianjia_basis(2);check(2);"> <input type="button" value="清 除" name="B8" class="button" onclick="qingchu(3);"><br>(将查询条件填加到<font class="textWarnPrompt">条件组合</font>框)</td>
</tr>
</table>
<input type="submit" value=" 查 询 " name="B7" class="button" disabled>
<input type="reset" value=" 全 部 清 除 " name="B8" class="button" onClick="qingchu(3);">
<br><br>
<table border="1" width="640" class="businessTable00">
<tr>
<td class="businessTd02"><font class="textWarnPrompt">说明：</font>只有完成步骤一和步骤二以后查询按钮才可用。</td>
</tr>
<tr>
<td class="businessTd02"><font class="textWarnPrompt">步骤一：</font>将字段条件添加到"查询条件"框中，可以按"并且"、"或者"的关系添加多个条件，组成若干字段条件的组合，但条件间不带"（）"</td>
</tr>
<tr>
<td class="businessTd02"><font class="textWarnPrompt">步骤二：</font>将步骤一的条件视为一组条件，每组条件都是用"（）"括起来的，然后将其添加到"条件组合"框中，可以按"并且"、"或者"的关系添加多组条件，这时查询按钮生效。</td>
</tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -