📄 main.jsp

📁 以JSP与TOMCAT数据库连接池实现的订餐系统
💻 JSP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<%@ page contentType="text/html;charset=gb2312" errorPage="errpage.jsp"  language="java" import="java.sql.*"%>
<%@include file="connect_odbc.jsp"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>浙江省台州医院职工网上订餐系统</title>
<style type="text/css">
<!--
.style1 {
	font-family: "宋体";
	font-size: 24px;
	font-weight: bold;
}
.style4 {font-family: "宋体"; font-size: 16px; font-weight: bold; }
-->
</style>
</head>

 <%
	int year,month,day;
	int ii_ksdm = Integer.parseInt(session.getAttribute("ksdm").toString());
	String ksmc = session.getAttribute("ksmc").toString();
	int k=7;
	GregorianCalendar calendar;
	calendar=new GregorianCalendar();
	year=calendar.get(Calendar.YEAR);
	month=calendar.get(Calendar.MONTH)+1;//月份
	day=calendar.get(Calendar.DAY_OF_MONTH);//天
	
	//out.println(ksmc);

%>

<body bgcolor="#009999" onload="addAll()">
<div align="center">
  <p class="style1">浙江省台州医院职工网上订餐系统</p>
</div>

<form name="thisform" method="POST">
  <div align="center"><font size="3" face="宋体">
  预订日期:</font>
    <input name="year_start" type="text" maxlength="4" style="width: 40px; border-style: solid; border-color: #000080" size="20" onchange="addOption()" value=<%=year%>>
      <font size="3" face="宋体">年</font>
      <select size="1" name="month_start" onchange="addOption(1)">
	    <option value="01">01</option>
	    <option value="02">02</option>
	    <option value="03">03</option>
	    <option value="04">04</option>
	    <option value="05">05</option> 
	    <option value="06">06</option>
	    <option value="07">07</option>
	    <option value="08">08</option>
	    <option value="09">09</option>
	    <option value="10">10</option>
	    <option value="11">11</option>
	    <option value="12">12</option>
      </select>
      <font size="3" face="宋体">月</font>
      <select name="day_start" size="1">
      </select>
    <font size="3" face="宋体">日
    <INPUT TYPE=submit name="sub" value="刷新数据" style="font-family: 宋体; font-size: 10pt; border-style: ridge; border-color: #000080">
  </div>
</form>
<div align="center">

<%
//变量定义
String syear=null,smonth=null,sday=null;
int zcsl=0,wcsl=0;
String ls_sysj;

syear=request.getParameter("year_start");
smonth=request.getParameter("month_start");
sday=request.getParameter("day_start");

if(syear==null)
{
	syear=year+"";
}
else
{
	year=Integer.parseInt(syear);
}
if(smonth==null)
{
	smonth=month+"";
}
else
{
	month=Integer.parseInt(smonth);
}

if(sday==null)
{
	sday=day+"";
}
else
{
	day=Integer.parseInt(sday);
}

ls_sysj=syear+"-"+smonth+"-"+sday+" 00:00:00";

String cdmc[] = new String[k];
int cdxh[] = new int[k] ;
int sysl=0;

int n=0;
for(int i=0;i<k;i++)
{
	cdmc[i]="无";
}
for(int i=0;i<k;i++)
{
	cdxh[i]=0;
}
request.getSession(true);

session.setAttribute("ksdm",ii_ksdm+"");


%>
<!-- 以下部分为中餐部分 -->
<form name="save_form" method="POST" action="savedata.jsp">
  <div align="center">
    <%
    
sql="select CDXH,CDMC,CDLX,SYSJ from YY_MRCD where SYSJ = to_date('"+ls_sysj+"','yyyy-mm-dd hh24:mi:ss') and CDCX=2 AND (CDLB = 1) order by CDXH";

//out.println(sql);

try{
	rs=stmt.executeQuery(sql);
	}
	catch(SQLException se)
	{
		out.println(se.getMessage());
	}
	while(rs.next())
	{
		if(n<k)
		{
			cdxh[n]=rs.getInt(1);
			cdmc[n]=rs.getString(2);
		}
		n++;
	}

	int saturday_lunch = -1,saturday_supper = -1 ;
	int sunday_lunch = -1 ,sunday_supper = -1;

	sql="SELECT XZFS,XZFS_WC,SATURDAY_LUNCH,SATURDAY_SUPPER,SUNDAY_LUNCH,SUNDAY_SUPPER FROM YY_KSDM WHERE KSDM ="+ii_ksdm+"";

	rs=stmt.executeQuery(sql);

	while(rs.next())
	{
		zcsl=rs.getInt(1);
		wcsl=rs.getInt(2);
		saturday_lunch=rs.getInt(3);
		saturday_supper=rs.getInt(4);
		sunday_lunch=rs.getInt(5);
		sunday_supper=rs.getInt(6);
	}

	if(n>0)
	{
	%>
		    <span class="style4"><tt>以下为中餐,请输入所需的份数:</tt></span><br>
    </div>

</div>
  <table width="100%" border="1" align="center" cellspacing="0" bordercolor="#0000FF">
		<tr>
		<td width="87">
		  <div align="center">菜单名
		  </div></td>

			<td width="113">
			  <div align="center"><%=cdmc[0]%>
	          </div></td>

			<td width="113">
			  <div align="center"><%=cdmc[1]%>
	          </div></td>
			<td width="113">
			  <div align="center"><%=cdmc[2]%>
	          </div></td>
			<td width="113">
			  <div align="center"><%=cdmc[3]%>
	          </div></td>
				<td width="113">
			  <div align="center"><%=cdmc[4]%>
		        </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 = "+cdxh[0]+"";
  rs=stmt.executeQuery(sql);

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

  %>
    <p align="center">
	<input name="zc1" 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 = "+cdxh[1]+"";
  rs=stmt.executeQuery(sql);

  while(rs.next())
  {
  	sysl=rs.getInt(1);
  }
   %>
  <p align="center">
  <input name="zc2" 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 = "+cdxh[2]+"";
  rs=stmt.executeQuery(sql);

  while(rs.next())
  {
  	sysl=rs.getInt(1);
  }
   %>
  <p align="center">
  <input name="zc3" 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 = "+cdxh[3]+"";
  rs=stmt.executeQuery(sql);

  while(rs.next())
  {
  	sysl=rs.getInt(1);
  }
   %>
   </td>
    <td width="113">
	<p align="center">
  <input name="zc4" 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 = "+cdxh[4]+"";
  rs=stmt.executeQuery(sql);

  while(rs.next())
  {
  	sysl=rs.getInt(1);
  }
   %>
	 <p align="center">
  <input name="zc5" 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 = "+cdxh[5]+"";
  rs=stmt.executeQuery(sql);

  while(rs.next())
  {
  	sysl=rs.getInt(1);
  }
   %>
	 <p align="center">
  <input name="zc6" 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 = "+cdxh[6]+"";
  rs=stmt.executeQuery(sql);

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


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

<!-- 以下部分为晚餐操作 -->
</table>
<br>
<div align="center">
    <%
int wcdxh[] = new int[k];

for(int i=0;i<k;i++)
{
	cdmc[i]="无";
}
for(int i=0;i<k;i++)
{
	wcdxh[i]=0;
}
n=0;

sql="select CDXH,CDMC,CDLX,SYSJ from YY_MRCD where SYSJ = to_date('"+ls_sysj+"','yyyy-mm-dd hh24:mi:ss') and CDCX=3 AND (CDLB = 1) ORDER BY CDXH";

try{
	rs=stmt.executeQuery(sql);
	}
	catch(SQLException se)
	{
		out.println(se.getMessage());
	}
	while(rs.next())
	{
		if(n<k)
		{
			wcdxh[n]=rs.getInt(1);
			cdmc[n]=rs.getString(2);
		}
		n++;
	}

	if(n>0)
	{
	%>
		    <span class="style4">以下为晚餐,请输入所需的份数:</span><br>
    </div>


<table width="100%" border="1" align="center" cellspacing="0" bordercolor="#0000FF">
		<tr>
		<td width="87">
		  <div align="center">菜单名
		  </div></td>

			<td width="113">
			  <div align="center"><%=cdmc[0]%>
	          </div></td>

			<td width="113">
			  <div align="center"><%=cdmc[1]%>
	          </div></td>
			<td width="113">
			  <div align="center"><%=cdmc[2]%>
	          </div></td>
			<td width="113">
			  <div align="center"><%=cdmc[3]%>
	          </div></td>
				<td width="113">
			  <div align="center"><%=cdmc[4]%>
12 下一页
💿 文件大小 1451 K
👤 上传用户 zxixi2007
📂 所属分类 Java编程
🏷️ 相关标签

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

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