⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 gl_zg.jsp

📁 JSP页面和oracle9i数据库的源代码
💻 JSP
字号:
🔍 
<%@ 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 type="text/css">
<!--
body {
	background-image: url(tu/mainbg.gif);
}
-->
</style></head>
<body>
<div align="center">
  <%@ include file="/commond/conn.jsp"%>
  <%
String page_type=(String)session.getAttribute("page_type");
String page_name=(String)session.getAttribute("page_name");
String page_bm=(String)session.getAttribute("page_bm");
if(page_type==null){page_type="";}
if(page_bm==null){page_type="";}
if(session.isNew()){response.sendRedirect("ptyg.jsp");}
else
{	if(!page_type.equals("sgz")&&!page_type.equals("gz"))
	{response.sendRedirect("ptyg.jsp");}	
}
%>
  <%String condition=null;
  if(page_type.equals("sgz"))
  {condition="select distinct BZGZ.BH from BZGZ";}
  if(page_type.equals("gz"))
  {condition="select distinct BZGZ.BH from BZGZ where BM='"+page_bm+"'";}
	rs=sql.executeQuery(condition);
%>
</div>
<form name="form1" method="post" action="gl_zg.jsp">
  <div align="center">请选择待输入职工编号:
    <select name="bh" id="select">
    <option value="0">工号</option>
    <%while(rs.next())
		  	   {%>
    <option value=<%=rs.getString("BH")%>><%=rs.getString("BH")%></option>
    <%}%>
  </select>
  <input type="submit" name="Submit" value="输入">
  <a href="ptyg.jsp">返回主菜单</a></div>
</form>
<div align="center">
        <% String bh=request.getParameter("bh");
	   	 if(bh==null){bh="";}
	   	 byte a[]=bh.getBytes("ISO-8859-1");
		 bh=new String(a);	 
		 int all=0;
		 int flag=0;
		 if(bh.equals("0")){out.print("请您选择工号");}
		 else
		 { condition="select * from BZGZ where BH="+"'"+bh+"'";
		 	rs=sql.executeQuery(condition);
			while(rs.next())
			{all++;%>
</div>
<form name="form2"  method="post" action="gl_zg.jsp?bh=<%=bh%>&flag=1">  			
<table width="900" height="100" border="1" align="center" cellpadding="0" cellspacing="1" bordercolor="#3399FF">
                  <!--DWLayoutTable-->
                  <tr>
                    <td height="20" colspan="8" valign="middle"bgcolor="#FF99CC"><div align="center"><%=rs.getString("BM")%>职工工资信息表</div></td>
                  </tr>
                  <tr>
                    <td width="119" bgcolor="#FF99CC"><div align="center">职工编号:</div></td>
                    <td width="103"><div align="center"><%=rs.getString("BH")%></div></td>
                    <td width="110" bgcolor="#FF99CC"><div align="center">职工姓名:</div></td>
                    <td width="108"><div align="center"><%=rs.getString("XM")%></div></td>
                    <td width="110" bgcolor="#FF99CC"><div align="center">所在部门:</div></td>
                    <td width="107"><div align="center"><%=rs.getString("BM")%></div></td>
                    <td width="114" bgcolor="#FF99CC"><div align="center">基本工资:</div></td>
                    <td width="102"><div align="center"><%=rs.getString("GZ")%></div></td>
                  </tr>
                  <tr>
                    <td bgcolor="#FF99CC"><div align="center">工龄:</div></td>
                    <td><div align="center"><%=rs.getString("GL")%></div></td>
                    <td bgcolor="#FF99CC"><div align="center">进厂年月:</div></td>
                    <td><div align="center"><%=rs.getDate("JCNY")%></div></td>
                    <td bgcolor="#FF99CC"><div align="center">工天:</div></td>
                    <td><div align="center"><%=rs.getString("GT")%></div></td>
                    <td bgcolor="#FF99CC"><div align="center">日工资:</div></td>
                    <td><div align="center"><%=rs.getString("RGZ")%></div></td>
                  </tr>
                  <tr>
                    <td bgcolor="#FF99CC"><div align="center">上月余:</div></td>
                    <td><div align="center"><%=rs.getString("SYY")%></div></td>
                    <td bgcolor="#FF99CC"><div align="center">应领:</div></td>
                    <td><div align="center"><%=rs.getString("YL")%></div></td>
                    <td bgcolor="#FF99CC"><div align="center">实领:</div></td>
                    <td><div align="center"><%=rs.getString("SL")%></div></td>
                    <td bgcolor="#FF99CC"><div align="center">余额:</div></td>
                    <td><div align="center"><%=rs.getString("YE")%></div></td>
                  </tr>
  </table>
                <br>                
                <table width="900" height="150" border="1" align="center" cellpadding="0" cellspacing="1" bordercolor="#3399FF">
                  <!--DWLayoutTable-->
                  <tr>
                    <td height="20" colspan="12" valign="top"bgcolor="#FF99CC"><div align="center"><%=rs.getString("XM")%>工资明细表</div></td>
                  </tr>
                  <tr>
				  <td bgcolor="#FF99CC"><div align="center">领签:</div></td>
                    <td><div align="center"><%=rs.getString("LQ")%></div></td>
                    
                    <td width="73" bgcolor="#FF99CC"><div align="center">超价:</div></td>
                    <td width="72"><div align="center"> <%=rs.getString("CJ")%>
                    </div></td>
                    <td width="75" bgcolor="#FF99CC"><div align="center">超资:</div></td>
                    <td width="73"><div align="center"><%=rs.getString("CZ")%></div></td>
					<td width="77" bgcolor="#FF99CC"><div align="center">扣公积金:</div></td>
                    <td width="64"><div align="center"><%=rs.getString("KGJJ")%></div></td>
                    
                   <td width="70" bgcolor="#FF99CC"><div align="center">加资:</div></td>
                    <td width="71"><p align="center"><%=rs.getString("JZ")%></p>                  </td>
                    <td width="71" bgcolor="#FF99CC"><div align="center">浮资:</div></td>
                    <td width="70"><div align="center"><%=rs.getString("FZ")%></div></td>
                  </tr>
                  <tr>
                    <td bgcolor="#FF99CC"><div align="center">粮副地工:</div></td>
                    <td><div align="center"><%=rs.getString("LFDG")%></div></td>
                    <td bgcolor="#FF99CC"><div align="center">粮贴:</div></td>
                    <td><div align="center"><%=rs.getString("LT")%></div></td>
                    <td bgcolor="#FF99CC"><div align="center">副贴:</div></td>
                    <td><div align="center"><%=rs.getString("FT")%></div></td>
                    <td bgcolor="#FF99CC"><div align="center">单位贴:</div></td>
                    <td><div align="center"><%=rs.getString("DWT")%></div></td>
                    <td bgcolor="#FF99CC"><div align="center">中夜班:</div></td>
                    <td><div align="center"><%=rs.getString("ZYB")%></div></td>
                    <td bgcolor="#FF99CC"><div align="center">岗位薪:</div></td>
                    <td><div align="center"><%=rs.getString("GWX")%></div></td>
                  </tr>
                  <tr>
                    <td bgcolor="#FF99CC"><div align="center">保健:</div></td>
                    <td><div align="center"><%=rs.getString("BJ")%></div></td>
                    <td bgcolor="#FF99CC"><div align="center">业务:</div></td>
                    <td><div align="center"><%=rs.getString("YW")%></div></td>
                    <td bgcolor="#FF99CC"><div align="center">房贴:</div></td>
                    <td><div align="center"><%=rs.getString("FANGTIE")%></div></td>
                    <td bgcolor="#FF99CC"><div align="center">交通:</div></td>
                    <td><div align="center"><%=rs.getString("JIAOTONG")%></div></td>
                    <td bgcolor="#FF99CC"><div align="center">书报:</div></td>
                    <td><div align="center"><%=rs.getString("SB")%></div></td>
                    <td bgcolor="#FF99CC"><div align="center">煤贴:</div></td>
                    <td><div align="center"><%=rs.getString("MT")%></div></td>
                  </tr>
                  <tr>

                    <td bgcolor="#FF99CC"><div align="center">卫生:</div></td>
                    <td><div align="center"><%=rs.getString("WS")%></div></td>
                    <td bgcolor="#FF99CC"><div align="center">药补:</div></td>
                    <td><div align="center"><%=rs.getString("YB")%></div></td>
                    <td bgcolor="#FF99CC"><div align="center">政府贴:</div></td>
                    <td><div align="center"><%=rs.getString("ZFT")%></div></td>
                    <td bgcolor="#FF99CC"><div align="center">工资贴:</div></td>
                    <td align="center"><%=rs.getString("GZBT")%></td>
                    <td bgcolor="#FF99CC"><div align="center">保险:</div></td>
                    <td><div align="center"><%=rs.getString("BX")%></div></td>
                    <td bgcolor="#FF99CC"><div align="center">违纪:</div></td>
                    <td><div align="center"><%=rs.getString("WJ")%></div></td>
                  </tr>
                  <tr>
                    <td bgcolor="#FF99CC"><div align="center">事天:</div></td>
                    <td><div align="center"><input name="st" type="text" value=<%=rs.getString("ST")%> size="8"></div></td>
                    <td bgcolor="#FF99CC"><div align="center">病天:</div></td>
                    <td><div align="center"><input name="bt" type="text" value=<%=rs.getString("BT")%> size="8"></div></td>
                    <td bgcolor="#FF99CC"><div align="center">扣缺勤:</div></td>
                    <td><div align="center"><%=rs.getString("KQQ")%></div></td>
                    <td bgcolor="#FF99CC"><div align="center">扣病假:</div></td>
                    <td><div align="center"><%=rs.getString("KBJ")%></div></td>
                    <td bgcolor="#FF99CC"><div align="center">房租:</div></td>
                    <td><div align="center"><%=rs.getString("KFZ")%></div></td>
                    <td bgcolor="#FF99CC"><div align="center">会费:</div></td>
                    <td><div align="center"><%=rs.getString("KHF")%></div></td>
                  </tr>
                  <tr>
                    <td width="74" bgcolor="#FF99CC"><div align="center">超时:</div></td>
                    <td width="71"><div align="center">
                      <input name="cs" type="text" value=<%=rs.getString("CS")%> size="8">
                    </div></td>
                   <td width="73" bgcolor="#FF99CC"><div align="center">加天:</div></td>
                    <td width="72"><div align="center"><input name="jt" type="text" value=<%=rs.getString("JT")%> size="8">
                    </div></td>
                    <td bgcolor="#FF99CC"><div align="center">其他:</div></td>
                    <td><div align="center"><%=rs.getString("QT")%></div></td>
                    <td bgcolor="#FF99CC">&nbsp;</td>
                    <td>&nbsp;</td>
                    <td bgcolor="#FF99CC">&nbsp;</td>
                    <td>&nbsp;</td>
                    <td bgcolor="#FF99CC">&nbsp;</td>
                    <td>&nbsp;</td>
                  </tr>
  </table>
                <p align="center">
                  <input type="submit" name="Submit2" value="提交">&nbsp;
                  <input type="reset" name="Submit3" value="重置">
  </p>
</form>
<% 
if (request.getParameter("flag")==null) {}
  else
  {
    String bh2=request.getParameter("bh");
float csx=Float.parseFloat(request.getParameter("cs"));
float jtx=Float.parseFloat(request.getParameter("jt"));
float stx=Float.parseFloat(request.getParameter("st"));
float btx=Float.parseFloat(request.getParameter("bt"));
sql.executeUpdate("update BZGZ set CS='"+csx+"',JT='"+jtx+"',ST='"+stx+"',BT='"+btx+"'");
}
%>
<div align="center">
  <hr align="center" width="900">       
  <%
			}
			 if(all==0 && !bh.equals("")){out.print("数据库中没有这个员工的信息");}
			 else{ if(all<0){out.print("系统错误！请关闭网页重新登入！如有疑问请与软件开发商联系！");}
			  if(all>1){	out.print("出现职工编号重复情况请与网站开发商联系");}
			}
		 }
	   %>
</div>
        <center> 
		</center>
</body>
</html>

⌨️ 快捷键说明

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