?? savedata.jsp
字號:
<%@page contentType="text/html; charset=gb2312"%>
<%@ page import="java.util.*"%>
<%@ include file="connect_odbc.jsp"%>
<html>
<head>
<title>
保存訂餐數(shù)據(jù)
</title>
</head>
<body bgcolor="#009999">
<%
String sk,temp=null;
String user="HXK";
String year_get,month_get,day_get;
int saturday_lunch,sunday_lunch,saturday_supper,sunday_supper;
int k=0;
int ksdm=0;
int zcsl=0;
int wcsl=0;
int zitemp=0,witemp=0;
int p=0;
String err="";
boolean save=true;
sk=session.getAttribute("k").toString();
k=Integer.parseInt(sk);
sk=session.getAttribute("ksdm").toString();
user=sk.toString();
ksdm=Integer.parseInt(sk);
sk=session.getAttribute("zcsl").toString();
zcsl=Integer.parseInt(sk);
sk=session.getAttribute("wcsl").toString();
wcsl=Integer.parseInt(sk);
sk=session.getAttribute("p").toString();
p=Integer.parseInt(sk);
sk=session.getAttribute("saturday_lunch").toString();
saturday_lunch=Integer.parseInt(sk);
sk=session.getAttribute("saturday_supper").toString();
saturday_lunch=Integer.parseInt(sk);
sk=session.getAttribute("sunday_lunch").toString();
sunday_lunch=Integer.parseInt(sk);
sk=session.getAttribute("sunday_supper").toString();
sunday_supper=Integer.parseInt(sk);
if(p>0)
{
err="對不起,數(shù)據(jù)已提交不能進行修改,如需修改請和營養(yǎng)科聯(lián)系!";
save=false;
}
else
{
if(k>0)
{
int cdxh[] = new int[k];
int wcdxh[] = new int[k];
int zc[] = new int[k];
int wc[] = new int[k];
for(int i=0;i<k;i++)
{
//取得菜單序號數(shù)組
temp=session.getAttribute("cdxh"+i).toString();
cdxh[i]=Integer.parseInt(temp);
temp=session.getAttribute("wcdxh"+i).toString();
wcdxh[i]=Integer.parseInt(temp);
//取得輸入的數(shù)量數(shù)組
temp=request.getParameter("zc"+(i+1));
zc[i]=Integer.parseInt(temp);
zitemp=zitemp+zc[i];
if(zitemp>zcsl)
{
err="對不起,中餐份數(shù)太多,請重輸!";
save=false;
break;
}
temp=request.getParameter("wc"+(i+1));
wc[i]=Integer.parseInt(temp);
witemp=witemp+wc[i];
if(witemp>wcsl)
{
err="對不起,晚餐份數(shù)太多,請重輸!";
save=false;
break;
}
}
int week;
year_get=session.getAttribute("year").toString();
month_get=session.getAttribute("month").toString();
day_get=session.getAttribute("day").toString();
Calendar calendar_week=Calendar.getInstance();
calendar_week.setFirstDayOfWeek(Calendar.SUNDAY);
calendar_week.set(Calendar.YEAR,Integer.parseInt(year_get));
calendar_week.set(Calendar.MONTH,Integer.parseInt(month_get));
calendar_week.set(Calendar.DAY_OF_MONTH,Integer.parseInt(day_get));
int year,month,day,hour,minute,second;
String syear="",smonth="",sday="",shour="",sminute="",ssecond="";
String sbtid="";
String sql_1;
int n=0;
String sysj;
boolean save_1=true;
boolean save_2=true;
String sqrq="";
String sq="";
/*以下部分為取得當前系統(tǒng)時間及取得BTID號碼*/
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+"";
}
sqrq = syear+"-"+smonth+"-"+sday+" "+shour+":"+sminute+":"+ssecond;
sq=syear+smonth+sday;
sbtid = year_get+month_get+day_get;
int y,y_1;
y=Integer.parseInt(sq);
y_1=Integer.parseInt(sbtid);
if(y>=y_1)
{
err="對不起，職工餐只能訂今天以后的菜肴！";
save=false;
}
if(y_1-y==1&&Integer.parseInt(shour)>=16)
{
err="對不起，職工餐必須在下午4點前預訂！";
save=false;
}
sysj = year_get+"-"+month_get+"-"+day_get+" 00:00:00";
/*結束*/
sql_1="SELECT BTID,KSDM,TJGH,TJRQ FROM YY_EMPLOYE WHERE BTID="+sbtid+" AND KSDM="+ksdm+"";
rs = stmt.executeQuery(sql_1);
while(rs.next())
{
n++;
}
sql="insert into YY_EMPLOYE(BTID,KSDM,SYRS,SQRQ,SQGH) VALUES("+sbtid+","+ksdm+",1,to_date('"+sqrq+"','yyyy-mm-dd hh24:mi:ss'),'"+user+"')";
if(save)
{
con.setAutoCommit(false); //事務控制語句
try{
if(n<=0)
{
stmt.executeUpdate(sql);
}
//保存中餐
n=0;
for(int i=0;i<k;i++)
{
if(cdxh[i]>0)
{
sql_1="SELECT BTID FROM YY_EMPLOYE_DETAIL WHERE KSDM ="+ksdm+" AND CDXH ="+cdxh[i]+"";
rs=stmt.executeQuery(sql_1);
while(rs.next())
{
n++;
}
if(n<=0)
{
sql="insert into YY_EMPLOYE_DETAIL(BTID,KSDM,CDXH,SYSJ,SYRS,CDCX,SYSL) VALUES("+sbtid+","+ksdm+","+cdxh[i]+",to_date('"+sysj+"','yyyy-mm-dd hh24:mi:ss'),1,2,"+zc[i]+")";
stmt.executeUpdate(sql);
}
else
{
sql="update YY_EMPLOYE_DETAIL set SYSL="+zc[i]+" WHERE KSDM ="+ksdm+" AND CDXH ="+cdxh[i]+"";
stmt.executeUpdate(sql);
}
}
//保存晚餐
if(wcdxh[i]>0)
{
n=0;
sql_1="SELECT BTID FROM YY_EMPLOYE_DETAIL WHERE KSDM ="+ksdm+" AND CDXH ="+wcdxh[i]+"";
rs=stmt.executeQuery(sql_1);
while(rs.next())
{
n++;
}
if(n<=0)
{
sql="insert into YY_EMPLOYE_DETAIL(BTID,KSDM,CDXH,SYSJ,SYRS,CDCX,SYSL) VALUES("+sbtid+","+ksdm+","+wcdxh[i]+",to_date('"+sysj+"','yyyy-mm-dd hh24:mi:ss'),1,3,"+wc[i]+")";
stmt.executeUpdate(sql);
}
else
{
sql="update YY_EMPLOYE_DETAIL set SYSL="+wc[i]+" WHERE KSDM ="+ksdm+" AND CDXH ="+wcdxh[i]+"";
stmt.executeUpdate(sql);
}
}
}
con.commit();
err="數(shù)據(jù)保存成功，謝謝使用！";
}
catch(SQLException se)
{
out.println(sql);
con.rollback();
err=se.getMessage()+",數(shù)據(jù)保存失敗!";
}
}
}
else
{
err="對不起,出現(xiàn)錯誤,數(shù)據(jù)不能保存!";
}
}
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>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -