Meeting Management System 会议管理系统
此项目涉及:【未涉及框架】
- 前端:HTML + CSS + JS
- 后端:JSP + Servlet + JDBC
- 数据库:Oracle
- 开发工具:Eclipse + 数据库第三方软件:PL / SQL Developer
- jar包
- 分层
- VO
- Util
- DAO
- Service
- Servlet
- Filter
- Listener
各层名字只是随意取的
Name | 别名 | 用途 |
---|---|---|
VO | Bean,Domain,Entity | 实体类 |
Util | / | 工具/功能层 |
DAO | / | 数据操作层 |
Service | / | 业务逻辑层 |
Servlet | / | 控制层 |
Filter | / | 过滤器 |
Listener | / | 监听器 |
其他
除了必备的专业知识,你还应该会
- Alt键+/ 的快捷方式(真的还有很多人不知道……)
- 代码查错
- Java 3.0 与以往版本相比之下的优势
前期准备
数据库建表:
- 部门表meetingdept;
- 员工表meetingemp;
- 会议室表meetingroom
涉及知识点回忆
JDBC
- 数据库连接方法
- JDBC API
- Connection接口
- Statement接口
- ResultSet接口
- 预处理语句
- PreparedStatement对象
- 连接池与数据源
代码区
一:VO:
1. Dept类
public class Dept {
//声明属性
private int deptid;
private String deptname;
//set get
public int getDeptid() {
return deptid;
}
public void setDeptid(int deptid) {
this.deptid = deptid;
}
public String getDeptname() {
return deptname;
}
public void setDeptname(String deptname) {
this.deptname = deptname;
}
//全参构造器
public Dept(int deptid, String deptname) {
super();
this.deptid = deptid;
this.deptname = deptname;
}
//无参构造器
public Dept() {
super();
}
//提供tostring
@Override
public String toString() {
return "Dept [deptid=" + deptid + ", deptname=" + deptname + "]";
}
}
2.Emp类
public class Emp {
//声明属性
private int empId;
private String empName;
private String username;
private String password;
private String phone;
private String email;
private int deptid;
private String status;
//提供set get 构造器 toString
public int getEmpId() {
return empId;
}
public void setEmpId(int empId) {
this.empId = empId;
}
public String getEmpName() {
return empName;
}
public void setEmpName(String empName) {
this.empName = empName;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public int getDeptid() {
return deptid;
}
public void setDeptid(int deptid) {
this.deptid = deptid;
}
public String getStatus() {
return status;
}
public void setStatus(String status) {
this.status = status;
}
public Emp(int empId, String empName, String username, String password,
String phone, String email, int deptid, String status) {
super();
this.empId = empId;
this.empName = empName;
this.username = username;
this.password = password;
this.phone = phone;
this.email = email;
this.deptid = deptid;
this.status = status;
}
public Emp() {
super();
}
@Override
public String