网上酒店管理系统JSP+Servlet+JDBC

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); } } }