gz_tj_dw_xx.jsp

来自「JSP页面和oracle9i数据库的源代码」· JSP 代码 · 共 176 行

JSP
176 行
字号 
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<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);	
}
.style6 {color: #3333FF}
-->
</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="gz_tj_dw.jsp">返回</a>



<%String mess=null;
  ResultSet rs=null; 
  int total=0;
 int all=Integer.parseInt(request.getParameter("all"));
String sp="select * from BZGZ where";
switch(all)
{case 0:sp=sp+" YL<1000";mess="工资少于1000的员工详细资料";break;
 case 1:sp=sp+" YL between 1000 and 2000";mess="工资在1000与2000之间的员工详细资料";break;
 case 2:sp=sp+" YL between 2000 and 5000";mess="工资在2000与5000之间的员工详细资料";break;
 case 3:sp=sp+" YL between 5000 and 8000";mess="工资在5000与8000之间的员工详细资料";break;
 case 4:sp=sp+" YL>8000";mess="工资在8000之上的员工详细资料";break;
 default:out.print("错误！请确认统计范围！");
}
sp=sp+" order by BH";
rs=conn.executeQuery(sp);
out.print("<div align=center>"+mess+"</div>");
while(rs.next())
{total++;
%>
      <br>

<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">&nbsp;</td>
         <td height="20" nowrap bgcolor="#FFFFFF">&nbsp;</td>
         <td height="20" nowrap bgcolor="#D2A3FF"><span class="style6"></span></td>
         <td height="20" bgcolor="#FFFFFF">&nbsp;</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">&nbsp;</td>
         <td nowrap>&nbsp;</td>
         <td nowrap bgcolor="#D2A3FF"><span class="style6">领签:</span></td>
         <td><%=rs.getString("LQ")%></td>
       </tr>
</table>
<%}
if(total==0)
{out.print("<p align=center>没有符合条件的员工记录！</p>");}%>
    


</body>
</html>

gz_tj_dw_xx.jsp - 源码说明

本页面展示了「JSP页面和oracle9i数据库的源代码」中的 gz_tj_dw_xx.jsp 源码文件，采用 JSP 编程语言编写，共 176 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与oracle9i相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?