gz_add_lxry.jsp
来自「JSP页面和oracle9i数据库的源代码」· JSP 代码 · 共 324 行
JSP
324 行
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.text.*"%>
<%@ page import="java.util.*"%>
<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/adminbg.gif);
}
-->
</style>
<script Language="JavaScript">
function on_gt(form,daynum){
var strs=form.gt.value;
var daynum;
if( !isAllNumber(strs)){
form.gt.value="";
alert("请输入正确的数据--数字！");
form.gt.focus();
}
if(strs>daynum) {
form.gt.value="";
alert("请输入正确的数据--\<"+daynum+"天！");
form.gt.focus();}
}
function on_rgz(form){
var strs=form.rgz.value;
if( !isdotNumber(strs)){
form.rgz.value="";
alert("请输入正确的数据--数字！");
form.rgzfocus();
}
}
function isdotNumber(str)
{
var test=true;
var i=str.length;
var staus;//staus用于记录.的个数
status=0;
//当最后一位为.时出错
if (str.charAt(i-1)=='.')
{
//alert("无效数字！.");
test=false;
return test;
}
for (j=0;j<i;j++)
{
if (str.charAt(j)=='.')
{
status++;
}
if (status>1)
{
//alert("无效数字！.");
test=false;
return test;
}
if (str.charAt(j)<'0' || str.charAt(j)>'9' )
{
if (str.charAt(j)!='.')
{
//alert("无效数字！.");
test=false;
return test;
}
}
}
return test;
}
function on_jcny()
{ var d=0;
var jcny_year=document.form1.jcny_year.value;
var jcny_month=document.form1.jcny_month.value;
var jcny_day=document.form1.jcny_day.value;
if(!isAllNumber(jcny_year))
{
document.form1.jcny_year.value="";
alert("请输入一个全部由数字组成的进厂年份！");return false;
}
if(!(jcny_year%100))
{ if(!(jcny_year%400))
var d=2;
else
var d=1;
}
else
{ if(!(jcny_year%4))
var d=2;
else
var d=1;
}
if(d!=0)
{ if(jcny_month=="4"||
jcny_month=="6"||
jcny_month=="9"||
jcny_month=="11"||
jcny_month=="2")
{if(jcny_day>30)
{ alert(jcny_month+"月没有"+jcny_day+"号");
document.form1.jcny_day.valuejc="1";
}
if(jcny_month=="2")
{ if(jcny_day==30)
{ alert("2月没有"+jcny_day+"号");document.form1.jcny_day.value="1";}
if(d==1)
{ if(jcny_day==29)
{alert(jcny_year+"年的2月没有"+jcny_day+"号");document.form1.jcny_day.value="1";}
}
}
}
}
}
function validate()
{
if (document.form1.xm.value=="")
{
alert("姓名不能为空！");
document.form1.xm.focus();
return false ;
}
if (document.form1.gt.value=="")
{
alert("工天不能为空！");
document.form1.gt.focus();
return false ;
}
if (document.form1.rgz.value=="")
{
alert("日工资不能为空！");
document.form1.rgz.focus();
return false ;
}
if(document.form1.jcny_year.value=="")
{
alert("进厂年月不能为空！");
document.form1.jcny.focus();
return false ;
}
if(on_jcny()) {return false;}
}
function isAllNumber(jcny_year)
{
var test = true;
for(var j=0;j<jcny_year.length;j++)
{
if(jcny_year.substring(j,j+1) != "0"&&
jcny_year.substring(j,j+1) != "1"&&
jcny_year.substring(j,j+1) != "2"&&
jcny_year.substring(j,j+1) != "3"&&
jcny_year.substring(j,j+1) != "4"&&
jcny_year.substring(j,j+1) != "5"&&
jcny_year.substring(j,j+1) != "6"&&
jcny_year.substring(j,j+1) != "7"&&
jcny_year.substring(j,j+1) != "8"&&
jcny_year.substring(j,j+1) != "9")
test=false;
}
return test;
}
</script>
</head>
<body>
<jsp:useBean id="conn" scope="page" class="beans3.conn"/>
<%try{
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=null;
int count=0;
String tmp_bh=null;
%>
<%
Calendar cal = Calendar.getInstance();
SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMddHHmmss");
tmp_bh="L"+formatter.format(cal.getTime());
%>
<%
condition="select to_char(last_day(sysdate),'dd') days,EXTRACT(year FROM SYSDATE) year,EXTRACT(month FROM SYSDATE) month,EXTRACT(day FROM SYSDATE) day from dual";
rs=conn.executeQuery(condition);
String daynum=null,years=null,months=null,dday=null;
while(rs.next())
{daynum=rs.getString("days");
years=rs.getString("year");
months=rs.getString("month");
dday=rs.getString("day");}
%>
<form name="form1" method="post" action="gz_add_sav_lxry.jsp?tmp_bh=<%=tmp_bh%>" onsubmit="return validate()">
<div align="center" class="style1">
<p class="f1">添加临时人员</p>
<p align="left" class="style4"> <span class="style2"><a href="../index/gz_index.jsp" class="f1">返回主页</a></span></p>
<table width="300" border="1" cellpadding="0" cellspacing="0" bordercolor="#F3D6F5">
<tr class="f1">
<td width="100"><div align="right" class="style3"> 编号：</div></td>
<td><div align="left">
<input name="bh" type="disable" disabled id="bh" value="<%=tmp_bh%>" maxlength="8"style=" 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">
</div></td>
</tr>
<tr class="f1">
<td><div align="right">部门：</div></td>
<td><select name="bm" id="select">
<option value="0">部门</option>
<% condition="select * from BGZDH.BM";
rs=conn.executeQuery(condition);
while(rs.next())
{
%>
<option value="<%=rs.getString("BM")%>" selected><%=rs.getString("BM")%></option>
<%
}
%>
</select></td>
</tr>
<tr class="f1">
<td><div align="right">姓名：</div></td>
<td><input name="xm" type="text" id="xm" maxlength="8"style=" 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"></td>
</tr>
<tr class="f1">
<td><div align="right">工天：</div></td>
<td><input name="gt" type="text" id="gt"style=" 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" onChange="on_gt(this.form,<%=daynum%>)" value="<%=daynum%>" maxlength="3"></td>
</tr>
<tr class="f1">
<td><div align="right">日工资：</div></td>
<td><input name="rgz" type="text" id="rgz" maxlength="5"style=" 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"onChange="on_rgz(this.form)"></td>
</tr>
<tr class="f1">
<td><div align="right">进厂年月：</div></td>
<td><input name="jcny_year" type="text" id="jcny_year"style=" 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" onChange="on_jcny()" value="<%=years%>" size="4" maxlength="4">
年
<select name="jcny_month" id="jcny_month" onChange="on_jcny()">
<option value="<%=months%>" selected><%=months%></option>
<% int i=0;
for(i=1;i<13;i++)
{if(i!=Integer.parseInt(months)){
%><option value="<%=i%>"><%=i%></option>
<%
} }
%>
</select>
月
<select name="jcny_day" id="jcny_day" onChange="on_jcny()">
<option value="<%=dday%>" selected><%=dday%></option>
<% int j=0;
for(j=1;j<32;j++)
{if(j!=Integer.parseInt(dday)){
%><option value="<%=j%>"><%=j%></option>
<%
}}
%>
</select>
日</td>
</tr>
</table>
<p>
<input name="Submit" type="submit" value="提交">
<input name="Submit2" type="reset" value="重置">
</p>
</div>
</form>
<div align="center">
<p class="f1">现有临时人员列表</p>
<span class="f1">
<%SimpleDateFormat formatter1 = new SimpleDateFormat("MM/dd/yyyy HH:mm:ss");%>
<%
int all=0;
%>
<%
condition="select * from BGZDH.BZGZ where BH LIKE "+"'"+"L%"+"'";
rs=conn.executeQuery(condition);
%>
</span>
<table width="600" border="1" cellpadding="0" cellspacing="1" bordercolor="#D2A3FF">
<tr bgcolor="#D2A3FF">
<th class="f1" scope="col">编号</th>
<th class="f1" scope="col">部门</th>
<th class="f1" scope="col">姓名</th>
<th class="f1" scope="col">日工资</th>
<th class="f1" scope="col">工天</th>
<th class="f1" scope="col">进厂年月</th>
</tr>
<%
while(rs.next())
{all++;
%>
<tr class="f1">
<td><div align="center" class="f1"><%=rs.getString("BH")%></div></td>
<td><div align="center" class="f1"><%=rs.getString("BM")%></div></td>
<td><div align="center" class="f1"><%=rs.getString("XM")%></div></td>
<td><div align="center" class="f1"><%=rs.getString("RGZ")%></div></td>
<td><div align="center" class="f1"><%=rs.getString("GT")%></div></td>
<td><div align="center" class="f1"><%=rs.getDate("JCNY")%></div></td>
</tr>
<%}%>
<%if(all==0){out.print("<tr bgcolor=#CCCCFF><td height=30 colspan=6><div align=center>当前无记录</div></td></tr> ");}%>
<% }catch (Exception e) {e.getMessage();}%>
</table>
<p></p>
</div>
</body>
</html>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?