del.jsp

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

JSP
71 行
字号 

<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ 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>My JSP 'del.jsp' starting page</title>
    <%-- <META http-equiv="refresh" content="2;url=checkout.jsp" > --%>
    <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="delguest" scope="session" class="db.DBCon" /> 
  <body >
   
    <%
    
    request.setCharacterEncoding("gb2312");
    String room=request.getParameter("room");
    String roomcode=request.getParameter("roomcode");
    String name=request.getParameter("name");
   
    ResultSet rs=null;
    String certificate=request.getParameter("certificate");
      	
    String sql="delete from guests where roomcode='"+roomcode+"' and name='"+name+"' and certificate='"+certificate+"';";
    delguest.excuteUpdate(sql);
    delguest.close();
    
    sql="select name from guests where roomcode='"+roomcode+"';";
    rs=delguest.excuteQuery(sql);
    if(!rs.next()){
    	
       	sql="update roomstate set roomstate='z' where roomcode='"+roomcode+"';";
    	delguest.excuteQuery(sql);
    }
    %>
    <script language=javascript> 
	function out(obj){ 
	var i = obj ; 
	if(i==0) 
		document.location.href="checkout.jsp";
		<%
		
		%>
		//document.body.innerHTML = i; 
	i--; 
	setTimeout("out("+i+")",1000); 
	} 
	</script> 
    <SCRIPT>
   out(1);
   alert("退房成功！");
   </SCRIPT>
  </body>
</html>

del.jsp - 源码说明

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

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

⌨️ 快捷键说明

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