Online Shopping System
3.8 SAMPLE CODE
LOGIN PAGE
<%@include file="template/top.jsp" %>
<%@include file="template/menu_public.jsp" %>
<%@include file="template/body_start.jsp" %>
<form id="form" action="loginbaseselect.jsp"> <table>
<tr>
<td><input type="text" name="uname" id="uname"
placeholder="username" required=""/> </td>
</tr>
<tr>
<td><input type="password" name="upass" id="upass"
placeholder="password" required=""/></td>
</tr>
<tr>
<td><button class="button" type="submit"
id="searchsubmit">Login</button> </td>
<td><div id="result"></div></td>
Department of Computer Science, CUSAT Page 1
Online Shopping System
</tr>
</table>
</form>
<script type="text/javascript">
<%
if (request.getParameter("login") != null &&
request.getParameter("login").contentEquals("failed")) {
%>
alert("Login Failed !!!");
<% }
%> <%
if (request.getParameter("login") != null &&
request.getParameter("login").contentEquals("dissabled")) {
%>
alert("User Blocked !!!");
<% }
%> <%
Department of Computer Science, CUSAT Page 2
Online Shopping System
if (request.getParameter("login") != null &&
request.getParameter("login").contentEquals("unknown")) {
%> alert("Unknown user !!!");
<% }
%>
</script>
%@include file="template/body_end.jsp" %
REGISTRATION
<%@page import="DataBase.DB"%>
<%@page import="java.sql.ResultSet"%>
<%@include file="template/top.jsp" %>
<%@include file="template/menu_public.jsp" %>
<%@include file="template/body_start.jsp" %>
<h2 class="title"><a href="#">Register </a></h2>
<div class="entry">
<form action="dbregister.jsp" onsubmit="return check()">
Department of Computer Science, CUSAT Page 3
Online Shopping System
<table>
<tr>
<td>User Name
</td>
<td><input type="text" required="" name="uname" id="uname"
/>
</td>
</tr>
<tr>
<td>Password
</td>
<td><input type="password" required="" name="upass" id="upass" />
</td>
</tr>
<tr>
<td>Login Name
Department of Computer Science, CUSAT Page 4
Online Shopping System
</td>
<td><input type="text" required="" name="lname" id="lname" />
</td>
</tr>
<tr>
<td>Email
</td>
<td><input type="email" name="emailid" id="emailid" />
</td>
</tr>
<tr>
<td>Mobile No.
</td>
<td><input type="text" name="mobno" id="mobno" />
</td>
</tr>
Department of Computer Science, CUSAT Page 5
Online Shopping System
<tr>
<td>
</td>
<td><button class="button" type="submit">Register</button>
</td>
</tr>
</table>
</form>
</div>
<script type="text/javascript">
<%
if (request.getParameter("reg") != null &&
request.getParameter("reg").contentEquals("failed")) {
%> alert("Registration Failed !!!");
Department of Computer Science, CUSAT Page 6
Online Shopping System
<% }
%> <%
if
(request.getParame
ter("reg") != null &&
request.getParamet
er("reg").contentEq
uals("success")) {
%>
alert("Registration Completed")
<% }
%>
</script>
%@include file="template/body_end.jsp" %
DB REGISTRATION
Department of Computer Science, CUSAT Page 7
Online Shopping System
<%@page import="config.Config"%>
<%@page import="java.io.File"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="DataBase.DB"%>
<%
if (DB.executeUpdate("insert into login values("
+ "null" + ",'" + request.getParameter("uname") + "',SHA1('"
+ request.getParameter("upass") + "'),'"
+ "user" + "','"
+ "false" + "')")) {
ResultSet r = DB.executeQuery("select max(uid) from login");
r.next();
String uid = r.getString(1);
if (DB.executeUpdate("insert into userdetails values("
+ uid + ",'"
+ request.getParameter("lname") + "','"
Department of Computer Science, CUSAT Page 8
Online Shopping System
+ request.getParameter("emailid") + "','"
+ request.getParameter("mobno") + "')")) {
// this code generates the qr code inside the QR_Code folder in the c
drive response.sendRedirect("index.jsp?reg=success");
} else {
response.sendRedirect("register.jsp?reg=failed");
}
%>
LOGIN BASE SELECTION
<%@page import="DataBase.DB"%>
<%@page import="java.sql.ResultSet"%>
<%
String uname = request.getParameter("uname");
String upass = request.getParameter("upass");
Department of Computer Science, CUSAT Page 9
Online Shopping System
ResultSet r = DB.executeQuery("select * from login where uname='" +
uname + "' and upass=SHA1('" + upass + "')");
if (r != null && r.next()) {
if (r.getString("enabled") != null &&
r.getString("enabled").contentEquals("true")) {
session.setAttribute("uname", uname);
session.setAttribute("uid", r.getString("uid"));
session.setAttribute("utype",r.getString("utype")); if
(r.getString("utype").contentEquals("admin")) {
response.sendRedirect("adminindex.jsp"); } else if
(r.getString("utype").contentEquals("mod")) {
response.sendRedirect("modindex.jsp");
} else if (r.getString("utype").contentEquals("user")) {
response.sendRedirect("userindex.jsp");
} else {
Department of Computer Science, CUSAT Page 10
Online Shopping System
session.setAttribute("uname", null);
session.setAttribute("uid", null); session.setAttribute("utype",null);
response.sendRedirect("login.jsp?login=unknown");
} else {
response.sendRedirect("login.jsp?login=dissabled");
} else {
response.sendRedirect("login.jsp?login=failed");
%>
DATABASE CONNECTION
package DataBase;
import java.sql.*; public class DB {
Department of Computer Science, CUSAT Page 11
Online Shopping System
static Connection con = null; static Statement stmt =
null; static ResultSet rs = null;
public static Connection getConnection() {
try {
Class.forName("com.mysql.jdbc.Driver");
con =
DriverManager.getConnection("jdbc:mysql://localhost:3306/online_shoppi ng",
"root", "root");
} catch (Exception e) {
System.out.println("Exception" + e);
return con;
public static boolean executeUpdate(String query) { boolean f =
false;
Department of Computer Science, CUSAT Page 12
Online Shopping System
try {
con = getConnection(); stmt =
con.createStatement(); int b =
stmt.executeUpdate(query);
if (b > 0) {
f = true; } else {
f = false;
} catch (Exception e) {
System.out.println("Exception" + e);
return f;
public static ResultSet executeQuery(String sql) {
Department of Computer Science, CUSAT Page 13
Online Shopping System
try {
con = getConnection(); stmt =
con.createStatement(); rs = stmt.executeQuery(sql);
return rs;
} catch (Exception e) {
System.out.println("Exception" + e);
return null;
}
public static void close() {
try {
con.close(); stmt.close(); rs.close();
} catch (Exception e) {
System.out.println("Exception" + e);
Department of Computer Science, CUSAT Page 14
Online Shopping System
ANDROID WEB-VIEW ACTIVITY
package com.onlineshopping.activity; import com.onlineshopping.activity.R;
import com.onlineshopping.activity.custom.CustomWebChromeClient; import
com.onlineshopping.activity.custom.CustomWebViewClient;
import android.annotation.SuppressLint; import
android.app.Activity; import
android.content.res.Configuration; import
android.os.Bundle; import android.view.KeyEvent;
import android.webkit.WebSettings.PluginState; import
android.webkit.WebView;
@SuppressLint("SetJavaScriptEnabled") public class
WebViewActivity extends Activity {
Department of Computer Science, CUSAT Page 15
Online Shopping System
// the web view refence object private WebView
webView;
// the site url link
public static final String SITE_URL_START = "http://";
public static String SITE_URL = ""; public static
final String SITE_URL_END = ":8084/OnlineShoppingCart/";
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_web_view);
// get the refernce of the web view
webView = (WebView) findViewById(R.id.siteWebView);
// set the web view chrome client and set for showing a progress bar
Department of Computer Science, CUSAT Page 16
Online Shopping System
this.webView.setWebChromeClient(new
CustomWebChromeClient(this));
this.webView.setWebViewClient(new
CustomWebViewClient(
getApplicationContext()));
// on the ui thread do the processing
runOnUiThread(new Runnable() {
@SuppressWarnings("deprecation") public void run() {
// set the javascript on
webView.getSettings().setJavaScriptEnabled(true);
// enable all the plugins
webView.getSettings().setPluginState(PluginState.ON);
// load the url
webView.loadUrl(SITE_URL_START +
SITE_URL + SITE_URL_END);
Department of Computer Science, CUSAT Page 17
Online Shopping System
});
// To handle "Back" key press event for WebView to go back to previous
// screen. @Override
public boolean onKeyDown(int keyCode, KeyEvent event) {
if ((keyCode == KeyEvent.KEYCODE_BACK) &&
webView.canGoBack()) {
webView.goBack();
return true;
return super.onKeyDown(keyCode, event);
// flipscreen not loading again
@Override
public void onConfigurationChanged(Configuration newConfig) {
super.onConfigurationChanged(newConfig);
Department of Computer Science, CUSAT Page 18
Online Shopping System
CHAPTER 4
CONCLUSION
The project entitled Online shopping system was completed successfully.
The system has been developed with much care and free of errors and at the same
time it is efficient and less time consuming. The purpose of this project was to
develop a web application and an android application for purchasing items from a
shop.
This project helped us in gaining valuable information and practical knowledge
on several topics like designing web pages using html & css, usage of responsive
templates, designing of android applications, and management of database using
Department of Computer Science, CUSAT Page 19
Online Shopping System
mysql . The entire system is secured. Also the project helped us understanding
about the development phases of a project and software development life cycle.
We learned how to test different features of a project.
This project has given us great satisfaction in having designed an application
which can be implemented to any nearby shops or branded shops selling various
kinds of products by simple modifications.
There is a scope for further development in our project to a great extend. A number
of features can be added to this system in future like providing moderator more
control over products so that each moderator can maintain their own products.
Another feature we wished to implement was providing classes for customers so
that different offers can be given to each class. System may keep track of history
of purchases of each customer and provide suggestions based on their history.
These features could have implemented unless the time did not limited us.
REFERENCES
Department of Computer Science, CUSAT Page 20
Online Shopping System
[1] JavaScript Enlightenment,Cody Lindley-First Edition, based on JavaScript 1.5,
ECMA-262, Edition
[2] Mc GrawHill’s , Java : The complete reference 7thEdition, Herbert
Schildit
[3] Complete CSS Guide ,Maxine Sherrin and John Allsopp-O'Reilly Media;
September 2012
[4] http://www.w3schools.com/html/defualt.asp,
http://www.w3schools.com/css/default.asp,
http://www.w3schools.com/js/default.asp
Department of Computer Science, CUSAT Page 21
