⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 rs_update_grjl.jsp

📁 JSP页面和oracle9i数据库的源代码
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>修改个人简历</title>
<style type="text/css">
<!--
body {
	background-image: url(../img/BK155.GIF);
}
-->
</style></head>
<%
String page_type=(String)session.getAttribute("page_type");
String page_name=(String)session.getAttribute("page_name");
if(page_type==null){page_type="";}
if(session.isNew()){response.sendRedirect("../index.jsp");}
else
{	if(!page_type.equals("srs"))
	{response.sendRedirect("../index.jsp");}	
}
%>
<script language="javascript">
function  check_bh()
{	var true_false=true;
	if(document.intobh.bh.value=="")
    {	alert("请填写'所要添加家庭成员信息的职工编号!'");
        true_false=false;
    }
	return true_false;
}
function  check()
{	var true_false=true;
	if(document.add.qzny_min_year.value=="")
    {	alert("请填写'起年份'");
        true_false=false;
    }
	else
	{	if(!isAllNumber(document.add.qzny_min_year.value))
		{	alert("请填写一个全部由数字组成的'起年份'")
			true_false=false;
		}
	}
	if(document.add.qzny_max_year.value=="")
    {	alert("请填写'止年份'");
        true_false=false;
    }
	else
	{	if(!isAllNumber(document.add.qzny_max_year.value))
		{	alert("请填写一个全部由数字组成的'止年份'")
			true_false=false;
		}
	}
	if(true_false==true)
	{	var qzny_min;
		qzny_min=Math.abs(document.add.qzny_min_year.value+document.add.qzny_min_month.value);
		var qzny_max;
		qzny_max=Math.abs(document.add.qzny_max_year.value+document.add.qzny_max_month.value);
		if(qzny_min>qzny_max)
		{	alert("'起年月'应小于等于'止年月'");
			true_false=false;
		}
	}
	if(document.add.gzdw.value=="")
    {	alert("请填写'工作单位'");
        true_false=false;
    }
	if(document.add.zmr.value=="")
    {	alert("请填写'证明人'");
        true_false=false;
    }
	return true_false;
}
function isAllNumber(str)
{	var test = true;
	for(var j=0;j<str.length;j++)
	{	if(str.substring(j,j+1) != "0"&&
			str.substring(j,j+1) != "1"&&
			str.substring(j,j+1) != "2"&&
			str.substring(j,j+1) != "3"&&
			str.substring(j,j+1) != "4"&&
			str.substring(j,j+1) != "5"&&
			str.substring(j,j+1) != "6"&&
			str.substring(j,j+1) != "7"&&  
			str.substring(j,j+1) != "8"&&
			str.substring(j,j+1) != "9")
			test=false;
	}  
	return test;
}
</script>
<style>
<!--
a {text-decoration: none}
.f1          { font-size: 9pt; font-family: Verdana; line-height: 15pt }
.f2          { font-size: 8pt; font-family: Verdana; line-height: 12pt }
.style1 {
	font-size: medium;
	font-weight: bold;
}
.style2 {font-size: 14px}
.style14 {color: #FF66CC}
-->
</style>
</head>
<body>
<jsp:useBean id="conn" scope="page" class="beans.conn"/>
<jsp:include page="../index/grjl_entry_menu.jsp"></jsp:include>
<%@ page import="java.util.Calendar"%>
<%@ page import="java.text.*"%>
<%	String meb=response.encodeURL("rs_update_grjl.jsp");%>
<p align="center" class="f1"><span class="style1">修改个人简历页面</span><br>   
<%	ResultSet rs=null;
	String bh=request.getParameter("bh");
	int all=0;
	if(bh==null){bh="";}
	else
	{	String condition_bh="select * from zgxx where bh='"+bh+"'";
		conn.setcondition(condition_bh);
		ResultSet rs_zgxx=conn.getrs();
		rs_zgxx.last();
		int all_zgxx=rs_zgxx.getRow();
		condition_bh="select * from txzgxx where bh='"+bh+"'";
		conn.setcondition(condition_bh);
		ResultSet rs_txzgxx=conn.getrs();
		rs_txzgxx.last();
		int all_txzgxx=rs_txzgxx.getRow();
		all=all_zgxx+all_txzgxx;
		if(all>1)
		{out.print("<center>出现职工编号重复错误!请予管理员联系!</center>");}
		else
		{	if(all==0){if(bh.equals("")){out.print("<center>您还没有输入编号,请输入!</center>");}else{out.print("<center>没有编号为"+bh+"的职工,请重新填写</center>");}}
			if(all==1)
			{	if(all_zgxx==1){rs=rs_zgxx;}
				if(all_txzgxx==1){rs=rs_txzgxx;}
			}
		}
	}
	if(bh.equals("")||all!=1)
	{	
%>
<form action="<%=meb%>" method="post" name="intobh" id="intobh" onSubmit="return check_bh()">
  <div align="center">请填写所要修改'个人简历'的'职工'的编号
    <input name="bh" type="text" id="bh" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" size="15" maxlength="15">    
      <input type="submit" name="Submit3" value="确定">
</div></form>
<%	}
	else
	{	rs.first();
		String condition_grjl="select * from grjl where bh='"+bh+"'";
		conn.setcondition(condition_grjl);
		ResultSet rs_grjl=conn.getrs();
		rs_grjl.last();
		int all_grjl=rs_grjl.getRow();
		if(all_grjl==0){out.print("<center>"+bh+"号"+rs.getString("XM")+"没有社会关系</center>");}
		else
		{	out.print("<center>找到"+bh+"号"+rs.getString("XM")+"社会关系记录共"+all_grjl+"个</center>");
			String pageNO=request.getParameter("pageNO");
			if(pageNO==null){pageNO="1";}
			int pageNO_c=Integer.parseInt(pageNO);
			int pagecount=1,pageall=0,i=0;
			if(all_grjl<=pagecount){pageall=1;}
			else
			{	int lastcount=0;
				lastcount=all_grjl%pagecount;
				if(lastcount==0){pageall=all_grjl/pagecount;}
				else{pageall=all_grjl/pagecount+1;}
			}
			rs_grjl.beforeFirst();
			for(i=0;i<(pageNO_c-1)*pagecount;i++){rs_grjl.next();}
%>
			<div align="center">
			第<%=pageNO_c%>页
			<%if(pageNO_c>1){String page_send=Integer.toString(1);%>
			<a href="<%=meb%>?pageNO=<%=page_send%>&bh=<%=bh%>">第一页</a>
			<%}%>
			<%if(pageNO_c>1){String page_send=Integer.toString(pageNO_c-1);%>
			<a href="<%=meb%>?pageNO=<%=page_send%>&bh=<%=bh%>">上一页</a>
			<%}%>			
			<%if(pageNO_c<pageall){String page_send=Integer.toString(pageNO_c+1);%>
			<a href="<%=meb%>?pageNO=<%=page_send%>&bh=<%=bh%>">下一页</a>
			<%}%>
			<%if(pageNO_c<pageall){String page_send=Integer.toString(pageall);%>
			<a href="<%=meb%>?pageNO=<%=page_send%>&bh=<%=bh%>">最末页</a>
			<%}%>
			共<%=pageall%>页
			</div>
			<%for(i=0;i<pagecount;i++)
			{	if(!rs_grjl.next()){break;}
			%> 
<form <%String meb_rs_update_grjl_sav=response.encodeURL("rs_update_grjl_sav.jsp");%>action="<%=meb_rs_update_grjl_sav%>?pageNO=<%=pageNO%>" method="post" name="add" id="add" onSubmit="return check()">
<table border="0" cellspacing="2" cellpadding="0" align="center">
  <!--DWLayoutTable-->
  <tr>
    <td width="84" nowrap class="f1"><div align="right" class="style2">职工编号:</div></td>
    <td colspan="2" nowrap><div align="left"><span class="style14"><%=rs.getString("bh")%>
          <input name="bh" type="hidden" id="bh" value="<%=bh%>">
    </span></div></td>
  </tr>
  <tr>
    <td nowrapclass="f1"><div align="right" class="style2">职工姓名:</div></td>
    <td colspan="2" nowrap>	<div align="left"><%=rs.getString("xm")%>
        <input name="xm" type="hidden" id="xm" value="<%=rs.getString("xm")%>">
</div></td>
  </tr>
  <tr>
    <td nowrap class="f1"><div align="right" class="style2">
      起止年月:</div></td>
    <td colspan="2" nowrap>
      <div align="left">        
        <p>
          <%String qzny=rs_grjl.getString("QZNY");
		  	String qzny_min_year="",qzny_min_month="",qzny_max_year="",qzny_max_month="";
			int j=0;
			for(j=0;j<qzny.length();j++)
			{	if(qzny.substring(j,j+1).equals("年")){break;}
				else
				{qzny_min_year=qzny_min_year+qzny.substring(j,j+1);}
			}
			for(j=j+1;j<qzny.length();j++)
			{	if(qzny.substring(j,j+1).equals("月")){break;}
				else
				{qzny_min_month=qzny_min_month+qzny.substring(j,j+1);}
			}
			for(j=j+2;j<qzny.length();j++)
			{	if(qzny.substring(j,j+1).equals("年")){break;}
				else
				{qzny_max_year=qzny_max_year+qzny.substring(j,j+1);}
			}
			for(j=j+1;j<qzny.length();j++)
			{	if(qzny.substring(j,j+1).equals("月")){break;}
				else
				{qzny_max_month=qzny_max_month+qzny.substring(j,j+1);}
			}
		  %>
		  <input name="qzny_min_year" type="text" id="qzny_min_year" size="4" maxlength="4" value="<%=qzny_min_year%>">
          <select name="qzny_min_month" id="select26">
		  	  <option value="<%=qzny_min_month%>"><%=qzny_min_month%></option>
              <option value="1">1</option>
              <option value="2">2</option>
              <option value="3">3</option>
              <option value="4">4</option>
              <option value="5">5</option>
              <option value="6">6</option>
              <option value="7">7</option>
              <option value="8">8</option>
              <option value="9">9</option>
              <option value="10">10</option>
              <option value="11">11</option>
              <option value="12">12</option>
          </select>
          月至<br>
          <input name="qzny_max_year" type="text" id="qzny_max_year" size="4" maxlength="4" value="<%=qzny_max_year%>">
    <select name="qzny_max_month" id="qzny_max_month">
			<option value="<%=qzny_max_month%>"><%=qzny_max_month%></option>
            <option value="1">1</option>
            <option value="2">2</option>
            <option value="3">3</option>
            <option value="4">4</option>
            <option value="5">5</option>
            <option value="6">6</option>
            <option value="7">7</option>
            <option value="8">8</option>
            <option value="9">9</option>
            <option value="10">10</option>
            <option value="11">11</option>
            <option value="12">12</option>
    </select>
    <input name="yqzny" type="hidden" id="yqzny" value="<%=qzny%>">
        </p>
        </div></td>
  </tr>
  <tr>
    <td nowrapclass="f1"><div align="right" class="style2">
      工作单位:</div></td>
    <td colspan="2" nowrap>      <div align="left">
        <input name="gzdw" type="text" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" value="<%=rs_grjl.getString("GZDW")%>" maxlength="10">
        <input name="ygzdw" type="hidden" id="ygzdw" value="<%=rs_grjl.getString("GZDW")%>">
      </div></td>
  </tr>
  <tr>
    <td nowrapclass="f1"><div align="right" class="style2">
      证明人:</div></td>
    <td colspan="2" nowrap><div align="left">
      <input name="zmr" type="text" id="zmr" value="<%=rs_grjl.getString("ZMR")%>" maxlength="4">
</div></td>
  </tr>
  <tr>
    <td nowrap><div align="center">
      <input name="Submit" type="submit" id="Submit" value="提交" width="388">
    </div></td>
    <td width="98" nowrap >        
          <div align="center">           </div></td>
    <td width="76" nowrap ><div align="center">
      <input type="reset" name="Submit2" value="重置">
    </div></td>
  </tr>
</table>
<br>
</form>
<%			}
		}
	}
%>
<jsp:include page="../checkout.jsp"></jsp:include>
</body>
</html>

⌨️ 快捷键说明

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