gz_cx_mh.jsp

来自「JSP页面和oracle9i数据库的源代码」· JSP 代码 · 共 329 行 · 第 1/2 页

JSP
329 行
字号
12
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>模糊查询</title>
<style>
<!--
a {text-decoration: none}
.f1          { font-size: 9pt; font-family: Verdana; line-height: 15pt }
.f2          { font-size: 8pt; font-family: Verdana; line-height: 12pt }
body {
	background-image: url(../img/adminbg.gif);
}
input.noborInput{background:#ffffff; border-bottom-width:0px;border-top-width:0px;border-left-width:0px;border-right-width:0px; solid #ff6633; COLOR: #3300FF; FONT-SIZE: 10pt}
input.smallInput{BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid}
input.buttonface{BACKGROUND: #CCCCFF; border:1 solid #CC33FF; COLOR: #CC00FF; FONT-SIZE: 9pt; FONT-STYLE: normal; FONT-VARIANT: normal; FONT-WEIGHT: normal; HEIGHT: 18px; LINE-HEIGHT: normal}
.style1 {
	font-family: Verdana;
	color: #3333FF;
}
-->
</style>
</head>
<body>
<jsp:useBean id="conn" scope="page" class="beans3.conn"/>
<%
String page_type=(String)session.getAttribute("page_type");
String page_name=(String)session.getAttribute("page_name");
if(page_type==null){page_type="";}
if(session.isNew()){response.sendRedirect("../index.jsp");}
else
{	if(!(page_type.equals("super")) && !page_type.equals("sgz"))
	{response.sendRedirect("../index.jsp");}	
}
%>
<%	ResultSet rs=null;
   int flag=0;
   String condition="select * from BGZDH.BM";
	rs=conn.executeQuery(condition);
	
%>
<div align="center">
<form name="form" method="post" action="gz_cx_mh.jsp?flag=1">
   <table width="425" height="160" border="0" align="center" cellpadding="0" cellspacing="0" class="f1">
     <tr>
       <td height="30" colspan="3"><div align="center" class="style1">模糊查询（可多选）</div></td>
      </tr>
     <tr>
       <td width="89">
          <div align="right">
            <input type="checkbox" name="bmcheck" value="bm">
         </div></td><td width="152" height="30"><div align="right">请选择职工所在部门&nbsp;</div></td>
       <td width="184"><select name="bm">
         <option value="">部门表</option>
		 <%while(rs.next())
		   {%>
		 <option value=<%=rs.getString("BM")%>><%=rs.getString("BM")%></option>
          <%}%>
       </select></td>
     </tr>
     <tr>
       <td>
          <div align="right">
            <input type="checkbox" name="bhcheck" value="bh">
         </div></td><td height="30"><div align="right">请输入职工号前几位&nbsp;</div></td>
       <td><input name="bh" type="text" class="smallInput" size="8" maxlength="2"></td>
     </tr>
     <tr>
       <td>
          <div align="right">
            <input type="checkbox" name="xmcheck" value="xm">
         </div></td><td height="30"><div align="right">请输入职工姓氏&nbsp;</div></td>
       <td><input name="xm" type="text" class="smallInput" size="8" maxlength="2">          
        </td>
     </tr>
     <tr>
       <td height="40" colspan="3">
          <div align="center">
            <input name="Submit" type="submit" class="buttonface" value="提交">
            &nbsp;&nbsp;
            <input name="reset" type="reset" class="buttonface" value="重置">
			&nbsp;&nbsp;
            <input name="back" type="button" class="buttonface" onClick="location.href='../index/gz_index.jsp';" value="退出"></div></td>
      </tr>
   </table>
</form>
<% String sp=null;
if (request.getParameter("flag")==null) {}
  else{
  String check1=request.getParameter("bmcheck");
  String check2=request.getParameter("bhcheck");
  String check3=request.getParameter("xmcheck");
  int a[]=new int[3];
  sp="select * from BGZDH.BZGZ";

 String bm=conn.toChinese(request.getParameter("bm"));
 String bh=conn.toChinese(request.getParameter("bh"));
 String xm=conn.toChinese(request.getParameter("xm"));
 if(check1==null)
  {}
 else
  { if(bm==null){}
  else{sp=sp+" where BM like '"+bm+"%'"; 
     a[0]=1; }
  }
if(check2==null||bh==null)
  {}
 else
  { a[1]=1;
    if(a[0]==1)
	 {sp=sp+" and BH LIKE '"+bh+"%'";}
	else
	 {sp=sp+" where BH LIKE '"+bh+"%'";}
  }
  
 if(check3==null||xm==null)
  {}
 else
  { a[2]=1;
    if(a[0]==1||a[1]==1)
	   {sp=sp+" and XM LIKE '"+xm+"%'";
	   }
	     else
	    {sp=sp+" where XM LIKE '"+xm+"%'";
		}  
  }
if(check1==null && check2==null && check3==null)
  {out.print("<p class=f1>请选择查询条件！</p>");} 
   sp=sp+" order by BH"; 
  
   int all=0,pagecount=1,pageall=0,i=0;
   String pageNO=request.getParameter("pageNO");
   if(pageNO==null){pageNO="1";}
   int pageNO_c=Integer.parseInt(pageNO);
   rs=conn.executeQuery(sp);
   while(rs.next())
	{all++;}
	if(all>0)
	{	out.print("<div align=center class=f1>共找到"+all+"条记录</div>");
	if(all<=pagecount){pageall=1;}
	else
	{	int lastcount=0;
		lastcount=all%pagecount;
		if(lastcount==0){pageall=all/pagecount;}
		else{pageall=all/pagecount+1;}
	 }
%>
<%if(pageall>1){%>	
<table width="254" border="0" class="f1">
   <tr>
    <td width="248">
	<form action="gz_cx_mh.jsp?bmcheck=<%=check1%>&bhcheck=<%=check2%>&xmcheck=<%=check3%>&bm=<%=bm%>&bh=<%=bh%>&xm=<%=xm%>&flag=1" method="post">
     <div align="center" class=f1>
        跳转到
      <select name="pageNO">
      <%for(i=1;i<=pageall;i++){%>
       <option value="<%=i%>">第<%=i%>页</option>
      <%}%>
      </select>  
      <input name="确定" type="submit" class="buttonface" value="确定">
      <input name="bm" type="hidden" id="sp" value="">
     </div>
	</form>
	</td>
12

gz_cx_mh.jsp - 源码说明

本页面展示了「JSP页面和oracle9i数据库的源代码」中的 gz_cx_mh.jsp 源码文件，采用 JSP 编程语言编写，共 329 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与oracle9i相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?