view_expinfo.jsp

实验室教学管理系统还能为实验室评估提供原始资料和基本数据

<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<%!String filename;%>
<%
Connection conn = null;
Statement stmt = null;
ResultSet rs,rs1 = null;

	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

String str = request.getParameter("id");
//if (str == null) str = "1";

	conn=DriverManager.getConnection("jdbc:odbc:libwm");
	stmt=conn.createStatement();
	//String str="SELECT * FROM subject WHERE 编号='"+str+"'";
	rs=stmt.executeQuery("SELECT * FROM experiments WHERE 实验编号='"+str+"'");
%>
	<table width="70%" height="60%" align="center" border="1" cellpadding="0" cellspacing="0">
<%   if(rs.next())
	{  
	   String name=rs.getString("实验名称");
	   String teacher_no=rs.getString("指导教师编号");
	   String jieshao=rs.getString("实验介绍");
	   String strSQL="SELECT 文档名称 FROM  instruction WHERE 实验编号='"+str+"'";
	   //out.print(strSQL);
	   rs1=stmt.executeQuery(strSQL);
	   while(rs1.next()) filename=rs1.getString("文档名称");

%>
      <tr>
          <td width="20%" class="STYLE11">实验名称:</td>
          <td width="200" height="12%"><span class="STYLE11"><%=name%></span></td>
      </tr>
      <tr>
          <td class="STYLE11">指导教师编号：</td>
          <td width="80%" height="55"><span class="STYLE11"><%=teacher_no%></span></td>
      </tr>
       <tr>
           <td class="STYLE11">实验介绍：</td>
           <td width="274" height="55"><span class="STYLE11"><%=jieshao%></span></td>
       </tr>
        <tr>
            <td height="56" class="STYLE11">附 件：</td>
            <td><a href="download.jsp?fileName=<%=filename%>"><%=filename%></a></td>
      </tr>
<%
     }
%>
</table>


</td>
        
      </tr>
    </table>     </td>
  </tr>