gz_dy_bm.jsp

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

JSP
159 行
字号 
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../Connections/sdog.jsp" %>
<%String Recordset1__MMColParam =null;
String bm=request.getParameter("bm");
if(bm==null){bm="";}
else{
  byte a[]=bm.getBytes("ISO-8859-1");
  bm=new String(a);
  Recordset1__MMColParam =bm;}
%>
<div align="center">
<%  out.print(bm+"工资详单");%></div>
<%
Driver DriverRecordset1 = (Driver)Class.forName(MM_sdog_DRIVER).newInstance();
Connection ConnRecordset1 = DriverManager.getConnection(MM_sdog_STRING,MM_sdog_USERNAME,MM_sdog_PASSWORD);
PreparedStatement StatementRecordset1 = ConnRecordset1.prepareStatement("SELECT * FROM BGZDH.BZGZ WHERE BM = '" + Recordset1__MMColParam + "'");
ResultSet Recordset1 = StatementRecordset1.executeQuery();
boolean Recordset1_isEmpty = !Recordset1.next();
boolean Recordset1_hasData = !Recordset1_isEmpty;
Object Recordset1_data;
int Recordset1_numRows = 0;
%>
<%
int Repeat1__numRows = -1;
int Repeat1__index = 0;
Recordset1_numRows += Repeat1__numRows;
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>部门工资报表</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body>
<div>
<%
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");}	
}
%>
<a href="gz_print_bm.jsp?bm=<%=bm%>">打印本部门工资条</a>
</div>
<table border="1">
  <tr>
    <td>编号</td>
    <td>部门</td>
    <td>姓名</td>
    <td>工资</td>
    <td>各种补贴</td>
    <td>日工资</td>
    <td>工天</td>
    <td>超时</td>
    <td>超价</td>
    <td>超资</td>
    <td>加天</td>
    <td>加资</td>
    <td>浮资</td>
    <td>上月余</td>
    <td>事天</td>
    <td>病天</td>
    <td>扣缺勤</td>
    <td>扣病假</td>
    <td>粮副地工</td>
    <td>粮贴</td>
    <td>副贴</td>
    <td>政府贴</td>
    <td>单位贴</td>
    <td>工龄</td>
    <td>中夜班</td>
    <td>岗位薪</td>
    <td>保健</td>
    <td>业务</td>
    <td>房贴</td>
    <td>交通补贴</td>
    <td>书报</td>
    <td>煤贴</td>
    <td>卫生</td>
    <td>药补</td>
    <td>应领</td>
    <td>扣房租</td>
    <td>扣会费</td>
    <td>扣公积金</td>
    <td>违纪</td>
    <td>余额</td>
    <td>实领</td>
    <td>其他</td>
    <td>保险</td>
    <td>领签</td>
    <td>进厂年月</td>
  </tr>
  <% while ((Recordset1_hasData)&&(Repeat1__numRows-- != 0)) { %>
  <tr>
    <td><%=(((Recordset1_data = Recordset1.getObject("BH"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("BM"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("XM"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("GZ"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("GZBT"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("RGZ"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("GT"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("CS"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("CJ"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("CZ"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("JT"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("JZ"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("FZ"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("SYY"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("ST"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("BT"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("KQQ"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("KBJ"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("LFDG"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("LT"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("FT"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("ZFT"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("DWT"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("GL"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("ZYB"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("GWX"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("BJ"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("YW"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("FANGTIE"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("JIAOTONG"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("SB"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("MT"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("WS"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("YB"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("YL"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("KFZ"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("KHF"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("KGJJ"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("WJ"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("YE"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("SL"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("QT"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("BX"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("LQ"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
    <td><%=(((Recordset1_data = Recordset1.getObject("JCNY"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
  </tr>
  <%
  Repeat1__index++;
  Recordset1_hasData = Recordset1.next();
}
%>
</table>
<div><a href="../index/gz_index.jsp">返回主页</a></div>
</body>
</html>
<%
Recordset1.close();
StatementRecordset1.close();
ConnRecordset1.close();
%>

gz_dy_bm.jsp - 源码说明

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

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

⌨️ 快捷键说明

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