📄 deallogin.jsp

📁 j2ee实现简单的bbs功能

💻 JSP

字号:

<%@ page language="java" import="java.sql.*"%>
<%@ page contentType="text/html;charset=gb2312"%>
<jsp:useBean id = "dBean" scope="session" class="BeanLink.DBBean"/>
<html>
<head>
<title>注册</title>
</head>
<body>
<center>
<%
String sdriver="sun.jdbc.odbc.JdbcOdbcDriver";
String sconn="jdbc:odbc:mydb";
String suser="";
String spass="";
String tablename="user";

String username = request.getParameter("username");
username = new String(username.getBytes("8859_1"));
String password = request.getParameter("mypass");
String email = request.getParameter("email");
String sql = "select * from "+ tablename+" where username='"+username+"' and password='"+password+"'"; //sql语句
System.out.println(sql);
dBean.openConn(sdriver,sconn,suser,spass);
ResultSet rs = dBean.executeQuery(sql);
if(rs.next())
{
	if(rs.getInt("purview")==0)
	{
		session.putValue("username",username);
		session.putValue("email",email);
		session.putValue("loginSign","ADMINOK");
	}
	else
	{
		session.putValue("loginErrMsg","对不起,您无此管理权限!");
	}
	if(rs!=null)
		rs.close();
	dBean.closeConn();
	response.sendRedirect("../index.jsp");
}
else
{
	session.putValue("loginErrMsg","用户名或密码有误,请重新登录!");
	if(rs!=null)
		rs.close();
	dBean.closeConn();
	response.sendRedirect("login.jsp");
}
%>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -