📄 employeesearch.jsp
字号:
<%@ page language="java" contentType="text/html; charset=GB2312" pageEncoding="GB2312"%>
<%@ page import="com.logistic.business.EmployeeManager" %>
<%@ page import="com.logistic.model.EmployeeInfo" %>
<%@ page import="java.sql.*" %>
<% request.setCharacterEncoding("gb2312");%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB2312">
<title>职员信息查询</title>
<style type="text/css">
<!--
body {
background-color: #168AC2;
}
-->
</style>
<link href="../../cssjs/comcss.css" rel="stylesheet" type="text/css">
<jsp:useBean id="dblink" class="com.logistic.data.DataConnect" scope="page"/>
</head>
<body>
<%
String eid=(String)request.getParameter("employeeid");
%>
<table width="375" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="#FF9999">
<tr>
<td width="369" align="center" class="style9">按职员编号查询职员信息</td>
</tr>
<tr>
<td height="30" align="center"><form name="employee" method="post" action="employeesearch.jsp">
<table width="350" border="0" cellpadding="1" cellspacing="0">
<tr>
<td width="103" height="21" align="right" class="code">请输入职员编号:</td>
<td width="163"><label>
<input name="employeeid" type="text" class="style9" id="employeeid" size="20" maxlength="20">
</label></td>
<td width="78" align="center"><label>
<input name="Submit" type="submit" class="buttonstyle" value="查询">
</label></td>
</tr>
</table>
</form></td>
</tr>
</table>
<%
if(eid!=null){
String deparname=null;
String jobsname=null;
EmployeeInfo ei=null;
EmployeeManager em=new EmployeeManager();
ei=em.EmployeeSearchById(eid);
//取得部门名称
String sqldepar="select *from departmentinfotable where DepartmentId="+ei.getDepartmentId();
Statement statdepar=dblink.getStmtread();
ResultSet rsdepar=statdepar.executeQuery(sqldepar);
while(rsdepar.next()){
deparname=rsdepar.getString("DepartmentName");
}
dblink.close();
//取得职务名称
String sqljobs="select *from jobsinfotable where JobsId="+ei.getJobsId();
Statement statjobs=dblink.getStmtread();
ResultSet rsjobs=statjobs.executeQuery(sqljobs);
while(rsjobs.next()){
jobsname=rsjobs.getString("JobsName");
}
dblink.close();
%>
<table width="515" height="166" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="#666699">
<tr>
<td width="98" height="22" align="right" valign="middle" class="style9">职员姓名:</td>
<td width="155" align="center" class="code"><%=ei.getEmployeeName() %></td>
<td width="80" align="right" valign="middle" class="style9">性别:</td>
<td width="164" align="center" class="code"><%=ei.getEmployeeSex() %></td>
</tr>
<tr>
<td height="23" align="right" valign="middle" class="style9">年龄:</td>
<td align="center" class="code"><%=ei.getEmployeeAge() %></td>
<td align="right" valign="middle" class="style9">身份证号:</td>
<td align="center" class="code"><%=ei.getEmployeeIdenCard() %></td>
</tr>
<tr>
<td height="24" align="right" valign="middle" class="style9">出生日期:</td>
<td align="center" class="code"><%=ei.getEmployeeBirthDate() %></td>
<td align="right" valign="middle" class="style9">学历:</td>
<td align="center" class="code"><%=ei.getEmployeeDiploma() %></td>
</tr>
<tr>
<td height="23" align="right" valign="middle" class="style9">加入公司时间:</td>
<td align="center" class="code"><%=ei.getEmployeeJoinDate() %></td>
<td align="right" valign="middle" class="style9">所属部门:</td>
<td align="center" class="code"><%=deparname %></td>
</tr>
<tr>
<td height="24" align="right" valign="middle" class="style9">所任职务:</td>
<td align="center" class="code"><%=jobsname %></td>
<td align="right" valign="middle" class="style9">固定电话:</td>
<td align="center" class="code"><%=ei.getEmployeePhone() %></td>
</tr>
<tr>
<td height="24" align="right" valign="middle" class="style9">移动电话:</td>
<td colspan="2" align="center" class="code"><%=ei.getEmployeeMobile() %></td>
<td class="code"> </td>
</tr>
<tr>
<td height="24" align="right" valign="middle" class="style9">家庭住址:</td>
<td colspan="3" align="center" class="code"><%=ei.getEmployeeAdd() %></td>
</tr>
</table>
<%
}
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -