📄 admin.jsp
字号:
<html>
<head>
<title>登录-读取Session</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFCC">
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<% String name=new String(request.getParameter("name"));
String mima=new String(request.getParameter("password"));
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:ch5";
Connection con=DriverManager.getConnection(url,"","");
Statement st=con.createStatement();
String strSql="select * from admin where name='"+name+"'";
ResultSet rs=st.executeQuery(strSql);
if (name.equals("")||mima.equals(""))
{out.print("请输入完整的信息!!");
return;}
else if(!rs.next())
{ out.print("<h2>没有此管理员,你不能登录!</h2>");
out.println("<a href=ch5main.htm>返回</a>");
return;}
else if(!mima.equals(rs.getString("password")))
{out.print("<h2>密码不正确,请从新填写!</h2>");
out.println("<a href=admin.htm>返回管理员登录</a>");
return;}
else
request.getSession(true);
session.putValue("name",name);
session.putValue("pass",mima);
session.putValue("ad","admin");
rs.close();
st.close();
response.sendRedirect("ch5-71.htm");
%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -