📄 test.jsp

📁 新生注册系统,用JSP和WEB数据库表写的系统,可以进行删除,添加,管理等操作.

💻 JSP

字号:


<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 + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -