目录:
前言:一、需求分析:1. 简单功能2. 复杂功能3.登录:二、设计:1. 技术选型:2. 数据库设计:三、开发:1. 环境搭建1. 创建数据库环境(mysql8.0)2. 创建项目,导入需要的jar包2. 编码四: 测试五. 部署运维最难不过坚持!加油!前言:
通过这几天在B站上学习的JSP,MVC开发模式,EL表达式,JSTL, 三层架构:软件设计架构 ,等JavaWeb知识,于是乎跟着视频做了一个用户信息管理系统,在此记录一下,以巩固所学知识。
一、需求分析:
1. 简单功能
1. 列表查询2. 登录3. 添加4. 删除5. 修改
2. 复杂功能
1. 删除选中2. 分页查询 好处:1. 减轻服务器内存的开销2. 提升用户体验3. 复杂条件查询
3.登录:
调整页面,加入验证码功能代码实现
二、设计:
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@","小A","123456");insert into user values(2,"小B","女",20,"上海","112234","a@","小B","123456");insert into user values(3,"小C","男",20,"北京","112235","a@","小C","123456");insert into user values(4,"小D","女",20,"上海","112236","a@",null,null);insert into user values(5,"小E","男",20,"北京","112237","a@",null,null);insert into user values(6,"小F","女",20,"上海","112238","a@",null,null);insert into user values(7,"小G","男",20,"北京","112239","a@",null,null);insert into user values(8,"小H","女",20,"上海","112240","a@",null,null);insert into user values(9,"小I","男",20,"北京","112241","a@",null,null);insert into user values(10,"小J","女",20,"上海","112242","a@",null,null);insert into user values(11,"小K","男",20,"北京","112243","a@",null,null);insert into user values(12,"小L","女",20,"上海","112244","a@",null,null);insert into user values(13,"小M","男",20,"北京","112245","a@",null,null);insert into user values(14,"小N","女",20,"上海","112246","a@",null,null);insert into user values(15,"小O","男",20,"北京","112247","a@",null,null);
初始我设置系统有三位管理员:小A,小B,小C,密码为123456. (个人随机设置,可以改动)
其他记录为普通用户。
三、开发:
1. 环境搭建
1. 创建数据库环境(mysql8.0)
创建数据库:day17;user表:存取用户信息
2. 创建项目,导入需要的jar包
2. 编码
完整项目地址:项目地址
四: 测试
登录模块:
登录成功显示:
进入系统:
添加联系人:
模糊查询:
修改信息:
删除:
五. 部署运维
启动Tomcat服务器。。。。。。
完整项目地址:/download/weixin_47942875/20688280