UPDATEBOOKING.JSP

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1"%>
<%@page import="com.ariyanihotel.DatabaseManager"%>
<%@page import="java.sql.*,java.util.*"%>

<%
	String a = request.getParameter("name");
	String b = request.getParameter("email");
	String c = request.getParameter("phone");
	String d = request.getParameter("guest");
	String e = request.getParameter("room");
	String f = request.getParameter("CheckIn");
	String g = request.getParameter("CheckOut");

	System.out.println(a);
	System.out.println(b);
	System.out.println(c);
	System.out.println(d);
	System.out.println(e);
	System.out.println(f);
	System.out.println(g);

	String insert = "insert into booking (name,email,phone,guest,room,CheckIn,CheckOut) values (?,?,?,?,?,?,?)";
	try (Connection conn = DatabaseManager.getConnection();
		 PreparedStatement stmt = conn.prepareStatement(insert)) {
		stmt.setString(1, a);
		stmt.setString(2, b);
		stmt.setString(3, c);
		stmt.setString(4, d);
		stmt.setString(5, e);
		stmt.setString(6, f);
		stmt.setString(7, g);
		stmt.executeUpdate();
		conn.commit();
	} catch (Exception h) {
		h.printStackTrace();
	}

	response.sendRedirect("cust.html");
%>