<style type="text/css">
<!--
.STYLE1 {
font-size: medium;
font-weight: bold;
}
.STYLE3 {color: #339966}
.STYLE5 {
color: #0000FF;
font-family: "幼圆";
}
.STYLE6 {
color: #990033;
font-weight: bold;
font-style: italic;
}
-->
</style>
<br>
<br>
<div align="center"><span class="STYLE1"><blink><span class="STYLE5">合同查询页面</span></blink></span></div>
<br>
<br>
<br>
<br>
<table>
<form action="checkcontra.jsp" method=get name="form1">
<tr>
<td>
<b><span class="STYLE3">协议号</span>:</b> </td>
<td><select name="agreeno" size=1 >
<option value="" selected></option>
<%
//打开数据库读出协议号
ResultSet rs=stmt.executeQuery("select DISTINCT Agreeno from Contract_Tab order by Agreeno");
while(rs.next())
{
%>
<option value="<%=rs.getString("AgreeNo")%>" selected><%=rs.getString("AgreeNo")%></option>
<%
}
%>
</select> <span class="STYLE6">and</span></td></tr><tr><td><b><span class="STYLE3">飞机型号</span>:</b> </td>
<td><select name="planetype" size=1 >
<option value="" selected></option>
<%
//打开数据库读出协议号
ResultSet rs1=stmt.executeQuery("select DISTINCT PlaneType from Contract_Tab order by PlaneType");
while(rs1.next())
{
%>
<option value="<%=rs1.getString("PlaneType")%>" selected><%=rs1.getString("PlaneType")%></option>
<%
}
%>
</select> <span class="STYLE6">and </span></td>
</tr>
<tr><td><b><span class="STYLE3">飞机型号</span>:</b>
<td><select name="company" size=1 >
<option value="" selected></option>
<%
//打开数据库读出协议号
ResultSet rs3=stmt.executeQuery("select DISTINCT Company from Contract_Tab order by Company");
while(rs3.next())
{
%>
<option><%=rs3.getString("Company")%></option>
<%
}
%>
</select> </td></tr><td>
<input type="submit" name="submit" value="查询"></td>
</form>
</tr>
</table>
************************************************************
以上是我的查询界面,有情趣的话可以用dreamweaver看看,不知道怎么实现。因为查询情况太多,希望大家帮帮忙
一定散分
<!--
.STYLE1 {
font-size: medium;
font-weight: bold;
}
.STYLE3 {color: #339966}
.STYLE5 {
color: #0000FF;
font-family: "幼圆";
}
.STYLE6 {
color: #990033;
font-weight: bold;
font-style: italic;
}
-->
</style>
<br>
<br>
<div align="center"><span class="STYLE1"><blink><span class="STYLE5">合同查询页面</span></blink></span></div>
<br>
<br>
<br>
<br>
<table>
<form action="checkcontra.jsp" method=get name="form1">
<tr>
<td>
<b><span class="STYLE3">协议号</span>:</b> </td>
<td><select name="agreeno" size=1 >
<option value="" selected></option>
<%
//打开数据库读出协议号
ResultSet rs=stmt.executeQuery("select DISTINCT Agreeno from Contract_Tab order by Agreeno");
while(rs.next())
{
%>
<option value="<%=rs.getString("AgreeNo")%>" selected><%=rs.getString("AgreeNo")%></option>
<%
}
%>
</select> <span class="STYLE6">and</span></td></tr><tr><td><b><span class="STYLE3">飞机型号</span>:</b> </td>
<td><select name="planetype" size=1 >
<option value="" selected></option>
<%
//打开数据库读出协议号
ResultSet rs1=stmt.executeQuery("select DISTINCT PlaneType from Contract_Tab order by PlaneType");
while(rs1.next())
{
%>
<option value="<%=rs1.getString("PlaneType")%>" selected><%=rs1.getString("PlaneType")%></option>
<%
}
%>
</select> <span class="STYLE6">and </span></td>
</tr>
<tr><td><b><span class="STYLE3">飞机型号</span>:</b>
<td><select name="company" size=1 >
<option value="" selected></option>
<%
//打开数据库读出协议号
ResultSet rs3=stmt.executeQuery("select DISTINCT Company from Contract_Tab order by Company");
while(rs3.next())
{
%>
<option><%=rs3.getString("Company")%></option>
<%
}
%>
</select> </td></tr><td>
<input type="submit" name="submit" value="查询"></td>
</form>
</tr>
</table>
************************************************************
以上是我的查询界面,有情趣的话可以用dreamweaver看看,不知道怎么实现。因为查询情况太多,希望大家帮帮忙
一定散分
解决方案 »
- 如何实现GIS,菜鸟弱弱的问
- 不知道高手能不能解决这样一个问题?
- FCKeditor工具栏不显示
- 在线,急!!!下拉筐
- 如何将sql语句封装到bean中,返回记录集?
- ps.executeUpdate();出错了!在上传图片时
- Tomcat4.1环境下运行servlet的疑问
- 用jspsmartupload上传文件,在表单中还有其他几个文本框,用一Servlet处理,上传文件正常,但其他几个文本框的值始终为null,请看里面的具体描
- 怎样在JAVABEAN中得到APPLICATION变量,要传什么参数?
- axis2-1.5 通讯设置代理服务器问题
- 搞了一个下午终于利用JNI成功获取了硬盘信息(型号,序列号,容量...) 开心,散分!!!
- 大哥!我把自己tomcat的webapps下一个应用拷贝到另台电脑的webapps下怎么出现异常运行不了呀!!
我想通过and查询,通过三个条件查询,三个选择框默认值为空 这样一共有很多种查询情况,比较复杂,因此我不知道怎么不表达 郁闷,不知道大家有没有懂我的意思
String noContract = request.getParameter("协议号");
String noPlane = request.getParameter("飞机型号");
String noCompany = request.getParameter("公司名称");StringBuffer sqlTmp = new StringBuffer();
sqlTmp.append("select col_1,col_2,...,col_n from tableName where 1=1");
if(noContract != null && !noContract.equals("")){
sqlTmp.append(" and 协议号='");
sqlTmp.append(noContract);
sqlTmp.append("'");
}
if(noPlane != null && !noPlane.equals("")){
sqlTmp.append(" and 飞机型号='");
sqlTmp.append(noPlane);
sqlTmp.append("'");
}
if(noCompany != null && !noCompany.equals("")){
sqlTmp.append(" and 公司名称='");
sqlTmp.append(noCompany);
sqlTmp.append("'");
}String sql = sqlTmp.toString();
sql=select * from table where fieldname like '%a% 'and fieldname like '%b%'
当为空时就不限定条件
newxy技术范例:http://www.newxy.net/zh_cn/samples/index.jsp
newxy技术网站:http://www.newxy.net
newxy技术文档:http://www.newxy.net/doc.htm
rs=stmt.executeQuery(sql); 也不行一定要设三个么?rs1,rs2,rs3 还有如果我不rs.close();有什么影响么?谢谢大家~~ 回答完就结贴