res_check.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 sql="SELECT * FROM result";
	rs=stmt.executeQuery(sql);
	
%>
	<table width="70%" height="60%" align="center" border="1" cellpadding="0" cellspacing="0">
<%   if(rs.next())
	{  
	   String filename=rs.getString("文档名称");
	   String name=rs.getString("学生编号");
	   //String teacher_no=rs.getString("指导教师编号");
	   
%>
      <tr>
          <td width="20%" class="STYLE11">学生编号:</td>
          <td width="200" height="12%"><span class="STYLE11"><%=name%></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>