📄 ch5-2.jsp
字号:
<html>
<head>
<title>登录</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<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("mima"));
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:ch5";
Connection con=DriverManager.getConnection(url,"","");
Statement st=con.createStatement();
String strSql="select * from user where 姓名='"+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=ch5-1.htm>去注册</a>");
return;}
else if(!mima.equals(rs.getString("密码")))
{out.print("<h2>密码不正确，请从新填写！</h2>");
out.println("<a href=ch5-2.htm>返回登录</a>");
return;}
else
request.getSession(true);
session.putValue("name",name);
session.putValue("mima",mima);
rs.close();
st.close();
response.sendRedirect("main.jsp");
%>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -