rs_del_all.jsp

JSP页面和oracle9i数据库的源代码

											birthday.setTime(rs_all.getDate("CSNY"));
											Calendar day=Calendar.getInstance();
											int age=0;
											age=day.get(day.YEAR)-birthday.get(birthday.YEAR);
											if(day.get(day.MONTH)<birthday.get(birthday.MONTH)){age--;}
											if(day.get(day.MONTH)==birthday.get(birthday.MONTH))
											{if(day.get(day.DATE)<birthday.get(birthday.DATE)){age--;}}
										%>
		      <%=age%></td>
			  <td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4"><span class="style1">所在部门:</span></div></td>
			  <td height="20" nowrap><%=rs_all.getString("BM")%></td>
			  <td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4"><span class="style1">现任职务:</span></div></td>
			  <td height="20" nowrap><%=rs_all.getString("XRZW")%></td>
			  <td nowrap bordercolor="#FF99CC"><a <%String page_send=Integer.toString(pageNO_c);%>href="<%=meb%>?bh=<%=rs_all.getString("bh")%>&pageNO=<%=page_send%>">详细信息...</a></td>
		  </tr>
		  <%}%>
		  <%if(bh.equals(rs_all.getString("BH")))
			{%>
			<tr>
			  <td nowrap bgcolor="#FF99CC"><input name="<%=rs_all.getString("BH")%>" type="checkbox" id="<%=rs_all.getString("BH")%>" value="<%=rs_all.getString("BH")%>"></td>
			  <td height="20" colspan="13" nowrap bgcolor="#FFFFFF"><table border="1" align="center" cellspacing="1" bordercolor="#FF99CC">
                <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_all.getString("BH")%></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_all.getString("XM")%></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_all.getString("XB")%></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>
                    <%	Calendar birthday=Calendar.getInstance();	
						birthday.setTime(rs_all.getDate("CSNY"));
						Calendar day=Calendar.getInstance();
						int age=0;
						age=day.get(day.YEAR)-birthday.get(birthday.YEAR);
						if(day.get(day.MONTH)<birthday.get(birthday.MONTH)){age--;}
						if(day.get(day.MONTH)==birthday.get(birthday.MONTH))
						{if(day.get(day.DATE)<birthday.get(birthday.DATE)){age--;}}
					%>
                    <%=age%></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_all.getString("BM")%></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_all.getString("XRZW")%></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_all.getDate("CSNY")%></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_all.getString("MZ")%></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_all.getString("JG")%></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_all.getString("ZZMM")%></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_all.getString("ZC")%></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>
                    <%  int xl=rs_all.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")%></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_all.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_all.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_all.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_all.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_all.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_all.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_all.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_all.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_all.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_all.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_all.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_all.getString("JTZZ")%></td>
                </tr>
                <tr bgcolor="#FF99CC">
                  <td height="20" colspan="8" nowrap><div align="center" class="style5">备注：</div></td>
                </tr>
                <tr>
                  <td colspan="8"><%=rs_all.getString("BZ")%></td>
                </tr>
              </table></td>
		  </tr>
		<%}%>
<%		}%>
		  <tr>
			<td height="20" colspan="9" nowrap><div align="center">
			<input type="submit" name="Submit" value="删除所选项">
			</div></td>
		    <td height="20" colspan="5" nowrap><div align="center">
		    <input type="reset" name="Submit2" value="重新选择">
		    </div></td>
	      </tr>
  		</table>
	</form>
<%	}
%>
<%}%>
<jsp:include page="../checkout.jsp"></jsp:include>
</body>
</html>