changeroom.jsp

来自「一个酒店房间登记系统」· JSP 代码 · 共 67 行

JSP
67 行
字号 

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>换房</title>
    
    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="cache-control" content="no-cache">
    <meta http-equiv="expires" content="0">
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="This is my page">
    
    <!--
    <link rel="stylesheet" type="text/css" href="styles.css">
    -->
  </head>
   <jsp:useBean id="change" scope="session" class="db.DBCon" /> 
  <body>
    <%
    String chgroom=request.getParameter("chgroom");
    String room=request.getParameter("room");
    String roomcode=request.getParameter("roomcode");
    String name=request.getParameter("name");       
    String certificate=request.getParameter("certificate");
    
    String roomcode1=change.roomcode(chgroom);
    String sql;
    
    out.println(roomcode1);
    out.println(change.beds(room));
    
    if(change.hasEmptyBed(chgroom)){
    		
    		sql="update guests set roomcode='"+roomcode1+"' where roomcode='"+roomcode+"' "+
    		"and name='"+name+"' and certificate='"+certificate+"';";
    		change.excuteUpdate(sql);
    		change.close();
    		
    		sql="update roomstate set roomstate='1' where roomcode='"+roomcode1+"';";
    		change.excuteUpdate(sql);
    		change.close();
    		
    		out.println("换房成功");
    		if(change.guestnum(room)==0){
    			
    			sql="update roomstate set roomstate='z' where roomcode='"+roomcode+"';";
    			change.excuteUpdate(sql);
    			change.close();
    		}
    }
    else{
    	out.println("你要换的房间没有空床，请换另一间！");
    		
    }
    %>
  </body>
</html>

changeroom.jsp - 源码说明

本页面展示了「一个酒店房间登记系统」中的 changeroom.jsp 源码文件，采用 JSP 编程语言编写，共 67 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫开发者社区收录了大量与酒店管理系统相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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