📄 employeeamendrun.jsp
字号:
<%--
模块名称：行政管理
模块功能：人员修改
版 本：V1.0
著 作 人：蔡静
著作日期：2001-10-25
使用说明：
主要技术说明：
参考文献：法律事务设计书
修改历史：= = = = = = = = = = = = = = = = = = = = = = = = = =
修改日期：
修 改 人：
修改理由：
修改出处：
= = = = = = = = = = = = = = = = = = = = = = = = = =
--%>
<%@ page contentType= "text/html; charset=gb2312" %>
<%@ page language="java" import="system.ExtendString" %>
<jsp:useBean id="db" class="dbconnection.DbConnection" scope="page" />
<%
ExtendString es = new ExtendString();
String employee_id, employee_name, sex, birth, dept_id, title, duty;
String education, expert, career_time, join_time, resume, achievement;
String remark, speciality, case_range,
tel = "", diploma = "";
employee_id = request.getParameter("employee_id");
employee_name = es.getStr(request.getParameter("employee_name"));
sex = request.getParameter("sex");
birth = request.getParameter("birth");
dept_id = request.getParameter("dept_id");
title = request.getParameter("title");
duty = request.getParameter("duty");
education = request.getParameter("education");
expert = request.getParameter("expert");
career_time = request.getParameter("career_time");
join_time = request.getParameter("join_time");
resume = request.getParameter("resume");
achievement = request.getParameter("achievement");
remark = request.getParameter("remark");
speciality = request.getParameter("speciality");
case_range = request.getParameter("case_range");
tel = request.getParameter("tel"); //
diploma = request.getParameter("diploma"); //
String sql = "update t_employee set employee_name='"+employee_name+"'";
sql = sql + ", sex = " + sex;
if ((birth != null) && (!birth.equals("")))
sql = sql + ", birth = '" + birth + "'";
else
sql = sql + ", birth = null";
sql = sql + ", dept_id='" + dept_id + "'";
if (title != null)
sql = sql + ", title = '" + es.getStr(title) + "'";
else
sql = sql + ", title = null";
if (duty != null)
sql = sql + ", duty = '" + es.getStr(duty) + "'";
else
sql = sql + ", duty = null";
sql = sql + ", education = '" + education + "'";
if (expert != null)
sql = sql + ", expert = '" + es.getStr(expert) + "'";
else
sql = sql + ", expert = null";
if ((career_time != null) && (!career_time.equals("")))
sql = sql + ", career_time = '" + career_time + "'";
else
sql = sql + ", career_time = null";
if ((join_time != null) && (!join_time.equals("")))
sql = sql + ", join_time = '" + join_time + "'";
else
sql = sql + ", join_time = null";
if (resume != null)
sql = sql + ", resume = '" + es.getStr(resume) + "'";
else
sql = sql + ", resume = null";
if (achievement != null)
sql = sql + ", achievement = '" + es.getStr(achievement) + "'";
else
sql = sql + ", achievement = null";
if (remark != null)
sql = sql + ", remark = '" + es.getStr(remark) + "'";
else
sql = sql + ", remark = null";
if (speciality != null)
sql = sql + ", speciality = '" + es.getStr(speciality) + "'";
else
sql = sql + ", speciality = null";
if (case_range != null)
sql = sql + ", case_range = '" + es.getStr(case_range) + "'";
else
sql = sql + ", case_range = null";
if (tel != null)
sql = sql + ", tel = '" + es.getStr(tel) + "'";
else
sql = sql + ", tel= null";
if (diploma != null)
sql = sql + ", diploma = '" + es.getStr(diploma) + "'";
else
sql = sql + ", diploma = null";
sql = sql + " where employee_id='" + employee_id + "'";
int num = db.executeUpdate(sql);
if (num <= 0) {%>
<script language="javascript">
alert("修改失败！");
</script>
<%}
%>
<html>
<head>
<title>修改成功</title>
</head>
<body>
<script language="javascript">
location = "Employee.jsp";
</script>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -