一、项目介绍

本项目是基于JavaWeb工程的用户管理系统，编写的目的在于更好的学习JavaWeb，博客最后附上项目的地址，欢迎大家下载。

二、项目功能介绍

1、登陆页面

使用了bootstrap.css来优化页面，使用session来存储用户的账号和密码

2、注册页面

与登陆页面相似，也使用了bootstrap.css，注册成功替换原先的cookie值

3、用户信息列表页面

从数据库中获取数据，并显示在页面中，并实现了分页加载技术

@WebServlet(urlPatterns = "/pageQueryServlet")
public class PageQueryServlet extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request, response);
    }

    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String strPageNum = request.getParameter("pageNum");
        String strPageSize = request.getParameter("pageSize");
        UserService userService = new UserService();
        //当前页的页数
        int pageNum = Integer.parseInt(strPageNum);
        //每页显示的个数
        int pageSize = Integer.parseInt(strPageSize);
        //每页的起始条目索引
        int startCount = (pageNum - 1) * pageSize;
        List<User> pageUsers = userService.pageQuery(startCount, pageSize);

        int totalItemCount = userService.queryTotalItemCount(pageSize);
        int totalPageCount;
        //计算总页数
        if (totalItemCount % pageSize == 0) {
            totalPageCount = totalItemCount % pageSize;
        } else {
            totalPageCount = totalItemCount / pageSize + 1;
        }

        if (pageUsers != null) {
            //查询成功
            request.setAttribute("pageUsers", pageUsers);
            request.setAttribute("pageNum", pageNum);
            request.setAttribute("pageSize", pageSize);
            request.setAttribute("totalPageCount", totalPageCount);
            request.setAttribute("totalItemCount", totalItemCount);
            request.getRequestDispatcher("/list.jsp").forward(request, response);
        }
    }
}

4、修改联系人页面

实现了数据的回显功能，但是没有做数据的校验，可以使用jQuery Validate的进行表单校验来优化项目

数据回显代码：

@WebServlet(urlPatterns = "/queryUserByIdServlet")
public class QueryUserByIdServlet extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request, response);
    }

    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //处理修改用户信息之前的查询操作
        request.setCharacterEncoding("utf-8");
        String id = request.getParameter("id");
        //根据ID获取用户信息
        UserService userService = new UserService();
        User userInfo = userService.queryUserById(id);
        String pageNum = request.getParameter("pageNum");
        String pageSize = request.getParameter("pageSize");
        if (userInfo != null) {
            //查询成功
            request.setAttribute("user", userInfo);
            request.setAttribute("pageNum", pageNum);
            request.setAttribute("pageSize", pageSize);
            request.getRequestDispatcher("/update.jsp").forward(request, response);
        } else {
            request.setAttribute("errorMsg", "查询用户信息失败！");
            request.getRequestDispatcher("/error.jsp").forward(request, response);
        }
    }
}

修改数据代码：

@WebServlet(urlPatterns = "/updateUserByIdServlet")
public class UpdateUserByIdServlet extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request, response);
    }

    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        //获取数据
        String id = request.getParameter("id");
        String name = request.getParameter("name");
        String sex = request.getParameter("sex");
        String age = request.getParameter("age");
        String address = request.getParameter("address");
        String qq = request.getParameter("qq");
        String email = request.getParameter("email");
        String pageNum = request.getParameter("pageNum");
        String pageSize = request.getParameter("pageSize");
        //处理数据
        User user = new User(Integer.parseInt(id), name, sex, Integer.parseInt(age), address, qq, email);
        UserService userService = new UserService();
        boolean isUpdate = userService.updateUserById(user);
        if (isUpdate) {
            //修改成功，查询所有用户信息
            response.sendRedirect("/pageQueryServlet?pageNum=" + pageNum + "&pageSize=" + pageSize);
        } else {
            //修改失败
            request.setAttribute("errorMsg", "修改用户信息失败");
            request.getRequestDispatcher("/error.jsp").forward(request, response);
        }
    }
}

5、删除用户功能

@WebServlet(urlPatterns = "/deleteUserByIdServlet")
public class DeleteUserByIdServlet extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request, response);
    }

    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //设置编码格式
        request.setCharacterEncoding("utf-8");
        String pageNum = request.getParameter("pageNum");
        String pageSize = request.getParameter("pageSize");
        //获取数据
        String id = request.getParameter("id");
        //处理数据
        UserService userService = new UserService();
        boolean isDelete = userService.deleteUserById(id);
        if (isDelete) {
            //删除成功，需要查询所有用户信息
            response.sendRedirect("/pageQueryServlet?pageNum=" + pageNum + "&pageSize=" + pageSize);
        } else {
            //删除失败，跳到错误页面
            request.setAttribute("errorMsg", "删除用户信息失败");
            request.getRequestDispatcher("/error.jsp").forward(request, response);
        }
    }
}

6、添加用户页面

和修改联系人页面一样，没有做表单校验。

提交代码：

@WebServlet(urlPatterns = "/addUserServlet")
public class AddUserServlet extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request, response);
    }

    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        //获取数据
        String name = request.getParameter("name");
        String sex = request.getParameter("sex");
        String age = request.getParameter("age");
        String address = request.getParameter("address");
        String qq = request.getParameter("qq");
        String email = request.getParameter("email");
        String pageNum = request.getParameter("pageNum");
        String pageSize = request.getParameter("pageSize");
        //处理数据
        User user = new User(null, name, sex, Integer.parseInt(age), address, qq, email);
        UserService userService = new UserService();
        boolean isAdd = userService.addUser(user);
        if (isAdd) {
            //添加成功，需要查询所有用户信息
            response.sendRedirect("/pageQueryServlet?pageNum=" + pageNum + "&pageSize=" + pageSize);
        } else {
            //添加失败，跳转失败页面
            request.setAttribute("errorMsg", "添加用户信息失败！");
            request.getRequestDispatcher("/error.jsp").forward(request, response);
        }
    }
}

项目地址：https://github.com/demon-gu/user-manager

用户管理系统

• 1.注册新用户
  如果注册用户已经存在,则报错
  需要填写信息: name, passwd, gender, email,age
• 2.用户登录 要求同之前写的用户登录系统
• 3.注销用户 用户注销时,需要输入用户名和正确的用户密码
• 4.显示用户信息 显示系统中存在所有已经注册用户的信息
• 5.退出系统

代码如下

#!/usr/bin/env python
#coding:utf-8

info = """
************************************************************
                       用户登录管理系统
************************************************************

                   1. 注册新用户
                   2. 用户登录
                   3. 用户注销
                   4. 用户信息显示
                   5. 退出系统
"""
userinfo = {

    'root': {
        'name': 'root',
        'password': 'redhat',
        'gender': 1,
        'email': '',
        'age': 12
    },
}

gender_choice = [0, 1, 2]

def CreateUser():
    print "注册用户界面".center(50, '*')
    name = raw_input("*注册用户名:")
    if name in userinfo:
        print "用户已存在，请更换注册名"
    else:
        password = raw_input("*用户密码:")
        while True:
            gender = input("*性别(0-男 1-女 2-其他):")
            if gender in gender_choice:
                break
            else:
                print "请输入正确的选择"

        email = raw_input("用户邮箱:")
        if not email:
            email = None
        age = raw_input("年龄:")
        if not age:
            age = None
        else:
            age = int(age)
        userinfo[name] = {
            'name': name,
            'password': password,
            'gender':   gender,
            'email':    email,
            'age':      age,
        }
        print "%s 用户注册成功!!!" % (name)

def UserLogin():
    print "用户登录界面".center(50, '*')
    trycount = 0
    while trycount < 3:
        name = raw_input("登录用户名：")
        if name not in userinfo:
            print "用户未注册"
            break
        password = raw_input("登录密码：")
        trycount += 1
        if password == userinfo[name]['password']:
            print "恭喜%s登录成功" % (name)
            break
        else:
            print "请输入正确的用户名或密码！"
    else:
        print "已登录三次，请稍后再试"


def DeleteUser():
    print "用户注销界面".center(50, '*')
    name = raw_input("注销用户名：")
    if name not in userinfo:
        print "用户未注册"
    else:
        password = raw_input("登录密码：")
        if password == userinfo[name]['password']:
            userinfo.pop(name)
            print "恭喜注销%s成功" % (name)

def UserInfo():
    for key, value in userinfo.items():
        print "用户:%s" % (key),
        print "性别:%d" % (value['gender']),
        print "邮箱:%s" % (value['email']),
        print "年龄:%s" % (value['age']),
        print "\n\n"

def main():
    while True:
        print info
        choice = raw_input("Choice:").strip()
        if choice == "1":
            CreateUser()
        elif choice == "2":
            UserLogin()
        elif choice == "3":
            DeleteUser()
        elif choice == "4":
            UserInfo()
        elif choice == "5":
            exit()
        else:
            print "输入正确的选择"

main()