gz_tj_bm.jsp
来自「JSP页面和oracle9i数据库的源代码」· JSP 代码 · 共 130 行
JSP
130 行
<%@ 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: 8pt; font-family: Verdana; line-height: 12pt }
body {
background-image: url(../img/011qq.gif);
}
input.noborInput{background:#ffffff; border-bottom-width:0px;border-top-width:0px;border-left-width:0px;border-right-width:0px; solid #ff6633; COLOR: #3300FF; FONT-SIZE: 10pt}
input.smallInput{BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid}
input.buttonface{BACKGROUND: #CCCCFF; border:1 solid #CC33FF; COLOR: #CC00FF; FONT-SIZE: 9pt; FONT-STYLE: normal; FONT-VARIANT: normal; FONT-WEIGHT: normal; HEIGHT: 18px; LINE-HEIGHT: normal}
.style2 {color: #3333FF}
.style3 {color: #000000}
-->
</style>
</head>
<body>
<div align="center">
<jsp:useBean id="conn" scope="page" class="beans1.conn"/>
<%--
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");}
}
--%>
<% ResultSet rs=null;
String condition="select * from BM";
String condition1="Insert into BGZDH.BZGZ.YQ select XM from BGZDH.BZK";
rs=conn.executeQuery(condition);
%>
</div>
<form name="form1" method="post" action="../sum/gz_tj_bm.jsp" class="f1">
<div align="center">请选择按那个部门查询:
<select name="bm" id="select">
<option value="0">部门</option>
<%while(rs.next())
{%>
<option value=<%=rs.getString("BM")%>><%=rs.getString("BM")%></option>
<%}%>
</select>
<input name="Submit" type="submit" class="buttonface" value="查询">
<a href="../index/gz_index.jsp" class="f1">返回主菜单</a></div>
</form>
<div align="center">
<%String bm=request.getParameter("bm");
if(bm==null){bm="";}
byte a[]=bm.getBytes("ISO-8859-1");
bm=new String(a);
int all=0;
if(bm.equals("0")){out.print("<SCRIPT language=JavaScript>alert('请您先选择要查询的部门！');</script>");}
else
{ condition="select * from BZGZ where BM='"+bm+"'";
condition=condition+" order by BH";
rs=conn.executeQuery(condition);
%>
</div>
<p> </p>
<table width="540" height="64" border="1" align="center" cellpadding="0" cellspacing="1" bordercolor="#CC66FF" class="f1">
<tr bgcolor="#CC99FF">
<th height="30" colspan="11" scope="col"><span class="style2"><%=bm%> 职工工资信息表</span></th>
</tr>
<tr>
<td width="70" bgcolor="#CC99FF"><div align="center" class="style2">职工编号</div></td>
<td width="70" bgcolor="#CC99FF"><div align="center" class="style2">职工姓名</div></td>
<td width="70" bgcolor="#CC99FF"><div align="center" class="style2">所在部门</div></td>
<td width="70" bgcolor="#CC99FF"><div align="center" class="style2">应发工资</div></td>
<td width="70" bgcolor="#CC99FF"><div align="center" class="style2">实领工资</div></td>
<td width="70" bgcolor="#CC99FF"><div align="center" class="style2"></div></td>
</tr>
<%
while(rs.next())
{all++;%>
<tr>
<td width="70"><div align="center"><%=rs.getString("BH")%></div></td>
<td width="70"><div align="center"><%=rs.getString("XM")%></div></td>
<td width="70"><div align="center"><%=rs.getString("BM")%></div></td>
<td width="70"><div align="center"><%=rs.getString("YL")%></div></td>
<td width="70"><div align="center"><%=rs.getString("SL")%></div></td>
<td width="70"><div align="center"><span class="style3"><a href="gz_tj_bm_xx.jsp?bh=<%=rs.getString("BH")%>">详细情况</a></span></div></td>
</tr>
<%}%>
<%if(all==0){out.print("<tr><td height=30 colspan=6><div align=center>当前无记录</div></td></tr> ");}%>
</table>
<br>
<% if(all==0 && !bm.equals("")){out.print("数据库中没有这个部门员工的信息");}
if(all<0){out.print("系统错误！请关闭网页重新登入！如有疑问请与软件开发商联系！");}
%>
<table width="540" border="1" align="center" cellpadding="0" cellspacing="1" bordercolor="#CC66FF" class="f1">
<tr bgcolor="#CC99FF">
<td><div align="center" class="style2"><strong>本单位应发工资总额</strong></div></td>
<td width="180"><div align="center" class="style2"><span class="style2"><strong>本部门应发工资总额</strong></span></div></td>
<td width="178"><div align="center" class="style2"><span class="style2"><strong>本部门平均工资</strong></span></div></td>
</tr>
<tr>
<%--
condition="select sum(YL) from BZGZ";
rs=conn.executeQuery(condition);
while(rs.next())
{ --%>
<%//}%>
<%
condition="select sum(YL),sum(SL),avg(YL) from BZGZ where BM='"+bm+"'";
rs=conn.executeQuery(condition);
while(rs.next())
{ %>
<td><div align="center"><%=rs.getString("sum(YL)")%> 元</div></td>
<td width="134"><div align="center"><%=rs.getString("sum(SL)")%> 元</div></td>
<td width="134"><div align="center"><%=rs.getString("avg(YL)")%> 元</div></td>
<%}%>
</tr>
</table>
<%}%>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?