order_3_2.jsp

该系统是一个B/S结构的公司定饭系统,整套软件由JSP编制,希望大家能够多提宝贵意见,但请不要将它应用于商业环境,如实在要使用的话,请与作者联系!(使用此系统无比要有ORACLE8i以上版本数据库!)

<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="com.hzs.order.*" %>
<jsp:useBean id="DB" scope="page" class="com.hzs.order.DBHandle" />
<%
if (session.getAttribute("grade")==null || session.getAttribute("user_nm")==null)
{
%>
      <jsp:forward page="con_error.jsp">
      <jsp:param name="error_nm" value="非 法 操 作" />
      <jsp:param name="error_all" value="非法操作,请重新登陆!" />
     </jsp:forward>
<%
}
String ndate=DBHandle.toChinese(request.getParameter("tx_date"));
String food_nm=DBHandle.toChinese(request.getParameter("tx_food"));
String mount=DBHandle.toChinese(request.getParameter("tx_mount"));
String price=DBHandle.toChinese(request.getParameter("tx_price"));
String tel=DBHandle.toChinese(request.getParameter("hid_tel"));
String user_nm=session.getAttribute("user_nm").toString();
String group=session.getAttribute("group").toString();
if (group==null)
{
%>
      <jsp:forward page="con_error.jsp">
      <jsp:param name="error_nm" value="非 法 操 作" />
      <jsp:param name="error_all" value="非法操作,请重试!" />
     </jsp:forward>
<%
}
int return_val=0;
try{
  DB.connect();
 // out.print("INSERT INTO user_foodinfo VALUES(user_foodinfosq.nextval,to_date('"+ndate+"','YYYY/MM/DD'),'"+user_nm+"','"+group+"','"+food_nm+"',"+price+","+mount);
  DB.transaction();
  return_val=DB.update("INSERT INTO user_foodinfo VALUES(user_foodinfosq.nextval,to_date('"+ndate+"','YYYY/MM/DD'),'"+user_nm+"','"+group+"','"+food_nm+"',"+price+","+mount+",'"+tel+"')");
	if (return_val!=1)
  {
	DB.rollback();
         DB.close();
%>
<jsp:forward page="con_error.jsp">
      <jsp:param name="error_nm" value="数 据 库 错 误" />
      <jsp:param name="error_all" value="数据插入出错，请重试！" />
     </jsp:forward>
<%
  }
  DB.commit();
  DB.close();
}
catch(DBException  e)
{
%>
      <jsp:forward page="con_error.jsp">
      <jsp:param name="error_nm" value="数 据 库 错 误" />
      <jsp:param name="error_all" value="<%=e.getMessage()%>"/>
      </jsp:forward>
<%
}
finally{
        DB.close();
          }
%>
<jsp:forward page="order_3_1.jsp" />