gz_cx_mh.jsp
来自「JSP页面和oracle9i数据库的源代码」· JSP 代码 · 共 329 行 · 第 1/2 页
JSP
329 行
</tr>
</table>
<%}%><div align="center" class="f1">
第<%=pageNO_c%>页
<%if(pageNO_c>1){String page_send=Integer.toString(1);%>
<a href="gz_cx_mh.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_cx_mh.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_cx_mh.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_cx_mh.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="800" height="100" border="1" align="center" cellpadding="0" cellspacing="1" bordercolor="#CC66FF" class="f1">
<tr bgcolor="#CC99FF">
<th colspan="8" scope="col"><%=rs.getString("BM")%> 职工工资信息表</th>
</tr>
<tr>
<td width="100" bgcolor="#CC99FF"><div align="center">职工编号</div></td>
<td width="100"><div align="center"><%=rs.getString("BH")%></div></td>
<td width="100" bgcolor="#CC99FF"><div align="center">职工姓名</div></td>
<td width="100"><div align="center"><%=rs.getString("XM")%></div></td>
<td width="100" bgcolor="#CC99FF"><div align="center">所在部门</div></td>
<td width="100"><div align="center"><%=rs.getString("BM")%></div></td>
<td width="100" bgcolor="#CC99FF"><div align="center">基本工资</div></td>
<td width="100"><div align="center"><%=rs.getString("GZ")%></div></td>
</tr>
<tr>
<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.getDate("JCNY")%></div></td>
<td bgcolor="#CC99FF"><div align="center">工天</div></td>
<td><div align="center"><%=rs.getString("GT")%></div></td>
<td bgcolor="#CC99FF"><div align="center">日工资</div></td>
<td><div align="center"><%=rs.getString("RGZ")%></div></td>
</tr>
<tr>
<td bgcolor="#CC99FF"><div align="center">上月余</div></td>
<td><div align="center"><%=rs.getString("SYY")%></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("YE")%></div></td>
</tr>
</table>
<br>
<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 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("JZ")%></p> </td>
<td width="66" bgcolor="#CC99FF"><div align="center">浮资</div></td>
<td width="66"><div align="center"><%=rs.getString("FZ")%></div></td>
</tr>
<tr>
<td bgcolor="#CC99FF"><div align="center">粮副地工</div></td>
<td><div align="center"><%=rs.getString("LFDG")%></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("YW")%></div></td>
<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("JIAOTONG")%></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("MT")%></div></td>
</tr>
<tr>
<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("YB")%></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("BX")%></div></td>
<td bgcolor="#CC99FF"><div align="center">违纪</div></td>
<td><div align="center"><%=rs.getString("WJ")%></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("KHF")%></div></td>
</tr>
<tr>
<td bgcolor="#CC99FF"><div align="center">领签</div></td>
<td><div align="center"><%=rs.getString("LQ")%></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"> </td>
<td> </td>
<td bgcolor="#CC99FF"> </td>
<td> </td>
<td bgcolor="#CC99FF"> </td>
<td> </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 + -
显示快捷键?