login.jsp.bak
来自「这套JSP学习资料」· BAK 代码 · 共 60 行
BAK
60 行
<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 + =
减小字号Ctrl + -
显示快捷键?