nl.jsp

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

JSP
201 行
字号 
<%@ 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>
<title>按年龄统计</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%--
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("../index.jsp");}
else
{	if(!(page_type.equals("gz")) && !page_type.equals("sgz"))
	{response.sendRedirect("../index.jsp");}	
}
--%>
<script language="javascript">
function check()
	{	
		var nl_min=document.cx_tj.nl_min.value;
		var nl_max=document.cx_tj.nl_max.value;
		if(!isAllNumber(nl_min))
		{
			document.cx_tj.nl_min.value="";
			alert("请输入一个全部由数字组成的年龄下限！");
			document.cx_tj.nl_min.focus();return false;
		}      
		if(!isAllNumber(nl_max))
		{
			document.cx_tj.nl_max.value="";
			alert("请输入一个全部由数字组成的年龄上限！");
			document.cx_tj.nl_max.focus();return false;
		}
		if(nl_min=="" || nl_max=="")
		{	alert("年龄的上下限都要填写！");
			return false;
		}
		if(document.cx_tj.nl_min.value!=""&&document.cx_tj.nl_max.value!=""&&isAllNumber(nl_max))  
		{	if(document.cx_tj.nl_min.value.length<document.cx_tj.nl_max.value.length){}
			if(document.cx_tj.nl_min.value.length>document.cx_tj.nl_max.value.length)
			{	alert("注意：年龄上限必须大于年龄下限！"); 
		 		return false;
			}
			if(	document.cx_tj.nl_min.value.length==document.cx_tj.nl_max.value.length)
			{	if(document.cx_tj.nl_min.value>document.cx_tj.nl_max.value)
				{	alert("注意：年龄上限必须大于年龄下限！"); 
					return false;
				}
			}
		}
		return true; 
	}
	function isAllNumber(nl_min)
	{
		var test = true;
		for(var j=0;j<nl_min.length;j++)
		{
			if(nl_min.substring(j,j+1) != "0"&&
				nl_min.substring(j,j+1) != "1"&&
				nl_min.substring(j,j+1) != "2"&&
				nl_min.substring(j,j+1) != "3"&&
				nl_min.substring(j,j+1) != "4"&&
				nl_min.substring(j,j+1) != "5"&&
				nl_min.substring(j,j+1) != "6"&&
				nl_min.substring(j,j+1) != "7"&&  
				nl_min.substring(j,j+1) != "8"&&
				nl_min.substring(j,j+1) != "9")
				test=false;
		}  
		return test;
	}
	function isAllNumber(nl_max)
	{
		var test = true;
		for(var j=0;j<nl_max.length;j++)
		{
			if(nl_max.substring(j,j+1) != "0"&&
				nl_max.substring(j,j+1) != "1"&&
				nl_max.substring(j,j+1) != "2"&&
				nl_max.substring(j,j+1) != "3"&&
				nl_max.substring(j,j+1) != "4"&&
				nl_max.substring(j,j+1) != "5"&&
				nl_max.substring(j,j+1) != "6"&&
				nl_max.substring(j,j+1) != "7"&&  
				nl_max.substring(j,j+1) != "8"&&
				nl_max.substring(j,j+1) != "9")
				test=false;
		}  
		return test;
	}
</script>
<style type="text/css">
<!--
.style1 {font-size: 16px}
.style2 {
	font-size: 24px;
	color: #FF66CC;
}
.style3 {color: #FFFFFF}
.style4 {font-size: 14px}
-->
</style>
<body>
<Font size=4>
<div align="center" class="style2">按年龄统计</div>
<jsp:useBean id="conn" scope="page" class="beans.conn"/>
<%@ page import="java.util.Calendar"%>
<%String meb=response.encodeURL("nl.jsp");%>
<FORM action="<%=meb%>" Method="post" name="cx_tj" id="cx_tj" onSubmit="return check()">
  <th width=100><table  border="0" align="center">
  <tr>
    <td colspan="2" nowrap><div align="center"><span class="style1">请输入要查询年龄的范围</span></div></td>
    </tr>
  <tr>
    <td colspan="2" nowrap><div align="center"><span class="style1">年龄在</span>
          <Input name="nl_min" type=text id="nl_min" maxlength="3">
          <span class="style1"> (岁)到</span>
          <Input name="nl_max" type=text id="nl_max" maxlength="3">
          <span class="style1">(岁)之间的职工 </span></div></td>
    </tr>
  <tr>
    <td nowrap><div align="center">
      <input type="submit" name="Submit" value="查询">
    </div></td>
    <td nowrap><div align="center">
      <input type="reset" name="Submit2" value="重置">
    </div></td>
  </tr>
</table>  
</Form>
<%	String condition_all="select bh from zgxx";
	conn.setcondition(condition_all);
	ResultSet rs_all=conn.getrs();
	rs_all.last();
	int all_all=rs_all.getRow();
	float nlmin=0;
	float nlmax=0;
	String nl_min=request.getParameter("nl_min");
	String nl_max=request.getParameter("nl_max");
	if(nl_min==null){nl_min="";}
	if(nl_max==null){nl_max="";}
	if(nl_min.equals("")||nl_max.equals("")){}
	else
	{	Calendar nowday=Calendar.getInstance();
		String condition_nl="select * from zgxx where CSNY<=to_timestamp('"+(nowday.get(nowday.YEAR)-Integer.parseInt(nl_min))+"-"+(nowday.get(nowday.MONTH)+1)+"-"+nowday.get(nowday.DATE)+"','yyyy-mm-dd') and CSNY>=to_timestamp('"+(nowday.get(nowday.YEAR)-Integer.parseInt(nl_max)-1)+"-"+(nowday.get(nowday.MONTH)+1)+"-"+nowday.get(nowday.DATE)+"','yyyy-mm-dd')"; 
		conn.setcondition(condition_nl);
		ResultSet rs=conn.getrs();
		rs.last();
		int all=rs.getRow();
		int all_int=rs.getRow();
		if(all==0){out.print("<center>没有此年龄范围内的职工</center>");}
		else
		{	double bl=(int)((all*100.0/all_all)*100.0)/100.0;
			out.print("<center>找到此范围内的职工共"+all_int+"人，占在职职工的"+bl+"%</center>");
			rs.first();
%>
<table border="0" align="center">
  <tr>
    <td><table border="1" align="center" cellspacing="1" bordercolor="#FF99CC">
<%			while(rs.next())
			{
%>

      <tr>
        <td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4"><span class="style3">编号:</span></div></td>
        <td height="20" nowrap><%=rs.getString("BH")%></td>
        <td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4"><span class="style3">姓名:</span></div></td>
        <td height="20" nowrap><%=rs.getString("XM")%></td>
        <td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4"><span class="style3">性别:</span></div></td>
        <td height="20" nowrap><%=rs.getString("XB")%></td>
        <td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4"><span class="style3">年龄:</span></div></td>
        <td height="20" nowrap>
          <%	Calendar birthday=Calendar.getInstance();	
				birthday.setTime(rs.getDate("CSNY"));
				Calendar day=Calendar.getInstance();
				int age=0;
				age=day.get(day.YEAR)-birthday.get(birthday.YEAR);
				if(day.get(day.MONTH)<birthday.get(birthday.MONTH)){age--;}
				if(day.get(day.MONTH)==birthday.get(birthday.MONTH))
				{if(day.get(day.DATE)<birthday.get(birthday.DATE)){age--;}}
		%>
          <%=age%></td>
        <td nowrap bgcolor="#FF99CC"><span class="style3">工资</span></td>
        <td nowrap><%=rs.getString("GZ")%></td>
		<td nowrap bgcolor="#FF99CC"><span class="style3">各种补贴:</span></td>
		<td nowrap><%=rs.getString("GZBT")%></td>
		<td valign="middle" nowrap><a href="../cx/rs_cx_card_xxxx.jsp?bh=<%=rs.getString("bh")%>" target="_blank">详细信息...</a></td>
      </tr>
<%			}%>
 	</table></td>
  </tr>
</table>
<%		}
	}
%>
<jsp:include page="../checkout.jsp"></jsp:include>
</body>
</html>

nl.jsp - 源码说明

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

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

⌨️ 快捷键说明

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