📄 login.jsp
字号:
<%@ page import="java.sql.Connection, java.sql.Statement, java.sql.ResultSet, com.connectBean"%> <%-- User: qing Date: 2005-6-30 Time: 14:06:41--%><%@ page contentType="text/html;charset=gb2312" language="java" %><jsp:useBean id="myCon" class="com.connectBean" scope="page"/><html> <head><title>login</title></head> <body> <% //get the information from other page String name = request.getParameter("username"); String pw = request.getParameter("password"); Connection con = connectBean.getconnect(); Statement statement=con.createStatement(); String isCorrect="select * from UserTable where username='" + name + "' and password='" + pw + "'"; ResultSet result=statement.executeQuery(isCorrect); session.setAttribute("isLog",new String("0")); if(!result.next())//说明查询结果为空 { result.close(); statement.close(); con.close(); response.sendRedirect("newuser.jsp"); } //如果查询后有记录，说明登录验证成功。 else { //保存登录信息到session对象中。 session.setAttribute("username",result.getString("username"));//用户名称 session.setAttribute("type",result.getString("type")); System.out.println(session.getAttribute("type")); session.setAttribute("isLog",new String("1")); //关闭数据库连接相关的资源。 statement.close(); con.close(); String type = (String)session.getAttribute("type"); if(type.trim().equals("admin")) response.sendRedirect("admin.jsp"); else response.sendRedirect("show.jsp"); } %> </body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -