📄 insertemployeesearch.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<jsp:directive.page import="com.wl.dbconnection.DBManager"/>
<jsp:directive.page import="java.sql.ResultSet"/>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<html>
<head>
<base href="<%=basePath%>">
<title>职员信息录入窗体</title>
<style type="text/css">
<!--
body {
background-color: #168AC2;
}
-->
</style>
<link href="<%=request.getContextPath()%>/cssjs/comcss.css" rel="stylesheet" type="text/css">
<script language="JavaScript" src="<%=request.getContextPath()%>/cssjs/comjs.js"></script>
<script language="javascript" src="<%=request.getContextPath()%>/cssjs/calendar.js"></script>
</head>
<body>
<h2 align="center">新职员录入</h2>
<table width="671" height="337" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="#666699">
<tr>
<td width="238" height="26" align="center" class="style5"><span class="style11">(注意：填写下表，*标识的项必须填写)</span> </td>
</tr>
<tr>
<td height="279" colspan="2"><form name="employeeinfoinput" method="post" action="">
<table width="632" height="242" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="#666699">
<tr>
<td width="98" height="28" align="right" valign="middle" class="code">职员姓名:</td>
<td width="215" align="left"><input name="employeename" type="text" class="style13" id="employeename" size="15" maxlength="15">
<span class="style5">*</span></td>
<td width="67" align="right" valign="middle" class="code">性别:</td>
<td width="234" align="left"><select name="employeesex" class="style13" id="employeesex">
<option value="">-选择-</option>
<option value="男">男</option>
<option value="女">女</option>
</select></td>
</tr>
<tr>
<td height="25" align="right" valign="middle" class="code">年龄:</td>
<td align="left"><input name="employeeage" type="text" class="style13" id="employeeage" size="5" maxlength="5">
<span class="style5">*</span></td>
<td align="right" valign="middle" class="code">身份证号:</td>
<td align="left"><input name="employeeidcard" type="text" class="style13" id="employeeidcard" size="18" maxlength="18">
<span class="style5">*（18位）</span></td>
</tr>
<tr>
<td height="27" align="right" valign="middle" class="code">出生日期:</td>
<td align="left"><input name="birthdate" type="text" class="style13" id="birthdate" size="10" maxlength="10" onClick="getDateString(this,oCalendarChs)"><span class="style5">*(单击选择日期)</span></td>
<td align="right" valign="middle" class="code">学历:</td>
<td align="left"><select name="diploma" class="style13" id="diploma">
<option value="">--选择--</option>
<%
String sql = "select * from diplomainfotable";
DBManager db = new DBManager();
db.openDB();
db.ps = db.conn.prepareStatement(sql);
ResultSet rs = db.ps.executeQuery();
while(rs.next()){
String id = rs.getString("Id");
String name = rs.getString("DiplomaName");
out.print("<option value="+id);
out.print(">"+name+"</option>");
}
db.closeDB();
%>
</select>
<span class="style5">*</span></td>
</tr>
<tr>
<td height="32" align="right" valign="middle" class="code">加入公司时间:</td>
<td align="left"><input name="joindate" type="text" class="style13" id="joindate" size="10" maxlength="10" onClick="getDateString(this,oCalendarChs)"><span class="style5">*(单击选择日期)</span></td>
<td align="right" valign="middle" class="code">所属部门:</td>
<td align="left"><select name="department" class="style13" id="department">
<option value="">--选择--</option>
<%
String sqldepart = "select * from departmentinfotable";
DBManager dbm = new DBManager();
dbm.openDB();
dbm.ps = dbm.conn.prepareStatement(sqldepart);
ResultSet re = dbm.ps.executeQuery();
while(re.next()){
String departmentId = re.getString("DepartmentId");
String departmentName = re.getString("DepartmentName");
out.print("<option value="+departmentId);
out.print(">"+departmentName+"</option>");
}
dbm.closeDB();
%>
</select>
<span class="style5">*</span></td>
</tr>
<tr>
<td height="30" align="right" valign="middle" class="code">所任职务:</td>
<td align="left">
<select name="jobs" class="style13" id="select2">
<option value="">--选择--</option>
<%
String sqljob = "select * from jobsinfotable";
DBManager man = new DBManager();
man.openDB();
man.ps = man.conn.prepareStatement(sqljob);
ResultSet set = man.ps.executeQuery();
while(set.next()){
String jobsId = set.getString("JobsId");
String jobsName = set.getString("JobsName");
out.print("<option value="+jobsId);
out.print(">"+jobsName+"</option>");
}
man.closeDB();
%>
</select></td>
<td align="right" valign="middle" class="code">固定电话:</td>
<td align="left"><input name="fixphone" type="text" class="style13" id="fixphone" size="12" maxlength="12"></td>
</tr>
<tr>
<td height="32" align="right" valign="middle" class="code">移动电话:</td>
<td colspan="2" align="left"><input name="mobile" type="text" class="style13" id="mobile" size="11" maxlength="11">
<span class="style5">*（11位合法手机号码）</span></td>
<td> </td>
</tr>
<tr>
<td height="32" align="right" valign="middle" class="code">家庭住址:</td>
<td colspan="3" align="left"><input name="homeaddress" type="text" class="style13" id="homeaddress" size="50" maxlength="50">
<span class="style5">（家庭住址最多50个字符）</span></td>
</tr>
<tr align="center">
<td height="34" colspan="4"><input name="Submit" type="submit" class="buttonstyle" value="提交数据">
<input name="cancle" type="reset" class="buttonstyle" id="cancle" value="重填数据"></td>
</tr>
</table>
</form></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -