WebRoot/admin/baoxiuQuery.jsp

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page language="java"  pageEncoding="gb2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="connDbBean" scope="page" class="db.db"/>
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>学科信息</title><LINK href="CSS.css" type=text/css 
rel=stylesheet>
    

  </head>

  <body >
  <p>所有已维修的报修信息：</p>
    <form name="form1" id="form1" method="post" action="">
设备名称：
     <input name="wupinName" type="text" id="wupinName" />
报修人姓名：
     <input name="xingming" type="text" id="xingming" />
     <input type="submit" name="Submit" value="查找" />
</form>
<table width="100%" border="1" align="center" cellpadding="3" cellspacing="1" bordercolor="00FFFF" style="border-collapse:collapse">  
  <tr>
    <td width="50" align="center" bgcolor="CCFFFF">序号</td>
    <td width="70" bgcolor='#CCFFFF'>设备名称</td>
    <td width="300" align="center" bgcolor="CCFFFF">故障原因</td>
     <td width="120" align="center" bgcolor="CCFFFF">报修时间</td>
      <td width="70" align="center" bgcolor="CCFFFF">报修人</td>
 <td width="70" align="center" bgcolor="CCFFFF">所在部门</td>
   <td width="70" align="center" bgcolor="CCFFFF">维修人</td>
    <td width="70" align="center" bgcolor="CCFFFF">维修时间</td>
  </tr>
  <%
  String sql="";
  sql="select a.*,b.xingming,bumen,c.xingming as weixiu from baoxiu a left join yuangong b on a.baoxiuren=b.bianhao left join weixiugong c on a.weixiuren=c.bianhao where a.Flag='已维修' ";
   if(request.getParameter("wupinName")=="" ||request.getParameter("wupinName")==null )
  {}
  else
  {
  	sql=sql+" and wupinName like '%"+new String(request.getParameter("wupinName").getBytes("8859_1"))+"%'";
  }
    if(request.getParameter("xingming")=="" ||request.getParameter("xingming")==null )
  {}
  else
  {
  	sql=sql+" and b.xingming like '%"+new String(request.getParameter("xingming").getBytes("8859_1"))+"%'";
  }
 
 ResultSet RS_result=connDbBean.executeQuery(sql);
 String id="";
 String wupinName="";
 String yuanyin="";
  String shijian="";
 String Flag="";