rs_add_jtcy.jsp

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

JSP
463 行
字号
12
.f1          { font-size: 9pt; font-family: Verdana; line-height: 15pt }
.f2          { font-size: 8pt; font-family: Verdana; line-height: 12pt }
.style11 {
	font-size: 12;
	font-family: Verdana;
	line-height: 15pt;
	font-weight: bold;
}
.style12 {font-size: 14px}
.style14 {color: #FF66CC}
body {
	background-image: url(../img/093.gif);
}
-->
</style>
</head>
<body>
</div>
<jsp:useBean id="conn" scope="page" class="beans.conn"/>
<jsp:include page="../index/jtcy_entry_muen.jsp"></jsp:include>
<%@ page import="java.util.Calendar"%>
<%@ page import="java.text.*"%>
<%	String meb=response.encodeURL("rs_add_jtcy.jsp");%>
<div align="center"><span class="style11">添加家庭成员页面</span>
<%	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();
%>
<form <%String meb_rs_add_jtcy_sav=response.encodeURL("rs_add_jtcy_sav.jsp");%>action="<%=meb_rs_add_jtcy_sav%>" method=post name="add" id="add" onSubmit="return check()">
<table border="0" cellspacing="2" cellpadding="0" align="center">
 
  <tr>
    <td nowrap class="style12"><div align="right"> 职工&#32534;&#21495;:</div></td>
    <td colspan="3" 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 nowrap class="style12"><div align="right">职工&#22995;&#21517;:</div></td>
    <td colspan="3" nowrap><div align="left"><%=rs.getString("xm")%>
          <input name="xm" type="hidden" id="xm" value="<%=rs.getString("xm")%>">
    </div></td>
  </tr>
  <tr>
    <td class="style12" nowrapclass="f1"><div align="right">&#25104;&#21592;&#22995;&#21517;:</div></td>
    <td colspan="3" nowrap>
      <div align="left">
        <input name="cyxm" 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" maxlength="4">
      </div></td>
  </tr>
  <tr>
    <td height="30" nowrap class="style12"><div align="right">&#23478;&#23646;&#20851;&#31995;:</div></td>
    <td colspan="3" nowrap><div align="left">
      <input name="jsgx" 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" maxlength="3">
    </div></td>
  </tr>
  <tr>
    <td height="30" nowrap class="style12"><div align="right">&#20986;&#29983;&#24180;&#26376;:</div></td>
    <td colspan="3" nowrap>
          
		  <div align="left">
  <input name="csny_year" type="text" id="csny_year2" size="4" maxlength="4" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(255,255,255) 0px solid; BORDER-RIGHT: rgb(255,255,255) 0px solid; BORDER-TOP: rgb(255,255,255) 0px solid">
&#24180;          
  <select name="csny_month" id="select26" onChange="oncsny()">
      <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> 
&#26376;
  <select name="csny_day" id="select27" onChange="oncsny()">
      <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>
      <option value="13">13</option>
      <option value="14">14</option>
      <option value="15">15</option>
      <option value="16">16</option>
      <option value="17">17</option>
      <option value="18">18</option>
      <option value="19">19</option>
      <option value="20">20</option>
      <option value="21">21</option>
      <option value="22">22</option>
      <option value="23">23</option>
      <option value="24">24</option>
      <option value="25">25</option>
      <option value="26">26</option>
      <option value="27">27</option>
      <option value="28">28</option>
      <option value="29">29</option>
      <option value="30">30</option>
      <option value="31">31</option>
  </select> 
&#26085;
          </div></td>		
  </tr>
  <tr>
    <td height="30" nowrap class="style12"><div align="right">&#23130;&#23035;&#29366;&#20917;:</div></td>
    <td colspan="3" nowrap><div align="left">
      <select name="hyzk" id="hyzk">
          <option value="0">--未选定--</option>
          <option value="未婚">&#26410;&#23130;</option>
          <option value="已婚">&#24050;&#23130;</option>
          <option value="离异">&#31163;&#24322;</option>
      </select>
    </div></td>
  </tr>
  <tr>
    <td height="30" nowrap class="style12"><div align="right">&#25991;&#21270;&#31243;&#24230;:</div></td>
    <td colspan="3" nowrap><div align="left">
      <select name="whcd" id="select15">
          <option value="0">--未选择--</option>
          <%String condition_xl="select * from XL";
		  	conn.setcondition(condition_xl);
			ResultSet rs_xl=conn.getrs();
			while(rs_xl.next())
			{
		    %>
          <option value="<%=rs_xl.getString("XLMC")%>"><%=rs_xl.getString("XLMC")%></option>
          <%}%>
      </select>
    </div></td>
  </tr>
  <tr>
    <td height="30" nowrap class="style12"><div align="right">&#25919;&#27835;&#38754;&#35980;:</div></td>
    <td colspan="3" nowrap><div align="left">
      <select name="zzmm" id="select22">
          <option value="0">--未选择--</option>
          <option value="党员">党员</option>
          <option value="团员">团员</option>
          <option value="群众">群众</option>
          <option value="少先队员">少先队员</option>
      </select>
    </div></td>
  </tr>
  <tr>
    <td height="30" nowrap class="style12"><div align="right">&#24037;&#20316;&#21333;&#20301;:</div></td>
    <td colspan="3" nowrap><div align="left">
      <input type="text" name="gzdw" 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">
    </div></td>
  </tr>
  <tr>
    <td height="30" nowrap class="style12"><div align="right">&#32844;&#21153;&#24037;&#31181;:</div></td>
    <td colspan="3" nowrap><div align="left">
      <input type="text" name="zwgz" 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">
    </div></td>
  </tr>
  <tr>
    <td height="27" nowrap class="style12"><div align="right">&#24037;&#36164;:</div></td>
    <td colspan="3" nowrap><div align="left">
      <input name="gz" 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" maxlength="9">
    </div></td>
  </tr>
  <tr>
    <td height="27" nowrap class="style12"><div align="right">&#32463;&#27982;&#26469;&#28304;:</div></td>
    <td colspan="3" nowrap><div align="left">
      <input type="text" name="jjly" 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">
    </div></td>
  </tr>

  <tr>
    <td colspan="2" nowrap class="f1">      
        <div align="center">
          <input type="submit" name="Submit" value="&#25552;&#20132;">
        </div></td>
    <td width="121" nowrap class="f1"><div align="center"></div></td>
    <td width="62" nowrap class="f1"><div align="center">
      <input type="reset" name="Submit2" value="&#37325;&#32622;">
    </div></td>
  </tr>
</table>
<br>
</center>
</form>
<%	}%>
</body>
<jsp:include page="../checkout.jsp"></jsp:include>
</html>
12

rs_add_jtcy.jsp - 源码说明

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

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

⌨️ 快捷键说明

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