gz_cx_bm.jsp

来自「JSP页面和oracle9i数据库的源代码」· JSP 代码 · 共 273 行 · 第 1/2 页

				%>	
                <table width="941" border="1" align="center" cellspacing="1" bordercolor="#D2A3FF">
                  <tr bgcolor="#D2A3FF">
                    <td height="30" colspan="10"><div align="center" class="style2">职工工资信息表</div></td>
  </tr>
                  <tr>
                    <td width="101" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1">编号：</span></div></td>
                    <td width="74" height="20"><%=rs.getString("BH")%></td>
                    <td width="101" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1">姓名：</span></div></td>
                    <td width="76" height="20"><%=rs.getString("XM")%></td>
                    <td width="101" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1">扣病假：</span></div></td>
                    <td width="122" height="20"><%=rs.getFloat("KBJ")%></td>
                    <td width="55" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1"> 保健：</span></div></td>
                    <td width="77" height="20"><%=rs.getFloat("BJ")%></td>
                    <td width="101" bgcolor="#D2A3FF" class="style5"> <div align="left">应领：</div></td>
                    <td width="80"><%=rs.getFloat("YL")%></td>
                  </tr>
                  <tr>
                    <td width="101" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1">所在部门：</span></div></td>
                    <td width="74" height="20"><%=rs.getString("BM")%></td>
                    <td width="101" height="20" bgcolor="#D2A3FF"><div align="left" class="style5">基本工资：</div></td>
                    <td width="76" height="20"><%=rs.getFloat("GZ")%></td>
                    <td width="101" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1"> 粮副地工：</span></div></td>
                    <td width="122" height="20"><%=rs.getFloat("LFDG")%></td>
                    <td width="55" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1"> 业务：</span></div></td>
                    <td width="77" height="20"><%=rs.getFloat("YW")%></td>
                    <td width="101" height="20" bgcolor="#D2A3FF" class="style5"> <div align="left">扣房租：</div></td>
                    <td width="80" height="20"><%=rs.getFloat("KFZ")%></td>
                  </tr>
                  <tr>
                    <td width="101" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1">超时：</span></div></td>
                    <td width="74" height="20"><%=rs.getFloat("CS")%></td>
                    <td width="101" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1">工天：</span></div></td>
                    <td width="76" height="20"><%=rs.getFloat("GT")%></td>
                    <td width="101" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1"> 粮贴：</span></div></td>
                    <td width="122" height="20"><%=rs.getFloat("LT")%></td>
                    <td width="55" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1"> 房贴：</span></div></td>
                    <td width="77" height="20"><%=rs.getFloat("FANGTIE")%></td>
                    <td width="101" height="20" bgcolor="#D2A3FF" class="style5"> <div align="left">扣会费：</div></td>
                    <td width="80" height="20"><%=rs.getFloat("KHF")%></td>
                  </tr>
                  <tr>
                    <td width="101" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1">超价：</span></div></td>
                    <td width="74" height="20"><%=rs.getFloat("CJ")%></td>
                    <td width="101" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1">日工资：</span></div></td>
                    <td width="76" height="20"><%=rs.getFloat("RGZ")%></td>
                    <td width="101" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1"> 副贴：</span></div></td>
                    <td width="122" height="20"><%=rs.getFloat("FT")%></td>
                    <td width="55" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1"> 交通：</span></div></td>
                    <td width="77" height="20"><%=rs.getFloat("JIAOTONG")%></td>
                    <td width="101" height="20" bgcolor="#D2A3FF" class="style5"> <div align="left">扣公积金：</div></td>
                    <td width="80" height="20"><%=rs.getFloat("KGJJ")%></td>
                  </tr>
                  <tr>
                    <td width="101" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1">超资：</span></div></td>
                    <td width="74" height="20"><%=rs.getFloat("CZ")%></td>
                    <td width="101" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1">上月余：</span></div></td>
                    <td width="76" height="20"><%=rs.getFloat("SYY")%></td>
                    <td width="101" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1"> 地差：</span></div></td>
                    <td width="122" height="20"><%=rs.getFloat("ZFT")%></td>
                    <td width="55" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1"> 书报：</span></div></td>
                    <td width="77" height="20"><%=rs.getFloat("SB")%></td>
                    <td width="101" height="20" bgcolor="#D2A3FF" class="style5"> <div align="left">违纪：</div></td>
                    <td width="80" height="20"><%=rs.getFloat("WJ")%></td>
                  </tr>
                  <tr>
                    <td width="101" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1">加天：</span></div></td>
                    <td width="74" height="20"><%=rs.getFloat("JT")%></td>
                    <td width="101" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1">事天：</span></div></td>
                    <td width="76" height="20"><%=rs.getFloat("ST")%></td>
                    <td width="101" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1"> 工龄：</span></div></td>
                    <td height="20"><%=rs.getFloat("GL")%></td>
                    <td height="20" bgcolor="#D2A3FF" class="style5"> <div align="left">煤贴：</div></td>
                    <td height="20"><%=rs.getFloat("MT")%></td>
                    <td height="20" bgcolor="#D2A3FF" class="style5"> <div align="left">余额：</div></td>
                    <td height="20"><%=rs.getFloat("YE")%></td>
                  </tr>
                  <tr>
                    <td width="101" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1">加资：</span></div></td>
                    <td height="20"><%=rs.getFloat("JZ")%></td>
                    <td height="20" bgcolor="#D2A3FF"><div align="left"><span class="style5">病天：</span></div></td>
                    <td height="20"><%=rs.getFloat("BT")%></td>
                    <td height="20" bgcolor="#D2A3FF" class="style5"> <div align="left">中夜班：</div></td>
                    <td height="20"><%=rs.getFloat("ZYB")%></td>
                    <td height="20" bgcolor="#D2A3FF" class="style5"> <div align="left">卫生：</div></td>
                    <td height="20"><%=rs.getFloat("WS")%></td>
                    <td height="20" bgcolor="#D2A3FF" class="style5"> <div align="left">实领：</div></td>
                    <td height="20"><%=rs.getFloat("SL")%></td>
                  </tr>
                  <tr bgcolor="#FF99CC">
                    <td height="20" bgcolor="#D2A3FF"><div align="center" class="style5">
                      <div align="left">浮资：</div>
                    </div></td>
  				    <td height="20" bgcolor="#FFFFFF"><%=rs.getFloat("FZ")%></td>
  				    <td height="20" bgcolor="#D2A3FF" class="style5"><div align="left">扣缺勤：</div></td>
  				    <td height="20" bgcolor="#FFFFFF"><%=rs.getFloat("KQQ")%></td>
  				    <td height="20" bgcolor="#D2A3FF" class="style5"> <div align="left">岗位：</div></td>
  				    <td height="20" bgcolor="#FFFFFF"><%=rs.getFloat("GWX")%></td>
  				    <td height="20" bgcolor="#D2A3FF" class="style5"> <div align="left">药补：</div></td>
  				    <td height="20" bgcolor="#FFFFFF"><%=rs.getFloat("YB")%></td>
                    <td height="20" bgcolor="#D2A3FF" class="style5"> <div align="left">其它：</div></td>
                    <td height="20" bgcolor="#FFFFFF"><%=rs.getFloat("QT")%></td>
                  </tr>
                  <tr>
                    <td bgcolor="#D2A3FF" class="style5"> <div align="left">保险： </div></td>
                    <td><%=rs.getFloat("BX")%></td>
                    <td bgcolor="#D2A3FF" class="style5"><div align="left">领签：</div></td>
                    <td><%=rs.getString("LQ")%></td>
                    <td bgcolor="#D2A3FF" class="style5"> <div align="left">进厂年月：</div></td>
                    <td><%=rs.getDate("JCNY")%></td>
                    <td bgcolor="#D2A3FF">&nbsp;</td>
                    <td>&nbsp;</td>
                    <td bgcolor="#D2A3FF">&nbsp;</td>
                    <td>&nbsp;</td>
                  </tr>
                  </table>
				</div>
				<div align="center"></div>
				<div align="center">
				  <hr align="center" width="1000">				 
				 <%
				}
			}
			else
			{ if(all==0 && !bm.equals("")){out.print("工资数据库中没有这个部门员工的工资信息");}
			  if(all<0){out.print("系统错误！请关闭网页重新登入！如有疑问请与软件开发商联系！");}
			}
		 }
}catch(Exception e) {out.print(e.getMessage());}		 
	   %>
                </div>

</body>
</html>