1、实验简介
1、理解MVC模式。
2、掌握JSP+Servlet+JavaBean实现MVC的方法。
3、JSP中数据库的增删改查操作
2、具体细节分析
设计一个Web应用,系统分为三层,系统根据每个Java类所负责的任务,把系统分为三层,分别为web层、service层和model层,web层用于放置Servlet类,service层负责存放业务逻辑类,model层负责存放数据JavaBean。
编写一个注册页面register.jsp,提供一个用户注册的表单,并把用户填写的信息提交给名为add的servlet。
add利用JDBC连接数据库,并实现往数据库中插入一条数据(同时写入JavaBean),成功跳转到list.jsp页面,失败跳转回register.jsp页面。
list.jsp页面负责显示所有已注册的用户信息,并提供删除和修改功能,分别对应名为edit和delete的servlet。
edit和delete分别完成用户信息修改和删除功能,成功后给用户相应提示信息。
3、实验工具
■ phpstudy_pro
■ Navicat Premium 12
■ idea64
■ Tomcat(apache-tomcat-8.5.45)
4、整体框架截图
5.代码实现
1.User
package com.li.bean;
public class User {
private Integer uid;
private String username;
private String password;
private String phone;
private String address;
public void setUid(Integer uid) {
this.uid = uid;
}
public void setUsername(String username) {
this.username = username;
}
public void setPassword(String password) {
this.password = password;
}
public void setPhone(String phone) {
this.phone = phone;
}
public void setAddress(String address) {
this.address = address;
}
public Integer getUid() {
return uid;
}
public String getUsername() {
return username;
}
public String getPassword() {
return password;
}
public String getPhone() {
return phone;
}
public String getAddress() {
return address;
}
@Override
public String toString() {
return "User{" +
"uid=" + uid +
", username='" + username + '\'' +
", password='" + password + '\'' +
", phone='" + phone + '\'' +
", address='" + address + '\'' +
'}';
}
}
2.Goods
package com.li.bean;
public class Goods {
private Integer gid;
private String gname;
private String price;
private String mark;
@Override
public String toString() {
return "Goods{" +
"gid=" + gid +
", gname='" + gname + '\'' +
", price='" + price + '\'' +
", mark='" + mark + '\'' +
'}';
}
public Integer getGid() {
return gid;
}
public void setGid(Integer gid) {
this.gid = gid;
}
public String getGname() {
return gname;
}
public void setGname(String gname) {
this.gname = gname;
}
public String getPrice() {
return price;
}
public void setPrice(String price) {
this.price = price;
}
public String getMark() {
return mark;
}
public void setMark(String mark) {
this.mark = mark;
}
}
3.UserDaoImpl
package com.li