java添加员工代码_JavaWeb_day03_员工信息添加修改删除

「爱情、让人受尽委屈。」 2022-11-06 03:59 170阅读 0赞

day03员工的添加,修改,删除

修改功能

思路 : 点击修改员工数据之后,跳转到单行文本,查询要修改的员工id的全部信息,主键id设置为readonly,其余的都可以修改,

修改之后,提交按钮,提交之后跳转到全部员工界面

![3b0abac16c2041e2aa81c3ff0967dbe4.png][]

修改界面 :

![8d9f41ce7d7998b98d4f36d4f7e137f7.png][]

部分代码 :

//点击修改跳转到UpShowEmp中转单行修改页面,并带上ID,可以查询员工id

修改 "

//中转修改界面

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException \{

//设置页面编码格式,显示汉字

response.setContentType("text/html;charset=utf-8");

String id = request.getParameter("EmpID");

EmpDao dao = new EmpDao();

EmpBean bean = new EmpBean();

bean = dao.ShowMsgByID(id);

PrintWriter pw = response.getWriter();//页面显示

StringBuffer sb = new StringBuffer();

sb.append("

");

sb.append("

员工编码员工姓氏员工名字员工工资入职时间");

sb.append("

");

sb.append("

");

sb.append("

");

sb.append("

");

sb.append("

");

sb.append("

sb.append("

");

pw.write(sb.toString());

//修改提交之后的代码

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException \{

EmpBean bean = new EmpBean();

EmpDao dao = new EmpDao();

String empId = request.getParameter("empId");

String firstName = request.getParameter("firstName");

String lastName = request.getParameter("lastName");

String salary = request.getParameter("salary");

String hireDate = request.getParameter("hireDate");

int EmpId = Integer.parseInt(empId);

double sal = Double.parseDouble(salary);

bean.setEmpID(EmpId);

bean.setFirstName(firstName);

bean.setLastName(lastName);

bean.setSalary(sal);

bean.setHireDate(hireDate);

int column = dao.updateEmp(bean);

System.out.println(column);

if(column!=0)\{

response.sendRedirect("ShowMsgByPage");

删除员工信息

那就相对简单了,点击删除之后,带上员工id,跳转到DeleteEmpServlet页面.然后request.getParameter获取传过来的id,dao中的delete方法输进去id,赋给int类型,若为1则删除成功,跳转全部员工页面.

/ /删除按钮

删除

public class DeleteEmp extends HttpServlet \{

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException \{

EmpDao dao = new EmpDao();

String id = request.getParameter("EmpID");

System.out.println(id);

int column = dao.deleteEmp(id);

if(column != 0)\{

response.sendRedirect("ShowMsgByPage");

添加员工信息

单独设置一个a标签,点击添加之后,跳转到一个单行文本框的html页面,其中id不可以添加,序列自动生成,点击按钮之后跳转addEmpServlet界面,通过request.getParmeter获取添加的信息,然后在bean中set,然后调用dao添加方法,

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException \{

EmpBean bean = new EmpBean();

EmpDao dao = new EmpDao();

request.getParameter("submit");

String firstName = request.getParameter("firstName");

String lastName = request.getParameter("lastName");

String salary = request.getParameter("salary");

String hireDate = request.getParameter("hireDate");

bean.setFirstName(firstName);

bean.setLastName(lastName);

bean.setHireDate(hireDate);

bean.setSalary(Double.parseDouble(salary));

int column = dao.addEmp(bean);

//System.out.println(column);

if(column!=0)\{

response.sendRedirect("ShowMsgByPage");

[3b0abac16c2041e2aa81c3ff0967dbe4.png]: /images/20221023/8aab015b90b84f26b84226ac79f6f821.png
[8d9f41ce7d7998b98d4f36d4f7e137f7.png]: /images/20221023/d98cf1d8e2a54c3ab783b57a5249ccc8.png

java添加员工代码_JavaWeb_day03_员工信息添加修改删除

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 PHP定义员工数组，用于保存员工信息

相关 java添加员工代码_JavaWeb_day03_员工信息添加修改删除

相关 JavaWeb-综合案例(用户信息)-学习笔记03【添加删除修改功能】

相关考勤信息（员工打卡）

相关 SSH—员工管理模块之添加员工.删除.修改

相关 Spring boot添加员工页面跳转

相关 Spring boot添加员工

相关 Spring boot删除员工

相关 Spring boot修改员工

相关 python--员工信息表修改