www.pudn.com > Hotel.rar > clientregist2_jsp.java

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(" 
请将信息填写完整
\r\n"); 
      out.write("\r\n"); 
 
 } 
 else  
   if(arridate.compareTo(leadate)>0){ 
      out.write("\r\n"); 
      out.write("  
抵达日期
"); 
out.print(arridate); 
      out.write("\r\n"); 
      out.write("  
拟走日期
"); 
out.print(leadate); 
      out.write("\r\n"); 
      out.write(" 
抵达日期不可以大于拟走日期
\r\n"); 
      out.write("\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("     
对不起，您所选择的房间已住满人！
\r\n"); 
      out.write("    \r\n"); 
 
  } else{ 
     conn.executeUpdate(sql); 
     out.print("登记成功!"); 
     String roomagain; 
        
        
      out.write("\r\n"); 
      out.write("\r\n"); 
      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("\r\n"); 
      out.write("  
\r\n"); 
      out.write("     \r\n"); 
      out.write("     
\r\n"); 
      out.write("     \r\n"); 
      out.write("\r\n"); 
      out.write(""); 
    } 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); 
    } 
  } 
}