📄 checkregister.jsp

📁 教务管理系统,能够实现大部分学校教务工作的内容.

💻 JSP

字号:


<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page contentType="text/html; charset=GBK" language="java"
	import="java.sql.*" errorPage=""%>
<%!boolean flage=true;%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    
  </head>
  
  <body>
<%
	Connection con;
	Statement statement;
	ResultSet rs;	
    String name=request.getParameter("name");
    String password=request.getParameter("password");   
    try
            {Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }
            catch(Exception e){out.print(e.getMessage());}
            try
            {String  url="jdbc:odbc:linbaowei";  
			String user="sa";
			String pas="linbaowei";//useUnicode=true&characterEncoding=gb2312"; 
            con = DriverManager.getConnection(url,user,pas); 
            statement =con.createStatement(); 
            String sql="select * from zhuce"; 
            rs = statement.executeQuery(sql);
            while(rs.next())
            { 
            out.print(rs.getString(1));
            out.print(rs.getString(2));
            try{
            if((name.equals(rs.getString(1))))
            {
            flage=true;
            break;
            }}catch(Exception qqqq){out.print(qqqq);}
            }  
            if(flage)
            {%>
            <jsp:forward page='IndexTrue.jsp'>
            <jsp:param name='zhuce' value='<%=name%>'/>
            </jsp:forward>            
           <%}
            rs.close(); 
            statement.close(); 
            con.close(); 
            }
            catch(Exception w){out.print(w.getMessage());}
            out.print("<br><br><br><font><a href=FirstIndex.jsp target=_self>返回</a></font>");
%>
  </body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -