rs_cx_card.jsp
来自「JSP页面和oracle9i数据库的源代码」· JSP 代码 · 共 1,807 行 · 第 1/5 页
JSP
1,807 行
{ if(whcd_fw.equals("1"))
{newcondition=newcondition+" and WHCD="+Integer.parseInt(whcd);}
if(whcd_fw.equals("2"))
{newcondition=newcondition+" and WHCD>="+Integer.parseInt(whcd);}
if(whcd_fw.equals("0"))
{newcondition=newcondition+" and WHCD<="+Integer.parseInt(whcd);}
}
}
}
String jg=request.getParameter("jg");
if(jg==null){jg="";}
else
{ if(jg.equals("0")){}
else
{ newcondition=newcondition+" and JG='"+jg+"'";
}
}
String mz=request.getParameter("mz");
if(mz==null){mz="";}
else
{ if(mz.equals("0")){}
else
{ newcondition=newcondition+" and MZ='"+mz+"'";
}
}
String jkzk=request.getParameter("jkzk");
if(jkzk==null){jkzk="";}
else
{ if(jkzk.equals("0")){}
else
{ newcondition=newcondition+" and JKZK='"+jkzk+"'";
}
}
String hyzk=request.getParameter("hyzk");
if(hyzk==null){hyzk="";}
else
{ if(hyzk.equals("0")){}
else
{ newcondition=newcondition+" and HYZK='"+hyzk+"'";
}
}
String zc=request.getParameter("zc");
if(zc==null){zc="";}
else
{ if(zc.equals("0")){}
else
{ newcondition=newcondition+" and ZC='"+zc+"'";
}
}
String jtcs=request.getParameter("jtcs");
if(jtcs==null){jtcs="";}
else
{ if(jtcs.equals("0")){}
else
{ newcondition=newcondition+" and JTCS='"+jtcs+"'";
}
}
String zzmm=request.getParameter("zzmm");
if(zzmm==null){zzmm="";}
else
{ if(zzmm.equals("0")){}
else
{ newcondition=newcondition+" and ZZMM='"+zzmm+"'";
}
}
String grcf=request.getParameter("grcf");
if(grcf==null){grcf="";}
else
{ if(grcf.equals("0")){}
else
{ newcondition=newcondition+" and GRCF='"+grcf+"'";
}
}
String csny=request.getParameter("csny");
if(csny==null){csny="";}
else
{ String csny_min_year=request.getParameter("csny_min_year");
String csny_min_month=request.getParameter("csny_min_month");
String csny_min_day=request.getParameter("csny_min_day");
String csny_max_year=request.getParameter("csny_max_year");
String csny_max_month=request.getParameter("csny_max_month");
String csny_max_day=request.getParameter("csny_max_day");
int csny_min_year_c=Integer.parseInt(csny_min_year);
int csny_min_month_c=Integer.parseInt(csny_min_month);
int csny_min_day_c=Integer.parseInt(csny_min_day);
int csny_max_year_c=Integer.parseInt(csny_max_year);
int csny_max_month_c=Integer.parseInt(csny_max_month);
int csny_max_day_c=Integer.parseInt(csny_max_day);
newcondition=newcondition+"and CSNY>=to_timestamp('"+csny_min_year_c+"-"+csny_min_month_c+"-"+csny_min_day_c+"','yyyy-mm-dd') and CSNY<=to_timestamp('"+csny_max_year_c+"-"+csny_max_month_c+"-"+csny_max_day_c+"','yyyy-mm-dd')";
}
String cjgzsj=request.getParameter("cjgzsj");
if(cjgzsj==null){cjgzsj="";}
else
{ String cjgzsj_min_year=request.getParameter("cjgzsj_min_year");
String cjgzsj_min_month=request.getParameter("cjgzsj_min_month");
String cjgzsj_min_day=request.getParameter("cjgzsj_min_day");
String cjgzsj_max_year=request.getParameter("cjgzsj_max_year");
String cjgzsj_max_month=request.getParameter("cjgzsj_max_month");
String cjgzsj_max_day=request.getParameter("cjgzsj_max_day");
int cjgzsj_min_year_c=Integer.parseInt(cjgzsj_min_year);
int cjgzsj_min_month_c=Integer.parseInt(cjgzsj_min_month);
int cjgzsj_min_day_c=Integer.parseInt(cjgzsj_min_day);
int cjgzsj_max_year_c=Integer.parseInt(cjgzsj_max_year);
int cjgzsj_max_month_c=Integer.parseInt(cjgzsj_max_month);
int cjgzsj_max_day_c=Integer.parseInt(cjgzsj_max_day);
newcondition=newcondition+"and CJGZSJ>=to_timestamp('"+cjgzsj_min_year_c+"-"+cjgzsj_min_month_c+"-"+cjgzsj_min_day_c+"','yyyy-mm-dd') and CJGZSJ<=to_timestamp('"+cjgzsj_max_year_c+"-"+cjgzsj_max_month_c+"-"+cjgzsj_max_day_c+"','yyyy-mm-dd')";
}
String jbdwsj=request.getParameter("jbdwsj");
if(jbdwsj==null){jbdwsj="";}
else
{ String jbdwsj_min_year=request.getParameter("jbdwsj_min_year");
String jbdwsj_min_month=request.getParameter("jbdwsj_min_month");
String jbdwsj_min_day=request.getParameter("jbdwsj_min_day");
String jbdwsj_max_year=request.getParameter("jbdwsj_max_year");
String jbdwsj_max_month=request.getParameter("jbdwsj_max_month");
String jbdwsj_max_day=request.getParameter("jbdwsj_max_day");
int jbdwsj_min_year_c=Integer.parseInt(jbdwsj_min_year);
int jbdwsj_min_month_c=Integer.parseInt(jbdwsj_min_month);
int jbdwsj_min_day_c=Integer.parseInt(jbdwsj_min_day);
int jbdwsj_max_year_c=Integer.parseInt(jbdwsj_max_year);
int jbdwsj_max_month_c=Integer.parseInt(jbdwsj_max_month);
int jbdwsj_max_day_c=Integer.parseInt(jbdwsj_max_day);
newcondition=newcondition+"and JBDWSJ>=to_timestamp('"+jbdwsj_min_year_c+"-"+jbdwsj_min_month_c+"-"+jbdwsj_min_day_c+"','yyyy-mm-dd') and JBDWSJ<=to_timestamp('"+jbdwsj_max_year_c+"-"+jbdwsj_max_month_c+"-"+jbdwsj_max_day_c+"','yyyy-mm-dd')";
}
}
}
}
}
if(way.equals("all"))
{ if(newcondition.equals("")){newcondition="select * from ZGXX";}}
if(!newcondition.equals(""))
{ conn.setcondition(newcondition);
newcondition=conn.toChinese();out.print(newcondition);
conn.setcondition(newcondition);
ResultSet rs=conn.getrs();
rs.last();
int all=0;
String ts=request.getParameter("ts");
if(ts==null){ts="";}
conn.setcondition(ts);
ts=conn.toChinese();
all=rs.getRow();
if(way.equals("tj_bh"))
{ if(ts.equals(""))
{ String bh=request.getParameter("bh");
if(bh==null){bh="";}
conn.setcondition(bh);
bh=conn.toChinese();
ts="找到编号为"+bh+"的职工共"+Integer.toString(all)+"人";
}
}
if(way.equals("tj_xm"))
{ if(ts.equals(""))
{ String xm=request.getParameter("xm");
if(xm==null){xm="";}
conn.setcondition(xm);
xm=conn.toChinese();
String bm=request.getParameter("bm");
if(bm==null){bm="";}
conn.setcondition(bm);
bm=conn.toChinese();
ts="找到姓名中含有'"+xm+"'字的职工共"+Integer.toString(all)+"人";
if(!bm.equals("0"))
{ ts="在'"+bm+"'中,"+ts;
}
}
}
if(way.equals("tj_jtzz"))
{ if(ts.equals(""))
{ String jtzz=request.getParameter("jtzz");
if(jtzz==null){jtzz="";}
conn.setcondition(jtzz);
jtzz=conn.toChinese();
String bm=request.getParameter("bm");
if(bm==null){bm="";}
conn.setcondition(bm);
bm=conn.toChinese();
ts="找到家庭住址中含有'"+jtzz+"'字的职工共"+Integer.toString(all)+"人";
if(!bm.equals("0"))
{ ts="在'"+bm+"'中,"+ts;
}
}
}
if(way.equals("tj_jtdh"))
{ if(ts.equals(""))
{ String jtdh=request.getParameter("jtdh");
if(jtdh==null){jtdh="";}
conn.setcondition(jtdh);
jtdh=conn.toChinese();
String bm=request.getParameter("bm");
if(bm==null){bm="";}
conn.setcondition(bm);
bm=conn.toChinese();
ts="找到家庭电话中含有'"+jtdh+"'字的职工共"+Integer.toString(all)+"人";
if(!bm.equals("0"))
{ ts="在'"+bm+"'中,"+ts;
}
}
}
if(way.equals("tj_dzyj"))
{ if(ts.equals(""))
{ String dzyj=request.getParameter("dzyj");
if(dzyj==null){dzyj="";}
conn.setcondition(dzyj);
dzyj=conn.toChinese();
String bm=request.getParameter("bm");
if(bm==null){bm="";}
conn.setcondition(bm);
bm=conn.toChinese();
ts="找到电子邮件地址中含有'"+dzyj+"'字的职工共"+Integer.toString(all)+"人";
if(!bm.equals("0"))
{ ts="在'"+bm+"'中,"+ts;
}
}
}
if(way.equals("tj_sjhm"))
{ if(ts.equals(""))
{ String sjhm=request.getParameter("sjhm");
if(sjhm==null){sjhm="";}
conn.setcondition(sjhm);
sjhm=conn.toChinese();
String bm=request.getParameter("bm");
if(bm==null){bm="";}
conn.setcondition(bm);
bm=conn.toChinese();
ts="找到手机号码中含有'"+sjhm+"'字的职工共"+Integer.toString(all)+"人";
if(!bm.equals("0"))
{ ts="在'"+bm+"'中,"+ts;
}
}
}
if(way.equals("all"))
{ ts="全部正式职工卡片信息";}
out.print(ts);
rs.beforeFirst();
String pageNO=request.getParameter("pageNO");
if(pageNO==null){pageNO="1";}
int pageNO_c=Integer.parseInt(pageNO);
int pagecount=1,pageall=0,k=0;
if(all<=10){pagecount=1;}
else{pagecount=10;}
if(all<=pagecount){pageall=1;}
else
{ int lastcount=0;
lastcount=all%pagecount;
if(lastcount==0){pageall=all/pagecount;}
else{pageall=all/pagecount+1;}
}
rs.beforeFirst();
for(k=0;k<(pageNO_c-1)*pagecount;k++){rs.next();}
%>
<table align="center">
<tr align="center" valign="top">
<td valign="baseline" nowrap><%if(all!=0){out.print("第");out.print(pageNO_c);out.print("页:");}%></td>
<td valign="baseline" nowrap>
<%if(pageall>1){%>
<form action="<%=meb%>?way=<%=way%>&ts=<%=ts%>" method="post">
<div align="center">
跳转到
<select name="pageNO">
<%for(k=1;k<=pageall;k++){%>
<option value="<%=k%>">第<%=k%>页</option>
<%}%>
</select>
<input name="确定" type="submit" value="确定">
<input type="hidden" name="newcondition" value="<%=newcondition%>">
</div>
</form>
<%}%></td>
<td valign="baseline" nowrap>
<%if(pageNO_c>1){String page_send=Integer.toString(1);%>
<form name="first" method="post" action="<%=meb%>?way=<%=way%>&ts=<%=ts%>&pageNO=<%=page_send%>">
<input name="first" type="submit" id="first" value="第一页" style="BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 2px solid; BORDER-LEFT: rgb(255,255,255) 2px solid; BORDER-RIGHT: rgb(255,255,255) 2px solid; BORDER-TOP: rgb(255,255,255) 2px solid">
<input type="hidden" name="newcondition" value="<%=newcondition%>">
</form>
<%}%> </td>
<td valign="baseline" nowrap>
<%if(pageNO_c>1){String page_send=Integer.toString(pageNO_c-1);%>
<form name="before" method="post" action="<%=meb%>?way=<%=way%>&ts=<%=ts%>&pageNO=<%=page_send%>">
<input name="before" type="submit" id="before" value="上一页"style="BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 2px solid; BORDER-LEFT: rgb(255,255,255) 2px solid; BORDER-RIGHT: rgb(255,255,255) 2px solid; BORDER-TOP: rgb(255,255,255) 2px solid">
<input type="hidden" name="newcondition" value="<%=newcondition%>">
</form>
<%}%> </td>
<td valign="baseline" nowrap>
<%if(pageNO_c<pageall){String page_send=Integer.toString(pageNO_c+1);%>
<form name="next" method="post" action="<%=meb%>?way=<%=way%>&ts=<%=ts%>&pageNO=<%=page_send%>">
<input name="next" type="submit" id="next" value="下一页"style="BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 2px solid; BORDER-LEFT: rgb(255,255,255) 2px solid; BORDER-RIGHT: rgb(255,255,255) 2px solid; BORDER-TOP: rgb(255,255,255) 2px solid">
<input type="hidden" name="newcondition" value="<%=newcondition%>">
</form>
<%}%> </td>
<td valign="baseline" nowrap>
<%if(pageNO_c<pageall){String page_send=Integer.toString(pageall);%>
<form name="last" method="post" action="<%=meb%>?way=<%=way%>&ts=<%=ts%>&pageNO=<%=page_send%>">
<input name="last" type="submit" id="last" value="最后页"style="BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 2px solid; BORDER-LEFT: rgb(255,255,255) 2px solid; BORDER-RIGHT: rgb(255,255,255) 2px solid; BORDER-TOP: rgb(255,255,255) 2px solid">
<input type="hidden" name="newcondition" value="<%=newcondition%>">
</form>
<%}%> </td>
<td valign="baseline" nowrap>
<%if(all!=0){out.print("共");out.print(pageall);out.print("页");}%></td>
</tr>
</table>
<%
if(all<=10)
{ for(k=0;k<pagecount;k++)
{if(!rs.next()){break;}%>
<table border="1" align="center" cellspacing="1" bordercolor="#FF99CC">
<tr bgcolor="#FF99CC">
<td height="30" colspan="8" nowrap><div align="center" class="style2">职工基本信息表</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><%=rs.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.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.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.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.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.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.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.getString("MZ")%></td>
</tr>
<tr>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">籍贯:</span></div>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?