package com.zw.controller;
import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.zw.dao.OperationDao;
import com.zw.jdbc.CommonJdbc;
/**
* Servlet implementation class ModReserveServlet
*/
public class ModReserveServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
Connection con=null;
ResultSet rs=null;
int oid=Integer.parseInt(request.getParameter("oid"));
String rid=request.getParameter("rid");
String name=request.getParameter("mName");
String number=request.getParameter("number");
String date=request.getParameter("odate");
String sql="select rid from reserve where oid="+rid;
con=new CommonJdbc().getCon();
String oldrid="";
try {
Statement st = con.createStatement();
rs=st.executeQuery(sql);
// oldrid = rs.getString(1);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if(oldrid!=rid){
String sql5="update room set isbusy=1 where rid=\'"+rid+"\';"; //设置客房状态为不可住
// String sql6="update room set isbusy=0 where rid=\'"+oldrid+"\';"; //设置客房状态为可住
OperationDao.change(sql5);
// OperationDao.change(sql6);
}
String sql1="update reserve set rid=\'"+rid+"\' where oid="+oid+"";
String sql2="update reserve set mname=\'"+name+"\' where oid="+oid+"";
String sql3="update reserve set number=\'"+number+"\' where oid="+oid+"";
String sql4="update reserve set odate=\'"+date+"\' where oid="+oid+"";
String ack1=OperationDao.insert(sql1);
String ack2=OperationDao.insert(sql2);
String ack3=OperationDao.insert(sql3);
String ack4=OperationDao.insert(sql4);
//设置客房状态为不可住
if("success".equals(ack1)&&"success".equals(ack2)&&"success".equals(ack3)&&"success".equals(ack4)){
request.getRequestDispatcher("ModReserve.jsp").forward(request, response);
}
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
sp网上酒店管理系统,ssh项目,网上酒店管理系统,酒店管理系统,java项目 网上酒店管理系统 主要面向酒店开发和使用: 系统使用JSP+Servlet+JDBC技术开发。 系统角色分为:经理(管理员)和员工(普通用户)两种用户, 其中经理(管理员)具有查看所有预定、删除客房、查看员工、添加员工等功能权限 员工(普通用户)具有查看空房、客户预订、修改预订、删除预订、注册新客户等功能权限
资源推荐
资源详情
资源评论
收起资源包目录
JSP+Servlet+JDBC.zip (89个子文件)
网上酒店管理系统JSP+Servlet+JDBC
.project 1KB
WebContent
Welcome.jsp 2KB
WEB-INF
lib
servlet-api.jar 173KB
javax.servlet.jsp.jstl-api-1.2.1.jar 32KB
mysql-connector-java-5.0.8-bin.jar 528KB
javax.servlet.jsp.jstl-1.2.1.jar 398KB
web.xml 5KB
logout.jsp 305B
Reservation.jsp 3KB
index.jsp 2KB
images
bg1.gif 5KB
bt7_2.jpg 4KB
bt6_2.jpg 4KB
bt4_2.jpg 3KB
bt9_2.jpg 4KB
bt9_1.jpg 4KB
bt2_2.jpg 3KB
bg1.jpg 231KB
bt8_1.jpg 3KB
bt8_2.jpg 4KB
bt1_1.jpg 3KB
bt5_1.jpg 4KB
bt7_1.jpg 3KB
bt5_2.jpg 5KB
bt3_2.jpg 3KB
bt2_1.jpg 3KB
bt3_1.jpg 3KB
bt4_1.jpg 3KB
bt1_2.jpg 4KB
bt6_1.jpg 3KB
login1.gif 1KB
login2.gif 118B
login.jpg 476KB
FreeRoom.jsp 3KB
Delete.jsp 969B
DelRoom.jsp 3KB
AddEmp.jsp 2KB
ModReserve.jsp 4KB
AddGuest.jsp 3KB
DelReserve.jsp 2KB
MReservation.jsp 3KB
META-INF
MANIFEST.MF 39B
ViewEmp.jsp 3KB
style.css 585B
src
com
zw
filter
LoginFilter.java 2KB
model
Member.java 611B
Reserve.java 959B
Room.java 799B
Employee.java 1KB
controller
ModReserveServlet.java 3KB
FreeRoomServlet.java 1005B
EmpInsertServlet.java 2KB
ViewEmpServlet.java 1KB
DelchRoomServlet.java 1KB
OrderDelServlet.java 2KB
OrderInsertServlet.java 2KB
AllReserveServlet.java 1011B
LoginServlet.java 2KB
MemberServlet.java 1KB
DelRoomServlet.java 1KB
dao
OperationDao.java 2KB
EmployeeDao.java 882B
jdbc
CommonJdbc.java 790B
.settings
org.eclipse.wst.jsdt.ui.superType.container 49B
org.eclipse.wst.common.project.facet.core.xml 345B
org.eclipse.jdt.core.prefs 364B
org.eclipse.wst.jsdt.ui.superType.name 6B
org.eclipse.wst.common.component 467B
.jsdtscope 503B
build
classes
com
zw
filter
LoginFilter.class 2KB
model
Member.class 1010B
Employee.class 2KB
Reserve.class 1KB
Room.class 1KB
controller
AllReserveServlet.class 1KB
LoginServlet.class 2KB
FreeRoomServlet.class 1KB
ModReserveServlet.class 3KB
DelRoomServlet.class 1KB
DelchRoomServlet.class 1KB
OrderDelServlet.class 2KB
OrderInsertServlet.class 2KB
ViewEmpServlet.class 1KB
MemberServlet.class 2KB
EmpInsertServlet.class 2KB
dao
OperationDao.class 2KB
EmployeeDao.class 1KB
jdbc
CommonJdbc.class 1KB
.classpath 1KB
共 89 条
- 1
li575563191
- 粉丝: 216
- 资源: 46
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
前往页