GTU-PROGRAMS: Write a JSP Page to which uses Session Tracking for online shopping.

[pro37index.jsp]

<%@ page import="java.sql.*" %>

try{

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","pankaj");

Statement stmt=con.createStatement();

ResultSet rs=stmt.executeQuery("select img,name from books");

<html>

<head>

<title>ONLINE BOOK STORE - LOGIN PAGE</title>

</head>

<body>

<tr>

<tr>

<td align=right><a href="http://master-gtu.blogspot.com">www.master-gtu.blogspot.com</a>

</table>

<tr>

<td colspan=5 align=center><h2>WELCOME TO ONLINE BOOK SHOPPING</h2>

<tr>

<tr>

while(rs.next())

{

<td>

<img src="<%="images/"+rs.getString("img") %>" width=100 height=150>

}

<tr>

rs=stmt.executeQuery("select img,name from books");

while(rs.next())

{

}

</table>

</marquee>

<i><h2>LOGIN</h2></i>

<table>

<tr>

<td>USERNAME

<tr>

<td>PASSWORD

<tr>

String msg=request.getParameter("msg");

if(msg!=null)

out.println("<font color=red>"+msg+"</font>");

<tr>

</table>

</form>

</table>

</body>

</html>

rs.close();

stmt.close();

con.close();

}catch(Exception e){}

[pro37purchase.jsp]

<%@ page import="java.sql.*" %>

int amt=0,sno=1;

String userid=String.valueOf(session.getAttribute("userid")); //converting to string becouse session will return Object type

String name=String.valueOf(session.getAttribute("name"));

try{

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","pankaj");

Statement stmt=con.createStatement();

ResultSet rs=stmt.executeQuery("select * from usercart where userid='"+userid+"'");

<html>

function purchase()

{

crno=document.getElementById("crno").value;

if(crno.length==10 )

alert('HIIIIII <%=name %> YOUR PAYMENT IS DONE, THANKING YOU !!! :-)');

else

alert('Pls Enter Proper Credit Card Number..');

//response.sendRedirect("/pro37showbooks.jsp");

}

</script>

<body>

<tr>

</table>

<tr>

<tr>

<th>SERIAL NO

<th>NAME OF PRODUCT

<th>PER PRICE

<th>QUANTITY

<th>PRICE

while(rs.next())

{

<tr>

amt=amt+(Integer.parseInt(rs.getString("quantity")) * Integer.parseInt(rs.getString("price")));

sno++;

}

<tr>

<td colspan=4 align=right>TOTAL AMOUNT

<tr>

master-gtu.blogspot.com<br>

pankaj & vijay<br>

MCA - 4<br>

<tr>

<th colspan=5> Credit Card Number : <input type="text" id="crno" ><br>

</table>

</body>

</html>

}catch(Exception e){ out.println(e); }

[pro37showbooks.jsp]

<%@ page import="java.sql.*" %>

try{

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","pankaj");

Statement stmt=con.createStatement();

String cat=request.getParameter("cat");

String userid=String.valueOf(session.getAttribute("userid"));

String name=String.valueOf(session.getAttribute("name"));

ResultSet rs;

if(cat!=null)

rs=stmt.executeQuery("select * from books where cat='"+cat+"'");

else

rs=stmt.executeQuery("select * from books");

<html>

<head>

<title>ONLINE BOOK STORE - LOGIN PAGE</title>

</head>

<body>

<tr>

<tr>

<td align=right><a href="http://master-gtu.blogspot.com">www.master-gtu.blogspot.com</a>

</table>

<tr>

<br><br><br><br><i><font face="MonoTypeCorsiva">SELECT CATEGORY</face></i><br><br>

<jsp:include page="pro37showlist.jsp"/>

<td>

Welcome <%=name %> | <a href="pro37showcart.jsp">Show My Cart</a> | My Account | <a href="pro37logout">Logout</a>

while(rs.next())

{

<tr>

<td><img src="<%="images/"+rs.getString("img") %>" width=100 height=150>

<td>

Name : <%=rs.getString("name") %><br>

Author : <%=rs.getString("auth") %><br>

Price : <%=rs.getString("price") %><br>

Status :

if(rs.getString("quantity").equals("0"))

{

out.println("<font color=red>Not Available</font>");

}

else

{

<font color=green>Available</font>

<td>

Quantity

</select><br><input type=submit value="ADD TO CART">

<%-- <a href="" onclick="javascript:alert(document.formsubmit.action)">slfj</a> --%>

</form>

}

</table>

</body>

</html>

}catch(Exception e){ out.println(e);}

[pro37showcart.jsp]

<%@ page import="java.sql.*,java.util.*" %>

try{

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","pankaj");

Statement stmt=con.createStatement();

String cat=request.getParameter("cat");

String userid=String.valueOf(session.getAttribute("userid")); //converting to string becouse session will return Object type

String name=String.valueOf(session.getAttribute("name"));

ResultSet rs;

rs=stmt.executeQuery("select * from usercart where userid='"+userid+"'");

<html>

<head>

<title>ONLINE BOOK STORE - LOGIN PAGE</title>

</head>

<body>

<tr>

<tr>

<td align=right><a href="http://master-gtu.blogspot.com">www.master-gtu.blogspot.com</a>

</table>

<tr>

<br><br><br><br><i><font face="MonoTypeCorsiva">SELECT CATEGORY</face></i><br><br>

<jsp:include page="pro37showlist.jsp"/>

<td>

Welcome <%=name %> | <a href="pro37showcart.jsp">Show My Cart</a> | My Account | <a href="pro37logout">Logout</a>

while(rs.next())

{

<tr>

<td><img src="<%="images/"+rs.getString("img") %>" width=100 height=150>

<td>

Name : <%=rs.getString("name") %><br>

Author : <%=rs.getString("auth") %><br>

Price : <%=Integer.parseInt(rs.getString("quantity")) * Integer.parseInt(rs.getString("price")) %><br>

Quantity : <%= rs.getString("quantity") %><br>

}

<tr>

<td colspan=3><a href="pro37purchase.jsp">PURCHASE</a>

</table>

</body>

</html>

rs.close();

stmt.close();

con.close();

}catch(Exception e)

{ out.println(e);}

[pro37showlist.jsp]

<ul>

<li>MIS

<li>ANDROID

<li>C++

</ul>

[pro37logincheck.java]

import java.io.*;

import java.sql.*;

import javax.servlet.*;

import javax.servlet.http.*;

import javax.servlet.annotation.*;

@WebServlet("/pro37logincheck")

public class pro37logincheck extends HttpServlet

{

public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException

{

res.setContentType("text/html");

PrintWriter out=res.getWriter();

String msg="Username Or Password Incorrect....";

try{

String username,password;

username=req.getParameter("username");

password=req.getParameter("password");

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","pankaj");

Statement stmt=con.createStatement();

ResultSet rs=stmt.executeQuery("select * from userinfo where username='"+username+"' and password='"+password+"'");

if(rs.next())

{

HttpSession session=req.getSession(true);

session.setAttribute("userid",rs.getString("userid"));

session.setAttribute("name",rs.getString("username"));

res.sendRedirect("pro37showbooks.jsp");

}

else

{

res.sendRedirect("pro37index.jsp?msg="+msg);

}

}catch(Exception e){ out.println(e); }

}

public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException

{

doGet(req,res);

}

[pro37addtocart.java]

import java.io.*;

import java.sql.*;

import javax.servlet.*;

import javax.servlet.http.*;

import javax.servlet.annotation.*;

@WebServlet("/pro37addtocart")

public class pro37addtocart extends HttpServlet

{

public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException

{

String cat="",id,msg="Username Or Password Incorrect....",userid,name,auth,img;

int quantity,price,selq,totalq;

HttpSession session=req.getSession(false);

userid=String.valueOf(session.getAttribute("userid"));

try{

res.setContentType("text/html");

PrintWriter out=res.getWriter();

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","pankaj");

Statement stmt=con.createStatement();

ResultSet rs;

id=req.getParameter("id");

selq=Integer.parseInt(req.getParameter("selq"));

rs=stmt.executeQuery("select * from books where id="+id);

rs.next();

totalq=Integer.parseInt(rs.getString("quantity"));

price=Integer.parseInt(rs.getString("price"));

name=rs.getString("name");

img=rs.getString("img");

cat=rs.getString("cat");

auth=rs.getString("auth");

quantity=totalq - selq;

rs=stmt.executeQuery("update books set quantity="+quantity+" where id="+id);

stmt.executeQuery("insert into usercart values('"+userid+"','"+id+"','"+selq+"','"+name+"','"+img+"','"+auth+"','"+cat+"','"+price+"')");

rs.close();

stmt.close();

con.close();

}catch(Exception e){}

res.sendRedirect("pro37showbooks.jsp?cat="+cat);

}

public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException

{

doGet(req,res);

}

[pro37logout.java]

import java.io.*;

import java.sql.*;

import javax.servlet.*;

import javax.servlet.http.*;

import javax.servlet.annotation.*;

@WebServlet("/pro37logout")

public class pro37logout extends HttpServlet

{

public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException

{

res.setContentType("text/html");

PrintWriter out=res.getWriter();

String msg="Logout Successfully....";

HttpSession session=req.getSession(true);

session.invalidate();

res.sendRedirect("pro37index.jsp?msg="+msg);

}

public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException

{

doGet(req,res);

}

5 comments:

master-gtu22 April 2012 at 02:28
DATABASE QUERIES
================

CREATE TABLE BOOKS
(
ID VARCHAR2(4000),
NAME VARCHAR2(4000),
IMG VARCHAR2(4000),
AUTH VARCHAR2(4000),
PRICE VARCHAR2(4000),
QUANTITY VARCHAR2(4000),
CAT VARCHAR2(4000)
);

insert into books values('1','WTAD Vol I','wtadvol1.jpg','Marty Hall, Larry Brown','175','300','java');
insert into books values('2','WTAD Vol II','wtadvol2.jpg','Marty Hall, Larry Brown','180','150','java');
insert into books values('3','Beginning HTML, XHTML, CSS, and JavaScript','beghtml.jpg','Jon Duckett','160','0','java');
insert into books values('4','McGraw-Hill - C - The Complete Reference, 4th Ed','ccompleteref.jpg','Herbert Schildt','160','150','c');
insert into books values('5','Data Communications and Networking','datacomnet.jpg','Behrouz A. Forouzan','250','60','network');
insert into books values('6','Java 2 - The Complete Reference 5E','comprefj2se.jpg','Herbert Schildt','230','50','java');

CREATE TABLE USERINFO
(
USERNAME VARCHAR2(4000),
PASSWORD VARCHAR2(4000),
USERID VARCHAR2(4000)
);

insert into userinfo values('pankaj','panku','1');
insert into userinfo values('ami','amu','2');
insert into userinfo values('vijay','viju','3');

CREATE TABLE USERCART
(
USERID VARCHAR2(4000),
ID VARCHAR2(4000),
QUANTITY VARCHAR2(4000),
NAME VARCHAR2(4000),
IMG VARCHAR2(4000),
AUTH VARCHAR2(4000),
CAT VARCHAR2(4000),
PRICE VARCHAR2(4000)
);
Anonymous19 June 2013 at 07:09
thanks
Unknown16 March 2016 at 01:48
It is a stunning post.your blog is giving very useful knowledge for all. Exceptionally valuable to me. I preferred it. And i'm sharing your information to all friends.If you
Want more details kindly Visit Here
Unknown28 June 2016 at 01:41
Valuable and informative blog. Keep sharing such kind of blogs in future as well. Thanks a lot.
Rated #1 Herbal Incense Super Store - LegalZensense.com
Unknown2 January 2017 at 05:37
Thank you to tell us so much useful information. I’m glad to read it. for more details you can go to below link…
herbal incense

Structure Query Language, C programming, Java, Servlet, Jsp, Unix

Sunday 22 April 2012

Write a JSP Page to which uses Session Tracking for online shopping.

5 comments: