修改员工信息java_使用jsp实现员工信息表的增删改查

更新操作：实现的方式，其中先编写DAO文件和数据库的连接

修改员工信息

Date date = new Date();

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");

String str = sdf.format(date);

%>

Main

修改员工信息:

int id = Integer.parseInt(request.getParameter("id"));

EmployeeDAO dao =new EmployeeDAO();

Employ emp=dao.findById(id);

%>

class="form_table">

id:

姓名:

value="" />

薪水:

value="" />

年龄:

value="" />

[email protected]

更新的逻辑页面：

request.setCharacterEncoding("utf-8");

response.setContentType("utf-8");

int id = Integer.parseInt(request.getParameter("id"));

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

double salary = Double.parseDouble(request.getParameter("salary"));

int age = Integer.parseInt(request.getParameter("age"));

Employ emp = new Employ();

emp.setAge(age);

emp.setId(id);

emp.setName(name);

emp.setSalary(salary);

EmployeeDAO dao = new EmployeeDAO();

dao.modify(emp);

response.sendRedirect("listEmp.jsp");

%>

增加页面：

添加员工信息

Date date = new Date();

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");

String str = sdf.format(date);

%>

Main

添加员工信息:

class="form_table">

姓名:

薪水:

年龄:

[email protected]

增加的逻辑页面：

request.setCharacterEncoding("utf-8");

response.setContentType("utf-8");

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

double salary = Double.parseDouble(request.getParameter("salary"));

int age = Integer.parseInt(request.getParameter("age"));

Employ emp = new Employ();

emp.setAge(age);

emp.setName(name);

emp.setSalary(salary);

EmployeeDAO dao= new EmployeeDAO();

dao.save(emp);

response.sendRedirect("listEmp.jsp");

%>

删除页面存在逻辑页面：

request.setCharacterEncoding("utf-8");

response.setContentType("utf-8");

int id =Integer.parseInt(request.getParameter("id"));

EmployeeDAO dao = new EmployeeDAO();

dao.delete(id);

response.sendRedirect("listEmp.jsp");

%>

查询页面的代码：

员工管理

function showtime(){

var d = new Date();

// 将系统时间的每一个值提取出来

var year = d.getYear();//年

var month = d.getMonth();//月

var day = d.getDate();//日

var hour = d.getHours()>=10 ? d.getHours() : ("0"+d.getHours());  //时

var mi = d.getMinutes()>=10 ? d.getMinutes() : ("0"+d.getMinutes()); //分

var ss = d.getSeconds()>=10 ? d.getSeconds() : ("0"+d.getSeconds());//秒

var t = year+"年"+(month+1)+"月"+day+"日"+" "+hour+":"+mi+":"+ss;

document.getElementById("showTimes").innerHTML=t;

setTimeout(showTime, 1000);

}

main

Welcome!

ID

姓名

薪水

年龄

操作

EmployeeDAO dao = new EmployeeDAO();

List employs = dao.findAll();

for(int i =0;i

Employ emp = employs.get(i);

%>

删除 

修改

οnclick="location=‘addEmp.jsp‘" />

[email protected]

原文：http://www.cnblogs.com/shaoyefeng/p/4890952.html