gz_tj_dw.jsp
来自「JSP页面和oracle9i数据库的源代码」· JSP 代码 · 共 193 行
JSP
193 行
<%@ 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>
<style>
<!--
a {text-decoration: none}
.f1 { font-size: 9pt; font-family: Verdana; line-height: 15pt }
.f2 { font-size: 12pt; font-family: Verdana; line-height: 12pt }
body {
background-image: url(../img/076.gif);
}
-->
</style>
</head>
<body>
<jsp:useBean id="conn" scope="page" class="beans3.conn"/>
<%--
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("super")) && !page_type.equals("sgz"))
{response.sendRedirect("../index.jsp");}
}
--%>
<div align="center">
<% ResultSet rs=null;
int i=0,j=0,k=0;
int alll=0;
float allsum=0,allsl=0;
String condition="select count(*) total from BGZDH.BZGZ";
rs=conn.executeQuery(condition);
while(rs.next())
{alll=Integer.parseInt(rs.getString("total"));}
condition="select sum(YL) total2,sum(SL) total3 from BGZDH.BZGZ";
rs=conn.executeQuery(condition);
while(rs.next())
{allsum=Float.parseFloat(rs.getString("total2"));
allsl=Float.parseFloat(rs.getString("total3"));}
%>
<p>全单位统计
</p>
<table width="500" border="1" cellspacing="1" bordercolor="#C3CDDE" class="f1">
<% String X1=conn.toPercent(String.valueOf(allsum)+"0");
String X2=conn.toPercent(String.valueOf(allsl)+"0");
String X3=conn.toPercent(String.valueOf(allsum-allsl)+"0");
String X4=conn.toPercent(String.valueOf(allsum/alll)+"0");
%>
<tr bgcolor="#C3CDDE">
<td width="100" bgcolor="#C3CDDE"><div align="center">应发工资总额</div></td>
<td width="100" bgcolor="#C3CDDE"><div align="center">实领工资总额</div></td>
<td width="100" bgcolor="#C3CDDE"><div align="center">工资总余额</div></td>
<td width="100" bgcolor="#C3CDDE"><div align="center">职工总人数</div></td>
<td width="100" bgcolor="#C3CDDE"><div align="center">个人平均工资</div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#FFFFFF"><div align="center"><%=X1%>元</div></td>
<td bgcolor="#FFFFFF"><div align="center"><%=X2%>元</div></td>
<td bgcolor="#FFFFFF"><div align="center"><%=X3%>元</div></td>
<td align=center bgcolor="#FFFFFF"><div align="center"><%=alll%>人</div></td>
<td bgcolor="#FFFFFF"><div align="center"><%=X4%>元</div></td>
</tr>
</table>
<% int t1=0,t2=0,t3=0,t4=0,t5=0;
condition="select count(*) from bgzdh.bzgz where YL<1000";
rs=conn.executeQuery(condition);
while(rs.next())
{t1=Integer.parseInt(rs.getString("count(*)"));}
condition="select count(*) from bgzdh.bzgz where YL between 1000 and 2000";
rs=conn.executeQuery(condition);
while(rs.next())
{t2=Integer.parseInt(rs.getString("count(*)"));}
condition="select count(*) from bgzdh.bzgz where YL between 2000 and 5000";
rs=conn.executeQuery(condition);
while(rs.next())
{t3=Integer.parseInt(rs.getString("count(*)"));}
condition="select count(*) from bgzdh.bzgz where YL between 5000 and 8000";
rs=conn.executeQuery(condition);
while(rs.next())
{t4=Integer.parseInt(rs.getString("count(*)"));}
condition="select count(*) from bgzdh.bzgz where YL>8000";
rs=conn.executeQuery(condition);
while(rs.next())
{t5=Integer.parseInt(rs.getString("count(*)"));}
String p1=conn.toPercent(String.valueOf((double)t1/alll*100)+"0");
String p2=conn.toPercent(String.valueOf((double)t2/alll*100)+"0");
String p3=conn.toPercent(String.valueOf((double)t3/alll*100)+"0");
String p4=conn.toPercent(String.valueOf((double)t4/alll*100)+"0");
String p5=conn.toPercent(String.valueOf((double)t5/alll*100)+"0");
%>
<table width="500" border="1" cellspacing="1" bordercolor="#C3CDDE" class="f1">
<tr>
<td width="150" bgcolor="#DEE3ED">工资在1000元以下:</td>
<td width="50"><%=t1%>人</td>
<td width="197"><img src = bar1.gif width =<%=Float.parseFloat(p1)*1.2%> height = 10> <%=p1%>%</td>
<td width="100"><a href="gz_tj_dw_xx.jsp?all=0">详细情况</a></td>
</tr>
<tr>
<td bgcolor="#DEE3ED">工资在1000－2000元:</td>
<td><%=t2%>人</td>
<td><img src = bar1.gif width =<%=Float.parseFloat(p2)*1.2%> height = 10> <%=p2%>%</td>
<td><a href="gz_tj_dw_xx.jsp?all=1">详细情况</a></td>
</tr>
<tr>
<td bgcolor="#DEE3ED">工资在2000－5000元:</td>
<td><%=t3%>人</td>
<td><img src = bar1.gif width =<%=Float.parseFloat(p3)*1.2%> height = 10> <%=p3%>%</td>
<td><a href="gz_tj_dw_xx.jsp?all=2">详细情况</a></td>
</tr>
<tr>
<td bgcolor="#DEE3ED">工资在5000－8000元:</td>
<td><%=t4%>人</td>
<td><img src = bar1.gif width =<%=Float.parseFloat(p4)*1.2%> height = 10> <%=p4%>%</td>
<td><a href="gz_tj_dw_xx.jsp?all=3">详细情况</a></td>
</tr>
<tr>
<td bgcolor="#DEE3ED">工资在8000元以上:</td>
<td><%=t5%>人</td>
<td><img src = bar1.gif width =<%=Float.parseFloat(p5)*1.2%> height = 10> <%=p5%>%</td>
<td><a href="gz_tj_dw_xx.jsp?all=4">详细情况</a></td>
</tr>
</table>
<%
condition="select * from BM";
rs=conn.executeQuery(condition);
while(rs.next())
{i++;}
String tmp_bm[]=new String[i];
String per1_bm[]=new String[i];
String sum_bm[]=new String[i];
double sum2_bm[]=new double[i];
String per2_bm[]=new String[i];
int count_bm[]=new int[i];
String avg_bm[]=new String[i];
String sl_bm[]=new String[i];
double sl2_bm[]=new double[i];
String ye_bm[]=new String[i];
rs=conn.executeQuery(condition);
while(rs.next())
{
tmp_bm[j]=rs.getString("BM");
j++;
}
for(k=0;k<j;k++)
{ rs=conn.executeQuery("select count(*),sum(YL),sum(SL),avg(YL) from BGZDH.BZGZ where BM='"+tmp_bm[k]+"'");
while(rs.next())
{ count_bm[k]=Integer.parseInt(rs.getString("count(*)"));
per1_bm[k]=conn.toPercent(String.valueOf((double)count_bm[k]/alll*100)+"0");
sum_bm[k]=conn.toPercent(String.valueOf(Double.parseDouble(rs.getString("sum(YL)")))+"0");
sum2_bm[k]=Double.parseDouble(rs.getString("sum(YL)"));
per2_bm[k]=conn.toPercent(String.valueOf((double)sum2_bm[k]/allsum*100.00)+"0");
avg_bm[k]=conn.toPercent(String.valueOf(Double.parseDouble(rs.getString("avg(YL)")))+"0");
sl_bm[k]=conn.toPercent(String.valueOf(Double.parseDouble(rs.getString("sum(SL)")))+"0");
sl2_bm[k]=Double.parseDouble(rs.getString("sum(SL)"));
ye_bm[k]=conn.toPercent(String.valueOf(sum2_bm[k]-sl2_bm[k])+"0");
}
}
if(j==0){out.print("<div align=center>当前无记录</div>");}
if(j<0){out.print("系统错误！请关闭网页重新登入！如有疑问请与软件开发商联系！");}
%> <div align=center class=f1>共有<%=alll%>条记录（包括临时工）</div><br>
<table class=f1>
<tr bgcolor=#C6CBD4><td>部门</td>
<td align=center>人数</td>
<td align=center>人数统计图</td>
<td align=center>应领总额</td>
<td align=center bgcolor="#C6CBD4">应领总额统计图</td>
<td align=center>实领总额</td>
<td align=center>余额</td>
<td align=center>人均工资</td>
<% for(k=0;k<j;k++)
{ %>
<tr>
<td bgcolor=#EFEFEF><%=tmp_bm[k]%></td>
<td align=center> <%=count_bm[k]%>人</td>
<td width=110><img src = bar1.gif width =<%=Float.parseFloat(per1_bm[k])*2%> height = 10> <%=per1_bm[k]%>%</td>
<td> <%=sum_bm[k]%>元</td>
<td width=110><img src = bar1.gif width =<%=Float.parseFloat(per2_bm[k])*2%> height = 10> <%=per2_bm[k]%>%</td>
<td> <%=sl_bm[k]%>元</td>
<td> <%=ye_bm[k]%>元</td>
<td> <%=avg_bm[k]%>元</td>
</tr>
<% }%>
</table>
<p><a href="../index/gz_index.jsp" class="f1">返回主页</a></p>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?