📄 login.jsp.bak

📁 可以让初学者有一个感性的认识

💻 BAK

字号:

<HTML>
<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*" %>

<BODY bgcolor=pink><Font size=3>
<P>成绩输入人员登录
<FORM action="login.jsp" method=post>
<BR>输入帐号：
<BR><INPUT type="text" name="account">
<BR>输入密码：
<BR><INPUT type="password" name="secret">
<BR><INPUT type="submit" value="提交" name="g">
</ FORM >

<%		String account=request.getParameter("account");
		if(account==null) account ="";
byte b[]=account.getBytes("ISO-8859-1");
account =new String(b);

		String secret=request.getParameter("secret");
		if(secret==null) secret ="";
byte c[]=secret.getBytes("ISO-8859-1");
secret=new String(c);

Connection con=null;
		Statement sql=null;
		ResultSet rs=null;
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}catch(ClassNotFoundException e){}
		try
		{
	con=DriverManager.getConnection("jdbc:odbc:manage","","");
			sql=con.createStatement();
			String condition="SELECT * FROM verify WHERE 帐号="+"'"+account+"'";
			rs=sql.executeQuery(condition);
			while(rs.next())
			{
				String	n=rs.getString("帐号");
				String	s=rs.getString("密码");
				if(account.equals(n)&&secret.equals(s))
				{
					session.setAttribute("account",account);
					session.setAttribute("secret",secret);
			String s1=response.encodeRedirectURL("inputMessage.jsp");
			String s2=response.encodeRedirectURL("inputResult.jsp");
					response.sendRedirect(s1);
				}
			}
			if(!(session.isNew()))
				out.print("<BR>您输入的帐号和密码不正确"+account+":"+secret);
		}catch(SQLException e1){}
%>

<BR><A href="main.jsp">返回主页</A>
</FONT>
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -