Java Web登录页面，重要题和自己想出的代码，用户表和用户类型表，导航栏【诗书画唱】
3、创建一个用户表user和用户类型表userType（项目中的角色和权限问题）
user:id,act,pwd,tid
userType:tid,tname
创建登录页面login.jsp，登录成功后将act和tid保存在session中
登录成功后跳转到manage.jsp页面，页面中有一个导航栏，有如下选项：
管理所有用户
个人中心
购物车
要求当用户类型是超级管理员时，能够显示出导航栏中的所有选项
当用户类型是其他时，只显示个人中心和购物车
create table user(
id int primary key auto_increment,
act varchar(100) ,
pwd varchar(100) ,
tid int
);
create table userType(
tid int primary key auto_increment,
tname varchar(100)
);
insert into User(act ,pwd ,tid ) values ("诗书画唱1","666",1),
("诗书画唱2","888",2);
insert into userType(tname) values ("超级管理员"),("其他");
--drop table User
--select * from User
--select * from userType
select * from User inner join userType on User.tid= userType.tid
package bean;
public class User {
private Integer id;
private String act;
private String pwd;
private Integer tid;
private String tname;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getAct() {
return act;
}
public void setAct(String act) {
this.act = act;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
public Integer getTid() {
return tid;
}
public void setTid(Integer tid) {
this.tid = tid;
}
public String getTname() {
return tname;
}
public void setTname(String tname) {
this.tname = tname;
}
}
package controller;
import bean.User;
import DAO.Dao;
import java.io.IOException;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import bean.User;
import DAO.Dao;
@WebServlet("/UFirstPageServletStart")
public class FirstPageServletStart extends HttpServlet {
private static final long serialVersionUID = 1L;
public FirstPageServletStart() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request,
* HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException {
// TODO Auto-generated method stub
this.doPost(request, response);
}
protected void doPost(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException {
String act = request.getParameter("act");
String pwd = request.getParameter("pwd");
System.out.println(act);
//2、查询数据库
Dao userDao = new Dao();
User u = userDao.selectByActAndPwd(act, pwd);
//3、根据查询出来的结果进行处理
if(u.getId() != null && u.getId() > 0) {
//将登录的账号存放到session
//后面当你跳转到任何的页面时，还需要验证是否是合法的访问
request.getSession().setAttribute("userName", act);
//a、根据账号和密码能够查询记录，就表示登录成功，跳转到后台管理页面
StringBuilder html = new StringBuilder();
if("超级管理员".equals(u.getTname())){
html.append(" <ul><li><a href='#'>管理所有用户</a></li><li>"
+ "<a href='#'>个人中心</a></li><li>"
+ "<a href='#'>购物车</a></li></ul>");
}
else if("其他".equals(u.getTname())){
html.append(" <ul><li><a href='#'>个人中心</a></li>"
+ "<li><a href='#'>购物车</a></li></ul>");
}
System.out.println(html);
request.setAttribute("html",html);
request.getRequestDispatcher("firstPage.jsp").forward(request, response);
} else {
String msg = "账号或者密码错误";
request.setAttribute("msg", msg);
//b、没有查询到记录，就表示登录失败，跳转回login.jsp
request.getRequestDispatcher("login.jsp")
.forward(request, response);
}
}
}
package DAO;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import utils.DBUtils;
import bean.User;
public class Dao {
public User selectByActAndPwd
(String act,String pwd){
String sql = "select * from user u inner"
+ " join userType ut on u.tid=ut.tid"
+ " where act = ? and pwd = ?";
Connection conn = null;
PreparedStatement pstm = null;
ResultSet rs = null;
User u = new User();
List<User>list = new ArrayList<User>();
try {
conn = DBUtils.getConn();
pstm = conn.prepareStatement(sql);
//设置占位符
pstm.setString(1, act);
pstm.setString(2, pwd);
rs = pstm.executeQuery();
if(rs.next()) {
Integer id = rs.getInt("id");
Integer tid= rs.getInt("tid");
String tname= rs.getString("tname");
u.setId(id);
u.setAct(act);
u.setPwd(pwd);
u.setTid(tid);
u.setTname(tname);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
//清理资源
DBUtils.close(rs, pstm, conn);
}
return u;
}
}
package Filter;
import java.io.IOException;
import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.annotation.WebFilter;
@WebFilter("/*")
public class CodeFilter implements Filter {
public CodeFilter() {
// TODO Auto-generated constructor stub
}
public void destroy() {
// TODO Auto-generated method stub
}
public void doFilter(ServletRequest request,
ServletResponse response, FilterChain chain)
throws IOException, ServletException {
// TODO Auto-generated method stub
// place your code here
request.setCharacterEncoding("utf-8");
chain.doFilter(request, response);
}
public void init(FilterConfig fConfig) throws ServletException {
// TODO Auto-generated method stub
}
}
package utils;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Properties;
public class DBUtils {
private static String driverName;
private static String url;
private static String userName;
private static String pwd;
//静态块，随着类加载而运行的
static{
//读取db.properties文件中的内容：
Properties prop = new Properties();
InputStream is = DBUtils.class.getClassLoader()
.getResourceAsStream("db.properties");
try {
prop.load(is);
driverName = prop.getProperty("dn");
url = prop.getProperty("url");
userName = prop.getProperty("un");
pwd = prop.getProperty("up");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static Connection getConn(){
Connection conn = null;
try {
Class.forName(driverName);
conn = DriverManager.getConnection(url,userName,pwd);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
public static void close(ResultSet rs,
PreparedStatement pstm
,Connection conn){
try {
if(rs != null) {
rs.close();
}
if(pstm != null) {
pstm.close();
}
if(conn != null) {
conn.close();
}
} catch(Exception e) {
e.printStackTrace();
}
}
}
dn=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/firstjsp?useUnicode=true&characterEncoding=UTF-8
un=root
up=root
<%@page import="bean.User"%>
<%@page import="DAO.Dao"%>
<%@ page language="java" contentType="text/html;
charset=UTF-8" pageEncoding="UTF-8"%>
<%
//中文乱码处理
request.setCharacterEncoding("utf-8");
//1、获取用户输入的账号和密码
String act = request.getParameter("act");
String pwd = request.getParameter("pwd");
System.out.println(act);
//2、查询数据库
Dao userDao = new Dao();
User u = userDao.selectByActAndPwd(act, pwd);
//3、根据查询出来的结果进行处理
if(u.getId() != null && u.getId() > 0) {
//将登录的账号存放到session
//后面当你跳转到任何的页面时，还需要验证是否是合法的访问
request.getSession().setAttribute("userName", act);
//a、根据账号和密码能够查询记录，就表示登录成功，跳转到后台管理页面
request.getRequestDispatcher("firstPage.jsp")
.forward(request, response);
} else {
String msg = "账号或者密码错误";
request.setAttribute("msg", msg);
//b、没有查询到记录，就表示登录失败，跳转回login.jsp
request.getRequestDispatcher("login.jsp")
.forward(request, response);
}
%>
<%@ page language="java" contentType="text/html;
charset=UTF-8" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()
+"://"+request.getServerName()
+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base hreff="<%=basePath%>">
<title></title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content=
"keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<style>
ul
{
list-style-type:none;
margin:0;
padding:0;
overflow:hidden;
background-color:black;
}
li
{
float:left;
padding:50px;
}
a
{
display:block;
text-decoration: none;
}
</style>
</head>
<body>
${html }
</body>
</html>
<%@ page language="java" contentType="text/html;
charset=UTF-8" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+
"://"+request.getServerName()
+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base hreff="<%=basePath%>">
<title></title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<style type="text/css">
*{
font-size:50px;
}
</style>
</head>
<body>
<form action="UFirstPageServletStart" method="post">
<table border="1">
<tr>
<td>账号：</td>
<td><input type="text" name="act" value="${userName }"
placeholder="请输入账号"/></td>
</tr>
<tr>
<td>密码：</td>
<td><input type="password" name="pwd" /></td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" value="提交" />
</td>
</tr>
</table>
<div>${msg }</div>
</form>
</body>
</html>
