rs_cx_card.jsp
来自「JSP页面和oracle9i数据库的源代码」· JSP 代码 · 共 1,807 行 · 第 1/5 页
JSP
1,807 行
<div align="center">
<input name="cjgzsj" type="checkbox" id="cjgzsj" value="checkbox">
参加工作时间:
<input name="cjgzsj_min_year" type="text" id="cjgzsj_min_year" size="4" maxlength="4" onchange="oncjgzsj()">
年
<select name="cjgzsj_min_month" id="cjgzsj_min_month" onchange="oncjgzsj()">
<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>
月
<select name="cjgzsj_min_day" id="select4" onchange="oncjgzsj()">
<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>
日至
<input name="cjgzsj_max_year" type="text" id="cjgzsj_max_year" size="4" maxlength="4" onchange="oncjgzsj()">
年
<select name="cjgzsj_max_month" id="select7" onchange="oncjgzsj()">
<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>
月
<select name="cjgzsj_max_day" id="select8" onchange="oncjgzsj()">
<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>
日之间</div></td></tr>
<tr>
<td colspan="4" nowrap>
<div align="center">
<input name="jbdwsj" type="checkbox" id="jbdwsj" value="checkbox">
进本单位时间:
<input name="jbdwsj_min_year" type="text" id="jbdwsj_min_year" size="4" maxlength="4" onChange="onjbdwsj()">
年
<select name="jbdwsj_min_month" id="select9">
<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>
月
<select name="jbdwsj_min_day" id="select10" onChange="onjbdwsj()">
<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>
日至
<input name="jbdwsj_max_year" type="text" id="jbdwsj_max_year" size="4" maxlength="4" onChange="onjbdwsj()">
年
<select name="jbdwsj_max_month" id="select11" onChange="onjbdwsj()">
<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>
月
<select name="jbdwsj_max_day" id="select12" onChange="onjbdwsj()">
<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>
日之间</div></td></tr>
<tr>
<td colspan="2" nowrap><div align="center">
<input name="Submit" type="submit" id="Submit" value="查询">
</div></td>
<td colspan="2" nowrap><div align="center">
<input type="reset" name="Submit3" value="重置">
</div></td>
</tr>
</table>
<%}%>
<%if(!way.equals("")){out.print("<hr align=center width=1000 color=#FF99CC>");}%>
</div>
</form>
<div align="center">
<%
String newcondition=request.getParameter("newcondition");
if(newcondition==null){newcondition="";}
if(way.equals("tj_bh"))
{ String bh=request.getParameter("bh");
if(bh==null){bh="";}
else
{ newcondition="select * from ZGXX where BH='"+bh+"'";
}
}
if(way.equals("tj_xm"))
{ String xm=request.getParameter("xm");
if(xm==null){xm="";}
else
{ newcondition="select * from ZGXX where XM LIKE '%"+xm+"%'";
String bm=request.getParameter("bm");
if(bm==null){bm="";}
else
{ if(bm.equals("0")){}
else
{ newcondition=newcondition+" and BM='"+bm+"'";
}
}
}
}
if(way.equals("tj_jtzz"))
{ String jtzz=request.getParameter("jtzz");
if(jtzz==null){jtzz="";}
else
{
newcondition="select * from ZGXX where JTZZ LIKE"+"'%"+jtzz+"%'";
String bm=request.getParameter("bm");
if(bm==null){bm="";}
else
{ if(bm.equals("0")){}
else
{ newcondition=newcondition+" and BM='"+bm+"'";
}
}
}
}
if(way.equals("tj_jtdh"))
{ String jtdh=request.getParameter("jtdh");
if(jtdh==null){jtdh="";}
else
{
newcondition="select * from ZGXX where JTDH LIKE"+"'%"+jtdh+"%'";
String bm=request.getParameter("bm");
if(bm==null){bm="";}
else
{ if(bm.equals("0")){}
else
{ newcondition=newcondition+" and BM='"+bm+"'";
}
}
}
}
if(way.equals("tj_dzyj"))
{ String dzyj=request.getParameter("dzyj");
if(dzyj==null){dzyj="";}
else
{
newcondition="select * from ZGXX where DZYJ LIKE"+"'%"+dzyj+"%'";
String bm=request.getParameter("bm");
if(bm==null){bm="";}
else
{ if(bm.equals("0")){}
else
{ newcondition=newcondition+" and BM='"+bm+"'";
}
}
}
}
if(way.equals("tj_sjhm"))
{ String sjhm=request.getParameter("sjhm");
if(sjhm==null){sjhm="";}
else
{
newcondition="select * from ZGXX where SJHM LIKE"+"'%"+sjhm+"%'";
String bm=request.getParameter("bm");
if(bm==null){bm="";}
else
{ if(bm.equals("0")){}
else
{ newcondition=newcondition+" and BM='"+bm+"'";
}
}
}
}
if(way.equals("tj_zhtj"))
{ if(newcondition.equals(""))
{ String Submit=request.getParameter("Submit");
if(Submit==null){Submit="";}
else
{ conn.setcondition(Submit);
Submit=conn.toChinese();
if(Submit.equals("查询"))
{ newcondition="select * from ZGXX where bh like '%'";
String bm=request.getParameter("bm");
if(bm==null){bm="";}
else
{ if(bm.equals("0")){}
else
{ newcondition=newcondition+" and BM='"+bm+"'";
}
}
String xb=request.getParameter("xb");
if(xb==null){xb="";}
else
{ if(xb.equals("0")){}
else
{ newcondition=newcondition+" and XB='"+xb+"'";
}
}
String nl_min=request.getParameter("nl_min");
String nl_max=request.getParameter("nl_max");
if(nl_min==null){nl_min="";}
if(nl_max==null){nl_max="";}
if(nl_min.equals("")||nl_max.equals("")){}
else
{ Calendar nowday=Calendar.getInstance();
newcondition=newcondition+"and CSNY<=to_timestamp('"+(nowday.get(nowday.YEAR)-Integer.parseInt(nl_min))+"-"+(nowday.get(nowday.MONTH)+1)+"-"+nowday.get(nowday.DATE)+"','yyyy-mm-dd') and CSNY>=to_timestamp('"+(nowday.get(nowday.YEAR)-Integer.parseInt(nl_max)-1)+"-"+(nowday.get(nowday.MONTH)+1)+"-"+nowday.get(nowday.DATE)+"','yyyy-mm-dd')";
}
String whcd=request.getParameter("whcd");
if(whcd==null){whcd="";}
else
{ if(whcd.equals("0")){}
else
{ String whcd_fw=request.getParameter("whcd_fw");
if(whcd_fw==null){whcd_fw="";}
else
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?