Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- product.jsp
- <%@page import="java.sql.DriverManager"%>
- <%@page import="java.sql.ResultSet"%>
- <%@page import="java.sql.PreparedStatement"%>
- <%@page import="java.sql.Connection"%>
- <%@page contentType="text/html" pageEncoding="UTF-8"%>
- <!DOCTYPE html>
- <html>
- <head>
- <link rel="stylesheet" href="css/bootstrap.min.css" >
- <link rel="stylesheet" href="css/bootstrap-theme.min.css" >
- <script src="js/jQuery.min.js"></script>
- <script src="js/bootstrap.min.js"></script>
- <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
- <title>JSP Page</title>
- <style>
- </style>
- </head>
- <body>
- <nav>
- <%@include file="header.jsp"%>
- </nav>
- <center>
- <form action="carts" style="padding: 20px;" method="post">
- <table class="table" style="width: 50%;">
- <%
- String pname=request.getParameter("prod");
- //Connection con = javaconnection.connectDB();
- Class.forName("com.mysql.jdbc.Driver");
- Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/shopping_database","root","");
- PreparedStatement pst = con.prepareStatement("select * from products where pname = 'Htc 816' ");
- ResultSet rs = pst.executeQuery();
- String name=rs.getString("pname");
- String price=rs.getString("price");
- String cam=rs.getString("pcamera");
- String size=rs.getString("psize");
- out.println(name);
- out.println(price);
- out.println(cam);
- out.println(size);
- int f=0;
- while (rs.next()) {
- f=1;
- out.println("<tr><th colspan='2' style='text-align:center;'><h2> Detailed About The Product: "
- + rs.getString("pname") + "</h2></th></tr>"
- + "<tr><th colspan='2'><center><img src='images/details_"+ rs.getString("pimg")+".jpg' height='500px' width='600px' /></center></th></tr>"
- + "<tr><th>Price</th>"
- + "<td>Rs. "+rs.getString("price")+"</td></tr>"
- + "<tr><th>Primary camera</th><td>"+rs.getString("pcamera")+"</td></tr>"
- + "<tr><th>Screen Size</th><td>"+rs.getString("psize")+"inches</td></tr>"
- + "<tr><th>Color</th><td>"+rs.getString("pcamera")+"</td></tr>"
- + "<tr></tr>");
- %>
- <%
- }
- if(f==0)
- {
- out.println("<h2>No such product</h2>");
- }
- %>
- <tr><td>
- <div class="row">
- <input type="submit" class="btn btn-success" value="Add selected items to cart" style="float: right; padding: 3px; border-radius: 8px;" name="addTablets">
- </div>
- </td><td></td></tr>
- </table>
- </form>
- <hr>
- <center>
- <div id="templatemo_footer">
- <a href="/project/Default.php">Home</a> | <a href="project/Default.php">Search</a> | <a href="project/Default.php">New Releases</a> | <a href="/project/feedback.php">Contact Us</a><br />
- Copyright © 2048 <a href="#"><strong>Mr. Mobile Store</strong></a>
- </div>
- </center>
- </body>
- </html>
- carts.java(Servlet Page)
- import java.io.IOException;
- import java.io.PrintWriter;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import javax.servlet.RequestDispatcher;
- import javax.servlet.ServletException;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- import javax.servlet.http.HttpSession;
- public class carts extends HttpServlet {
- protected void processRequest(HttpServletRequest request, HttpServletResponse response)
- throws ServletException, IOException {
- response.setContentType("text/html;charset=UTF-8");
- PrintWriter out = response.getWriter();
- try{
- Connection conn;
- Class.forName("com.mysql.jdbc.Driver");
- conn =DriverManager.getConnection("jdbc:mysql://localhost/shopping_database?" +"user=root&password=");
- String s1=request.getParameter("name");
- String s2=request.getParameter("price");
- String s3=request.getParameter("cam");
- String s4=request.getParameter("size");
- out.println(s1);
- out.println(s2);
- out.println(s3);
- out.println(s4);
- PreparedStatement pst = conn.prepareStatement("INSERT INTO cartstore\"\n" +
- " + \"(pname, price, pcamera, psize) VALUES\"\n" +
- " + \"(?,?,?,?)");
- pst.setString(1,s1);
- pst.setString(2,s2);
- pst.setString(3,s3);
- pst.setString(4,s4);
- ResultSet rs = pst.executeQuery();
- if (rs.next())
- {
- response.sendRedirect("home.jsp");
- //out.println("SuccessfullyLogi");
- }
- else
- {
- RequestDispatcher rd = request.getRequestDispatcher("/index.html");
- out.println("<center><h1>Invalid product details. Please try again.</h1></center>");
- rd.include(request, response);
- }
- }
- catch(Exception e)
- {
- System.out.println(e);
- }
- }
- }
Add Comment
Please, Sign In to add comment