exp_apply1.jsp

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

<%@ page contentType="text/html; charset=gbk" language="java" import="java.sql.*" errorPage="" %>
<%!String strapp_tea_id,exp;%>
 <%strapp_tea_id=(String)session.getAttribute("teacher");%>
%>
<%
   Connection conn=null;
   Statement stmt=null;
   ResultSet rs=null;
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   request.setCharacterEncoding("gbk");
  String strapp_exp_name=request.getParameter("app_exp_name");
  String strapp_exp_id=request.getParameter("app_exp_id");
  String strapp_exp_text=request.getParameter("textfield");
  out.print(strapp_exp_name);
  conn=DriverManager.getConnection("jdbc:odbc:libwm");
  stmt=conn.createStatement();
  String s="select * from experiments where 实验编号='"+strapp_exp_id+"'";
  out.print(s);
  rs=stmt.executeQuery(s);
 if(rs.next()){
 out.print("<a href=exp_apply.jsp>此实验已存在，请返回重新添加！</a>");
  }
  else{ 

 String sql="insert into experiments (实验编号,实验名称,指导教师编号,实验介绍) values ('"+strapp_exp_id+"','"+strapp_exp_name+"','"+strapp_tea_id+"','"+strapp_exp_text+"')";
 out.print(sql);
       
    
	  stmt.executeUpdate(sql); 
	  String sql3="insert into instruction (实验编号) values ('"+strapp_exp_id+"')";
	  stmt.executeUpdate(sql3);
	  session.setAttribute("exp",strapp_exp_id);
	  out.print(exp);
      response.sendRedirect("upload.jsp");
  }
%>