gz_tj_bm_xx.jsp
来自「JSP页面和oracle9i数据库的源代码」· JSP 代码 · 共 158 行
JSP
158 行
<%@ 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: 12pt; font-family: Verdana; line-height: 12pt }
body {
background-image: url(../img/011qq.gif);
}
-->
</style>
</head>
<body>
<%
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");}
}
%>
<jsp:useBean id="conn" scope="page" class="beans3.conn"/>
<a href="javascript:history.go(-1)" class="f1">返回</a>
<p>
<%ResultSet rs=null;
String bh=request.getParameter("bh");
String condition="select * from bzgz where BH='"+bh+"'";
rs=conn.executeQuery(condition);
while(rs.next())
{
%>
</p>
<table width="450" border="1" align="center" cellspacing="1" bordercolor="#D2A3FF" class="f1">
<tr bgcolor="#D2A3FF">
<td height="30" colspan="10" nowrap><div align="center" class="style6"><%=rs.getString("XM")%>工资信息表</div></td>
</tr>
<tr>
<td bgcolor="#D2A3FF"><span class="style6">编号:</span></td>
<td height="20" nowrap><%=rs.getString("BH")%></td>
<td height="20" bgcolor="#D2A3FF"><span class="style6">姓名:</span></td>
<td height="20" nowrap><%=rs.getString("XM")%></td>
<td height="20" bgcolor="#D2A3FF"><span class="style6">工龄:</span></td>
<td height="20" nowrap><%=rs.getFloat("GL")%></td>
<td height="20" nowrap bgcolor="#D2A3FF"><span class="style6">工天:</span></td>
<td height="20" nowrap><%=rs.getFloat("GT")%></td>
<td bgcolor="#D2A3FF"><span class="style6">基本工资:</span></td>
<td nowrap><%=rs.getFloat("GZ")%></td>
</tr>
<tr>
<td height="20" bgcolor="#D2A3FF"><span class="style6">部门:</span></td>
<td height="20" nowrap><%=rs.getString("BM")%></td>
<td height="20" bgcolor="#D2A3FF"><span class="style6">日工资:</span></td>
<td height="20" nowrap><%=rs.getFloat("RGZ")%></td>
<td height="20" bgcolor="#D2A3FF"><span class="style6">浮资: </span></td>
<td height="20" nowrap><%=rs.getFloat("FZ")%></td>
<td height="20" bgcolor="#D2A3FF"><span class="style6"> 业务:</span></td>
<td height="20" nowrap><%=rs.getFloat("YW")%></td>
<td height="20" bgcolor="#D2A3FF"><span class="style6">各种补贴:</span></td>
<td height="20" nowrap><%=rs.getFloat("GZBT")%></td>
</tr>
<tr>
<td height="20" bgcolor="#D2A3FF"><span class="style6">超时:</span></td>
<td height="20" nowrap><%=rs.getFloat("CS")%></td>
<td height="20" bgcolor="#D2A3FF"><span class="style6">超资:</span></td>
<td height="20" nowrap><%=rs.getFloat("CZ")%></td>
<td height="20" bgcolor="#D2A3FF"><span class="style6">粮贴:</span></td>
<td height="20" nowrap><%=rs.getFloat("LT")%></td>
<td height="20" bgcolor="#D2A3FF"><span class="style6">房贴:</span></td>
<td height="20" nowrap><%=rs.getFloat("FANGTIE")%></td>
<td height="20" bgcolor="#D2A3FF"><span class="style6">粮副地工:</span></td>
<td height="20" nowrap><%=rs.getFloat("LFDG")%></td>
</tr>
<tr>
<td height="20" nowrap bgcolor="#D2A3FF"><span class="style6">加天:</span></td>
<td height="20" nowrap><%=rs.getFloat("JT")%></td>
<td height="20" nowrap bgcolor="#D2A3FF"><span class="style6">加资:</span></td>
<td height="20" nowrap><%=rs.getFloat("JZ")%></td>
<td height="20" nowrap bgcolor="#D2A3FF"><span class="style6">副贴:</span></td>
<td height="20" nowrap><%=rs.getFloat("FT")%></td>
<td height="20" nowrap bgcolor="#D2A3FF"><span class="style6">交通:</span></td>
<td height="20" nowrap><%=rs.getFloat("JIAOTONG")%></td>
<td height="20" nowrap bgcolor="#D2A3FF"><span class="style6">扣公积金:</span></td>
<td height="20" nowrap><%=rs.getFloat("KGJJ")%></td>
</tr>
<tr>
<td height="20" nowrap bgcolor="#D2A3FF"><span class="style6">事天:</span></td>
<td height="20" nowrap><%=rs.getFloat("ST")%></td>
<td height="20" nowrap bgcolor="#D2A3FF"><span class="style6">扣缺勤:</span></td>
<td height="20" nowrap><%=rs.getFloat("KQQ")%></td>
<td height="20" nowrap bgcolor="#D2A3FF"><span class="style6"> 地差:</span></td>
<td height="20" nowrap><%=rs.getFloat("ZFT")%></td>
<td height="20" nowrap bgcolor="#D2A3FF"><span class="style6"> 书报:</span></td>
<td height="20" nowrap><%=rs.getFloat("SB")%></td>
<td height="20" nowrap bgcolor="#D2A3FF"><span class="style6">扣房租:</span></td>
<td height="20" nowrap><%=rs.getFloat("KFZ")%></td>
</tr>
<tr>
<td height="20" bgcolor="#D2A3FF"><span class="style6">病天:</span></td>
<td height="20" nowrap><%=rs.getFloat("BT")%></td>
<td height="20" nowrap bgcolor="#D2A3FF"><span class="style6">扣病假:</span></td>
<td height="20" nowrap><%=rs.getFloat("KBJ")%></td>
<td height="20" nowrap bgcolor="#D2A3FF"><span class="style6">违纪: </span></td>
<td height="20" nowrap><%=rs.getFloat("WJ")%></td>
<td height="20" nowrap bgcolor="#D2A3FF"><span class="style6">煤贴:</span></td>
<td height="20" nowrap><%=rs.getFloat("MT")%></td>
<td height="20" nowrap bgcolor="#D2A3FF"><span class="style6">扣会费:</span></td>
<td height="20"><%=rs.getFloat("KHF")%></td>
</tr>
<tr>
<td height="20" bgcolor="#D2A3FF"><span class="style6">保健:</span></td>
<td height="20" nowrap><%=rs.getFloat("BJ")%></td>
<td height="20" nowrap bgcolor="#D2A3FF"><span class="style6">岗位薪:</span></td>
<td height="20" nowrap><%=rs.getFloat("GWX")%></td>
<td height="20" nowrap bgcolor="#D2A3FF"><span class="style6">保险:</span></td>
<td height="20" nowrap><%=rs.getFloat("BX")%></td>
<td height="20" nowrap bgcolor="#D2A3FF"><span class="style6">卫生:</span></td>
<td height="20" nowrap><%=rs.getFloat("WS")%></td>
<td height="20" nowrap bgcolor="#D2A3FF"><span class="style6">上月余:</span></td>
<td height="20"><%=rs.getFloat("SYY")%></td>
</tr>
<tr bgcolor="#FF99CC">
<td height="20" nowrap bgcolor="#D2A3FF"><span class="style6">药补:</span></td>
<td height="20" nowrap bgcolor="#FFFFFF"><%=rs.getFloat("YB")%></td>
<td height="20" nowrap bgcolor="#D2A3FF"><span class="style6">中夜班:</span></td>
<td height="20" nowrap bgcolor="#FFFFFF"><%=rs.getFloat("ZYB")%></td>
<td height="20" nowrap bgcolor="#D2A3FF"><span class="style6">其它:</span></td>
<td height="20" nowrap bgcolor="#FFFFFF"><%=rs.getFloat("QT")%></td>
<td height="20" nowrap bgcolor="#D2A3FF"> </td>
<td height="20" nowrap bgcolor="#FFFFFF"> </td>
<td height="20" nowrap bgcolor="#D2A3FF"><span class="style6"></span></td>
<td height="20" bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td bgcolor="#D2A3FF"><span class="style6">应领:</span></td>
<td nowrap><%=rs.getFloat("YL")%></td>
<td nowrap bgcolor="#D2A3FF"><span class="style6">实领:</span></td>
<td nowrap><%=rs.getFloat("SL")%></td>
<td nowrap bgcolor="#D2A3FF"><span class="style6">余额:</span></td>
<td nowrap><%=rs.getFloat("YE")%></td>
<td nowrap bgcolor="#D2A3FF"> </td>
<td nowrap> </td>
<td nowrap bgcolor="#D2A3FF"><span class="style6">领签:</span></td>
<td><%=rs.getString("LQ")%></td>
</tr>
</table>
<%}%>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?