rs_print_all.jsp

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

                        <div align="right"><span class="style1">家庭电话号码:</span></div>
                    </div></td>
                    <td nowrap><span class="style6"><%=rs.getString("JTDH")%></span></td>
                  </tr>
                  <tr>
                    <td nowrap bgcolor="#FF99CC"><div align="left" class="style6">
                        <div align="right"><span class="style1">手机号码:</span></div>
                    </div></td>
                    <td nowrap><span class="style6"><%=rs.getString("SJHM")%></span></td>
                    <td nowrap bgcolor="#FF99CC"><div align="left" class="style6">
                        <div align="right"><span class="style1">家庭出身:</span></div>
                    </div></td>
                    <td nowrap><span class="style6"><%=rs.getString("JTCS")%></span></td>
                    <td nowrap bgcolor="#FF99CC"><div align="left" class="style6">
                        <div align="right"><span class="style1">电子邮件地址:</span></div>
                    </div></td>
                    <td colspan="3" nowrap><div align="center" class="style6"><%=rs.getString("DZYJ")%></div></td>
                  </tr>
                  <tr>
                    <td nowrap bgcolor="#FF99CC"><div align="left" class="style6">
                        <div align="right"><span class="style1">家庭住址:</span></div>
                    </div></td>
                    <td colspan="7" nowrap><span class="style6"><%=rs.getString("JTZZ")%></span></td>
                  </tr>
                  <tr bgcolor="#FF99CC">
                    <td colspan="8" nowrap><div align="center" class="style5 style6">备注：</div></td>
                  </tr>
                  <tr>
                    <td height="22" colspan="8"><span class="style6"><%=rs.getString("BZ")%></span></td>
                  </tr>
				  <tr><td colspan="8">
                  <div align="center">
                    <%String bh=rs.getString("BH");
		  int jtcy=0;
		  String newcondition2="select * from JTCY where BH="+"'"+bh+"'";
		  conn.setcondition(newcondition2);
		  ResultSet rs2=conn.getrs();
		  while(rs2.next())
		  {jtcy++;}
		  if(jtcy==0){out.print("无家庭成员记录！");}
		  else
		  {out.print(rs.getString("XM"));out.print("的家庭成员信息表：");}
		   conn.setcondition(newcondition2);
		   rs2=conn.getrs();
		   while(rs2.next())  
		  {
		%>
                  </div>
				  </td></tr>
                    <tr>
                      <td bgcolor="#FF99CC"><div align="right"><span class="style6 style6">成员姓名:</span></div></td>
                      <td><div align="left"><span class="style6"><%=rs2.getString("CYXM")%></span></div></td>
                      <td bgcolor="#FF99CC"><div align="right"><span class="style6 style6">家属关系:</span></div></td>
                      <td><div align="left"><span class="style6"><%=rs2.getString("JSGX")%></span></div></td>
                      <td bgcolor="#FF99CC"><div align="right"><span class="style6 style6">出生年月:</span></div></td>
                      <td><div align="left"><span class="style6"><%=rs2.getDate("CSNY")%></span></div></td>
                      <td bgcolor="#FF99CC"><div align="right"><span class="style6 style6">婚姻状况:</span></div></td>
                      <td><div align="left"><span class="style6"><%=rs2.getString("HYZK")%></span></div></td>
                    </tr>
                    <tr>
                      <td bgcolor="#FF99CC"><div align="right"><span class="style6 style6">文化程度:</span></div></td>
                      <td><div align="left"><span class="style6"><%=rs2.getString("WHCD")%></span></div></td>
                      <td bgcolor="#FF99CC"><div align="right"><span class="style6 style6">政治面目:</span></div></td>
                      <td><div align="left"><span class="style6"><%=rs2.getString("ZZMM")%></span></div></td>
                      <td bgcolor="#FF99CC"><div align="right"><span class="style6 style6">职务工种:</span></div></td>
                      <td><div align="left"><span class="style6"><%=rs2.getString("ZWGZ")%></span></div></td>
                      <td bgcolor="#FF99CC"><div align="right"><span class="style6 style6">工资:</span></div></td>
                      <td><div align="left"><span class="style6"><%=rs2.getString("GZ")%></span></div></td>
                    </tr>
                    <tr>
                      <td bgcolor="#FF99CC"><div align="right"><span class="style6 style6">工作单位:</span></div></td>
                      <td colspan="3"><div align="left"><span class="style6"><%=rs2.getString("GZDW")%></span></div></td>
                      <td bgcolor="#FF99CC"><div align="right"><span class="style6 style6">经济来源:</span></div></td>
                      <td colspan="3"><div align="left"><span class="style6"><%=rs2.getString("JJLY")%></span></div></td>
                    </tr>
                  <%}%>
				   <tr><td colspan="8">
                  <div align="center">
                    <%
		  int shgx=0;
		  String newcondition3="select * from SHGX where BH="+"'"+bh+"'";
		  conn.setcondition(newcondition3);
		  ResultSet rs3=conn.getrs();
		  while(rs3.next())
		  {shgx++;}
		  if(shgx==0){out.print("无社会关系记录！");}
		  else
		  {out.print(rs.getString("XM"));out.print("的社会关系表：");}
		   conn.setcondition(newcondition3);
		   rs3=conn.getrs();
		   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 width="70" 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">
                    <%
		  int grjl=0;
		  String newcondition4="select * from GRJL where BH="+"'"+bh+"'";
		  conn.setcondition(newcondition4);
		  ResultSet rs4=conn.getrs();
		  while(rs4.next())
		  {grjl++;}
		  if(grjl==0){out.print("无个人简历！");}
		  else
		  {out.print(rs.getString("XM"));out.print("的个人简历：");}
		   conn.setcondition(newcondition4);
		   rs4=conn.getrs();
		   while(rs4.next())  
		  {
		%>
                  </div>
				  </td></tr>
                  <table border="1" align="center" cellspacing="1" bordercolor="#FF99CC">
                    <tr>
                      <td bgcolor="#FF99CC" class="style6"><div align="right">前工作单位:</div></td>
                      <td class="style6"><div align="left"><%=rs4.getString("GZDW")%></div></td>
                      <td bgcolor="#FF99CC" class="style6"><div align="right">起止年月:

 
</div></td>
                      <td colspan="3" class="style6"><div align="left"><%=rs4.getString("QZNY")%></div></td>
                      <td bgcolor="#FF99CC" class="style6"><div align="right">证明人:</div></td>
                      <td class="style6"><div align="left"><%=rs4.getString("ZMR")%></div></td>
                    </tr>
                  <%}%>
		<%}%>
		    </table>
		</td>
              </tr>	
</table>
	<%}%>
		<script language="javascript">
			window.focus();window.print();
		</script>
	<%}%>
</body>
</html>