rs_cx_bm.jsp

来自「JSP页面和oracle9i数据库的源代码」· JSP 代码 · 共 388 行 · 第 1/2 页

						Statement sql_xl=null;
						sql_xl=con.createStatement();
						rs_xl=sql_xl.executeQuery(condition_xl);
						rs_xl.next();
					%>
					<%=rs_xl.getString("XLMC")%></td>
                  </tr>
                  <tr>
                    <td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
                      <div align="right"><span class="style1">健康状况:</span></div>
                    </div></td>
                    <td height="20" nowrap><%=rs.getString("JKZK")%></td>
                    <td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
                      <div align="right"><span class="style1">婚姻状况:</span></div>
                    </div></td>
                    <td height="20" nowrap><%=rs.getString("HYZK")%></td>
                    <td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
                      <div align="right"><span class="style1">参加工作时间:</span></div>
                    </div></td>
                    <td height="20" nowrap><%=rs.getDate("CJGZSJ")%></td>
                    <td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
                      <div align="right"><span class="style1">进本单位时间:</span></div>
                    </div></td>
                    <td height="20" nowrap><%=rs.getDate("JBDWSJ")%></td>
                  </tr>
                  <tr>
                    <td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
                      <div align="right"><span class="style1">基本工资:</span></div>
                    </div></td>
                    <td height="20" nowrap><%=rs.getString("GZ")%></td>
                    <td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
                      <div align="right"><span class="style1">各种补贴:</span></div>
                    </div></td>
                    <td height="20" nowrap><%=rs.getString("GZBT")%></td>
                    <td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
                      <div align="right"><span class="style1">个人成份:</span></div>
                    </div></td>
                    <td height="20" nowrap><%=rs.getString("GRCF")%></td>
                    <td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
                      <div align="right"><span class="style1">家庭电话号码:</span></div>
                    </div></td>
                    <td height="20" nowrap><%=rs.getString("JTDH")%></td>
                  </tr>
                  <tr>
                    <td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
                      <div align="right"><span class="style1">手机号码:</span></div>
                    </div></td>
                    <td height="20" nowrap><%=rs.getString("SJHM")%></td>
                    <td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
                      <div align="right"><span class="style1">家庭出身:</span></div>
                    </div></td>
                    <td height="20" nowrap><%=rs.getString("JTCS")%></td>
                    <td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
                      <div align="right"><span class="style1">电子邮件地址:</span></div>
                    </div></td>
                    <td height="20" colspan="3" nowrap><div align="center"><%=rs.getString("DZYJ")%></div></td>
                  </tr>
                  <tr>
                    <td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
                      <div align="right"><span class="style1">家庭住址:</span></div>
                    </div></td>
                    <td height="20" colspan="7" nowrap><%=rs.getString("JTZZ")%></td>
                  </tr>
                  <tr bgcolor="#FF99CC">
                    <td height="20" nowrap><div align="center" class="style5">备注：</div></td>
  				    <td height="20" colspan="7" nowrap bgcolor="#FFFFFF"><%=rs.getString("BZ")%></td>
			      </tr>
                  <tr>
                    <td colspan="8">
				<div align="center">
				    <%	ResultSet rs2=null;
					Statement sql2=null;
					sql2=con.createStatement();			
					String bh=rs.getString("BH");
					int jtcy=0;
					String condition2="select * from JTCY where BH="+"'"+bh+"'";
					rs2=sql2.executeQuery(condition2);
					while(rs2.next())
					{jtcy++;}
					if(jtcy==0){out.print("无家庭成员记录！");}
					else{out.print(rs.getString("XM"));out.print("的家庭成员信息表：");}
					rs2=sql2.executeQuery(condition2);
					while(rs2.next())  
				    {%>	
</div>
				</td></tr>
                      <tr>
                        <td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6 style6">成员姓名:</span></div></td>
                        <td nowrap><div align="left"><span class="style6"><%=rs2.getString("CYXM")%></span></div></td>
                        <td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6 style6">家属关系:</span></div></td>
                        <td nowrap><div align="right"><span class="style6"><%=rs2.getString("JSGX")%></span></div></td>
                        <td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6 style6">出生年月:</span></div></td>
                        <td nowrap><div align="right"><span class="style6"><%=rs2.getDate("CSNY")%></span></div></td>
                        <td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6 style6">婚姻状况:</span></div></td>
                        <td nowrap><div align="left"><span class="style6"><%=rs2.getString("HYZK")%></span></div></td>
                      </tr>
                      <tr>
                        <td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6 style6">文化程度:</span></div></td>
                        <td nowrap><div align="left"><span class="style6"><%=rs2.getString("WHCD")%></span></div></td>
                        <td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6 style6">政治面目:</span></div></td>
                        <td nowrap><div align="right"><span class="style6"><%=rs2.getString("ZZMM")%></span></div></td>
                        <td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6 style6">职务工种:</span></div></td>
                        <td nowrap><div align="right"><span class="style6"><%=rs2.getString("ZWGZ")%></span></div></td>
                        <td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6 style6">工资:</span></div></td>
                        <td nowrap><div align="left"><span class="style6"><%=rs2.getString("GZ")%></span></div></td>
                      </tr>
                      <tr>
                        <td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6 style6">工作单位:</span></div></td>
                        <td colspan="3" nowrap><div align="left"><span class="style6"><%=rs2.getString("GZDW")%></span></div></td>
                        <td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6 style6">经济来源:</span></div></td>
                        <td colspan="3" nowrap><div align="left"><span class="style6"><%=rs2.getString("JJLY")%></span></div></td>
                      </tr>
					<%}%>
					<tr><td colspan="8">
					<div align="center">
				    <%	ResultSet rs3=null;
					Statement sql3=null;
					sql3=con.createStatement();			
					bh=rs.getString("BH");
					int shgx=0;
					String condition3="select * from SHGX where BH="+"'"+bh+"'";
					rs3=sql3.executeQuery(condition3);
					while(rs3.next())
					{shgx++;}
					if(shgx==0){out.print("无社会关系记录！");}
					else{out.print(rs.getString("XM"));out.print("的社会关系表：");}
					rs3=sql3.executeQuery(condition3);
					while(rs3.next())  
				    {%>	
					</div>
					</td></tr>
                      <tr>
                        <td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6">关系人姓名:</span></div></td>
                        <td nowrap><div align="left"><span class="style6"><%=rs3.getString("GXXM")%></span></div></td>
                        <td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6">二人关系:</span></div></td>
                        <td nowrap><div align="left"><span class="style6"><%=rs3.getString("YBRGX")%></span></div></td>
                        <td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6">政治面目:</span></div></td>
                        <td nowrap><div align="left"><span class="style6"><%=rs3.getString("ZZMM")%></span></div></td>
                        <td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6">职务工种:</span></div></td>
                        <td nowrap><div align="left"><span class="style6"><%=rs3.getString("ZWGZ")%></span></div></td>
                      </tr>
                      <tr>
                        <td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6">工作单位:</span></div></td>
                        <td colspan="7" nowrap><div align="left"><span class="style6"><%=rs3.getString("GZDW")%></span></div></td>
                      </tr>
                      <tr>
                        <td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6">备注：</span></div></td>
                        <td colspan="7" nowrap><div align="left"><span class="style6"><%=rs3.getString("BZ")%></span></div></td>
                      </tr>		
					<%}%>
					<tr><td colspan="8">
					 <div align="center">
					<%ResultSet rs4=null;
					Statement sql4=null;
					sql4=con.createStatement();			
					bh=rs.getString("BH");
					int grjl=0;
					String condition4="select * from GRJL where BH="+"'"+bh+"'";
					rs4=sql4.executeQuery(condition4);
					while(rs4.next())
					{grjl++;}
					if(grjl==0){out.print("无个人简历资料！");}
					else{out.print(rs.getString("XM"));out.print("的个人简历：");}
					rs4=sql4.executeQuery(condition4);
					while(rs4.next())  
				    {%>
					</div>
					</td></tr>
                       <tr>
                         <td nowrap bgcolor="#FF99CC" class="style6"><div align="right">前工作单位:</div></td>
                         <td nowrap class="style6"><div align="left"><%=rs4.getString("GZDW")%></div></td>
                         <td nowrap bgcolor="#FF99CC" class="style6"><div align="right">起止年月:</div></td>
                         <td nowrap colspan="3" class="style6"><div align="left"><%=rs4.getString("QZNY")%></div></td>
                         <td nowrap bgcolor="#FF99CC" class="style6"><div align="right">证明人:</div></td>
                         <td nowrap class="style6"><div align="left"><%=rs4.getString("ZMR")%></div></td>
                       </tr>
					<%}%>		
					</table>
				<div align="center">
				 <%
				}
			}
			else
			{ if(all==0 && !bm.equals("")){out.print("职工数据库中没有这个部门员工的信息");}
			  if(all<0){out.print("系统错误！请关闭网页重新登入！如有疑问请与软件开挖上联系！");}
			}
		 }
	   %>
</div>
<%con.close();%>
<jsp:include page="../checkout.jsp"></jsp:include>
</body>
</html>