tea_login.jsp

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

<%@ page contentType="text/html; charset=gbk"%>
<%@ page import="java.sql.*"%>
<%
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 user="";
 String password="";
 user=request.getParameter("tea_id");
 password=request.getParameter("tea_password");
 
out.print(user);
out.print(password);
  conn=DriverManager.getConnection("jdbc:odbc:libwm");
  stmt=conn.createStatement();
  String sd="select *from teacher where 教师编号='"+user+"' and 密码='"+password+"'" ;
  
  rs=stmt.executeQuery(sd);
  out.print("<br>");
     if(rs.next()){
	   out.println("登录成功");
	   out.print("<br>");
	   String t=rs.getString("教师编号");
	   response.sendRedirect("tea_manage.jsp");
	   	   session.setAttribute("teacher",t);
	   
	 }else{
	   response.sendRedirect("erron.htm");
	 }
  
}catch(SQLException e){
  out.println(e.getMessage());  
}

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