JavaWeb:用户信息管理系统

前言：

通过这几天在B站上学习的JSP，MVC开发模式，EL表达式，JSTL， 三层架构：软件设计架构 ，等JavaWeb知识，于是乎跟着视频做了一个用户信息管理系统，在此记录一下，以巩固所学知识。

---

一、需求分析：

1. 简单功能

  1. 列表查询
  2. 登录
  3. 添加
  4. 删除
  5. 修改

2. 复杂功能

  1. 删除选中
  2. 分页查询 好处：
  		1. 减轻服务器内存的开销
  		2. 提升用户体验
  3. 复杂条件查询

3.登录：

1. 调整页面，加入验证码功能
2. 代码实现

二、设计：

1. 技术选型：

Servlet+JSP+MySQL+JDBCTempleat+Duird+BeanUtilS+tomcat

2. 数据库设计：

drop database if exists day17;
create database day17;  
		use day17; 			
		create table user(
			id int primary key auto_increment,
			name varchar(20) not null,
			gender varchar(5),
			age int,
			address varchar(32),
			qq varchar(20),
			email varchar(50),
			username varchar(20),
			password varchar(32)
		);

insert into user values(1,"小A","男",20,"北京","112233","a@111.com","小A","123456");
insert into user values(2,"小B","女",20,"上海","112234","a@112.com","小B","123456");
insert into user values(3,"小C","男",20,"北京","112235","a@113.com","小C","123456");
insert into user values(4,"小D","女",20,"上海","112236","a@114.com",null,null);
insert into user values(5,"小E","男",20,"北京","112237","a@115.com",null,null);
insert into user values(6,"小F","女",20,"上海","112238","a@116.com",null,null);
insert into user values(7,"小G","男",20,"北京","112239","a@117.com",null,null);
insert into user values(8,"小H","女",20,"上海","112240","a@118.com",null,null);
insert into user values(9,"小I","男",20,"北京","112241","a@119.com",null,null);
insert into user values(10,"小J","女",20,"上海","112242","a@120.com",null,null);
insert into user values(11,"小K","男",20,"北京","112243","a@121.com",null,null);
insert into user values(12,"小L","女",20,"上海","112244","a@122.com",null,null);
insert into user values(13,"小M","男",20,"北京","112245","a@123.com",null,null);
insert into user values(14,"小N","女",20,"上海","112246","a@124.com",null,null);
insert into user values(15,"小O","男",20,"北京","112247","a@125.com",null,null);

初始我设置系统有三位管理员：小A,小B,小C,密码为123456. （个人随机设置，可以改动）
其他记录为普通用户。

三、开发：

1. 环境搭建

1. 创建数据库环境（mysql8.0）

1. 创建数据库:day17;
2. user表:存取用户信息

2. 创建项目，导入需要的jar包

2. 编码

完整项目地址：项目地址

四： 测试

登录模块：

登录成功显示：

进入系统：

添加联系人：

模糊查询：

修改信息:

删除：

五. 部署运维

启动Tomcat服务器。。。。。。

完整项目地址：https://download.csdn.net/download/weixin_47942875/20688280

---

最难不过坚持！加油！