📄 employeeinfo.jsp
字号:
<%--
模块名称：行政管理
模块功能：人员信息
版 本：V1.0
著 作 人：蔡静
著作日期：2001-10-25
使用说明：
主要技术说明：
参考文献：法律事务设计书
修改历史：= = = = = = = = = = = = = = = = = = = = = = = = = =
修改日期：
修 改 人：
修改理由：
修改出处：
= = = = = = = = = = = = = = = = = = = = = = = = = =
--%>
<%@ page contentType= "text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="db" class="dbconnection.DbConnection" scope="page" />
<%@ page import="system.*" %>
<%
Security auth = new Security();
String scu_employee_id = (String)session.getAttribute("employee_id");
if(scu_employee_id == null || scu_employee_id.equals(""))
{
response.sendRedirect(response.encodeRedirectURL("../Error/nonlogin.htm"));
}
String modelid = "Off031"; // 员工资料管理内容显示
int authflag = auth.popedom(scu_employee_id, modelid);
if(authflag == 0 || authflag == 2 || authflag == -1)
{%>
<jsp:forward page="../inc/noauth.jsp" >
</jsp:forward>
<%}%>
<%
String employee_id = request.getParameter("employee_id");
String employee_name, sex, birth, dept_name, title, duty;
String education, expert, career_time, join_time, resume, achievement;
String remark, speciality, case_range, tel = "", diploma = "";
String sql = "select a.employee_name, a.sex, a.birth, b.dept_name, a.title,";
sql = sql + "a.duty, a.education, a.expert, a.career_time, a.join_time, a.resume,";
sql = sql + "a.achievement, a.remark, a.speciality, a.case_range,";
sql = sql + "a.tel, a.diploma ";
sql = sql + " from t_employee a,t_dept b where a.dept_id = b.dept_id and employee_id = '";
sql = sql + employee_id + "' and active = 1";
ResultSet rs = db.executeQuery(sql);
if (rs.next()) {
employee_name = rs.getString("employee_name");
sex = rs.getString("sex");
birth = rs.getString("birth");
dept_name = rs.getString("dept_name");
title = rs.getString("title");
duty = rs.getString("duty");
education = rs.getString("education");
expert = rs.getString("expert");
career_time = rs.getString("career_time");
join_time = rs.getString("join_time");
resume = rs.getString("resume");
achievement = rs.getString("achievement");
remark = rs.getString("remark");
speciality = rs.getString("speciality");
case_range = rs.getString("case_range");
//add by SIMM 2001.11.15
tel = rs.getString("tel");
if(tel == null) tel = "";
diploma = rs.getString("diploma");
if(diploma == null) diploma = "";
%>
<html>
<head>
<title>人员信息</title>
<%@ include file="../inc/config.jsp" %>
</head>
<body class=page>
<table width="98%" align="center" cellspacing="0" cellpadding="0" border="0">
<tr>
<td>
<a href="Employee.jsp"><img src="../images/all.gif" height="22" border="0" alt="显示所有内容"></a>
<a href="EmployeeAdd.jsp"><img src="../images/add.gif" alt="增加内容" width="79" height="22" border="0" style="cursor:hand" ></a>
<img src="../images/delete.gif" alt="删除选中的内容" style="cursor:hand" width="79" height="22"></td>
<td width="108" height="30" align="center"> <img src="../images/back.gif" width="50" height="22" onClick="window.history.back()" style="cursor:hand" alt="返回"></td>
</tr>
</table>
<table width="98%" background="../images/line.gif" border="0" cellspacing="0" cellpadding="0" height="12" align="center">
<tr>
<td> </td>
</tr>
</table>
<table width="98%" align="center" border="0" cellspacing="1" cellpadding="0" class="table_bg">
<tr>
<td height="24" width="19%" align="right" class="title_bg"> 员工编号：</td>
<td height="24" width="32%" class="tr_bg1"><%=employee_id%></td>
<td height="24" width="17%" align="right" class="title_bg"> 姓名：</td>
<td height="24" width="32%" class="tr_bg1"><%=employee_name%></td>
</tr>
<tr>
<td align="right" height="28" width="19%" class="title_bg"> 性别：</td>
<td height="28" width="32%" class="tr_bg1">
<%
if (sex.equals("1"))
out.print("男");
else
out.print("女");
%>
</td>
<td align="right" height="28" width="17%" class="title_bg"> 出生年月：</td>
<td height=28 width=32% class="tr_bg1">
<%
if (birth != null)
out.print(birth.substring(0,10));
%>
</td>
</tr>
<tr>
<td align=right height=28 width=19% class="title_bg"> 联系方式：</td>
<td height=28 width=32% class="tr_bg1"><%=tel%></td>
<td align="right" height="28" width="17%" class="title_bg"> 所属部门：</td>
<td height=28 width=32% class="tr_bg1"><%=dept_name%></td>
</tr>
<tr>
<td align=right height=28 width=19% class="title_bg"> 职称：</td>
<td height=28 width=32% class="tr_bg1">
<%
if (title != null)
out.print(title);
%>
</td>
<td align=right height=28 width=17% class="title_bg"> 职务：</td>
<td height=28 width=32% class="tr_bg1" >
<%
if (duty != null)
out.print(duty);
%>
</td>
</tr>
<tr>
<td align=right height=28 width=19% class="title_bg"> 学历：</td>
<td class="tr_bg1">
<%
int flag = Integer.parseInt(education);
switch(flag) {
case 1: out.print("小学");break;
case 2: out.print("初中");break;
case 3: out.print("高中");break;
case 4: out.print("中专");break;
case 5: out.print("大专");break;
case 6: out.print("本科");break;
case 7: out.print("硕士");break;
case 8: out.print("博士");break;
}
%>
</td>
<td align=right height=28 width=17% class="title_bg"> 专业方向：</td>
<td height=28 width=32% class="tr_bg1" >
<%
if (expert != null)
out.print(expert);
%>
</td>
</tr>
<tr>
<td align=right height=28 width=19% class="title_bg"> 毕业学校：</td>
<td colspan=3 height=28 class="tr_bg1"><%=diploma%></td>
</tr>
<tr>
<td align=right height=28 width=19% class="title_bg"> 从业时间：</td>
<td height=28 width=32% class="tr_bg1">
<%
if (career_time != null)
out.print(career_time.substring(0,10));
%>
</td>
<td align=right height=28 width=17% class="title_bg"> 入司时间:
</td>
<td height=28 width=32% class="tr_bg1" >
<%
if (join_time != null)
out.print(join_time.substring(0,10));
%>
</td>
</tr>
<tr>
<td align=right height=28 width=19% class="title_bg">个人简历：</td>
<td colspan=4 height=28 class="tr_bg1">
<%
if (resume != null)
out.print(resume);
%>
</td>
</tr>
<tr>
<td align=right height=28 width=19% class="title_bg"> 主要业绩：</td>
<td colspan=4 height=28 class="tr_bg1">
<%
if (achievement != null)
out.print(achievement);
%>
</td>
</tr>
<tr>
<td align=right height=56 class="title_bg" width="19%"> 备注：</td>
<td colspan=4 height=56 class="tr_bg1">
<%
if (remark != null)
out.print(remark);
%>
</td>
</tr>
<tr>
<td align=left height=28 class="title_bg" colspan="5"> 律师员工资料
</td>
</tr>
<tr>
<td align=right height=28 width=19% class="title_bg"> 律师专长：</td>
<td colspan=4 height=28 class="tr_bg1">
<%
if (speciality != null)
out.print(speciality);
%>
</td>
</tr>
<tr>
<td align=right height=28 width=19% class="title_bg"> 办案范围：</td>
<td colspan=4 height=28 class="tr_bg1">
<%
if (case_range != null)
out.print(case_range);
%>
</td>
</tr>
</table>
<br>
</body>
</html>
<%}%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -