📄 login_conf.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<head>
<title>jsp数据库留言板-登陆页面</title>
</head>
<body>
<center>
<h1>留言管理范例-jsp+jdbc实现</h1>
<hr>
<br>
<%!
//声明变量
String DBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String DBurl = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=notes";
String DBuser = "sa";
String DBpassword = "sa";
Connection conn = null;
PreparedStatement prestmt = null;
ResultSet rs = null;
String sql = "select name from person where id=? and password=?";
%>
<%
//声明一个boolean变量，用于保存用户是否合法的状态
boolean flag = false;
//接受参数
String id = request.getParameter("id");
String password = request.getParameter("password");
%>
<%
try
{
Class.forName(DBDriver);
conn = DriverManager.getConnection(DBurl,DBuser,DBpassword);
prestmt = conn.prepareStatement(sql);
prestmt.setString(1,id);
prestmt.setString(2,password);
rs = prestmt.executeQuery();
if(rs.next())
{
//用户合法
flag = true;
//将用户保存在session之中
session.setAttribute("uname",rs.getString(1));
}
else
{
//保存错误的信息
request.setAttribute("err","错误的用户名及密码");
}
}
catch (ClassNotFoundException e)
{
out.println("驱动找不着");
e.printStackTrace();
}
catch (SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
if(prestmt != null)
{
prestmt.close();
prestmt = null;
}
if(conn != null)
{
conn.close();
conn = null;
}
}
catch (SQLException e)
{
e.printStackTrace();
}
}
%>
<%
if(flag)
{
// 用户合法
%>
<jsp:forward page="login_success.jsp"/>
<%
}
else
{
//用户非法
%>
<jsp:forward page="login.jsp"/>
<%
}
%>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -