用户登录页面
login.jsp
<html>
<head>
<title>登录页面</title>
<%--引入css文件和js文件--%>
<link rel="stylesheet" href="css/bootstrap.css">
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.js"></script>
<script src="js/bootstrap.bundle.js"></script>
<style>
.container{
width: 20%;
height: 20%;
margin-top: 10%;
}
</style>
</head>
<body>
<div class="container">
<div class="row clearfix">
<div class="col-md-12 column">
<form role="form" method="post" action="user?method=addUser">
<h3 style="text-align: center">登录</h3>
<div class="form-group">
<label for="exampleInputEmail1">用户名:</label><input type="text" name="username" class="form-control" id="exampleInputEmail1" />
</div>
<div class="form-group">
<label for="exampleInputPassword1">密码:</label><input type="password" name="password" class="form-control" id="exampleInputPassword1" />
</div>
<button type="submit" style="width: 100%" class="btn btn-info">提交</button>
</form>
</div>
</div>
</div>
</body>
</html>
登陆成功后进入个人主页
home.jsp
<%
//加载数据库驱动
Class.forName("com.mysql.jdbc.Driver");
//建立数据库连接
String url="jdbc:mysql://localhost:3306/stuinfo";
Connection connection= DriverManager.getConnection(url,"root","root");
String sql ="select * from user";
PreparedStatement pstm =connection.prepareStatement(sql);
ResultSet rs=pstm.executeQuery();
%>
<div class="container">
<div class="row clearfix">
<div class="col-md-12 column">
<h3 style="text-align: center">欢迎来到个人主页</h3>
<a class="btn" id="modal-198502" role="button" href="#modal-container-198502" data-toggle="modal">添加用户</a>
<table class="table">
<thead>
<th>ID</th>
<th>用户名</th>
<th>性别</th>
<th>年龄</th>
</thead>
<tbody>
<%
while(rs.next()){
out.print("<tr>");
out.print(
"<td>"+rs.getString("id")
+"</td><td>"+rs.getString("username")
+"</td><td>"+rs.getString("gender")
+"</td><td>"+rs.getString("age")
+"</td>"
+"<td><a href='delete.jsp?id="+rs.getString("id")+"'>删除</a>"
+" <a href='edit.jsp?id="+rs.getString("id")+"'>修改</a>"+
"</td>"
);
out.print("</tr>");
}
%>
</tbody>
</table>
</div>
</div>
</div>
<div class="modal fade" id="modal-container-198502" role="dialog" aria-hidden="true" aria-labelledby="myModalLabel">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button class="close" aria-hidden="true" type="button" data-dismiss="modal">×</button>
<h4 class="modal-title" id="myModalLabel">
标题
</h4>
<button type="button" class="close" data-dismiss="modal" aria-hidden="true"></button>
</div>
<form method="post" action="add.jsp">
<div class="modal-body">
<div class="form-group">
<label>用户名:</label><input type="text" name="username" class="form-control" />
</div>
<div class="form-group">
<label>密码:</label><input type="text" name="password" class="form-control" />
</div>
<div class="form-group">
<label>性别:</label><input type="text" name="gender" class="form-control" />
</div>
<div class="form-group">
<label>年龄:</label><input type="text" name="age" class="form-control" />
</div>
</div>
<div class="modal-footer">
<button class="btn btn-default" type="button" data-dismiss="modal">关闭</button>
<button class="btn btn-primary" type="submit">提交</button>
</div>
</form>
</div>
</div>
</div>
</body>
</html>
LoginController.java
package com.media.controller;
import com.media.bean.UserBean;
import com.media.util.DBUtil;
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 javax.servlet.http.HttpSession;
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
/**
* Servlet 注解配置信息
*/
@WebServlet(name = "LoginServlet",value = "/login")
public class LoginController<JSONObject> extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request,response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
System.out.println("servlet 请求");
request.setCharacterEncoding("utf-8");
BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(request.getInputStream(),"utf-8"));
String line = null;
StringBuilder stringBuilder = new StringBuilder();
while ((line = bufferedReader.readLine())!=null){
stringBuilder.append(line);
}
JSONObject jsonObject = JSONObject.parseObject(stringBuilder.toString());
String username = jsonObject.getString("username");
HttpSession session = request.getSession();
if("1".equals(request.getParameter("invalidate")) && session.getAttribute("username") != null){
session.invalidate();
//session.removeAttribute("username");
response.sendRedirect("login.jsp");
}
try {
Connection connection = DBUtil.getConnection();
//sql 模板
String sql = "select * from user where username = ?";
//使用PreparedStatement对象执行sql语句
PreparedStatement ps = connection.prepareStatement(sql);
ps.setString(1,username);
ResultSet rs = ps.executeQuery();
response.setContentType("application/json;charset=UTF-8");
PrintWriter out = response.getWriter();
UserBean user = new UserBean();
if(rs.next()){
user.setUsername(rs.getString("username"));
user.setPassword(rs.getString("password"));
//表示登录成功
session.setAttribute("username",username);
//response.sendRedirect("home.jsp");
}else{
//表示登录未成功
out.print("登录失败,3秒之后跳转登录页面...");
response.setHeader("refresh","3;url=login.jsp");
}
DBUtil.close(connection,ps,rs);
JSONObject json = new JSONObject();
json.put("user",user);
json.put("message","登录成功");
out.write(json.toJSONString());
out.flush();
}catch (Exception e){
e.printStackTrace();
}
}
}
UserController.java
package com.media.controller;
import com.media.bean.UserBean;
import com.media.service.UserService;
import com.media.service.impl.UserServiceImpl;
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 java.io.IOException;
import java.sql.SQLException;
@WebServlet("/user")
public class UserController extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request,response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String method = request.getParameter("method");
UserBean userBean = new UserBean();
userBean.setUsername(request.getParameter("username"));
userBean.setPassword(request.getParameter("password"));
UserService userService = new UserServiceImpl();
if("addUser".equals(method)){
try {
int count = userService.addUser(userBean);
if(count == 0){
response.sendRedirect("");
}else{
response.sendRedirect("home.jsp");
}
}catch (SQLException e){
e.printStackTrace();
}
}
if("editUser".equals(method)){
userBean.setId(Integer.parseInt(request.getParameter("id")));
userService.editUser(userBean);
}
if("deleteUser".equals(method)){
userService.deleteUserById(Integer.parseInt(request.getParameter("id")));
}
}
}
接口UserDao
public interface UserDao {
UserBean getUserById(int id);
UserBean getUserByName(String username);
List<UserBean> getUserList(UserBean user);
int addUser(UserBean user) throws SQLException;
int editUser(UserBean user);
int deleteUserById(int id);
}
UserDaolmpl,java
public class UserDaoImpl implements UserDao {
@Override
public UserBean getUserById(int id) {
UserBean userBean = new UserBean();
try{
Connection connection = DBUtil.getConnection();
String sql = "select * from user where id = ?";
PreparedStatement ps = connection.prepareStatement(sql);
ps.setInt(1,id);
ResultSet rs = ps.executeQuery();
if(rs.next()){
userBean.setId(rs.getInt("id"));
userBean.setUsername(rs.getString("username"));
userBean.setPassword(rs.getString("password"));
userBean.setGender(rs.getInt("gender"));
userBean.setAge(rs.getInt("age"));
userBean.setStatus(rs.getInt("status"));
}
}catch (SQLException e){
e.printStackTrace();
}
return userBean;
}
@Override
public UserBean getUserByName(String username) {
UserBean userBean = new UserBean();
try{
Connection connection = DBUtil.getConnection();
String sql = "select * from user where username = ?";
PreparedStatement ps = connection.prepareStatement(sql);
ps.setString(1,username);
ResultSet rs = ps.executeQuery();
if(rs.next()){
userBean.setUsername(rs.getString("username"));
userBean.setPassword(rs.getString("password"));
userBean.setGender(rs.getInt("gender"));
userBean.setAge(rs.getInt("age"));
userBean.setStatus(rs.getInt("status"));
userBean.setId(rs.getInt("id"));
}
}catch (SQLException e){
e.printStackTrace();
}
return userBean;
}
@Override
public List<UserBean> getUserList(UserBean user) {
List<UserBean> userList = new ArrayList<>();
UserBean userBean = null;
try{
Connection connection = DBUtil.getConnection();
String sql = "select * from user where username like ?";
PreparedStatement ps = connection.prepareStatement(sql);
ps.setString(1,user.getUsername());
ResultSet rs = ps.executeQuery();
while (rs.next()){
userBean = new UserBean();
userBean.setUsername(rs.getString("username"));
userBean.setPassword(rs.getString("password"));
userBean.setGender(rs.getInt("gender"));
userBean.setAge(rs.getInt("age"));
userBean.setId(rs.getInt("id"));
userBean.setStatus(rs.getInt("status"));
userList.add(userBean);
}
}catch (SQLException e){
e.printStackTrace();
}
return userList;
}
@Override
public int addUser(UserBean user) throws SQLException {
Connection connection = DBUtil.getConnection();
String sql = "inert into user (username,password,age,gender,status) values (?,?,?,?,?)";
PreparedStatement ps = connection.prepareStatement(sql);
ps.setString(1,user.getUsername());
ps.setString(2,user.getPassword());
ps.setInt(3,user.getAge());
ps.setInt(4,user.getGender());
ps.setInt(5,user.getStatus());
int count = ps.executeUpdate();
DBUtil.close(connection,ps,null);
return count;
}
@Override
public int editUser(UserBean user) {
return 0;
}
@Override
public int deleteUserById(int id) {
return 0;
}
}
接口UserService
public interface UserService {
UserBean getUserById(int id);
UserBean getUserByName(String username);
List<UserBean> getUserList();
int addUser(UserBean user) throws SQLException;
int editUser(UserBean user);
int deleteUserById(int id);
}
监听器
UserCountListener.java
package com.listener;
import javax.servlet.ServletContext;
import javax.servlet.ServletContextEvent;
import javax.servlet.ServletContextListener;
import javax.servlet.annotation.WebListener;
import javax.servlet.http.*;
@WebListener
public class UserCountListener implements ServletContextListener,HttpSessionListener,HttpSessionAttributeListener {
@Override
public void sessionCreated(HttpSessionEvent se) {
ServletContext application = se.getSession().getServletContext();
int userCount = (int)application.getAttribute("userCount");
userCount++;
application.setAttribute("userCount",userCount);
System.out.println("用户登录,系统当前在线人数:"+userCount);
}
@Override
public void sessionDestroyed(HttpSessionEvent se) {
ServletContext application = se.getSession().getServletContext();
int userCount = (int)application.getAttribute("userCount");
if(userCount != 0){
userCount--;
}else{
userCount = 0;
}
application.setAttribute("userCount",userCount);
System.out.println("用户注销,系统当前在线人数:"+userCount);
}
@Override
public void contextInitialized(ServletContextEvent sce) {
ServletContext application = sce.getServletContext();
application.setAttribute("userCount",0);
}
@Override
public void contextDestroyed(ServletContextEvent sce) {
}
@Override
public void attributeAdded(HttpSessionBindingEvent se) {
System.out.println("session添加属性");
}
@Override
public void attributeRemoved(HttpSessionBindingEvent se) {
}
@Override
public void attributeReplaced(HttpSessionBindingEvent se) {
}
}
过滤器
package com.filter;
import javax.servlet.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
public class CharsetFilter implements Filter {
public void destroy() {
}
public void doFilter(ServletRequest req, ServletResponse resp, FilterChain chain) throws ServletException, IOException {
HttpServletRequest request = (HttpServletRequest) req;
HttpServletResponse response = (HttpServletResponse)resp;
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=UTF-8");
chain.doFilter(request, response);
}
public void init(FilterConfig config) throws ServletException {
}
}
LoginFilter.java
package com.filter;
import javax.servlet.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
public class LoginFilter implements Filter {
String[] ignores;
public void doFilter(ServletRequest req, ServletResponse resp, FilterChain chain) throws ServletException, IOException {
HttpServletRequest request = (HttpServletRequest) req;
HttpServletResponse response = (HttpServletResponse)resp;
HttpSession session = request.getSession();
String uri = request.getRequestURI();
if(session.getAttribute("username") != null || isIgnore(uri)){
chain.doFilter(request, response);//过滤链
}else{
response.sendRedirect("login.jsp");
}
}
private boolean isIgnore(String uri){
for (String str:ignores) {
if(uri.indexOf(str) != -1){
return true;
}
}
return false;
}
public void init(FilterConfig config) throws ServletException {
String ignore = config.getInitParameter("ignore");
ignores = ignore.split(",");
}
}
UserServicelmpl.java
public class UserServiceImpl implements UserService {
@Override
public UserBean getUserById(int id) {
return null;
}
@Override
public UserBean getUserByName(String username) {
return null;
}
@Override
public List<UserBean> getUserList() {
return null;
}
@Override
public int addUser(UserBean user) throws SQLException {
//业务层 负责业务数据处理
UserDao userDao = new UserDaoImpl();
return userDao.addUser(user);
}
@Override
public int editUser(UserBean user) {
return 0;
}
@Override
public int deleteUserById(int id) {
return 0;
}
}
DBUtil.java
package com.media.util;
import java.sql.*;
public class DBUtil {
public static Connection getConnection(){
Connection connection = null;
try {
//加载数据库驱动
Class.forName("com.mysql.jdbc.Driver");
//建立数据库连接
String url = "jdbc:mysql://localhost:3306/book";
connection = DriverManager.getConnection(url,"root","root");
}catch (Exception e){
e.printStackTrace();
}
return connection;
}
public static void close(Connection connection, PreparedStatement ps, ResultSet rs){
//关闭数据库连接
if(rs != null){
try{
rs.close();
}catch (SQLException e){
e.printStackTrace();
}
}
if(ps != null){
try {
ps.close();
}catch (SQLException e){
e.printStackTrace();
}
}
if(connection != null){
try {
connection.close();
}catch (SQLException e){
e.printStackTrace();
}
}
}
}