📄 chklogin.jsp.htm
字号:
<html>
<head>
<title>登陆验证</title>
</head>
<%@page import="java.util.*, java.sql.*" contentType="text/html;charset=GB2312" %>
<body>
<%
boolean success=false; //是否能够登陆
String strname=new String(request.getParameter("name").getBytes("ISO8859_1"),"GBK");
String strpsw=new String(request.getParameter("psw").getBytes("ISO8859_1"),"GBK");
int rankid=0;
//加载数据库驱动并用连接池连结数据库
String sql="";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{
out.print(e);
}
String strDirPath=application.getRealPath(request.getRequestURI());
strDirPath=strDirPath.substring(0,strDirPath.lastIndexOf('\\'))+"\\";
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+strDirPath+"forum.mdb";
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
sql="select * from User where UserName='"+strname+"' and Password='"+strpsw+"'";
ResultSet rs =stmt.executeQuery(sql);
if (rs.next()){
success=true;
rankid=rs.getInt("Rank");
}else{
success=false;
}
//释放数据库连结
//根据登陆结果判断
if (success){
session.setAttribute("username",strname);
response.sendRedirect("listboard.jsp?rankid="+String.valueOf(rankid));
}
else{%>
<h3>用户名或密码有误，请重新登录！</h3>
<%}%>
<a href="javascript:history.back();">返回</a>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -