<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="errorPage.html" %> <%@ page import="java.util.*" %> <%@ page import="data.*,com.jspsmart.upload.*" %> <%@ page import="java.sql.*" %> CAD CG <% Conn conn=new Conn(); //String sql = "select * from news order by shijian desc"; ResultSet rs1=null; ResultSet rs2=null; ResultSet rs3=null; ResultSet rs4=null; ResultSet rs5=null; ResultSet rs6=null; int i=0; String title=null; String address=null; String content=null; String shijian=null; String id=null; String field=null; // System.out.println("22"); %>

实验室管理

管理人员
<% rs1=conn.executeQuery("SELECT * FROM manage where com_position=5"); if(rs1==null) throw new Exception("database exception"); if(rs1.next()){ %> <%} rs1.close(); rs2=conn.executeQuery("SELECT * FROM manage where com_position=3"); if(rs2==null) throw new Exception("database exception"); if(rs2.next()){ %> <% rs2.close();} rs3=conn.executeQuery("SELECT * FROM manage where com_position=4"); if(rs3==null) throw new Exception("database exception"); if(rs3.next()){ %> <% rs3.close();} rs4=conn.executeQuery("SELECT * FROM manage where com_position=6"); if(rs4==null) throw new Exception("database exception"); if(rs4.next()){ %> <% if(rs4.next()){ %> <% } if(rs4.next()){ %> <% } }rs4.close(); %>
办公室主任: <%=rs1.getString("com_name") %>
设备管理: <%=rs2.getString("com_name") %>
科研管理: <%=rs3.getString("com_name") %>
机房管理: <%=rs4.getString("com_name") %><%=rs4.getString("com_name") %><%=rs4.getString("com_name") %>

规章制度

<% rs5=conn.executeQuery("SELECT * FROM rules order by shijian desc"); if(rs5==null) throw new Exception("database exception"); while(rs5.next()) { title=rs5.getString("title"); //System.out.println(title); shijian=rs5.getString("shijian"); address=rs5.getString("address"); id=rs5.getString("ID"); %>

·<%=title %>>[查看详细]

<% } rs5.close();%>
文档下载
<% rs6=conn.executeQuery("SELECT * FROM doc order by shijian desc"); if(rs6==null) throw new Exception("database exception"); i=0; while(rs6.next()) { title=rs6.getString("title"); //System.out.println(title); shijian=rs6.getString("shijian"); address=rs6.getString("address"); id=rs6.getString("ID"); // System.out.println(address); %>

·<%=title %> > [点击下载表格]

<% } rs6.close(); conn.close(); %>