test.jsp

来自「新生注册系统,用JSP和WEB数据库表写的系统,可以进行删除,添加,管理等操作.」· JSP 代码 · 共 59 行

JSP
59
字号

<html>
<head>
<meta http-equiv="content-type" content="text/html;charset=gb2312">
<title>验证登录</title>
</head>

<%@ page language = "java" import = "java.sql.*" %>

 <% 
    
    
	    
   
  try
  {
       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   }catch(ClassNotFoundException ce){
   
       out.print(ce);
   }
      
	   
 try {	 
      
	   request.setCharacterEncoding("gb2312");
       String number = request.getParameter("number");
       Connection con=DriverManager.getConnection("jdbc:odbc:stu","","");
	    String mysql="select stuNum='"+number+"' from stu ";
        
       Statement s=con.createStatement();
	   
       ResultSet rs = s.executeQuery(mysql);
       
      if(rs.next()){
           
           session.putValue("stuNum",number); 
           response.sendRedirect("chaxun.jsp"); 
      
     }else
       {
           out.println("登陆失败,请确认你是否已进行注册!");
           session.putValue("stuNum","");
        }
		s.close();
		rs.close();
        con.close();
  }
  catch (SQLException ce)
  {
     out.println(ce);
   //e.printStackTrace();
  }
 %>
   
</div> 

</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?