?? commitdata.jsp
字號:
<%@page contentType="text/html; charset=gb2312"%>
<%@ page import="java.util.*,java.text.SimpleDateFormat"%>
<%@ include file="connect_odbc.jsp"%>
<html>
<head>
<title>
提交數據
</title>
</head>
<body bgcolor="#009999" >
<%
String tjrq,btid;
int year,month,day,hour,minute,second;
String syear,smonth,sday,shour,sminute,ssecond;
String ksdm,year_get,month_get,day_get;
int iyear_get,imonth_get,iday_get,n;
String err="";
String user="BSS";
String sql_1="";
String temp=null;
GregorianCalendar calendar;
calendar=new GregorianCalendar();
year=calendar.get(Calendar.YEAR);
month=calendar.get(Calendar.MONTH)+1;//月份
day=calendar.get(Calendar.DAY_OF_MONTH);//天
hour=calendar.get(Calendar.HOUR_OF_DAY);//小時(24小時制)
minute=calendar.get(Calendar.MINUTE);//分鐘
second=calendar.get(Calendar.SECOND);//秒
//年份
if(year<10)
{
syear="0"+year;
}
else
{
syear=year+"";
}
//月份
if(month<10)
{
smonth="0"+month;
}
else
{
smonth=month+"";
}
//日
if(day<10)
{
sday="0"+day;
}
else
{
sday=day+"";
}
//小時
if(hour<10)
{
shour="0"+hour;
}
else
{
shour=hour+"";
}
//分鐘
if(minute<10)
{
sminute="0"+minute;
}
else
{
sminute=minute+"";
}
//秒
if(second<10)
{
ssecond="0"+second;
}
else
{
ssecond=second+"";
}
year_get=session.getAttribute("year").toString();
month_get=session.getAttribute("month").toString();
day_get=session.getAttribute("day").toString();
ksdm=session.getAttribute("ksdm").toString();
user=ksdm;
iyear_get=Integer.parseInt(year_get);
imonth_get=Integer.parseInt(month_get);
iday_get=Integer.parseInt(day_get);
if(iyear_get<10)
{
// year_get="0"+year_get;
}
if(imonth_get<10)
{
// month_get="0"+month_get;
}
if(iday_get<10)
{
// day_get="0"+day_get;
}
tjrq = syear+"-"+smonth+"-"+sday+" "+shour+":"+sminute+":"+ssecond;
btid = year_get+month_get+day_get;
int y,y_1;
y=Integer.parseInt(syear+smonth+sday);
y_1=Integer.parseInt(btid);
//計算相差的天數
SimpleDateFormat formatter = new SimpleDateFormat ("yyyy-MM-dd");
java.util.Date dt1=formatter.parse(syear+"-"+smonth+"-"+sday);
java.util.Date dt2=formatter.parse(year_get+"-"+month_get+"-"+day_get);
long l = (dt2.getTime() - dt1.getTime())/(3600*24*1000);
if(y>=y_1)
{
err="對不起，職工餐只能提交今天以后的菜肴！";
}
else
{
if(Integer.parseInt(shour)>=16 && l<=1)
{
err="對不起,職工餐必須在下午4點鐘以前提交到營養科!";
}
else
{
sql="SELECT BTID,KSDM, TJGH,TJRQ FROM YY_EMPLOYE WHERE BTID="+btid+" AND KSDM="+ksdm+"";
n=0;
sql_1="UPDATE YY_EMPLOYE SET TJGH='"+user+"',TJRQ=to_date('"+tjrq+"','yyyy-mm-dd hh24:mi:ss') WHERE BTID="+btid+" AND KSDM="+ksdm+"";
con.setAutoCommit(false); //事務控制語句
try
{
rs=stmt.executeQuery(sql);
while(rs.next())
{
temp=rs.getString(4);
n++;
}
if(n>0)
{
if(temp==null||temp.equals("null"))
{
stmt.executeUpdate(sql_1);
con.commit();
err="數據提交成功，謝謝使用！";
}
else
{
err="數據已經提交，無需再提交！";
}
}
else
{
err="對不起，數據未保存，請先保存數據！";
}
}
catch(SQLException se1)
{
con.rollback();
err="對不起，數據提交失敗，"+se1.getMessage();
}
}
}
pool.releaseConnection(con);
%>
<BR><BR><BR>
<FONT face="宋體" SIZE="5" COLOR=""><CENTER><%=err%></CENTER></FONT>
<BR>
<CENTER><a href="javascript:history.back();"><FONT face="宋體" SIZE="5" COLOR="">返回</FONT></a></CENTER>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -