基于Java的JSP+Servlet动态网站开发设计源码

```mysql # 数据库名称：CompanyManager create database CompanyManager charset utf8; use CompanyManager; # 表： Dept (部门信息表) create table Dept ( DeptID int primary key auto_increment, # 部门编号主键,自动增长列 DeptName varchar(20) not null # 部门名称 不允许为空 ); insert into Dept values (0, '后勤部'), (0, '法务部'), (0, '开发部'), (0, '人力部'), (0, '财务部'); # 表：Emp (员工信息表) create table Emp ( EmpID int primary key auto_increment, # 员工编号主键,自动增长列 EmpName varchar(20) not null, # 员工姓名 不允许为空 Sex char(2) not null, # 性别不允许为空 Age int not null, # 员工年龄不允许为空 Tel varchar(20) unique not null, # 联系电话 不允许为空（唯一约束） PassWord varchar(12) not null, # 密码 不允许为空 DeptID int, foreign key (DeptID) references Dept (DeptID)# 部门编号外键，关联部门表DeptID字段 ); insert into Emp values (0, '季川', '男', 22, '1516816', '123', 1), (0, '梓兰', '女', 23, '1515530', '456', 4), (0, '华容', '女', 25, '1805862', '789', 2), (0, '李铭', '男', 23, '1348028', '023', 5), (0, '季静', '女', 21, '1516658', '112', 3); ``` ```java package bean; public class Dept { private int deptId; private String deptName; public Dept(int empId) { } 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() { } public Dept(int deptId, String deptName) { this.deptId = deptId; this.deptName = deptName; } @Override public String toString() { return "Dept{" + "deptId=" + deptId + ", deptName='" + deptName + '\'' + '}'; } } ``` ```java package bean; public class Emp { private int empId; private String empName; private String sex; private int age; private String tel; private String passWord; private int deptId; private String deptName; public Emp(int empId) { } 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 getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } public int getAge() { return age; } public void setAge(int age) { this.age = age; } public String getTel() { return tel; } public void setTel(String tel) { this.tel = tel; } public String getPassWord() { return passWord; } public void setPassWord(String passWord) { this.passWord = passWord; } 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 Emp() { } public Emp(int empId, String empName, String sex, int age, String tel, String passWord, int deptId, String deptName) { this.empId = empId; this.empName = empName; this.sex = sex; this.age = age; this.tel = tel; this.passWord = passWord; this.deptId = deptId; this.deptName = deptName; } @Override public String toString() { return "Emp{" + "empId=" + empId + ", empName='" + empName + '\'' + ", sex='" + sex + '\'' + ", age=" + age + ", tel='" + tel + '\'' + ", passWord='" + passWord + '\'' + ", deptId=" + deptId + ", deptName='" + deptName + '\'' + '}'; } } ``` ```java package servlet; import bean.Dept; import bean.Emp; import util.DBUtil; import javax.servlet.*; import javax.servlet.http.*; import javax.servlet.annotation.*; import java.io.IOException; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; @WebServlet("/add") public class Add extends HttpServlet { @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); String sql="select * from Dept"; ResultSet rst = DBUtil.query(sql); ArrayList<Dept> list = new ArrayList<>(); try { while (rst.next()) { int deptId = rst.getInt("deptId"); String deptName = rst.getString("deptName"); Dept dept = new Dept(deptId, deptName); list.add(dept); } } catch (SQLException e) { e.printStackTrace(); } request.setAttribute("list",list); request.getRequestDispatcher("/WEB-INF/add.jsp").forward(request,response); } @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { } } ``` ```java package servlet; import bean.Dept; import bean.Emp; import util.DBUtil; import javax.servlet.*; import javax.servlet.http.*; import javax.servlet.annotation.*; import java.io.IOException; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; @WebServlet("/delete") public class Delete extends HttpServlet { @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String sql="select * from Emp"; ResultSet rst = DBUtil.query(sql); ArrayList<Emp> list = new ArrayList<>(); try { while (rst.next()) { int empId = rst.getInt("empId"); Emp emp = new Emp(empId); list.add(emp); } } catch (SQLException e) { e.printStackTrace(); } request.setAttribute("list",list); request.getRequestDispatcher("/WEB-INF/delete.jsp").forward(request,response); } @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); response.setContentType("text/html;charset=utf-8"); String sql="delete from Emp where EmpID=?"; int empId = Integer.parseInt(request.getParameter("empId")); int i = DBUtil.update(sql, empId); if(i>0){ request.setAttribute("msg","删除成功！"); response.sendRedirect("/list"); }else{ request.setAttribute("msg","删除失败！"); request.getRequestDispatcher("/WEB-INF/msg.jsp").forward(request,response); } } } ``` ```java package servlet; import bean.Emp; import util.DBUtil; import javax.servlet.*; import javax.servlet.http.*; import javax.servlet.annotation.*; import java.io.IOException; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; @WebServlet("/list") public class List extends HttpServlet { @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String sql="select * from Dept d,Emp e where d.DeptID=e.DeptID"; ResultSet rst = DBUtil.query(sql); ArrayList<Emp> list = new ArrayList<>