rs_cx_zc.jsp

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

JSP
405 行
字号
12
                    <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>
					  <div align="left">
				        <%  int xl=rs.getInt("WHCD");
						String condition_xl="select * from XL where XLBH="+"'"+xl+"'";
						conn.setcondition(condition_xl);
						ResultSet rs_xl=conn.getrs();
						rs_xl.next();
					%>
				        <%=rs_xl.getString("XLMC")%></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" nowrap><div align="left"><%=rs.getString("JKZK")%></div></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><div align="left"><%=rs.getString("HYZK")%></div></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><div align="left"><%=rs.getDate("CJGZSJ")%></div></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><div align="left"><%=rs.getDate("JBDWSJ")%></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" nowrap><div align="left"><%=rs.getString("GZ")%></div></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><div align="left"><%=rs.getString("GZBT")%></div></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><div align="left"><%=rs.getString("GRCF")%></div></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><div align="left"><%=rs.getString("JTDH")%></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" nowrap><div align="left"><%=rs.getString("SJHM")%></div></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><div align="left"><%=rs.getString("JTCS")%></div></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="left"><%=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><div align="left"><%=rs.getString("JTZZ")%></div></td>
                  </tr>
                  <tr bgcolor="#FF99CC">
                    <td height="20" colspan="8" nowrap><div align="center" class="style5">备注：</div></td>
                  </tr>
                  <tr>
                    <td colspan="8"><%=rs.getString("BZ")%></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 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="left"><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="left"><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="left"><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="left"><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>
		<%}%>
		
		<div align="center">        
        <%bh=rs.getString("BH");
		  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>
                        <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">        
        <%bh=rs.getString("BH");
		  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 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 colspan="3" nowrap 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>
					<hr align="center" width="90%">
	<%}%>	
<%
		}
	}
}
%>
<%}%>
<%}
  else
  {out.print(trypage);}
%>
<jsp:include page="../checkout.jsp"></jsp:include>
</body>
</html>
12

rs_cx_zc.jsp - 源码说明

本页面展示了「JSP页面和oracle9i数据库的源代码」中的 rs_cx_zc.jsp 源码文件，采用 JSP 编程语言编写，共 405 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫开发者社区收录了大量与JSP相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?