gz_tj_gr.jsp
来自「JSP页面和oracle9i数据库的源代码」· JSP 代码 · 共 310 行
JSP
310 行
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<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: 8pt; font-family: Verdana; line-height: 12pt }
body {
background-image: url(../img/011qq.gif);
}
input.noborInput{background:#ffffff; border-bottom-width:0px;border-top-width:0px;border-left-width:0px;border-right-width:0px; solid #ff6633; COLOR: #3300FF; FONT-SIZE: 10pt}
input.smallInput{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}
input.buttonface{BACKGROUND: #CCCCFF; border:1 solid #CC33FF; COLOR: #CC00FF; FONT-SIZE: 9pt; FONT-STYLE: normal; FONT-VARIANT: normal; FONT-WEIGHT: normal; HEIGHT: 18px; LINE-HEIGHT: normal}
.style1 {
font-family: Verdana;
color: #3333FF;
}
-->
</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");
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("super")) && !page_type.equals("sgz"))
{response.sendRedirect("../index.jsp");}
}
--%>
<% ResultSet rs=null;
int flag=0;
String condition="select * from BGZDH.BM";
rs=conn.executeQuery(condition);
%>
<div align="center">
<form name="form" method="post" action="gz_tj_gr.jsp?flag=1">
<table width="425" height="160" border="0" align="center" cellpadding="0" cellspacing="0" class="f1">
<tr>
<td height="30" colspan="3"><div align="center" class="style1">可多选</div></td>
</tr>
<tr>
<td width="89">
<div align="right">
<input type="checkbox" name="bmcheck" value="bm">
</div></td><td width="152" height="30"><div align="right">请选择职工所在部门 </div></td>
<td width="184"><select name="bm">
<option value="">部门表</option>
<%while(rs.next())
{%>
<option value=<%=rs.getString("BM")%>><%=rs.getString("BM")%></option>
<%}%>
</select></td>
</tr>
<tr>
<td>
<div align="right">
<input type="checkbox" name="bhcheck" value="bh">
</div></td><td height="30"><div align="right">请输入职工号前几位 </div></td>
<td><input name="bh" type="text" class="smallInput" size="8" maxlength="2"></td>
</tr>
<tr>
<td>
<div align="right">
<input type="checkbox" name="xmcheck" value="xm">
</div></td><td height="30"><div align="right">请输入职工姓氏 </div></td>
<td><input name="xm" type="text" class="smallInput" size="8" maxlength="2">
</td>
</tr>
<tr>
<td height="40" colspan="3">
<div align="center">
<input name="Submit" type="submit" class="buttonface" value="提交">
<input name="reset" type="reset" class="buttonface" value="重置">
<input name="back" type="button" class="buttonface" onClick="location.href='../index/gz_index.jsp';" value="退出"></div></td>
</tr>
</table>
</form>
<% String sp=null;
if (request.getParameter("flag")==null) {}
else{
String check1=request.getParameter("bmcheck");
String check2=request.getParameter("bhcheck");
String check3=request.getParameter("xmcheck");
int a[]=new int[3];
sp="select * from BGZDH.BZGZ";
String bm=conn.toChinese(request.getParameter("bm"));
String bh=conn.toChinese(request.getParameter("bh"));
String xm=conn.toChinese(request.getParameter("xm"));
if(check1==null)
{}
else
{ if(bm==null){}
else{sp=sp+" where BM like '"+bm+"%'";
a[0]=1; }
}
if(check2==null||bh==null)
{}
else
{ a[1]=1;
if(a[0]==1)
{sp=sp+" and BH LIKE '"+bh+"%'";}
else
{sp=sp+" where BH LIKE '"+bh+"%'";}
}
if(check3==null||xm==null)
{}
else
{ a[2]=1;
if(a[0]==1||a[1]==1)
{sp=sp+" and XM LIKE '"+xm+"%'";
}
else
{sp=sp+" where XM LIKE '"+xm+"%'";
}
}
if(check1==null && check2==null && check3==null)
{out.print("<p class=f1>请选择查询条件！</p>");}
sp=sp+" order by BH";
int all=0,pagecount=1,pageall=0,i=0;
String pageNO=request.getParameter("pageNO");
if(pageNO==null){pageNO="1";}
int pageNO_c=Integer.parseInt(pageNO);
rs=conn.executeQuery(sp);
while(rs.next())
{all++;}
if(all>0)
{ out.print("<div align=center class=f1>共找到"+all+"条记录</div>");
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" class="f1">
<tr>
<td width="248">
<form action="gz_cx_mh.jsp?bmcheck=<%=check1%>&bhcheck=<%=check2%>&xmcheck=<%=check3%>&bm=<%=bm%>&bh=<%=bh%>&xm=<%=xm%>&flag=1" method="post">
<div align="center" class=f1>
跳转到
<select name="pageNO">
<%for(i=1;i<=pageall;i++){%>
<option value="<%=i%>">第<%=i%>页</option>
<%}%>
</select>
<input name="确定" type="submit" class="buttonface" value="确定">
<input name="bm" type="hidden" id="sp" value="">
</div>
</form>
</td>
</tr>
</table>
<%}%><div align="center" class="f1">
第<%=pageNO_c%>页
<%if(pageNO_c>1){String page_send=Integer.toString(1);%>
<a href="gz_tj_gr.jsp?pageNO=<%=page_send%>&bmcheck=<%=check1%>&bhcheck=<%=check2%>&xmcheck=<%=check3%>&bm=<%=bm%>&bh=<%=bh%>&xm=<%=xm%>&flag=1">第一页</a>
<%}%>
<%if(pageNO_c>1){String page_send=Integer.toString(pageNO_c-1);%>
<a href="gz_tj_gr.jsp?pageNO=<%=page_send%>&bmcheck=<%=check1%>&bhcheck=<%=check2%>&xmcheck=<%=check3%>&bm=<%=bm%>&bh=<%=bh%>&xm=<%=xm%>&flag=1">上一页</a>
<%}%>
<%if(pageNO_c<pageall){String page_send=Integer.toString(pageNO_c+1);%>
<a href="gz_tj_gr.jsp?pageNO=<%=page_send%>&bmcheck=<%=check1%>&bhcheck=<%=check2%>&xmcheck=<%=check3%>&bm=<%=bm%>&bh=<%=bh%>&xm=<%=xm%>&flag=1">下一页</a>
<%}%>
<%if(pageNO_c<pageall){String page_send=Integer.toString(pageall);%>
<a href="gz_tj_gr.jsp?pageNO=<%=page_send%>&bmcheck=<%=check1%>&bhcheck=<%=check2%>&xmcheck=<%=check3%>&bm=<%=bm%>&bh=<%=bh%>&xm=<%=xm%>&flag=1">最末页</a>
<%}%>
共<%=pageall%>页
</div>
<%
rs=conn.executeQuery(sp);
for(i=0;i<(pageNO_c-1)*pagecount;i++)
{rs.next();}
for(i=0;i<pagecount;i++)
{ if(!rs.next())
{break;}
%>
<table width="798" height="150" border="1" align="center" cellpadding="0" cellspacing="1" bordercolor="#CC66FF" class="f1">
<tr>
<th colspan="12" bgcolor="#CC99FF" scope="col"><%=rs.getString("XM")%> 工资明细表</th>
</tr>
<tr>
<td bgcolor="#CC99FF"><div align="center">编号</div></td>
<td><div align="center"><%=rs.getString("BH")%></div></td>
<td bgcolor="#CC99FF"><div align="center">姓名</div></td>
<td><div align="center"><%=rs.getString("XM")%></div></td>
<td bgcolor="#CC99FF"><div align="center">部门</div></td>
<td><div align="center"><%=rs.getString("BM")%></div></td>
<td bgcolor="#CC99FF"><div align="center">工龄</div></td>
<td><div align="center"><%=rs.getString("GL")%></div></td>
<td bgcolor="#CC99FF"><div align="center">基本工资</div></td>
<td><div align="center"><%=rs.getString("GZ")%></div></td>
<td bgcolor="#CC99FF"><div align="center">粮副地工</div></td>
<td><div align="center"><%=rs.getString("LFDG")%></div></td>
</tr>
<tr>
<td width="66" bgcolor="#CC99FF"><div align="center">超时</div></td>
<td width="66"><div align="center"><%=rs.getString("CS")%></div></td>
<td width="66" bgcolor="#CC99FF"><div align="center">超价</div></td>
<td width="66"><div align="center"><%=rs.getString("CJ")%></div></td>
<td width="66" bgcolor="#CC99FF"><div align="center">超资</div></td>
<td width="66"><div align="center"><%=rs.getString("CZ")%></div></td>
<td width="66" bgcolor="#CC99FF"><div align="center">加天</div></td>
<td width="66"><div align="center"><%=rs.getString("JT")%></div></td>
<td width="66" bgcolor="#CC99FF"><div align="center">日工资</div></td>
<td width="66"><p align="center"><%=rs.getString("RGZ")%></p></td>
<td width="66" bgcolor="#CC99FF"><div align="center">加资</div></td>
<td width="66"><div align="center"><%=rs.getString("JZ")%></div></td>
</tr>
<tr>
<td bgcolor="#CC99FF"><div align="center">保险</div></td>
<td><div align="center"><%=rs.getString("BX")%></div></td>
<td bgcolor="#CC99FF"><div align="center">粮贴</div></td>
<td><div align="center"><%=rs.getString("LT")%></div></td>
<td bgcolor="#CC99FF"><div align="center">副贴</div></td>
<td><div align="center"><%=rs.getString("FT")%></div></td>
<td bgcolor="#CC99FF"><div align="center">单位贴</div></td>
<td><div align="center"><%=rs.getString("DWT")%></div></td>
<td bgcolor="#CC99FF"><div align="center">中夜班</div></td>
<td><div align="center"><%=rs.getString("ZYB")%></div></td>
<td bgcolor="#CC99FF"><div align="center">岗位薪</div></td>
<td><div align="center"><%=rs.getString("GWX")%></div></td>
</tr>
<tr>
<td bgcolor="#CC99FF"><div align="center">保健</div></td>
<td><div align="center"><%=rs.getString("BJ")%></div></td>
<td bgcolor="#CC99FF"><div align="center">浮资</div></td>
<td><div align="center"><%=rs.getString("FZ")%></div></td>
<td bgcolor="#CC99FF"><div align="center">药补</div></td>
<td><div align="center"><%=rs.getString("YB")%></div></td>
<td bgcolor="#CC99FF"><div align="center">卫生</div></td>
<td><div align="center"><%=rs.getString("WS")%></div></td>
<td bgcolor="#CC99FF"><div align="center">书报</div></td>
<td><div align="center"><%=rs.getString("SB")%></div></td>
<td bgcolor="#CC99FF"><div align="center">交通</div></td>
<td><div align="center"><%=rs.getString("JIAOTONG")%></div></td>
</tr>
<tr>
<td bgcolor="#CC99FF"><div align="center">房贴</div></td>
<td><div align="center"><%=rs.getString("FANGTIE")%></div></td>
<td bgcolor="#CC99FF"><div align="center">煤贴</div></td>
<td><div align="center"><%=rs.getString("MT")%></div></td>
<td bgcolor="#CC99FF"><div align="center">政府贴</div></td>
<td><div align="center"><%=rs.getString("ZFT")%></div></td>
<td bgcolor="#CC99FF"><div align="center">工资贴</div></td>
<td align="center"><%=rs.getString("GZBT")%></td>
<td bgcolor="#CC99FF"><div align="center">业务</div></td>
<td><div align="center"><%=rs.getString("YW")%></div></td>
<td bgcolor="#CC99FF"><div align="center">会费</div></td>
<td><div align="center"><%=rs.getString("KHF")%></div></td>
</tr>
<tr>
<td bgcolor="#CC99FF"><div align="center">事天</div></td>
<td><div align="center"><%=rs.getString("ST")%></div></td>
<td bgcolor="#CC99FF"><div align="center">病天</div></td>
<td><div align="center"><%=rs.getString("BT")%></div></td>
<td bgcolor="#CC99FF"><div align="center">扣缺勤</div></td>
<td><div align="center"><%=rs.getString("KQQ")%></div></td>
<td bgcolor="#CC99FF"><div align="center">扣病假</div></td>
<td><div align="center"><%=rs.getString("KBJ")%></div></td>
<td bgcolor="#CC99FF"><div align="center">房租</div></td>
<td><div align="center"><%=rs.getString("KFZ")%></div></td>
<td bgcolor="#CC99FF"><div align="center">各种补贴</div></td>
<td><div align="center"><%=rs.getString("GZBT")%></div></td>
</tr>
<tr>
<td bgcolor="#CC99FF"><div align="center">违纪</div></td>
<td><div align="center"><%=rs.getString("WJ")%></div></td>
<td bgcolor="#CC99FF"><div align="center">扣公积金</div></td>
<td><div align="center"><%=rs.getString("KGJJ")%></div></td>
<td bgcolor="#CC99FF"><div align="center">其他</div></td>
<td><div align="center"><%=rs.getString("QT")%></div></td>
<td bgcolor="#CC99FF"><div align="center">应领工资</div></td>
<td><div align="center"><%=rs.getString("YL")%></div></td>
<td bgcolor="#CC99FF"><div align="center">实领工资</div></td>
<td><div align="center"><%=rs.getString("SL")%></div></td>
<td bgcolor="#CC99FF">
<div align="center">领签人</div></td>
<td><div align="center"><%=rs.getString("LQ")%></div></td>
</tr>
</table>
<%
}
}
else
{ if(all==0){out.print("<div align=center class=f1>数据库中没有符合该条件的员工信息</div>");}
if(all<0){out.print("<div align=center class=f1>系统错误！请关闭网页重新登入！如有疑问请与软件开发商联系！</div>");}
}
}
%>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?