📄 check.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="gbk"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="sqltest" class="database.sqlbean" scope="page">
</jsp:useBean>
<html>
<head>
<title>认证码验证页面</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<META HTTP-EQUIV="Cache-Control" CONTENT="no-cache">
<META HTTP-EQUIV="Expires" CONTENT="0">
</head>
<body>
<%
String rand =(String)session.getAttribute("random");
String input =(String)session.getAttribute("input");
String user_name=(String)session.getAttribute("user_name");
String pass_word= (String)session.getAttribute("pass_word");
%>
<% int id;
String permit;
ResultSet rs=null;
String SqlString="select * from managerinfo where userName='"+user_name+"'and password='"+pass_word+"'";
try
{
//设置连接
sqltest.setConnection("org.gjt.mm.mysql.Driver",
"jdbc:mysql://localhost:3306/cliniquemanager",
"root","root");
//设置SQL语句
sqltest.setQuerystatement(SqlString);
//得到查询结果
rs=sqltest.getResult();
if (rs.next())
{
//out.print("登录成功");
//获得用户的权限
permit=rs.getString("remark");
if (permit.equals("1"))
{
// out.println(":你的权限是管理员组");
// id=rs.getInt("id");
// session.setAttribute("id",id);
%>
<jsp:forward page="login.do?method=managerLogin"/>
<%
}
else
{ response.setContentType("text/html;charset=gbk");
request.setCharacterEncoding("gbk");
out.println("<div align='center'>"+user_name+"<font color='red'>,<br>你的权限不够。<br>系统将在3秒后返回，请重新登录。</font><div>");
response.setHeader("refresh","3;URL=login.jsp" );
}
}
else
{
out.print("<div align='center'><font color='red'>登录失败,用户名或密码错。<br>系统将在3秒后返回，请重新登录。</font><div>");
response.setHeader("refresh","3;URL=login.jsp" );
}
}
catch(SQLException e1)
{
out.print("SQL异常！");
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -