rs_print_gr.jsp

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

                    <td nowrap><span class="style6"><%=rs.getString("GZBT")%></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("GRCF")%></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("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">        
        <%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>
                       <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>
		<%}%>
		<%}%>	
		<script language="javascript">
			window.focus();window.print();
		</script>
	<%}%>

</body>
</html>