📄 login.jsp

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

💻 JSP

字号:

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