Мобильная версияHOME
ABOUT US
CONTACT US
NO OF SEATS :
follow us on:
heins road, chennai - 82
86473473289
a1 servlet:
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
//import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
import java.io.PrintWriter;
import static java.lang.System.out;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Arrays;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.ServletContext;
import javax.servlet.annotation.WebServlet;
/**
*
* @author Princy Beenu L
*/
@WebServlet(urlPatterns = {"/a1"})
public class a1 extends HttpServlet {
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
try (PrintWriter out = response.getWriter()) {
/* TODO output your page here. You may use following sample code. */
out.println("");
out.println("");
out.println("");
out.println("Servlet a1");
out.println("");
out.println("");
out.println("Servlet a1 at " + request.getContextPath() + "");
out.println("");
out.println("");
}
}
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
res.setContentType("text/html;charset=UTF-8");
PrintWriter out = res.getWriter();
try(Connection conn = DriverManager.getConnection("jdbc:derby://localhost:1527/shopmedb")) {
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT COUNT(*) AS row_count FROM DB1");
rs.next();
int rowCount = rs.getInt("row_count");
if (rowCount == 0) {
String qry = "INSERT INTO DB1 (total_seats) VALUES (?)";
PreparedStatement insertPs = conn.prepareStatement(qry);
insertPs.setInt(1, 30);
insertPs.executeUpdate();
}
} catch (SQLException ex) {
Logger.getLogger(a1.class.getName()).log(Level.SEVERE, null, ex);
}
int no_of_seats_to_book = Integer.parseInt(req.getParameter("ticketCount"));
int price_per_ticket = 190;
int tp = no_of_seats_to_book*190;
int seat_num = 4;
try (Connection conn = DriverManager.getConnection("jdbc:derby://localhost:1527/shopmedb")) {
String query = "INSERT INTO DB1 (no_of_seats_to_book, seat_numbers, price_of_1, total_price) VALUES (?, ?, ?, ?)";
PreparedStatement ps = conn.prepareStatement(query);
//ps.setInt(1, total);
ps.setInt(1, no_of_seats_to_book);
ps.setInt(2, seat_num);
ps.setInt(3, price_per_ticket);
ps.setInt(4, tp);
ps.executeUpdate();
}
catch (SQLException ex) {
Logger.getLogger(a1.class.getName()).log(Level.SEVERE, null, ex);
}
out.println("im here");
try (Connection conn = DriverManager.getConnection("jdbc:derby://localhost:1527/shopmedb")) {
String query = "SELECT total_seats FROM DB1";
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(query);
int ogtotal_seats = 0;
if (rs.next()) {
ogtotal_seats = rs.getInt("total_seats");
}
int updatedTotalSeats = ogtotal_seats - no_of_seats_to_book;
String query1 = "UPDATE DB1 SET total_seats = ? WHERE total_seats >= ?";
PreparedStatement ps = conn.prepareStatement(query1);
ps.setInt(1, updatedTotalSeats);
ps.setInt(2, no_of_seats_to_book);
ps.executeUpdate();
out.println("im here");
res.sendRedirect("a2");
out.println("im here");
}
catch (SQLException ex) {
Logger.getLogger(a1.class.getName()).log(Level.SEVERE, null, ex);
}
}
@Override
public String getServletInfo() {
return "Short description";
}//
}
a2 servlet:
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
import java.io.PrintWriter;
import static java.lang.System.out;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Arrays;
import java.util.logging.Level;
import java.util.logging.Logger;
/**
*
* @author Princy Beenu L
*/
@WebServlet(urlPatterns = {"/a2"})
public class a2 extends HttpServlet {
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
try (PrintWriter out = response.getWriter()) {
out.println("");
out.println("");
out.println("");
out.println("Servlet a2");
out.println("");
out.println("");
out.println("Servlet a2 at " + request.getContextPath() + "");
out.println("");
out.println("");
}
}
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
res.setContentType("text/html");
PrintWriter out = res.getWriter();
HttpSession session = req.getSession(false);
String username = (String) session.getAttribute("name");
//String password = (String) session.getAttribute("password");
try (Connection conn = DriverManager.getConnection("jdbc:derby://localhost:1527/shopmedb")) {
String query = "SELECT * FROM DB1 ORDER BY id DESC FETCH FIRST ROW ONLY";
PreparedStatement ps = conn.prepareStatement(query);
ResultSet resultSet = ps.executeQuery();
while(resultSet.next()) {
int total_booked_seat = resultSet.getInt("no_of_seats_booked");
int totalPrice = resultSet.getInt("price");
int seat_numbers = resultSet.getInt("seat_numbers");
out.println("\n" +
"\n" +
" \n" +
" Payment Gateway - BIXcinemas\n" +
" \n" +
" \n" +
" \n" +
" \n" +
" #t1{\n" +
" color: orange; \n" +
" }\n" +
" \n" +
" body{\n" +
" background-color: rgb(127, 199, 217);\n" +
" }\n" +
"\n" +
" #btn1{\n" +
" position:absolute;\n" +
" top: 80%;\n" +
" left: 30%;\n" +
" font-size: 14px;\n" +
" padding: 8px;\n" +
" border: 2px solid rgb(251, 168, 52);\n" +
" border-radius: 12px;\n" +
" color: rgb(251, 168, 52);\n" +
" display: block;\n" +
" margin: 50px;\n" +
" background: transparent;\n" +
" transition: .3s ease-in-out 0s;\n" +
" }\n" +
" \n" +
" #btn1:hover{\n" +
" cursor: pointer;\n" +
" transform: scale(1.25);\n" +
" background: rgb(251, 168, 52);\n" +
" color: #000;\n" +
" }\n" +
"\n" +
" #p2{\n" +
" width: 100%; \n" +
" height: 120px; \n" +
" background-color: rgb(54, 84, 134);\n" +
" border-radius: 15px;\n" +
" }\n" +
" \n" +
" #i1{\n" +
" position:absolute;\n" +
" top: 4%;\n" +
" left: 2%;\n" +
" width: 20%;\n" +
" height: 100px;\n" +
" }\n" +
" \n" +
" .btn2 {\n" +
" position:absolute;\n" +
" top: 10%;\n" +
" left: 35%;\n" +
" margin-right: 11%;\n" +
" font-size: 15px;\n" +
" font-weight: bold;\n" +
" padding: 8px;\n" +
" padding-left: 20px;\n" +
" padding-right: 20px;\n" +
" border: 2px solid rgb(251, 168, 52);\n" +
" border-radius: 12px;\n" +
" color: #fff;\n" +
" background: rgb(251, 168, 52);\n" +
" transition: .3s ease-in-out 0s;\n" +
" }\n" +
"\n" +
" .btn2:hover {\n" +
" cursor: pointer;\n" +
" transform: scale(1.25);\n" +
" background: transparent;\n" +
" color: rgb(251, 168, 52);\n" +
" } \n" +
" \n" +
" .btn22 {\n" +
" position: absolute;\n" +
" top: 10%;\n" +
" left: 45%;\n" +
" margin-right: 11%;\n" +
" font-size: 15px;\n" +
" font-weight: bold;\n" +
" padding: 8px;\n" +
" padding-left: 20px;\n" +
" padding-right: 20px;\n" +
" border: 2px solid rgb(251, 168, 52);\n" +
" border-radius: 12px;\n" +
" color: #fff; \n" +
" background: rgb(251, 168, 52);\n" +
" transition: .3s ease-in-out 0s;\n" +
" }\n" +
"\n" +
" .btn22:hover {\n" +
" cursor: pointer;\n" +
" transform: scale(1.25);\n" +
" background: transparent; \n" +
" color: rgb(251, 168, 52); \n" +
" }\n" +
"\n" +
" .btn23 {\n" +
" position:absolute;\n" +
" top: 10%;\n" +
" left: 58%;\n" +
" margin-right: 11%;\n" +
" font-size: 15px;\n" +
" font-weight: bold;\n" +
" padding: 8px;\n" +
" padding-left: 20px;\n" +
" padding-right: 20px;\n" +
" border: 2px solid rgb(251, 168, 52);\n" +
" border-radius: 12px;\n" +
" color: #fff;\n" +
" background: rgb(251, 168, 52); \n" +
" transition: .3s ease-in-out 0s;\n" +
" }\n" +
"\n" +
" .btn23:hover {\n" +
" cursor: pointer;\n" +
" transform: scale(1.25);\n" +
" background: transparent; \n" +
" color: rgb(251, 168, 52);\n" +
" } \n" +
" \n" +
" .text{\n" +
" font-family: cooper black;\n" +
" }\n" +
" \n" +
" h2{\n" +
" color: rgb(71, 79, 122);\n" +
" font-family: calibri;\n" +
" font-size: 27px;\n" +
" }\n" +
" \n" +
" #a {\n" +
" text-decoration: none;\n" +
" color: inherit;\n" +
" }\n" +
" \n" +
" #p4{\n" +
" position:absolute;\n" +
" top: 180%;\n" +
" left: 0.5%;\n" +
" width: 99%; \n" +
" height: 200px; \n" +
" background-color: rgb(54, 84, 134);\n" +
" border-radius: 8px;\n" +
" }\n" +
" \n" +
" #pa1{\n" +
" font-family: calibri;\n" +
" font-size: 20px;\n" +
" color: white;\n" +
" font-weight: bold;\n" +
" }\n" +
" \n" +
" #d1{\n" +
" text-align: center;\n" +
" }\n" +
" \n" +
" #p6{\n" +
" position:absolute;\n" +
" top: 30%;\n" +
" left: 36%;\n" +
" width: 400px; \n" +
" height: 300px; \n" +
" background-color: rgb(255, 210, 63);\n" +
" border-radius: 15px;\n" +
" box-shadow: 0 4px 8px rgba(0, 0, 0, 0.2); \n" +
" }\n" +
" \n" +
" #div1{\n" +
" position:absolute;\n" +
" top: 35%;\n" +
" left: 40%;\n" +
" color: rgb(54, 84, 134);\n" +
" font-size: 18px;\n" +
" font-weight: bold;\n" +
" font-family: calibri;\n" +
" }\n" +
" \n" +
" .t1{\n" +
" border: none;\n" +
" background-color: transparent;\n" +
" }\n" +
" \n" +
" #l4 {\n" +
" position: absolute;\n" +
" top: 79%;\n" +
" left: 74%;\n" +
" margin-right: 10px;\n" +
" font-size: 15px;\n" +
" font-family: cooper black;\n" +
" }\n" +
" \n" +
" \n" +
" \n" +
" \n" +
" \n" +
"
\n" +
" HOME\n" +
" ABOUT US\n" +
" CONTACT US\n" +
"
\n" +
"
\n" +
" \n" +
"
\n" +
"
\n");
out.println("
--PREVIEW--
");
out.println("");
out.println("User:" + username);
out.println("");
out.println("Seat Numbers: " + seat_numbers + "
");
out.println("No of Seats: " + total_booked_seat + "
");
out.println("Total Price: " + totalPrice + "
");
out.println("");
out.println("Pay");
out.println("");
out.println(" \n" +
"
follow us on:
\n" +
"
\n" +
"
\n" +
"
\n" +
"
\n" +
"
\n" +
" \n" +
"
heins road, chennai - 82
86473473289
\n" +
" \n" +
" \n" +
"\n");
}
} catch (SQLException ex) {
Logger.getLogger(a2.class.getName()).log(Level.SEVERE, null, ex);
}
}
Подробнее здесь: https://stackoverflow.com/questions/781 ... e-is-blank
