gz_print_all.jsp
来自「JSP页面和oracle9i数据库的源代码」· JSP 代码 · 共 205 行
JSP
205 行
<%@ 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">
<%@page import="java.util.Calendar"%>
<title>打印全体职工工资条</title>
<style type="text/css">
<!--
.style1 {color: #FFFFFF}
.style5 {color: #FFFFFF; font-size: 12px; }
.style6 {font-size: 12px}
body {
background-image: url(../img/allbg.gif);
}
.style7 {color: #FFFFFF; font-size: 14px; }
.style8 {
font-size: 16px;
color: #FF0099;
}
-->
</style>
</head>
<body>
<div align="center">
<%
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>
<jsp:useBean id="conn" scope="page" class="beans3.conn"/>
<div align="center">
<%
int all=0;
String condition=null;
condition="select * from BZGZ";
ResultSet rs=conn.executeQuery(condition);
%>
<div align="center" class="style7 style8">全体工资信息表</div>
<hr width="700">
<%
while(rs.next())
{all++;}
if(all==0)
{out.print("该部门职工信息库中无记录！");}
else {rs.beforeFirst();
while(!rs.isAfterLast())
{
%>
</div>
<table width="100%" height="1000" border="0" cellpadding="5">
<tr>
<td valign="top">
<%for(int i=0;i<4;i++){
if(!rs.next()){break;}%>
<table border="1" align="center" cellspacing="1" bordercolor="#D2A3FF">
<tr bgcolor="#D2A3FF">
<td height="30" colspan="10" nowrap><div align="center" class="style1 style6"><%=rs.getString("XM")%>工资信息表</div></td>
</tr>
<tr>
<td bgcolor="#D2A3FF"><div align="left" class="style6"><span class="style1">编号:</span></div></td>
<td height="20" nowrap><span class="style6"><%=rs.getString("BH")%></span></td>
<td height="20" bgcolor="#D2A3FF"><div align="left" class="style6"><span class="style1">姓名:</span></div></td>
<td height="20" nowrap><span class="style6"><%=rs.getString("XM")%></span></td>
<td height="20" bgcolor="#D2A3FF"><div align="left" class="style6"><span class="style1">扣病假:</span></div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("KBJ")%></span></td>
<td height="20" nowrap bgcolor="#D2A3FF"><div align="left" class="style6"><span class="style1"> 保健:</span></div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("BJ")%></span></td>
<td bgcolor="#D2A3FF" class="style1">
<div align="left" class="style6">应领:</div></td>
<td nowrap><span class="style6"><%=rs.getFloat("YL")%></span></td>
</tr>
<tr>
<td height="20" bgcolor="#D2A3FF"><div align="left" class="style6"><span class="style1">所在部门:</span></div></td>
<td height="20" nowrap><span class="style6"><%=rs.getString("BM")%></span></td>
<td height="20" bgcolor="#D2A3FF"><div align="left" class="style5">基本工资:</div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("GZ")%></span></td>
<td height="20" bgcolor="#D2A3FF"><div align="left" class="style6"><span class="style1"> 粮副地工:</span></div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("LFDG")%></span></td>
<td height="20" bgcolor="#D2A3FF"><div align="left" class="style6"><span class="style1"> 业务:</span></div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("YW")%></span></td>
<td height="20" bgcolor="#D2A3FF" class="style1">
<div align="left" class="style6">扣房租:</div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("KFZ")%></span></td>
</tr>
<tr>
<td height="20" bgcolor="#D2A3FF"><div align="left" class="style6"><span class="style1">超时:</span></div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("CS")%></span></td>
<td height="20" bgcolor="#D2A3FF"><div align="left" class="style6"><span class="style1">工天:</span></div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("GT")%></span></td>
<td height="20" bgcolor="#D2A3FF"><div align="left" class="style6"><span class="style1"> 粮贴:</span></div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("LT")%></span></td>
<td height="20" bgcolor="#D2A3FF"><div align="left" class="style6"><span class="style1"> 房贴:</span></div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("FANGTIE")%></span></td>
<td height="20" bgcolor="#D2A3FF" class="style1">
<div align="left" class="style6">扣会费:</div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("KHF")%></span></td>
</tr>
<tr>
<td height="20" nowrap bgcolor="#D2A3FF"><div align="left" class="style6"><span class="style1">超价:</span></div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("CJ")%></span></td>
<td height="20" nowrap bgcolor="#D2A3FF"><div align="left" class="style6"><span class="style1">日工资:</span></div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("RGZ")%></span></td>
<td height="20" nowrap bgcolor="#D2A3FF"><div align="left" class="style6"><span class="style1"> 副贴:</span></div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("FT")%></span></td>
<td height="20" nowrap bgcolor="#D2A3FF"><div align="left" class="style6"><span class="style1"> 交通:</span></div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("JIAOTONG")%></span></td>
<td height="20" nowrap bgcolor="#D2A3FF" class="style1">
<div align="left" class="style6">扣公积金:</div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("KGJJ")%></span></td>
</tr>
<tr>
<td height="20" nowrap bgcolor="#D2A3FF"><div align="left" class="style6"><span class="style1">超资:</span></div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("CZ")%></span></td>
<td height="20" nowrap bgcolor="#D2A3FF"><div align="left" class="style6"><span class="style1">上月余:</span></div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("SYY")%></span></td>
<td height="20" nowrap bgcolor="#D2A3FF"><div align="left" class="style6"><span class="style1"> 地差:</span></div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("ZFT")%></span></td>
<td height="20" nowrap bgcolor="#D2A3FF"><div align="left" class="style6"><span class="style1"> 书报:</span></div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("SB")%></span></td>
<td height="20" nowrap bgcolor="#D2A3FF" class="style1">
<div align="left" class="style6">违纪:</div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("WJ")%></span></td>
</tr>
<tr>
<td height="20" bgcolor="#D2A3FF"><div align="left" class="style6"><span class="style1">加天:</span></div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("JT")%></span></td>
<td height="20" nowrap bgcolor="#D2A3FF"><div align="left" class="style6"><span class="style1">事天:</span></div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("ST")%></span></td>
<td height="20" nowrap bgcolor="#D2A3FF"><div align="left" class="style6"><span class="style1"> 工龄:</span></div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("GL")%></span></td>
<td height="20" nowrap bgcolor="#D2A3FF" class="style1">
<div align="left" class="style6">煤贴:</div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("MT")%></span></td>
<td height="20" nowrap bgcolor="#D2A3FF" class="style1">
<div align="left" class="style6">余额:</div></td>
<td height="20"><span class="style6"><%=rs.getFloat("YE")%></span></td>
</tr>
<tr>
<td height="20" bgcolor="#D2A3FF"><div align="left" class="style6"><span class="style1">加资:</span></div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("JZ")%></span></td>
<td height="20" nowrap bgcolor="#D2A3FF"><div align="left" class="style6"><span class="style1">病天:</span></div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("BT")%></span></td>
<td height="20" nowrap bgcolor="#D2A3FF" class="style1">
<div align="left" class="style6">中夜班:</div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("ZYB")%></span></td>
<td height="20" nowrap bgcolor="#D2A3FF" class="style1">
<div align="left" class="style6">卫生:</div></td>
<td height="20" nowrap><span class="style6"><%=rs.getFloat("WS")%></span></td>
<td height="20" nowrap bgcolor="#D2A3FF" class="style1">
<div align="left" class="style6">实领:</div></td>
<td height="20"><span class="style6"><%=rs.getFloat("SL")%></span></td>
</tr>
<tr bgcolor="#FF99CC">
<td height="20" bgcolor="#D2A3FF"><div align="center" class="style5">
<div align="left">浮资:</div>
</div></td>
<td height="20" nowrap bgcolor="#FFFFFF"><span class="style6"><%=rs.getFloat("FZ")%></span></td>
<td height="20" nowrap bgcolor="#D2A3FF" class="style1"><div align="left" class="style6">扣缺勤:</div></td>
<td height="20" nowrap bgcolor="#FFFFFF"><span class="style6"><%=rs.getFloat("KQQ")%></span></td>
<td height="20" nowrap bgcolor="#D2A3FF" class="style1">
<div align="left" class="style6">岗位:</div></td>
<td height="20" nowrap bgcolor="#FFFFFF"><span class="style6"><%=rs.getFloat("GWX")%></span></td>
<td height="20" nowrap bgcolor="#D2A3FF" class="style1">
<div align="left" class="style6">药补:</div></td>
<td height="20" nowrap bgcolor="#FFFFFF"><span class="style6"><%=rs.getFloat("YB")%></span></td>
<td height="20" nowrap bgcolor="#D2A3FF" class="style1">
<div align="left" class="style6">其它:</div></td>
<td height="20" bgcolor="#FFFFFF"><span class="style6"><%=rs.getFloat("QT")%></span></td>
</tr>
<tr>
<td bgcolor="#D2A3FF" class="style1">
<div align="left" class="style6">保险:</div></td>
<td nowrap><span class="style6"><%=rs.getFloat("BX")%></span></td>
<td nowrap bgcolor="#D2A3FF" class="style1"><div align="left" class="style6">领签:</div></td>
<td nowrap><span class="style6"><%=rs.getString("LQ")%></span></td>
<td nowrap bgcolor="#D2A3FF" class="style1">
<div align="left" class="style6">进厂年月:</div></td>
<td nowrap><span class="style6"><%=rs.getDate("JCNY")%></span></td>
<td nowrap bgcolor="#D2A3FF"><span class="style6"></span></td>
<td nowrap><span class="style6"></span></td>
<td nowrap bgcolor="#D2A3FF"><span class="style6"></span></td>
<td><span class="style6"></span></td>
</tr>
</table>
<hr width="700">
<%}%>
</td>
</tr>
</table>
<%}%>
<script language="javascript">
window.focus();window.print();
</script>
<%}%>
</body>
</html>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?