clientregist2_jsp.java

JSP+SQL SERVER,酒店管理系统

package org.apache.jsp;

import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
import codechange.Codechange;
import myhotel.MyConn;

public final class clientregist2_jsp extends org.apache.jasper.runtime.HttpJspBase
    implements org.apache.jasper.runtime.JspSourceDependent {

String url,sql;
Connection conn;
  private static java.util.List _jspx_dependants;

  public Object getDependants() {
    return _jspx_dependants;
  }

  public void _jspService(HttpServletRequest request, HttpServletResponse response)
        throws java.io.IOException, ServletException {

    JspFactory _jspxFactory = null;
    PageContext pageContext = null;
    HttpSession session = null;
    ServletContext application = null;
    ServletConfig config = null;
    JspWriter out = null;
    Object page = this;
    JspWriter _jspx_out = null;
    PageContext _jspx_page_context = null;


    try {
      _jspxFactory = JspFactory.getDefaultFactory();
      response.setContentType("text/html; charset=gb2312");
      pageContext = _jspxFactory.getPageContext(this, request, response,
      			"", true, 8192, true);
      _jspx_page_context = pageContext;
      application = pageContext.getServletContext();
      config = pageContext.getServletConfig();
      session = pageContext.getSession();
      out = pageContext.getOut();
      _jspx_out = out;

      out.write("\r\n");
      out.write("\r\n");
      out.write(" \r\n");
      out.write("\r\n");
      out.write(" ");
      out.write("\r\n");
      out.write("  ");
      out.write(' ');
      out.write('\r');
      out.write('\n');


Codechange code=new Codechange();
String room=request.getParameter("room2");
room=room.replaceAll(" ","");
  String name=request.getParameter("name");
  

  String sex=request.getParameter("sex");
  String sex1;
  if(sex.compareTo("1")==0)
  sex1="男";
  else sex1="女";
  String age=request.getParameter("age"); 
  String id=request.getParameter("id");
  String idcode=request.getParameter("idcode");
  String nation=request.getParameter("nation");
  String nation1;
  if(nation.compareTo("china")==0)
  nation1="中国";
  else nation1="美国";
  
  String arriyear=request.getParameter("select");
String arrimonth=request.getParameter("select2");
String arriday=request.getParameter("select3");
String arridate=arriyear+"/"+arrimonth+"/"+arriday;


String leayear=request.getParameter("select4");
String leamonth=request.getParameter("select5");
String leaday=request.getParameter("select6");
String leadate=leayear+"/"+leamonth+"/"+leaday;

 
  String specialprice=request.getParameter("specialprice");
  String remarks=request.getParameter("remarks");
   String sql="insert into guests (roomcode,name,sex,age,certclassno,countryno,arridate,leftdate,remarks)values('"+room+"','"+code.toGB(name)+"','"+sex1+"','"+age+"','"+idcode+"','"+nation1+"','"+arridate+"','"+leadate+"','"+remarks+"');";
  String sql1="select * from roomstate;";
  if(name.length()==0||sex.length()==0||id.length()==0||idcode.length()==0)
 {
  
      out.write("\r\n");
      out.write("\r\n");
      out.write(" <p>请将信息填写完整</p>\r\n");
      out.write("<input type=\"button\" value=\"返回重填\" onclick=\"JavaScript:location.href='clientregist.jsp';\" >\r\n");

 }
 else 
   if(arridate.compareTo(leadate)>0){
      out.write("\r\n");
      out.write("  <p>抵达日期</p>");
out.print(arridate);
      out.write("\r\n");
      out.write("  <p>拟走日期</p>");
out.print(leadate);
      out.write("\r\n");
      out.write(" <p>抵达日期不可以大于拟走日期</p>\r\n");
      out.write("<input type=\"button\" value=\"返回重填\" onclick=\"JavaScript:location.href='clientregist.jsp';\" >\r\n");

 
 }
 else{
  MyConn conn=new MyConn();
 ResultSet rs=conn.executeQuery(sql1);
  while(rs.next())
  {
    String roomcode1=rs.getString(1);
   String roomstate1=rs.getString(2);
 
    int freebed1=rs.getInt(3);

  
    if(room.compareTo(roomcode1)==-6)// 为什么用0不行?
    {
    if(freebed1==0){
         
      out.write("\r\n");
      out.write("     <p>对不起，您所选择的房间已住满人！</p>\r\n");
      out.write("    <input type=\"button\" value=\"重新选择房间\" onclick=\"JavaScript:location.href='roominfo.jsp? ';\" >\r\n");

  } else{
     conn.executeUpdate(sql);
     out.print("登记成功!");
     String roomagain;
       
       
      out.write("\r\n");
      out.write("\r\n");
      out.write("    <input type=\"submit\" value=\"再登记\" onclick=\"JavaScript:location.href='clientregist.jsp?roomagain=");
      out.print(room);
      out.write("';\"><!--值为什么传不过去?-->\r\n");
      out.write("  \r\n");
      out.write("   ");

     freebed1=freebed1-1;
     conn.executeUpdate("update roomstate set freebed='"+freebed1+"' where roomcode='"+roomcode1+"';" );
 
      if(freebed1==0)
     {
      conn.executeUpdate("update roomstate set roomstate='住人'where roomcode='"+roomcode1+"';");
     }//if
     }//else
       conn.close();
        break;
    }//if

  
    
    }
  
}

      out.write("\r\n");
      out.write("<body>\r\n");
      out.write(" <td width=\"127\"> <form name=\"form1\" method=\"post\" action=\"index.jsp\">\r\n");
      out.write("     <input type=\"submit\" name=\"Submit4\" value=\" 返回首页 \">\r\n");
      out.write("     </form>\r\n");
      out.write("     </td>\r\n");
      out.write("<script language=Javascript>\r\n");
      out.write("\r\n");
      out.write("</script>\r\n");
      out.write("</body>");
    } catch (Throwable t) {
      if (!(t instanceof SkipPageException)){
        out = _jspx_out;
        if (out != null && out.getBufferSize() != 0)
          out.clearBuffer();
        if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
      }
    } finally {
      if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
    }
  }
}