passcheck.jsp

来自「实验室教学管理系统还能为实验室评估提供原始资料和基本数据」· JSP 代码 · 共 42 行

<%@ page contentType="text/html; charset=gbk" language="java" import="java.sql.*" errorPage="" %>
<%
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 sql="update experiments set 开放状态='1' where 实验编号='"+id+"' ";
  stmt.executeUpdate(sql);
  response.sendRedirect("exppass.jsp");
  
}catch(SQLException e){
  out.println(e.getMessage());  
}

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