select_exp.jsp

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

<%@page contentType="text/html;charset=GBK"%>
<%@page import="java.sql.*"%>
 <%!String stu_id;%>
 <%stu_id=(String)session.getAttribute("student");%>
 <%
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
try{
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException ce){
  out.println(ce.getMessage());
}
try{
 request.setCharacterEncoding("gbk");
 
 String id=request.getParameter("id");
 
  conn=DriverManager.getConnection("jdbc:odbc:libwm");
  stmt=conn.createStatement();
  String h="select 选择实验编号 from student where 选择实验编号!='0'and 学生编号='"+stu_id+"' ";
  rs=stmt.executeQuery(h);
  if(rs.next()){
  out.print("你已经选过题了！");
  }else{
  
  String sql="update student set 选择实验编号='"+id+"'  where 学生编号='"+stu_id+"'  ";
       
  
  stmt.executeUpdate(sql);
  }
}catch(SQLException e){
  out.println(e.getMessage());  
}

finally{
  stmt.close();
  conn.close();
}
%>