WebRoot/weixiu/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>


<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='已维修' ";
 ResultSet RS_result=connDbBean.executeQuery(sql);
 String id="";
 String wupinName="";
 String yuanyin="";
  String shijian="";
 String Flag="";
   String xingming="";
 String bumen="";
 
  String weixiu="";
 String weixiushijian="";
 
 int i=0;
 
 
 
 
 
 while(RS_result.next()){
 i=i+1;
 id=RS_result.getString("id");
wupinName=RS_result.getString("wupinName");
 yuanyin=RS_result.getString("yuanyin");
 shijian=RS_result.getString("shijian");