Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%>
- <%@ page import="java.sql.*" %>
- <%@ page import="java.io.*" %>
- <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
- <link rel="stylesheet" type="text/css" href="css/style.css">
- <title>Booking Confirmation</title>
- </head>
- <body>
- <h4 align="center">Hotel Reservation System</h4>
- <ul>
- <li><a class="active" href="home.html">Home</a></li>
- <li><a href="admin.html">Admin</a></li>
- </ul>
- <%
- String f_name=request.getParameter("fname");
- String l_name = null;
- l_name = request.getParameter("lname");
- String gender = null;
- gender = request.getParameter("gender");
- String g = null;
- if(gender.equals("male")){
- g = "M";
- }
- else if (gender.equals("female")){
- g = "F";
- }
- else if (gender.equals("other")){
- g = "O";
- }
- System.out.println(g);
- String email = request.getParameter("email");
- String phone = request.getParameter("phone");
- String check_in = request.getParameter("check-in");
- String check_out = request.getParameter("check-out");
- String room_type = request.getParameter("room_type");
- String user_name = f_name +" "+l_name;
- try{
- Class.forName("com.mysql.jdbc.Driver");
- Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql","root","1234");
- Statement st= con.createStatement();
- String query_string = "insert into customer values (NULL,'"+user_name+"','"+email+"','"+g+"','"+phone+"',STR_TO_DATE('"+check_in+"','%Y-%m-%d'),STR_TO_DATE('"+check_out+"','%Y-%m-%d'),'"+room_type+"')";
- System.out.println(query_string);
- int i=st.executeUpdate(query_string);
- if (i > 0){
- out.println("Hello "+user_name+", your booking is done successfully");
- }
- else{
- out.println("Hello "+user_name+", your booking could not be completed. Sorry for the inconvenience");
- }
- }
- catch(Exception e){
- e.printStackTrace();
- }
- %>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement