📄 main.jsp

📁 以JSP与TOMCAT数据库连接池实现的订餐系统
💻 JSP
📖 第 1 页 / 共 2 页
字号:
上一页 12
		        </div></td>
				<td width="113">
			  <div align="center"><%=cdmc[5]%>
		        </div></td>
				<td width="113">
			  <div align="center"><%=cdmc[6]%>
		        </div></td>
  </tr>
  <tr>
   <td width="87">
  	 <div align="center">份数
    </div></td>
  <td width="113">
  <%
  sql="Select SYSL,SYRS FROM YY_EMPLOYE_DETAIL Where KSDM = "+ii_ksdm+" And CDXH = "+wcdxh[0]+"";
  rs=stmt.executeQuery(sql);

  while(rs.next())
  {
  	sysl=rs.getInt(1);
  }

  %>
    <p align="center">
	<input name="wc1" type="text" value=<%=sysl%> size="9" align="right" style="text-align: right">
    </p>
   </td>
   <td width="113">
   <%
  sysl=0;
  sql="Select SYSL,SYRS FROM YY_EMPLOYE_DETAIL Where KSDM = "+ii_ksdm+" And CDXH = "+wcdxh[1]+"";
  rs=stmt.executeQuery(sql);

  while(rs.next())
  {
  	sysl=rs.getInt(1);
  }
   %>
  <p align="center">
  <input name="wc2" type="text" value=<%=sysl%> size="9" align="right" style="text-align: right">
  </p>
   </td>
    <td width="113">
   <%
  sysl=0;
  sql="Select SYSL,SYRS FROM YY_EMPLOYE_DETAIL Where KSDM = "+ii_ksdm+" And CDXH = "+wcdxh[2]+"";
  rs=stmt.executeQuery(sql);

  while(rs.next())
  {
  	sysl=rs.getInt(1);
  }
   %>
  <p align="center">
  <input name="wc3" type="text" value=<%=sysl%> size="9" align="right" style="text-align: right">
  </p>
     <%
  sysl=0;
  sql="Select SYSL,SYRS FROM YY_EMPLOYE_DETAIL Where KSDM = "+ii_ksdm+" And CDXH = "+wcdxh[3]+"";
  rs=stmt.executeQuery(sql);

  while(rs.next())
  {
  	sysl=rs.getInt(1);
  }
   %>
   </td>
    <td width="113">
	<p align="center">
  <input name="wc4" type="text" value=<%=sysl%> size="9" align="right" style="text-align: right">
  </p>
   </td>
     <td width="113">
   <%
  sysl=0;
  sql="Select SYSL,SYRS FROM YY_EMPLOYE_DETAIL Where KSDM = "+ii_ksdm+" And CDXH = "+wcdxh[4]+"";
  rs=stmt.executeQuery(sql);

  while(rs.next())
  {
  	sysl=rs.getInt(1);
  }
   %>
	 <p align="center">
  <input name="wc5" type="text" value=<%=sysl%> size="9" align="right" style="text-align: right">
   </p>
   </td>
     <td width="113">
	   <%
  sysl=0;
  sql="Select SYSL,SYRS FROM YY_EMPLOYE_DETAIL Where KSDM = "+ii_ksdm+" And CDXH = "+wcdxh[5]+"";
  rs=stmt.executeQuery(sql);

  while(rs.next())
  {
  	sysl=rs.getInt(1);
  }
   %>
	 <p align="center">
  <input name="wc6" type="text" value=<%=sysl%> size="9" align="right" style="text-align: right">
   </p>
   </td>

    <td width="113">
	   <%
  sysl=0;
  sql="Select SYSL,SYRS FROM YY_EMPLOYE_DETAIL Where KSDM = "+ii_ksdm+" And CDXH = "+wcdxh[6]+"";
  rs=stmt.executeQuery(sql);

  while(rs.next())
  {
  	sysl=rs.getInt(1);
  }
   %>
	 <p align="center">
  <input name="wc7" type="text" value=<%=sysl%> size="9" align="right" style="text-align: right">
   </p>
   </td>

  </tr>
	<%
	}
	else
	{
	out.print("对不起,今天营养科没有配晚餐!");
	}
%>
</table>

<%
String syear1="",smonth1="",sday1="",btid;
int p;
if(year<10)
{
	syear1="0"+year;
}
else
{
	syear1=year+"";
}
if(month<10)
{
	smonth1="0"+month;
}
else
{
	smonth1=month+"";
}
if(day<10)
{
	sday1="0"+day;
}
else
{
	sday1=day+"";
}

btid = syear1+smonth1+sday1;

sql="SELECT BTID,KSDM,TJGH,TJRQ FROM YY_EMPLOYE WHERE BTID="+btid+" and KSDM="+ii_ksdm+" and TJRQ IS NOT NULL";

rs=stmt.executeQuery(sql);
p=0;

while(rs.next())
{
	p++;
}

rs.close();
pool.releaseConnection(con);

%>

<B><CENTER><FONT face="宋体" SIZE="3" COLOR="yellow">注意:【<%=ksmc%>】中餐<%=zcsl%>份,晚餐<%=wcsl%>份,
<!-- 周六 -->
<%if(saturday_lunch>0)
{%>
周六中餐<%=saturday_lunch%>份,
<%}
if(saturday_supper>0)
{
%>
周六晚餐<%=saturday_supper%>份,
<%}%>

<%if(saturday_lunch==-1)
{%>
周六无中餐,
<%}
if(saturday_supper==-1)
{
%>
周六无晚餐,
<%}%>

<!--周日 -->

<%if(sunday_lunch>0)
{%>
周日中餐<%=sunday_lunch%>份,
<%}
if(sunday_supper>0)
{
%>
周日晚餐<%=sunday_supper%>份,
<%}%>

<%if(sunday_lunch==-1)
{%>
周日无中餐,
<%}
if(sunday_supper==-1)
{
%>
周日无晚餐,
<%}%>
<!-- 结束 -->

<%
if(p<=0)
{%>数据未提交,请在每天下午四点前输入并提交到营养科
<%}
else
{
%>
数据已提交
<%}%></FONT>
</CENTER></B>

<br>
  <div align="center">
  <input name="savedata1" type="submit" value="保存数据" style="font-family: 宋体; font-size: 10pt; border-style: ridge; border-color: #000080" onclick="savedata()" >&nbsp;&nbsp;&nbsp;&nbsp;
  <input name="commit1" type="button" value="提交数据" style="font-family: 宋体; font-size: 10pt; border-style: ridge; border-color: #000080" onClick="commitdata()">&nbsp;&nbsp;&nbsp;

 <input name="zx1" type="button" value="重新登录" style="font-family: 宋体; font-size: 10pt; border-style: ridge; border-color: #000080" onClick="zx()">

</div>
</form>

</body>
<SCRIPT LANGUAGE="JavaScript">
//添加开始日期及结束日期
function addOption()
{

	//取当前选中行的值
	//thisform.month_start.options[thisform.month_start.selectedIndex].value



	var s=document.thisform.month_start.value;
	var year=document.thisform.year_start.value;

	if (document.thisform.day_start.options.length!=0){
			for(k=0;k<document.thisform.day_start.options.length;k++){
				document.thisform.day_start.options[k]=null ;
				document.thisform.day_start.options.remove(k);
			}
		}


	if(s=="03"||s=="01"||s=="05"||s=="07"||s=="08"||s=="10"||s=="12")
	{
		for(var k=0;k<=30;k++)
		{
			//向下拉单选框中添加内容

			document.thisform.day_start.add(document.createElement("OPTION"));
			document.thisform.day_start.options[k].text=k+1;
			document.thisform.day_start.options[k].value=k+1;

		 }

	}
	else if(s=="04"||s=="06"||s=="09"||s=="11")
	{
		for(var k=0;k<=29;k++)
		{
			document.thisform.day_start.add(document.createElement("OPTION"));
			document.thisform.day_start.options[k].text=k+1;
			document.thisform.day_start.options[k].value=k+1;
		}

	}
	else
	{
		//判断2月份的闰年
		if(year%4==0&&year%100!=0)
		{
			for(var k=0;k<=28;k++)
			{
				document.thisform.day_start.add(document.createElement("OPTION"));
				document.thisform.day_start.options[k].text=k+1;
				document.thisform.day_start.options[k].value=k+1;
			}
		}
		else
		{
			for(var k=0;k<=27;k++)
			{
				document.thisform.day_start.add(document.createElement("OPTION"));
				document.thisform.day_start.options[k].text=k+1;
				document.thisform.day_start.options[k].value=k+1;
			}
		}

	}
}
//以下函数增加当天时间
function addAll()
{
	addOption();
	//jsp脚本文件与javascript混用
	var k=<%=month%>;
	document.thisform.month_start.selectedIndex=k-1;

	k=<%=day%>;
	document.thisform.day_start.selectedIndex=k-1;

	document.thisform.year_start.focus();
}

function savedata()
{
		<%

		boolean save = false;


		for(int i=0;i<k;i++)
		{
			session.setAttribute("cdxh"+i,cdxh[i]+"");
			if(cdxh[i]>0)
			{

				save=true;
			}
			session.setAttribute("wcdxh"+i,wcdxh[i]+"");
			if(wcdxh[i]>0)
			{
				save=true;
			}

		}

		if(save)
		{
			session.setAttribute("zcsl",zcsl+"");
			session.setAttribute("wcsl",wcsl+"");
			session.setAttribute("k",k+"");
			session.setAttribute("year",syear1);
			session.setAttribute("month",smonth1);
			session.setAttribute("day",sday1);
			session.setAttribute("p",p+"");
			session.setAttribute("saturday_lunch",String.valueOf(saturday_lunch));
			session.setAttribute("saturday_supper",String.valueOf(saturday_supper));
			session.setAttribute("sunday_lunch",String.valueOf(sunday_lunch));
			session.setAttribute("sunday_supper",String.valueOf(sunday_supper));
		}
		%>

}

function commitdata()
{
	<%
	session.setAttribute("day",sday1);
	session.setAttribute("year",syear1);
	session.setAttribute("month",smonth1);
	%>

	document.save_form.action="commitdata.jsp";
	document.save_form.submit();
}

function zx()
{
	var mm="index.jsp";
	window.open(mm,"_self");
}

//设置日期
document.thisform.year_start.value=<%=year%>;
document.thisform.month_start.options.selectedIndex=<%=month - 1%>;
document.thisform.day_start.options.selectedIndex=<%=day - 1%>;

</SCRIPT>
</html>
上一页 12
💿 文件大小 1451 K
👤 上传用户 zxixi2007
📂 所属分类 Java编程
🏷️ 相关标签

#TOMCAT #JSP #数据库 #连接
⌨️ 快捷键说明

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