?? 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 + -