📄 login.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY bgcolor=pink>
<CENTER>
<p>管理员登录
<FORM action="" method=post>
<BR>输入账号
<BR><Input type="text" name="username">
<BR>输入密码
<BR><Input type=password name="password">
<BR><Input type="submit" value="提交">
</FORM>
<%
String account=request.getParameter("username");
if(account==null){account="";}
byte a[] = account.getBytes("ISO-8859-1");
account=new String(a);
String secret=request.getParameter("password");
if(secret==null){secret="";}
byte s[] = secret.getBytes("ISO-8859-1");
secret=new String(s);
Connection con;
Statement sql;
ResultSet rs;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:login","","");
sql=con.createStatement();
String condition="SELECT * FROM login WHERE user="+"'"+account+"'";
rs=sql.executeQuery(condition);
while(rs.next())
{
String z = rs.getString("user");
String m = rs.getString("password");
if(secret.equals(m)&&account.equals(z))
{
%>
<jsp:forward page="ad.jsp" >
<jsp:param name="" value="" />
</jsp:forward >
<%
}
else if(!(account.equals(z))&&secret.equals(m))
{
%>
<jsp:forward page="error.jsp" >
<jsp:param name="" value="" />
</jsp:forward >
<%
}
else
{
%>
<jsp:forward page="error.jsp" >
<jsp:param name="" value="" />
</jsp:forward >
<%
}
}
%>
<BR><A HREF="myindex.jsp">返回主页</A>
</CENTER>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -