order_2_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" />
<%
  String user_nm=DBHandle.toChinese(request.getParameter("tx_nm"));
  String user_pass=DBHandle.toChinese(request.getParameter("tx_pass"));
  if (user_nm == null || user_pass == null)
  {
%>
     <jsp:forward page="con_error.jsp">
      <jsp:param name="error_nm" value="非 法 操 作" />
      <jsp:param name="error_all" value="非法操作,请先登陆!" />
     </jsp:forward>
<%
  }
  Vector Result=new Vector();
  try{
  DB.connect();
  Result=DB.select("SELECT count(*) FROM user_info WHERE user_nm='"+user_nm+"' AND user_ps='"+user_pass+"'");
  }//end try
  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>
  <%
  }
  if (Result.elementAt(0).toString().equals("0"))
  {
    try{
    DB.close();
    }//end try
    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>
<%
  }
%>
    <jsp:forward page="con_error.jsp">
      <jsp:param name="error_nm" value="登 陆 错 误" />
      <jsp:param name="error_all" value="登陆错误,是由您输入的用户名和密码不正确引起的!" />
    </jsp:forward>
<%
  }
  else
  {
    Result=new Vector();
    try{
    Result=DB.select("SELECT user_grade,user_group FROM user_info WHERE user_nm='"+user_nm+"' AND user_ps='"+user_pass+"'");
    DB.close();
     }//end try
    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>
  <%
  }
    session.setAttribute("user_nm",user_nm);
    session.setAttribute("grade",Result.elementAt(0).toString());
    session.setAttribute("group",Result.elementAt(1).toString());
    out.print(session.getAttribute("grade").toString());
    if(session.getAttribute("grade").equals("6"))//系统管理员
    {
%>
      <jsp:forward page="order_supad.jsp" />
<%
    }
     else if (session.getAttribute("grade").equals("0"))
      {
%>
       <jsp:forward page="order_user.jsp" />
<%
      }
      else if (session.getAttribute("grade").equals("1"))//管理员页
     {
%>
       <jsp:forward page="order_admin.jsp" />
<%
      }
  }
%>