📄 pass.jsp~1~
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>验证用户身份</title></head><body><jsp:useBean id="dbconn" class="org.DBConnection" scope="page"></jsp:useBean><%Connection conn=dbconn.getConnection();//连接数据库Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);String user_name=request.getParameter("user_name");//获取user_name参数String password=request.getParameter("password");//获取password参数String sql="select * from users where user_name='"+user_name+"' and password='"+password+"'";//查询users表中是否有符合条件的记录ResultSet rs=stmt.executeQuery(sql);/*判断查询结果集是否为空*/int i=0;while(rs.next()){i++;}/*如果不为空，将用户名保存到session变量user中，并转向浏览图片页面browse.jsp*/if(i!=0){ session.setAttribute("user",user_name); response.sendRedirect("browse.jsp");}else /*否则转向错误页面error.jsp*/response.sendRedirect("error.jsp");rs.close();stmt.close();conn.close();%></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -