zzmm.jsp
来自「JSP页面和oracle9i数据库的源代码」· JSP 代码 · 共 211 行
JSP
211 行
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>按政治面貌查询</title>
</head>
<body>
<%--
String page_type=(String)session.getAttribute("page_type");
String page_name=(String)session.getAttribute("page_name");
String page_bm=(String)session.getAttribute("page_bm");
if(page_type==null){page_type="";}
if(page_bm==null){page_type="";}
if(session.isNew()){response.sendRedirect("../index.jsp");}
else
{ if(!(page_type.equals("gz")) && !page_type.equals("sgz"))
{response.sendRedirect("../index.jsp");}
}
--%>
<jsp:useBean id="conn" scope="page" class="beans.conn"/>
<%@ page import="java.util.Calendar"%>
<%
String condition_zzmm="select zzmm from zgxx";
conn.setcondition(condition_zzmm);
ResultSet rs_all=conn.getrs();
int all_all=0,all_dy=0,all_ty=0,all_sxdy=0,all_qz=0;
while(rs_all.next())
{ all_all++;
if(rs_all.getString("zzmm").equals("党员")){all_dy++;}
if(rs_all.getString("zzmm").equals("团员")){all_ty++;}
if(rs_all.getString("zzmm").equals("群众")){all_qz++;}
if(rs_all.getString("zzmm").equals("少先队员")){all_sxdy++;}
}
%>
<table height="29" border="4" align="center" cellpadding="0" cellspacing="0" bordercolor="#999999">
<tr bgcolor="#FFFFFF">
<td height="30" nowrap bgcolor="#FF99CC"><div align="center" class="style3">
<div align="right"><strong>党员总人数为：</strong></div>
</div></td>
<td nowrap bgcolor="#CCCCCC"><div align="center"><%=all_dy%>人，占在职职工总人数的<%=(int)((all_dy*100.0/all_all)*100.0)/100.0%>人</div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="30" nowrap bgcolor="#FF99CC"><div align="center" class="style3">
<div align="right"><strong>团员总人数为：</strong></div>
</div></td>
<td nowrap bgcolor="#CCCCCC"><div align="center"><%=all_ty%>人，占在职职工总人数的<%=(int)((all_ty*100.0/all_all)*100.0)/100.0%>%</div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="30" nowrap bgcolor="#FF99CC"><div align="center" class="style3">
<div align="right"><strong>群众总人数为：</strong></div>
</div></td>
<td nowrap bgcolor="#CCCCCC"><div align="center"><%=all_qz%>人，占在职职工总人数的<%=(int)((all_qz*100.0/all_all)*100.0)/100.0%>%</div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="30" nowrap bgcolor="#FF99CC"><div align="center" class="style3">
<div align="right"><strong>少先队员总人数为：</strong></div>
</div></td>
<td nowrap bgcolor="#CCCCCC"><div align="center"><%=all_sxdy%>人，占在职职工总人数的<%=(int)((all_sxdy*100.0/all_all)*100.0)/100.0%>%</div></td>
</tr>
</table>
<form name="form1" method="post" action="zzmm.jsp">
<div align="center">请选择政治面貌:
<select name="zzmm" id="select">
<option value="0">政治面貌</option>
<option value="党员">党员</option>
<option value="团员">团员</option>
<option value="群众">群众</option>
<option value="少先队员">少先队员</option>
</select>
<input type="submit" name="Submit" value="查询">
<a href="../index/rs_index.jsp">返回</a></div>
</form>
<div align="center">
<%String zzmm=request.getParameter("zzmm");
if(zzmm==null){zzmm="";}
byte b[]=zzmm.getBytes("ISO-8859-1");
zzmm=new String(b);
String pageNO=request.getParameter("pageNO");
if(pageNO==null){pageNO="1";}
int pageNO_c=Integer.parseInt(pageNO);
int all=0,pagecount=10,pageall=0,i=0;
if(zzmm.equals("0")){out.print("请您选择政治面貌");}
else
{ String condition="select * from zgxx where ZZMM="+"'"+zzmm+"'";
conn.setcondition(condition);
ResultSet rs=conn.getrs();
rs.last();
all=rs.getRow();
if(all>0)
{ out.print("此政治面貌的职工一共有");out.print(all);out.print("人");
if(all<=pagecount){pageall=1;}
else
{ int lastcount=0;
lastcount=all%pagecount;
if(lastcount==0){pageall=all/pagecount;}
else{pageall=all/pagecount+1;}
}
%>
<%if(pageall>1){%>
<table width="254" border="0">
<tr>
<td width="248">
<form action="zzmm.jsp" method="post">
<div align="center">
跳转到
<select name="pageNO">
<%for(i=1;i<=pageall;i++){%>
<option value="<%=i%>">第<%=i%>页</option>
<%}%>
</select>
<input name="确定" type="submit" value="确定">
<input name="zzmm" type="hidden" id="zzmm" value="<%=zzmm%>">
</div>
</form>
</td>
</tr>
</table>
<div align="center">
<%}%>
</div>
<hr align="center" width="1000" color="#FF99CC">
<div align="center">第<%=pageNO_c%>页
<%if(pageNO_c>1){String page_send=Integer.toString(1);%>
<a href="zzmm.jsp?pageNO=<%=page_send%>&zzmm=<%=zzmm%>">第一页</a>
<%}%>
<%if(pageNO_c>1){String page_send=Integer.toString(pageNO_c-1);%>
<a href="zzmm.jsp?pageNO=<%=page_send%>&zzmm=<%=zzmm%>">上一页</a>
<%}%>
<%if(pageNO_c<pageall){String page_send=Integer.toString(pageNO_c+1);%>
<a href="zzmm.jsp?pageNO=<%=page_send%>&zzmm=<%=zzmm%>">下一页</a>
<%}%>
<%if(pageNO_c<pageall){String page_send=Integer.toString(pageall);%>
<a href="zzmm.jsp?pageNO=<%=page_send%>&zzmm=<%=zzmm%>">最末页</a>
<%}%>
共<%=pageall%>页
<%
rs.beforeFirst();
for(i=0;i<(pageNO_c-1)*pagecount;i++){rs.next();}
%>
</div>
</div>
<table border="1" align="center" cellpadding="0" cellspacing="0">
<tr bgcolor="#FF99CC">
<th colspan="8" nowrap scope="col"><%=zzmm%>职工基本信息表</th>
</tr>
<% for(i=0;i<pagecount;i++)
{ if(!rs.next()){break;}
%>
</tr>
<tr nowrap >
<td colspan="8"><hr align="center" noshade color="#FFCCCC"></td>
</tr>
<tr>
<td nowrap bgcolor="#FF99cc"><div align="center">职工编号</div></td>
<td nowrap><div align="center"><%=rs.getString("BH")%></div></td>
<td nowrap bgcolor="#FF99CC"><div align="center">所在部门</div></td>
<td nowrap><div align="center"><%=rs.getString("BM")%></div></td>
<td nowrap bgcolor="#FF99CC"><div align="center">职工姓名</div></td>
<td nowrap><div align="center"><%=rs.getString("XM")%></div></td>
<td nowrap bgcolor="#FF99CC"><div align="center">性别</div></td>
<td nowrap><div align="center"><%=rs.getString("XB")%></div></td>
</tr>
<tr>
<td nowrap bgcolor="#FF99cc"><div align="center">年龄</div></td>
<td nowrap><div align="center">
<% 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%></div></td>
<td nowrap bgcolor="#FF99CC"><div align="center">现任职务</div></td>
<td nowrap><div align="center"><%=rs.getString("XRZW")%></div></td>
<td nowrap bgcolor="#FF99CC"><div align="center">出生年月</div></td>
<td nowrap><div align="center"><%=rs.getDate("CSNY")%></div></td>
<td nowrap bgcolor="#FF99CC"><div align="center">民族</div></td>
<td nowrap><div align="center"><%=rs.getString("MZ")%></div></td>
</tr>
<tr>
<td nowrap bgcolor="#FF99cc"><div align="center">籍贯</div></td>
<td nowrap><div align="center"><%=rs.getString("JG")%></div></td>
<td nowrap bgcolor="#FF99CC"><div align="center">政治面貌</div></td>
<td nowrap><div align="center"><%=rs.getString("ZZMM")%></div></td>
<td nowrap bgcolor="#FF99CC"><div align="center">职称</div></td>
<td nowrap><div align="center"><%=rs.getString("ZC")%></div></td>
<td nowrap bgcolor="#FF99CC"><div align="center">文化程度</div></td>
<td nowrap><div align="center">
<%
String condition_xl="select * from XL where XLBH="+rs.getInt("WHCD");
conn.setcondition(condition_xl);
ResultSet rs_xl=conn.getrs();
rs_xl.next();
out.print(rs_xl.getString("xlmc"));
%></div></td>
<% }%>
</table>
<% }
else
{ if(all==0 && !zzmm.equals("")){out.print("数据库中没有这种政治面目的职工的信息");}
if(all<0){out.print("系统错误！请关闭网页重新登入！如有疑问请与软件开发商联系！");}
}
}
%>
<jsp:include page="../checkout.jsp"></jsp:include>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?