Project Prerequisites:<\/h3>\n\n- IDE Used: NetBeans 8.2. (you can also use Eclipse)<\/li>\n
- Java should be installed on the machine.<\/li>\n
- Database Used: MySQL 5.5.<\/li>\n
- To build an online shopping system using java we require basic knowledge of java and also knowledge of the MySQL databases.<\/li>\n
- Java provides the Servlet package for handling http requests and responses. Also, we need two more libraries such as Mysql-JDBC-connector and apache-commons-fileupload.<\/li>\n<\/ul>\n
Download Online Shopping Project Java Code<\/h3>\n
Please download the java source code of online shopping project: Online Shopping System Java Project Code<\/strong><\/a><\/p>\nSteps to Create Online Shopping Project in Java<\/h2>\n
These are the step to build Online Shopping System using java:<\/p>\n
1) Creating Database
\n2) Importing packages
\n3) System files structure
\n4) Functions used
\n5) Connection to database
\n6) Defining new customer registering servlet
\n7) Defining customer login servlet
\n8) Defining admin login servlet
\n9) Defining servlet for adding product in the database
\n10) Defining add to cart servlet
\n11) Defining servlet for customer to update product quantity in the cart
\n12) Defining servlet for admin to get current products status<\/p>\n
1) Creating Database (MYSQL):<\/h3>\n
In this step, we basically create java online shopping system database.<\/p>\n
And also we create five tables:<\/p>\n
a) Admin table for storing information such as username, password, name and admin table is used for login purposes.
\nb) Cart table for storing information about the cart such as customer_id, quantity, product_id, etc.
\nc) Customer table for storing information such as username, password, name and customer table is used for login purposes.
\nd) Order table for storing information the customer has ordered the product from the website such as custiomer_id, product_id, payment_id, customer name, product name, total amount, quantity, address, etc.
\ne) Product table for storing information about the product such as product_name, id, image, price, mrp price, category, etc.<\/p>\n
1) ADMIN TABLE: (tbladmin)<\/h4>\nCREATE TABLE `tbladmin` (\r\n `id` bigint(20) NOT NULL AUTO_INCREMENT,\r\n `added_date` datetime NOT NULL,\r\n `email` varchar(100) NOT NULL,\r\n `password` varchar(100) NOT NULL,\r\n `name` varchar(100) NOT NULL,\r\n PRIMARY KEY (`id`)\r\n) ;\r\n<\/pre>\n2) CART TABLE: (tblcart)<\/h4>\nCREATE TABLE `tblcart` (\r\n `id` bigint(20) NOT NULL AUTO_INCREMENT,\r\n `discount_price` varchar(200) DEFAULT NULL,\r\n `quantity` int(11) NOT NULL,\r\n `total_price` varchar(200) DEFAULT NULL,\r\n `customer_id` bigint(20) NOT NULL,\r\n `product_id` bigint(20) NOT NULL,\r\n `mrp_price` varchar(200) DEFAULT NULL,\r\n PRIMARY KEY (`id`)\r\n) ;\r\n<\/pre>\n3) CUSTOMER TABLE: (tblcustomer):<\/h4>\nCREATE TABLE `tblcustomer` (\r\n `id` int(11) NOT NULL AUTO_INCREMENT,\r\n `address` varchar(255) NOT NULL,\r\n `added_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\r\n `email` varchar(100) NOT NULL,\r\n `gender` varchar(6) NOT NULL,\r\n `name` varchar(50) NOT NULL,\r\n `password` varchar(60) NOT NULL,\r\n `phone` varchar(200) NOT NULL,\r\n `pin_code` varchar(255) NOT NULL,\r\n PRIMARY KEY (`id`)\r\n) ;\r\n<\/pre>\n4) ORDERS TABLE: (tblorders)<\/h4>\nCREATE TABLE `tblorders` (\r\n `id` int(11) NOT NULL AUTO_INCREMENT,\r\n `order_no` int(11) DEFAULT NULL,\r\n `customer_name` varchar(200) DEFAULT NULL,\r\n `mobile_number` varchar(100) DEFAULT NULL,\r\n `email_id` varchar(100) DEFAULT NULL,\r\n `address` varchar(400) DEFAULT NULL,\r\n `address_type` varchar(100) DEFAULT NULL,\r\n `pincode` varchar(100) DEFAULT NULL,\r\n `image` varchar(200) DEFAULT NULL,\r\n `product_name` varchar(400) DEFAULT NULL,\r\n `quantity` int(11) DEFAULT NULL,\r\n `product_price` varchar(100) DEFAULT NULL,\r\n `product_selling_price` varchar(100) DEFAULT NULL,\r\n `product_total_price` varchar(100) DEFAULT NULL,\r\n `order_status` varchar(100) DEFAULT NULL,\r\n `order_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\r\n `payment_mode` varchar(100) DEFAULT NULL,\r\n `payment_id` int(11) DEFAULT NULL,\r\n PRIMARY KEY (`id`)\r\n) ;\r\n<\/pre>\n5) PRODUCT TABLE: (tblproduct)<\/h4>\nCREATE TABLE `tblproduct` (\r\n `id` bigint(20) NOT NULL AUTO_INCREMENT,\r\n `active` varchar(100) DEFAULT NULL,\r\n `code` varchar(5) DEFAULT NULL,\r\n `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n `description` varchar(255) DEFAULT NULL,\r\n `image` varchar(100) DEFAULT NULL,\r\n `image_name` varchar(400) DEFAULT NULL,\r\n `name` varchar(30) DEFAULT NULL,\r\n `price` varchar(200) DEFAULT NULL,\r\n `mrp_price` varchar(200) DEFAULT NULL,\r\n `product_category` varchar(100) DEFAULT NULL,\r\n PRIMARY KEY (`id`)\r\n) ;\r\n<\/pre>\n6) INSERTING VALUE FOR ADMIN:<\/h4>\nINSERT INTO tbladmin(email,password,name) VALUES('admin@gmail.com','admin','DataFlair');\r\n<\/pre>\n2) Importing packages<\/h3>\n
By default, Servlet packages are installed by JAVA (J2EE).<\/p>\n
But, mysql-connector library and apache-commons-fileupload we have to download from the internet and import into our project.<\/p>\n
Download mysql-connector library<\/a> for online shopping system<\/p>\nDownload apache-commons-fileupload library<\/a><\/p>\nHow to import them?<\/strong><\/p>\na) Click on Tools > Libraries<\/p>\n
![\"add](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/add-library.png\")
<\/a><\/p>\nb) At bottom left Click on \u201cNew Library\u201d<\/p>\n
![\"new](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/new-library.png\")
<\/a><\/p>\nName your library and click on \u201cOK\u201d.<\/p>\n
![\"create](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/create-new-lib.png\")
<\/a><\/p>\nNow Click on Add JAR\/Folder and select the downloaded file to add in online shopping java project and click on \u201cok\u201d.<\/p>\n
![\"add](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/add-jar-in-java-project.png\")
<\/a><\/p>\nNow, add that library on in your project.<\/p>\n
3) Project Structure:<\/h3>\n
![\"online](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/online-shopping-project-structure.png\")
<\/a><\/p>\nFiles Description:<\/strong><\/p>\na) Admin-add-products.jsp: It is used by admin to add new products in the database of the system.
\nb) Admin-all-orders.jsp: It is used by admin to view all orders from the database of the system.
\nc) Admin-delete-product.jsp: It is used by admin to delete any specific product from the database of the system.
\nd) Admin-delivered-products.jsp: It is used by admin to mark the products as delivered which were pending in the system.
\ne) Admin-edit-product-process.jsp: It is used by admin to update the details of specific products in the database of the system.
\nf) Admin-edit-product.jsp: It takes input from the admin to update the specific product and after that process is handled by the Admin-edit-product-process.jsp
\ng) Admin-login.jsp: It checks the authentication of the admin and redirected to the dashboard.jsp page
\nh) Admin-logout.jsp: It logouts the admin from the session and sends it back to the admin-login.jsp page.
\ni) Admin-pending-orders.jsp: It is used by admin to view all pending orders from the database of the system.
\nj) Admin-view-customers.jsp: It is used by admin to view all customers from the database of the system.
\nk) Admin-view-product.jsp: It is used by admin to view all products from the database of the system.
\nl) AdminHeader.jsp: This page contains a navigation bar for the admin\/seller dashboard in java online shopping project.
\nm) Checkout.jsp: This page is used by the customer when it checks out his\/her orders, all the order entries made in the database of the system.
\nn) Customer-login.jsp: It checks the authentication of the customer and redirected to the index.jsp page
\no) Customer-register.jsp: This page is used by the customer to register the new customer\/user.
\np) Dashboard.jsp: This page is used by the admin to display all the counts of the customers, products, orders.
\nq) Footer.jsp: This is a common page that includes footer and used by all the jsp pages in java online shopping system.
\nr) Header.jsp: This page contains a navigation bar for the customer\/user dashboard.
\ns) Index.jsp: This is a main display page that includes all products.
\nt) Logout.jsp: It logouts the user\/customer from the session and sends it back to the index.jsp page.
\nu) My-orders.jsp: This page is used by customers and it contains all the order history of the customer.
\nv) Products.jsp: This is a display page that includes all products and their descriptions.
\nw) RemoveProductFromTheCart.jsp: This is used by the customer and it removes specific products from the cart provided by the customer.<\/p>\n
4) Functions Used:<\/h3>\n
a) getParameter(\u201cname\u201d):<\/strong> This function will return the value of the name object of the input of the client.
\nb) getSession():<\/strong> This function will return the current session object. If the parameter is true, then it will create a new session in java online shopping project.
\nc) getAttribute(\u201cobject_name\u201d):<\/strong> This function will return the stored value of a specified object from the session.
\nd) setAttribute(“object_name”,object_value):<\/strong> This function will take the parameters as key and value and store it inside the session.
\ne)sendRedirect(\u201cname_of_the_page\u201d):<\/strong> This function will redirect the current page to the specified page. The specified page can be html or jsp format.
\nf) invalidate():<\/strong> This function will invalidate the session. It is used to clear current session values and also for logout.<\/p>\n5) Connection to Database:<\/h3>\n
In this step, we will create a universal connection method as a reusable method for java online shopping system project project, this method will connect to MySQL database. Make sure that you enter the proper url string of database connection such as port number, username, password, etc.<\/p>\n
Function definitions:<\/strong><\/p>\na) forName(driverClassName):<\/strong> This function is used to register with the driver of the database.
\nb) getConnection(url):<\/strong> This function is used to make connections with databases. It takes parameters such as hostname, port number, database, username, password, etc. Generalized form: “jdbc:mysql:\/\/hostname:port\/dbName”, “username”, “password”. If your mysql does not have a password then enter \u201c\u201d as an empty string.
\nc) close():<\/strong> This function will close the connection of mysql database. This function is important to clean the garbage values and to make an optimized system.<\/p>\nCode:<\/strong><\/p>\npackage com.connection;\r\n\r\nimport java.sql.Connection;\r\nimport java.sql.DriverManager;\r\nimport java.sql.ResultSet;\r\nimport java.sql.SQLException;\r\n\r\npublic class DatabaseConnection {\r\n\r\n \/\/Creating database Connection in java online shopping system\r\n public static Connection connection;\r\n\r\n \/\/Creating universal method to open connect will mysql database\r\n public static Connection getConnection() {\r\n try {\r\n \/\/Registering with mysql Driver\r\n Class.forName(\"com.mysql.jdbc.Driver\");\r\n connection = DriverManager.getConnection(\"jdbc:mysql:\/\/localhost:3306\/shoppingsystem\", \"root\", \"yourpassword\");\r\n } catch (Exception e) {\r\n e.printStackTrace();\r\n }\r\n return (connection);\r\n }\r\n\r\n \/\/Creating universal method to close connect will mysql database\r\n public static void CloseConnection() {\r\n if (connection != null) {\r\n try {\r\n connection.close();\r\n connection = null;\r\n } catch (SQLException ex) {\r\n ex.printStackTrace();\r\n }\r\n }\r\n }\r\n\r\n \/\/Creating universal method to query for retrieving information\r\n public static ResultSet getResultFromSqlQuery(String SqlQueryString) {\r\n \/\/Creating Resultset object\r\n ResultSet rs = null;\r\n try {\r\n \/\/Checking whether the connection is null or null\r\n if (connection == null) {\r\n getConnection();\r\n }\r\n \/\/Querying the query\r\n rs = connection.createStatement().executeQuery(SqlQueryString);\r\n } catch (Exception ex) {\r\n ex.printStackTrace();\r\n }\r\n return rs;\r\n }\r\n\r\n \/\/Creating universal method to query for inserting or updating information in mysql database\r\n public static int insertUpdateFromSqlQuery(String SqlQueryString) {\r\n int i = 2;\r\n try {\r\n \/\/Checking whether the connection is null or null\r\n if (connection == null) {\r\n getConnection();\r\n }\r\n \/\/Querying the query\r\n i = connection.createStatement().executeUpdate(SqlQueryString);\r\n\r\n } catch (Exception ex) {\r\n ex.printStackTrace();\r\n }\r\n return i;\r\n }\r\n}\r\n<\/pre>\n6) Defining new customer registering servlet<\/h3>\n
In this step of online shopping system, we will take the values from the frontend (customer-register.jsp) values and insert into our tblcustomer table and if data entered successfully then we will send a response that you have been registered successfully and redirecting to the customer-login.jsp page.<\/p>\n
Code:<\/strong><\/p>\nimport java.io.IOException;\r\n\r\nimport javax.servlet.ServletException;\r\nimport javax.servlet.annotation.WebServlet;\r\nimport javax.servlet.http.HttpServlet;\r\nimport javax.servlet.http.HttpServletRequest;\r\nimport javax.servlet.http.HttpServletResponse;\r\nimport javax.servlet.http.HttpSession;\r\n\r\nimport com.connection.DatabaseConnection;\r\n\r\n@WebServlet(\"\/AddCustomer\")\r\npublic class AddCustomer extends HttpServlet {\r\n\r\n protected void doPost(HttpServletRequest request, HttpServletResponse response)\r\n throws ServletException, IOException {\r\n\r\n \/\/Retrieving values from the frontend\r\n String name = request.getParameter(\"name\");\r\n String email = request.getParameter(\"email\");\r\n String password = request.getParameter(\"password\");\r\n String mobile = request.getParameter(\"mobile\");\r\n String gender = request.getParameter(\"gender\");\r\n String address = request.getParameter(\"address\");\r\n String pincode = request.getParameter(\"pincode\");\r\n \r\n \/\/Creating Session\r\n HttpSession hs = request.getSession();\r\n \r\n \/\/Inserting all values inside the database\r\n try {\r\n \/\/Connecting database connection and querying in the database\r\n int addCustomer = DatabaseConnection.insertUpdateFromSqlQuery(\"insert into tblcustomer(address,email,gender,name,password,phone,pin_code)values('\" + address + \"','\" + email + \"','\" + gender + \"','\" + name + \"','\" + password + \"','\"\r\n + mobile + \"','\" + pincode + \"')\");\r\n \r\n \/\/If customer registered successfully in java online shopping system\r\n if (addCustomer > 0) {\r\n String message = \"Customer register successfully.\";\r\n \/\/Passing message via session.\r\n hs.setAttribute(\"success-message\", message);\r\n \/\/Sending response back to the user\/customer\r\n response.sendRedirect(\"customer-register.jsp\");\r\n } else {\r\n \/\/If customer fails to register \r\n String message = \"Customer registration fail\";\r\n \/\/Passing message via session.\r\n hs.setAttribute(\"fail-message\", message);\r\n \/\/Sending response back to the user\/customer\r\n response.sendRedirect(\"customer-register.jsp\");\r\n }\r\n } catch (Exception ex) {\r\n ex.printStackTrace();\r\n }\r\n }\r\n}\r\n<\/pre>\n7) Defining customer login servlet:<\/h3>\n
In this step, we will take the values from the frontend (customer-login.jsp) values and check credentials via database. If credentials are correct then user\/customer will be redirected to index.jsp page else customer-login.jsp page.<\/p>\n
Code:<\/strong><\/p>\nimport java.io.IOException;\r\nimport java.sql.ResultSet;\r\nimport javax.servlet.ServletException;\r\nimport javax.servlet.annotation.WebServlet;\r\nimport javax.servlet.http.HttpServlet;\r\nimport javax.servlet.http.HttpServletRequest;\r\nimport javax.servlet.http.HttpServletResponse;\r\nimport javax.servlet.http.HttpSession;\r\n\r\nimport com.connection.DatabaseConnection;\r\n\r\n@WebServlet(\"\/CustomerLogin\")\r\npublic class CustomerLogin extends HttpServlet {\r\n\r\n protected void doPost(HttpServletRequest request, HttpServletResponse response)\r\n throws ServletException, IOException {\r\n\r\n \/\/Getting all data from user\/customer\r\n String email = request.getParameter(\"email\");\r\n String password = request.getParameter(\"password\");\r\n \/\/Creating Session\r\n HttpSession hs = request.getSession();\r\n try {\r\n \/\/Creating Resultset\r\n ResultSet resultset = null;\r\n \/\/Query to check Login Details\r\n resultset = DatabaseConnection.getResultFromSqlQuery(\"select * from tblcustomer where email='\" + email + \"' and password='\" + password + \"'\");\r\n \/\/Checking whether the details of user are null or not\r\n if (email != null && password != null) {\r\n if (resultset.next()) {\r\n \/\/Storing the login details in session\r\n hs.setAttribute(\"id\", resultset.getInt(\"id\"));\r\n hs.setAttribute(\"name\", resultset.getString(\"name\"));\r\n \/\/Redirecting response to the index.jsp\r\n response.sendRedirect(\"index.jsp\");\r\n } else {\r\n \/\/If wrong credentials are entered in java online shopping system\r\n String message = \"You have enter wrong credentials\";\r\n hs.setAttribute(\"credential\", message);\r\n \/\/Redirecting response to the customer-login.jsp\r\n response.sendRedirect(\"customer-login.jsp\");\r\n }\r\n } else {\r\n \/\/If username or password is empty or null\r\n String message = \"User name or Password is null\";\r\n hs.setAttribute(\"credential\", message);\r\n \/\/Redirecting response to the customer-login.jsp\r\n response.sendRedirect(\"customer-login.jsp\");\r\n }\r\n\r\n } catch (Exception e) {\r\n e.printStackTrace();\r\n }\r\n }\r\n}\r\n<\/pre>\n8) Defining admin login servlet<\/h4>\n
In this step, we will take the values from the frontend (admin-login.jsp) values and check credentials via database. If credentials are correct then admin\/seller will be redirected to dashboard.jsp page else admin-login.jsp page in online shopping project.<\/p>\n
Code:<\/strong><\/p>\nimport java.io.IOException;\r\nimport java.sql.Connection;\r\nimport java.sql.ResultSet;\r\nimport java.sql.Statement;\r\n\r\nimport javax.servlet.ServletException;\r\nimport javax.servlet.annotation.WebServlet;\r\nimport javax.servlet.http.HttpServlet;\r\nimport javax.servlet.http.HttpServletRequest;\r\nimport javax.servlet.http.HttpServletResponse;\r\nimport javax.servlet.http.HttpSession;\r\n\r\nimport com.connection.DatabaseConnection;\r\n\r\n@WebServlet(\"\/AdminLogin\")\r\npublic class AdminLogin extends HttpServlet {\r\n\r\n protected void doPost(HttpServletRequest request, HttpServletResponse response)\r\n throws ServletException, IOException {\r\n try {\r\n \/\/Getting all the parameters from the frontend (admin)\r\n String email = request.getParameter(\"email\");\r\n String pass = request.getParameter(\"upass\");\r\n\r\n \/\/Retriving our session\r\n HttpSession hs = request.getSession();\r\n\r\n \/\/Calling Connection method\r\n Connection con = DatabaseConnection.getConnection();\r\n\r\n \/\/Creating Statement\r\n Statement st = con.createStatement();\r\n\r\n \/\/Querying inside the database\r\n ResultSet resultset = st.executeQuery(\"select * from tbladmin where email='\" + email + \"' AND password='\" + pass + \"'\");\r\n \/\/If all the details are correct\r\n if (resultset.next()) {\r\n hs.setAttribute(\"uname\", resultset.getString(\"name\"));\r\n \/\/Redirecting admin to dashboard page\r\n response.sendRedirect(\"dashboard.jsp\");\r\n\r\n } else {\r\n \/\/If details are wrong\r\n String message = \"You have enter wrong credentials\";\r\n hs.setAttribute(\"credential\", message);\r\n \/\/Redirecting admin to admin login page\r\n response.sendRedirect(\"admin-login.jsp\");\r\n }\r\n } catch (Exception e) {\r\n System.out.println(e);\r\n }\r\n }\r\n}\r\n<\/pre>\n9) Defining servlet for adding product in the database<\/h3>\n
In this step of online shopping project, we will take all the parameters\/inputs from the frontend (admin) and all the inputs of the new product such as image, category, product name, price, etc will be saved to the database.<\/p>\n
Code:<\/strong><\/p>\nimport java.io.File;\r\nimport java.io.IOException;\r\nimport java.util.List;\r\nimport java.util.Random;\r\n\r\nimport javax.servlet.ServletException;\r\nimport javax.servlet.annotation.WebServlet;\r\nimport javax.servlet.http.HttpServlet;\r\nimport javax.servlet.http.HttpServletRequest;\r\nimport javax.servlet.http.HttpServletResponse;\r\nimport javax.servlet.http.HttpSession;\r\n\r\nimport org.apache.commons.fileupload.FileItem;\r\nimport org.apache.commons.fileupload.disk.DiskFileItemFactory;\r\nimport org.apache.commons.fileupload.servlet.ServletFileUpload;\r\n\r\nimport com.connection.DatabaseConnection;\r\n\r\n@WebServlet(\"\/AddProducts\")\r\npublic class AddProducts extends HttpServlet {\r\n\r\n \/\/Path where all the images are stored\r\n private final String UPLOAD_DIRECTORY = \"ENTER_YOUR_DIRECTORY_PATH\";\r\n\r\n @Override\r\n protected void doPost(HttpServletRequest request, HttpServletResponse response)\r\n throws ServletException, IOException {\r\n\r\n \/\/Creating session in java online shopping project\r\n HttpSession session = request.getSession();\r\n if (ServletFileUpload.isMultipartContent(request)) {\r\n try {\r\n \/\/Taking all image requests\r\n List<FileItem> multiparts = new ServletFileUpload(new DiskFileItemFactory()).parseRequest(request);\r\n String imageName = null;\r\n String productName = null;\r\n String productQuantity = null;\r\n String productPrice = null;\r\n String descrip = null;\r\n String mrpPrice = null;\r\n String status = null;\r\n String category = null;\r\n\r\n \/\/SALTCHARS to generate unique code for product\r\n String SALTCHARS = \"ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890\";\r\n StringBuilder salt = new StringBuilder();\r\n Random rnd = new Random();\r\n while (salt.length() < 3) { \/\/ length of the random string.\r\n int index = (int) (rnd.nextFloat() * SALTCHARS.length());\r\n salt.append(SALTCHARS.charAt(index));\r\n }\r\n String code = salt.toString();\r\n\r\n for (FileItem item : multiparts) {\r\n if (!item.isFormField()) {\r\n \/\/Getting image name\r\n imageName = new File(item.getName()).getName();\r\n \/\/Storing in the specified directory\r\n item.write(new File(UPLOAD_DIRECTORY + File.separator + imageName));\r\n\r\n \/\/Retrieving all information from frontend of online shopping system\r\n FileItem pName = (FileItem) multiparts.get(0);\r\n productName = pName.getString();\r\n\r\n FileItem price = (FileItem) multiparts.get(1);\r\n productPrice = price.getString();\r\n\r\n FileItem description = (FileItem) multiparts.get(2);\r\n descrip = description.getString();\r\n\r\n FileItem mprice = (FileItem) multiparts.get(3);\r\n mrpPrice = mprice.getString();\r\n\r\n FileItem fstatus = (FileItem) multiparts.get(4);\r\n status = fstatus.getString();\r\n\r\n FileItem pcategory = (FileItem) multiparts.get(5);\r\n category = pcategory.getString();\r\n\r\n }\r\n }\r\n try {\r\n int id = 0;\r\n String imagePath = UPLOAD_DIRECTORY + imageName;\r\n \/\/Querying to insert product in the table\r\n int i = DatabaseConnection.insertUpdateFromSqlQuery(\"insert into tblproduct(id,active,code,description,image,image_name,name,price,mrp_price,product_category) values('\" + id + \"','\" + status + \"','\" + code + \"','\" + descrip + \"','\" + imagePath + \"','\" + imageName + \"','\" + productName + \"','\" + productPrice + \"','\" + mrpPrice + \"','\" + category + \"')\");\r\n \/\/If product inserted successfully in the database\r\n if (i > 0) {\r\n String success = \"Product added successfully.\";\r\n \/\/Adding method in session.\r\n session.setAttribute(\"message\", success);\r\n \/\/Response send to the admin-add-product.jsp\r\n response.sendRedirect(\"admin-add-product.jsp\");\r\n }\r\n } catch (Exception e) {\r\n e.printStackTrace();\r\n }\r\n } catch (Exception ex) {\r\n \/\/If any error occurred while uploading product image\r\n request.setAttribute(\"message\", \"File Upload Failed due to \" + ex);\r\n }\r\n } else {\r\n request.setAttribute(\"message\", \"Sorry this Servlet only handles file upload request\");\r\n }\r\n }\r\n}\r\n<\/pre>\n10) Defining add to cart servlet<\/h3>\n
In this section, we will take products (product_id) as input from the user\/customer which he\/she wants to add the product into the cart of online shopping system. The products which are added in the cart by the user, their details will be added in the table tblcart.<\/p>\n
Code:<\/strong><\/p>\nimport java.io.IOException;\r\nimport javax.servlet.ServletException;\r\nimport javax.servlet.annotation.WebServlet;\r\nimport javax.servlet.http.HttpServlet;\r\nimport javax.servlet.http.HttpServletRequest;\r\nimport javax.servlet.http.HttpServletResponse;\r\nimport javax.servlet.http.HttpSession;\r\n\r\nimport com.connection.DatabaseConnection;\r\n\r\n@WebServlet(\"\/AddToCart\")\r\npublic class AddToCart extends HttpServlet {\r\n\r\n @Override\r\n protected void doPost(HttpServletRequest request, HttpServletResponse response)\r\n throws ServletException, IOException {\r\n\r\n int id = 0;\r\n\r\n \/\/Getting all the parameters from the user\r\n int productId = Integer.parseInt(request.getParameter(\"productId\"));\r\n String price = request.getParameter(\"price\");\r\n String mrp_price = request.getParameter(\"mrp_price\");\r\n HttpSession hs = request.getSession();\r\n try {\r\n \/\/If user session is null user have to re-login\r\n if ((String) hs.getAttribute(\"name\") == null) {\r\n response.sendRedirect(\"customer-login.jsp\");\r\n \/\/Inserting cart details to the database\r\n } else {\r\n int customerId = (int) hs.getAttribute(\"id\");\r\n \/\/Querying to the database.\r\n int addToCart = DatabaseConnection.insertUpdateFromSqlQuery(\"insert into tblcart values('\" + id + \"','\" + price + \"',1,'\" + price + \"','\" + customerId + \"','\" + productId + \"','\" + mrp_price + \"')\");\r\n if (addToCart > 0) {\r\n response.sendRedirect(\"index.jsp\");\r\n }\r\n }\r\n\r\n } catch (Exception e) {\r\n e.printStackTrace();\r\n }\r\n }\r\n}\r\n<\/pre>\n11) Defining servlet for customer to update product quantity in the cart<\/h4>\n
In this section, we will take products as input from user\/customer whenever user\/customer updates the quantity of product to the cart. The quantity of product details will be updated to the cart table. (tblcart)<\/p>\n
Code:<\/strong><\/p>\nimport java.io.IOException;\r\nimport javax.servlet.ServletException;\r\nimport javax.servlet.annotation.WebServlet;\r\nimport javax.servlet.http.HttpServlet;\r\nimport javax.servlet.http.HttpServletRequest;\r\nimport javax.servlet.http.HttpServletResponse;\r\nimport javax.servlet.http.HttpSession;\r\nimport java.sql.*;\r\nimport com.connection.DatabaseConnection;\r\n\r\n@WebServlet(\"\/UpdateProductQuantity\")\r\npublic class UpdateProductQuantity extends HttpServlet {\r\n\r\n protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {\r\n \/\/Getting all the data from the user\/cutomer\r\n int quantity = Integer.parseInt(request.getParameter(\"quantity\"));\r\n int productId = Integer.parseInt(request.getParameter(\"productId\"));\r\n HttpSession session = request.getSession();\r\n String discount_price = null;\r\n Double productPrice = 0.0;\r\n try {\r\n \/\/Querying to database\r\n ResultSet rs = DatabaseConnection.getResultFromSqlQuery(\"select discount_price from tblcart where customer_id='\" + session.getAttribute(\"id\") + \"' and product_id='\" + productId + \"'\");\r\n while (rs.next()) {\r\n \/\/Getting data\r\n discount_price = rs.getString(\"discount_price\");\r\n \/\/Converting into double from string\r\n productPrice = Double.parseDouble(discount_price);\r\n }\r\n productPrice = productPrice * quantity;\r\n \/\/Update Query for updating product quantity\r\n int updateQuantity = DatabaseConnection.insertUpdateFromSqlQuery(\"update tblcart set quantity='\" + quantity + \"',total_price='\" + productPrice + \"' where customer_id='\" + session.getAttribute(\"id\") + \"' and product_id='\" + productId + \"' \");\r\n \/\/If cart of online shopping systemis sucessfully updated\r\n if (updateQuantity > 0) {\r\n \/\/Sending response back to the user\/customer.\r\n response.sendRedirect(\"checkout.jsp\");\r\n \/\/If cart is not updated\r\n } else {\r\n \/\/Sending response back to the user\/customer.\r\n response.sendRedirect(\"checkout.jsp\");\r\n }\r\n } catch (Exception e) {\r\n e.printStackTrace();\r\n }\r\n }\r\n}\r\n<\/pre>\n12) Defining servlet for admin to get current products status<\/h4>\n
In this section, admin will provide order id as input to the seller, and by using database servlet will send responses such as ordered completed, pending order, etc.<\/p>\n
Code:<\/strong><\/p>\nimport com.connection.DatabaseConnection;\r\nimport java.io.IOException;\r\nimport java.sql.ResultSet;\r\n\r\nimport javax.servlet.ServletException;\r\nimport javax.servlet.annotation.WebServlet;\r\nimport javax.servlet.http.HttpServlet;\r\nimport javax.servlet.http.HttpServletRequest;\r\nimport javax.servlet.http.HttpServletResponse;\r\n\r\n\r\n@WebServlet(\"\/CustomerProductsOrderStatus\")\r\npublic class CustomerProductsOrderStatus extends HttpServlet {\r\n\r\n protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {\r\n try {\r\n int statusMode = 0;\r\n \/\/Taking input from admin order-id to get the order status from the database of online shopping system in Java\r\n ResultSet rs = DatabaseConnection.getResultFromSqlQuery(\"select order_status from tblorders where order_no='\" + request.getParameter(\"orderId\") + \"'\");\r\n while (rs.next()) {\r\n if (rs.getString(1).equals(\"Deliver\")) {\r\n statusMode = DatabaseConnection.insertUpdateFromSqlQuery(\"update tblorders set order_status='Pending' where order_no='\" + request.getParameter(\"orderId\") + \"'\");\r\n } else {\r\n statusMode = DatabaseConnection.insertUpdateFromSqlQuery(\"update tblorders set order_status='Deliver' where order_no='\" + request.getParameter(\"orderId\") + \"'\");\r\n }\r\n }\r\n if (statusMode > 0) {\r\n \/\/Sending response back to admin-all-orders.jsp page when sql query executed successfully\r\n response.sendRedirect(\"admin-all-orders.jsp\");\r\n } else {\r\n \/\/Sending response back to admin-all-orders.jsp page\r\n response.sendRedirect(\"admin-all-orders.jsp\");\r\n }\r\n } catch (Exception e) {\r\n e.printStackTrace();\r\n }\r\n }\r\n\r\n}\r\n<\/pre>\nJava Online Shopping System Output<\/h3>\n
a) Home Screen:<\/p>\n
![\"java](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/java-online-shopping-system-output.png\")
<\/a><\/p>\nb) Admin Login:<\/p>\n
![\"admin](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/admin-login.png\")
<\/a><\/p>\nc) Admin Add Product:<\/p>\n
![\"admin](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/admin-add-products-in-online-shopping-system.png\")
<\/a><\/p>\nd) Customer New Registration (Sign-Up):<\/p>\n
![\"online](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/online-shopping-customer-registration.png\")
<\/a><\/p>\ne) Adding product to cart, you can also modify the quantity of product, can also delete the product<\/p>\n
Download Online Shopping Project Java Code<\/h3>\n
Please download the java source code of online shopping project: Online Shopping System Java Project Code<\/strong><\/a><\/p>\n These are the step to build Online Shopping System using java:<\/p>\n 1) Creating Database In this step, we basically create java online shopping system database.<\/p>\n And also we create five tables:<\/p>\n a) Admin table for storing information such as username, password, name and admin table is used for login purposes. By default, Servlet packages are installed by JAVA (J2EE).<\/p>\n But, mysql-connector library and apache-commons-fileupload we have to download from the internet and import into our project.<\/p>\n Download mysql-connector library<\/a> for online shopping system<\/p>\n Download apache-commons-fileupload library<\/a><\/p>\n How to import them?<\/strong><\/p>\n a) Click on Tools > Libraries<\/p>\n b) At bottom left Click on \u201cNew Library\u201d<\/p>\n Name your library and click on \u201cOK\u201d.<\/p>\n Now Click on Add JAR\/Folder and select the downloaded file to add in online shopping java project and click on \u201cok\u201d.<\/p>\n Now, add that library on in your project.<\/p>\n Files Description:<\/strong><\/p>\n a) Admin-add-products.jsp: It is used by admin to add new products in the database of the system. a) getParameter(\u201cname\u201d):<\/strong> This function will return the value of the name object of the input of the client. In this step, we will create a universal connection method as a reusable method for java online shopping system project project, this method will connect to MySQL database. Make sure that you enter the proper url string of database connection such as port number, username, password, etc.<\/p>\n Function definitions:<\/strong><\/p>\n a) forName(driverClassName):<\/strong> This function is used to register with the driver of the database. Code:<\/strong><\/p>\n In this step of online shopping system, we will take the values from the frontend (customer-register.jsp) values and insert into our tblcustomer table and if data entered successfully then we will send a response that you have been registered successfully and redirecting to the customer-login.jsp page.<\/p>\n Code:<\/strong><\/p>\n In this step, we will take the values from the frontend (customer-login.jsp) values and check credentials via database. If credentials are correct then user\/customer will be redirected to index.jsp page else customer-login.jsp page.<\/p>\n Code:<\/strong><\/p>\n In this step, we will take the values from the frontend (admin-login.jsp) values and check credentials via database. If credentials are correct then admin\/seller will be redirected to dashboard.jsp page else admin-login.jsp page in online shopping project.<\/p>\n Code:<\/strong><\/p>\n In this step of online shopping project, we will take all the parameters\/inputs from the frontend (admin) and all the inputs of the new product such as image, category, product name, price, etc will be saved to the database.<\/p>\n Code:<\/strong><\/p>\n In this section, we will take products (product_id) as input from the user\/customer which he\/she wants to add the product into the cart of online shopping system. The products which are added in the cart by the user, their details will be added in the table tblcart.<\/p>\n Code:<\/strong><\/p>\n In this section, we will take products as input from user\/customer whenever user\/customer updates the quantity of product to the cart. The quantity of product details will be updated to the cart table. (tblcart)<\/p>\n Code:<\/strong><\/p>\n In this section, admin will provide order id as input to the seller, and by using database servlet will send responses such as ordered completed, pending order, etc.<\/p>\n Code:<\/strong><\/p>\n a) Home Screen:<\/p>\n b) Admin Login:<\/p>\n c) Admin Add Product:<\/p>\n d) Customer New Registration (Sign-Up):<\/p>\n e) Adding product to cart, you can also modify the quantity of product, can also delete the product<\/p>\nSteps to Create Online Shopping Project in Java<\/h2>\n
\n2) Importing packages
\n3) System files structure
\n4) Functions used
\n5) Connection to database
\n6) Defining new customer registering servlet
\n7) Defining customer login servlet
\n8) Defining admin login servlet
\n9) Defining servlet for adding product in the database
\n10) Defining add to cart servlet
\n11) Defining servlet for customer to update product quantity in the cart
\n12) Defining servlet for admin to get current products status<\/p>\n1) Creating Database (MYSQL):<\/h3>\n
\nb) Cart table for storing information about the cart such as customer_id, quantity, product_id, etc.
\nc) Customer table for storing information such as username, password, name and customer table is used for login purposes.
\nd) Order table for storing information the customer has ordered the product from the website such as custiomer_id, product_id, payment_id, customer name, product name, total amount, quantity, address, etc.
\ne) Product table for storing information about the product such as product_name, id, image, price, mrp price, category, etc.<\/p>\n1) ADMIN TABLE: (tbladmin)<\/h4>\n
CREATE TABLE `tbladmin` (\r\n `id` bigint(20) NOT NULL AUTO_INCREMENT,\r\n `added_date` datetime NOT NULL,\r\n `email` varchar(100) NOT NULL,\r\n `password` varchar(100) NOT NULL,\r\n `name` varchar(100) NOT NULL,\r\n PRIMARY KEY (`id`)\r\n) ;\r\n<\/pre>\n
2) CART TABLE: (tblcart)<\/h4>\n
CREATE TABLE `tblcart` (\r\n `id` bigint(20) NOT NULL AUTO_INCREMENT,\r\n `discount_price` varchar(200) DEFAULT NULL,\r\n `quantity` int(11) NOT NULL,\r\n `total_price` varchar(200) DEFAULT NULL,\r\n `customer_id` bigint(20) NOT NULL,\r\n `product_id` bigint(20) NOT NULL,\r\n `mrp_price` varchar(200) DEFAULT NULL,\r\n PRIMARY KEY (`id`)\r\n) ;\r\n<\/pre>\n
3) CUSTOMER TABLE: (tblcustomer):<\/h4>\n
CREATE TABLE `tblcustomer` (\r\n `id` int(11) NOT NULL AUTO_INCREMENT,\r\n `address` varchar(255) NOT NULL,\r\n `added_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\r\n `email` varchar(100) NOT NULL,\r\n `gender` varchar(6) NOT NULL,\r\n `name` varchar(50) NOT NULL,\r\n `password` varchar(60) NOT NULL,\r\n `phone` varchar(200) NOT NULL,\r\n `pin_code` varchar(255) NOT NULL,\r\n PRIMARY KEY (`id`)\r\n) ;\r\n<\/pre>\n
4) ORDERS TABLE: (tblorders)<\/h4>\n
CREATE TABLE `tblorders` (\r\n `id` int(11) NOT NULL AUTO_INCREMENT,\r\n `order_no` int(11) DEFAULT NULL,\r\n `customer_name` varchar(200) DEFAULT NULL,\r\n `mobile_number` varchar(100) DEFAULT NULL,\r\n `email_id` varchar(100) DEFAULT NULL,\r\n `address` varchar(400) DEFAULT NULL,\r\n `address_type` varchar(100) DEFAULT NULL,\r\n `pincode` varchar(100) DEFAULT NULL,\r\n `image` varchar(200) DEFAULT NULL,\r\n `product_name` varchar(400) DEFAULT NULL,\r\n `quantity` int(11) DEFAULT NULL,\r\n `product_price` varchar(100) DEFAULT NULL,\r\n `product_selling_price` varchar(100) DEFAULT NULL,\r\n `product_total_price` varchar(100) DEFAULT NULL,\r\n `order_status` varchar(100) DEFAULT NULL,\r\n `order_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\r\n `payment_mode` varchar(100) DEFAULT NULL,\r\n `payment_id` int(11) DEFAULT NULL,\r\n PRIMARY KEY (`id`)\r\n) ;\r\n<\/pre>\n
5) PRODUCT TABLE: (tblproduct)<\/h4>\n
CREATE TABLE `tblproduct` (\r\n `id` bigint(20) NOT NULL AUTO_INCREMENT,\r\n `active` varchar(100) DEFAULT NULL,\r\n `code` varchar(5) DEFAULT NULL,\r\n `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n `description` varchar(255) DEFAULT NULL,\r\n `image` varchar(100) DEFAULT NULL,\r\n `image_name` varchar(400) DEFAULT NULL,\r\n `name` varchar(30) DEFAULT NULL,\r\n `price` varchar(200) DEFAULT NULL,\r\n `mrp_price` varchar(200) DEFAULT NULL,\r\n `product_category` varchar(100) DEFAULT NULL,\r\n PRIMARY KEY (`id`)\r\n) ;\r\n<\/pre>\n
6) INSERTING VALUE FOR ADMIN:<\/h4>\n
INSERT INTO tbladmin(email,password,name) VALUES('admin@gmail.com','admin','DataFlair');\r\n<\/pre>\n2) Importing packages<\/h3>\n
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n3) Project Structure:<\/h3>\n
<\/a><\/p>\n
\nb) Admin-all-orders.jsp: It is used by admin to view all orders from the database of the system.
\nc) Admin-delete-product.jsp: It is used by admin to delete any specific product from the database of the system.
\nd) Admin-delivered-products.jsp: It is used by admin to mark the products as delivered which were pending in the system.
\ne) Admin-edit-product-process.jsp: It is used by admin to update the details of specific products in the database of the system.
\nf) Admin-edit-product.jsp: It takes input from the admin to update the specific product and after that process is handled by the Admin-edit-product-process.jsp
\ng) Admin-login.jsp: It checks the authentication of the admin and redirected to the dashboard.jsp page
\nh) Admin-logout.jsp: It logouts the admin from the session and sends it back to the admin-login.jsp page.
\ni) Admin-pending-orders.jsp: It is used by admin to view all pending orders from the database of the system.
\nj) Admin-view-customers.jsp: It is used by admin to view all customers from the database of the system.
\nk) Admin-view-product.jsp: It is used by admin to view all products from the database of the system.
\nl) AdminHeader.jsp: This page contains a navigation bar for the admin\/seller dashboard in java online shopping project.
\nm) Checkout.jsp: This page is used by the customer when it checks out his\/her orders, all the order entries made in the database of the system.
\nn) Customer-login.jsp: It checks the authentication of the customer and redirected to the index.jsp page
\no) Customer-register.jsp: This page is used by the customer to register the new customer\/user.
\np) Dashboard.jsp: This page is used by the admin to display all the counts of the customers, products, orders.
\nq) Footer.jsp: This is a common page that includes footer and used by all the jsp pages in java online shopping system.
\nr) Header.jsp: This page contains a navigation bar for the customer\/user dashboard.
\ns) Index.jsp: This is a main display page that includes all products.
\nt) Logout.jsp: It logouts the user\/customer from the session and sends it back to the index.jsp page.
\nu) My-orders.jsp: This page is used by customers and it contains all the order history of the customer.
\nv) Products.jsp: This is a display page that includes all products and their descriptions.
\nw) RemoveProductFromTheCart.jsp: This is used by the customer and it removes specific products from the cart provided by the customer.<\/p>\n4) Functions Used:<\/h3>\n
\nb) getSession():<\/strong> This function will return the current session object. If the parameter is true, then it will create a new session in java online shopping project.
\nc) getAttribute(\u201cobject_name\u201d):<\/strong> This function will return the stored value of a specified object from the session.
\nd) setAttribute(“object_name”,object_value):<\/strong> This function will take the parameters as key and value and store it inside the session.
\ne)sendRedirect(\u201cname_of_the_page\u201d):<\/strong> This function will redirect the current page to the specified page. The specified page can be html or jsp format.
\nf) invalidate():<\/strong> This function will invalidate the session. It is used to clear current session values and also for logout.<\/p>\n5) Connection to Database:<\/h3>\n
\nb) getConnection(url):<\/strong> This function is used to make connections with databases. It takes parameters such as hostname, port number, database, username, password, etc. Generalized form: “jdbc:mysql:\/\/hostname:port\/dbName”, “username”, “password”. If your mysql does not have a password then enter \u201c\u201d as an empty string.
\nc) close():<\/strong> This function will close the connection of mysql database. This function is important to clean the garbage values and to make an optimized system.<\/p>\npackage com.connection;\r\n\r\nimport java.sql.Connection;\r\nimport java.sql.DriverManager;\r\nimport java.sql.ResultSet;\r\nimport java.sql.SQLException;\r\n\r\npublic class DatabaseConnection {\r\n\r\n \/\/Creating database Connection in java online shopping system\r\n public static Connection connection;\r\n\r\n \/\/Creating universal method to open connect will mysql database\r\n public static Connection getConnection() {\r\n try {\r\n \/\/Registering with mysql Driver\r\n Class.forName(\"com.mysql.jdbc.Driver\");\r\n connection = DriverManager.getConnection(\"jdbc:mysql:\/\/localhost:3306\/shoppingsystem\", \"root\", \"yourpassword\");\r\n } catch (Exception e) {\r\n e.printStackTrace();\r\n }\r\n return (connection);\r\n }\r\n\r\n \/\/Creating universal method to close connect will mysql database\r\n public static void CloseConnection() {\r\n if (connection != null) {\r\n try {\r\n connection.close();\r\n connection = null;\r\n } catch (SQLException ex) {\r\n ex.printStackTrace();\r\n }\r\n }\r\n }\r\n\r\n \/\/Creating universal method to query for retrieving information\r\n public static ResultSet getResultFromSqlQuery(String SqlQueryString) {\r\n \/\/Creating Resultset object\r\n ResultSet rs = null;\r\n try {\r\n \/\/Checking whether the connection is null or null\r\n if (connection == null) {\r\n getConnection();\r\n }\r\n \/\/Querying the query\r\n rs = connection.createStatement().executeQuery(SqlQueryString);\r\n } catch (Exception ex) {\r\n ex.printStackTrace();\r\n }\r\n return rs;\r\n }\r\n\r\n \/\/Creating universal method to query for inserting or updating information in mysql database\r\n public static int insertUpdateFromSqlQuery(String SqlQueryString) {\r\n int i = 2;\r\n try {\r\n \/\/Checking whether the connection is null or null\r\n if (connection == null) {\r\n getConnection();\r\n }\r\n \/\/Querying the query\r\n i = connection.createStatement().executeUpdate(SqlQueryString);\r\n\r\n } catch (Exception ex) {\r\n ex.printStackTrace();\r\n }\r\n return i;\r\n }\r\n}\r\n<\/pre>\n6) Defining new customer registering servlet<\/h3>\n
import java.io.IOException;\r\n\r\nimport javax.servlet.ServletException;\r\nimport javax.servlet.annotation.WebServlet;\r\nimport javax.servlet.http.HttpServlet;\r\nimport javax.servlet.http.HttpServletRequest;\r\nimport javax.servlet.http.HttpServletResponse;\r\nimport javax.servlet.http.HttpSession;\r\n\r\nimport com.connection.DatabaseConnection;\r\n\r\n@WebServlet(\"\/AddCustomer\")\r\npublic class AddCustomer extends HttpServlet {\r\n\r\n protected void doPost(HttpServletRequest request, HttpServletResponse response)\r\n throws ServletException, IOException {\r\n\r\n \/\/Retrieving values from the frontend\r\n String name = request.getParameter(\"name\");\r\n String email = request.getParameter(\"email\");\r\n String password = request.getParameter(\"password\");\r\n String mobile = request.getParameter(\"mobile\");\r\n String gender = request.getParameter(\"gender\");\r\n String address = request.getParameter(\"address\");\r\n String pincode = request.getParameter(\"pincode\");\r\n \r\n \/\/Creating Session\r\n HttpSession hs = request.getSession();\r\n \r\n \/\/Inserting all values inside the database\r\n try {\r\n \/\/Connecting database connection and querying in the database\r\n int addCustomer = DatabaseConnection.insertUpdateFromSqlQuery(\"insert into tblcustomer(address,email,gender,name,password,phone,pin_code)values('\" + address + \"','\" + email + \"','\" + gender + \"','\" + name + \"','\" + password + \"','\"\r\n + mobile + \"','\" + pincode + \"')\");\r\n \r\n \/\/If customer registered successfully in java online shopping system\r\n if (addCustomer > 0) {\r\n String message = \"Customer register successfully.\";\r\n \/\/Passing message via session.\r\n hs.setAttribute(\"success-message\", message);\r\n \/\/Sending response back to the user\/customer\r\n response.sendRedirect(\"customer-register.jsp\");\r\n } else {\r\n \/\/If customer fails to register \r\n String message = \"Customer registration fail\";\r\n \/\/Passing message via session.\r\n hs.setAttribute(\"fail-message\", message);\r\n \/\/Sending response back to the user\/customer\r\n response.sendRedirect(\"customer-register.jsp\");\r\n }\r\n } catch (Exception ex) {\r\n ex.printStackTrace();\r\n }\r\n }\r\n}\r\n<\/pre>\n7) Defining customer login servlet:<\/h3>\n
import java.io.IOException;\r\nimport java.sql.ResultSet;\r\nimport javax.servlet.ServletException;\r\nimport javax.servlet.annotation.WebServlet;\r\nimport javax.servlet.http.HttpServlet;\r\nimport javax.servlet.http.HttpServletRequest;\r\nimport javax.servlet.http.HttpServletResponse;\r\nimport javax.servlet.http.HttpSession;\r\n\r\nimport com.connection.DatabaseConnection;\r\n\r\n@WebServlet(\"\/CustomerLogin\")\r\npublic class CustomerLogin extends HttpServlet {\r\n\r\n protected void doPost(HttpServletRequest request, HttpServletResponse response)\r\n throws ServletException, IOException {\r\n\r\n \/\/Getting all data from user\/customer\r\n String email = request.getParameter(\"email\");\r\n String password = request.getParameter(\"password\");\r\n \/\/Creating Session\r\n HttpSession hs = request.getSession();\r\n try {\r\n \/\/Creating Resultset\r\n ResultSet resultset = null;\r\n \/\/Query to check Login Details\r\n resultset = DatabaseConnection.getResultFromSqlQuery(\"select * from tblcustomer where email='\" + email + \"' and password='\" + password + \"'\");\r\n \/\/Checking whether the details of user are null or not\r\n if (email != null && password != null) {\r\n if (resultset.next()) {\r\n \/\/Storing the login details in session\r\n hs.setAttribute(\"id\", resultset.getInt(\"id\"));\r\n hs.setAttribute(\"name\", resultset.getString(\"name\"));\r\n \/\/Redirecting response to the index.jsp\r\n response.sendRedirect(\"index.jsp\");\r\n } else {\r\n \/\/If wrong credentials are entered in java online shopping system\r\n String message = \"You have enter wrong credentials\";\r\n hs.setAttribute(\"credential\", message);\r\n \/\/Redirecting response to the customer-login.jsp\r\n response.sendRedirect(\"customer-login.jsp\");\r\n }\r\n } else {\r\n \/\/If username or password is empty or null\r\n String message = \"User name or Password is null\";\r\n hs.setAttribute(\"credential\", message);\r\n \/\/Redirecting response to the customer-login.jsp\r\n response.sendRedirect(\"customer-login.jsp\");\r\n }\r\n\r\n } catch (Exception e) {\r\n e.printStackTrace();\r\n }\r\n }\r\n}\r\n<\/pre>\n8) Defining admin login servlet<\/h4>\n
import java.io.IOException;\r\nimport java.sql.Connection;\r\nimport java.sql.ResultSet;\r\nimport java.sql.Statement;\r\n\r\nimport javax.servlet.ServletException;\r\nimport javax.servlet.annotation.WebServlet;\r\nimport javax.servlet.http.HttpServlet;\r\nimport javax.servlet.http.HttpServletRequest;\r\nimport javax.servlet.http.HttpServletResponse;\r\nimport javax.servlet.http.HttpSession;\r\n\r\nimport com.connection.DatabaseConnection;\r\n\r\n@WebServlet(\"\/AdminLogin\")\r\npublic class AdminLogin extends HttpServlet {\r\n\r\n protected void doPost(HttpServletRequest request, HttpServletResponse response)\r\n throws ServletException, IOException {\r\n try {\r\n \/\/Getting all the parameters from the frontend (admin)\r\n String email = request.getParameter(\"email\");\r\n String pass = request.getParameter(\"upass\");\r\n\r\n \/\/Retriving our session\r\n HttpSession hs = request.getSession();\r\n\r\n \/\/Calling Connection method\r\n Connection con = DatabaseConnection.getConnection();\r\n\r\n \/\/Creating Statement\r\n Statement st = con.createStatement();\r\n\r\n \/\/Querying inside the database\r\n ResultSet resultset = st.executeQuery(\"select * from tbladmin where email='\" + email + \"' AND password='\" + pass + \"'\");\r\n \/\/If all the details are correct\r\n if (resultset.next()) {\r\n hs.setAttribute(\"uname\", resultset.getString(\"name\"));\r\n \/\/Redirecting admin to dashboard page\r\n response.sendRedirect(\"dashboard.jsp\");\r\n\r\n } else {\r\n \/\/If details are wrong\r\n String message = \"You have enter wrong credentials\";\r\n hs.setAttribute(\"credential\", message);\r\n \/\/Redirecting admin to admin login page\r\n response.sendRedirect(\"admin-login.jsp\");\r\n }\r\n } catch (Exception e) {\r\n System.out.println(e);\r\n }\r\n }\r\n}\r\n<\/pre>\n9) Defining servlet for adding product in the database<\/h3>\n
import java.io.File;\r\nimport java.io.IOException;\r\nimport java.util.List;\r\nimport java.util.Random;\r\n\r\nimport javax.servlet.ServletException;\r\nimport javax.servlet.annotation.WebServlet;\r\nimport javax.servlet.http.HttpServlet;\r\nimport javax.servlet.http.HttpServletRequest;\r\nimport javax.servlet.http.HttpServletResponse;\r\nimport javax.servlet.http.HttpSession;\r\n\r\nimport org.apache.commons.fileupload.FileItem;\r\nimport org.apache.commons.fileupload.disk.DiskFileItemFactory;\r\nimport org.apache.commons.fileupload.servlet.ServletFileUpload;\r\n\r\nimport com.connection.DatabaseConnection;\r\n\r\n@WebServlet(\"\/AddProducts\")\r\npublic class AddProducts extends HttpServlet {\r\n\r\n \/\/Path where all the images are stored\r\n private final String UPLOAD_DIRECTORY = \"ENTER_YOUR_DIRECTORY_PATH\";\r\n\r\n @Override\r\n protected void doPost(HttpServletRequest request, HttpServletResponse response)\r\n throws ServletException, IOException {\r\n\r\n \/\/Creating session in java online shopping project\r\n HttpSession session = request.getSession();\r\n if (ServletFileUpload.isMultipartContent(request)) {\r\n try {\r\n \/\/Taking all image requests\r\n List<FileItem> multiparts = new ServletFileUpload(new DiskFileItemFactory()).parseRequest(request);\r\n String imageName = null;\r\n String productName = null;\r\n String productQuantity = null;\r\n String productPrice = null;\r\n String descrip = null;\r\n String mrpPrice = null;\r\n String status = null;\r\n String category = null;\r\n\r\n \/\/SALTCHARS to generate unique code for product\r\n String SALTCHARS = \"ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890\";\r\n StringBuilder salt = new StringBuilder();\r\n Random rnd = new Random();\r\n while (salt.length() < 3) { \/\/ length of the random string.\r\n int index = (int) (rnd.nextFloat() * SALTCHARS.length());\r\n salt.append(SALTCHARS.charAt(index));\r\n }\r\n String code = salt.toString();\r\n\r\n for (FileItem item : multiparts) {\r\n if (!item.isFormField()) {\r\n \/\/Getting image name\r\n imageName = new File(item.getName()).getName();\r\n \/\/Storing in the specified directory\r\n item.write(new File(UPLOAD_DIRECTORY + File.separator + imageName));\r\n\r\n \/\/Retrieving all information from frontend of online shopping system\r\n FileItem pName = (FileItem) multiparts.get(0);\r\n productName = pName.getString();\r\n\r\n FileItem price = (FileItem) multiparts.get(1);\r\n productPrice = price.getString();\r\n\r\n FileItem description = (FileItem) multiparts.get(2);\r\n descrip = description.getString();\r\n\r\n FileItem mprice = (FileItem) multiparts.get(3);\r\n mrpPrice = mprice.getString();\r\n\r\n FileItem fstatus = (FileItem) multiparts.get(4);\r\n status = fstatus.getString();\r\n\r\n FileItem pcategory = (FileItem) multiparts.get(5);\r\n category = pcategory.getString();\r\n\r\n }\r\n }\r\n try {\r\n int id = 0;\r\n String imagePath = UPLOAD_DIRECTORY + imageName;\r\n \/\/Querying to insert product in the table\r\n int i = DatabaseConnection.insertUpdateFromSqlQuery(\"insert into tblproduct(id,active,code,description,image,image_name,name,price,mrp_price,product_category) values('\" + id + \"','\" + status + \"','\" + code + \"','\" + descrip + \"','\" + imagePath + \"','\" + imageName + \"','\" + productName + \"','\" + productPrice + \"','\" + mrpPrice + \"','\" + category + \"')\");\r\n \/\/If product inserted successfully in the database\r\n if (i > 0) {\r\n String success = \"Product added successfully.\";\r\n \/\/Adding method in session.\r\n session.setAttribute(\"message\", success);\r\n \/\/Response send to the admin-add-product.jsp\r\n response.sendRedirect(\"admin-add-product.jsp\");\r\n }\r\n } catch (Exception e) {\r\n e.printStackTrace();\r\n }\r\n } catch (Exception ex) {\r\n \/\/If any error occurred while uploading product image\r\n request.setAttribute(\"message\", \"File Upload Failed due to \" + ex);\r\n }\r\n } else {\r\n request.setAttribute(\"message\", \"Sorry this Servlet only handles file upload request\");\r\n }\r\n }\r\n}\r\n<\/pre>\n10) Defining add to cart servlet<\/h3>\n
import java.io.IOException;\r\nimport javax.servlet.ServletException;\r\nimport javax.servlet.annotation.WebServlet;\r\nimport javax.servlet.http.HttpServlet;\r\nimport javax.servlet.http.HttpServletRequest;\r\nimport javax.servlet.http.HttpServletResponse;\r\nimport javax.servlet.http.HttpSession;\r\n\r\nimport com.connection.DatabaseConnection;\r\n\r\n@WebServlet(\"\/AddToCart\")\r\npublic class AddToCart extends HttpServlet {\r\n\r\n @Override\r\n protected void doPost(HttpServletRequest request, HttpServletResponse response)\r\n throws ServletException, IOException {\r\n\r\n int id = 0;\r\n\r\n \/\/Getting all the parameters from the user\r\n int productId = Integer.parseInt(request.getParameter(\"productId\"));\r\n String price = request.getParameter(\"price\");\r\n String mrp_price = request.getParameter(\"mrp_price\");\r\n HttpSession hs = request.getSession();\r\n try {\r\n \/\/If user session is null user have to re-login\r\n if ((String) hs.getAttribute(\"name\") == null) {\r\n response.sendRedirect(\"customer-login.jsp\");\r\n \/\/Inserting cart details to the database\r\n } else {\r\n int customerId = (int) hs.getAttribute(\"id\");\r\n \/\/Querying to the database.\r\n int addToCart = DatabaseConnection.insertUpdateFromSqlQuery(\"insert into tblcart values('\" + id + \"','\" + price + \"',1,'\" + price + \"','\" + customerId + \"','\" + productId + \"','\" + mrp_price + \"')\");\r\n if (addToCart > 0) {\r\n response.sendRedirect(\"index.jsp\");\r\n }\r\n }\r\n\r\n } catch (Exception e) {\r\n e.printStackTrace();\r\n }\r\n }\r\n}\r\n<\/pre>\n11) Defining servlet for customer to update product quantity in the cart<\/h4>\n
import java.io.IOException;\r\nimport javax.servlet.ServletException;\r\nimport javax.servlet.annotation.WebServlet;\r\nimport javax.servlet.http.HttpServlet;\r\nimport javax.servlet.http.HttpServletRequest;\r\nimport javax.servlet.http.HttpServletResponse;\r\nimport javax.servlet.http.HttpSession;\r\nimport java.sql.*;\r\nimport com.connection.DatabaseConnection;\r\n\r\n@WebServlet(\"\/UpdateProductQuantity\")\r\npublic class UpdateProductQuantity extends HttpServlet {\r\n\r\n protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {\r\n \/\/Getting all the data from the user\/cutomer\r\n int quantity = Integer.parseInt(request.getParameter(\"quantity\"));\r\n int productId = Integer.parseInt(request.getParameter(\"productId\"));\r\n HttpSession session = request.getSession();\r\n String discount_price = null;\r\n Double productPrice = 0.0;\r\n try {\r\n \/\/Querying to database\r\n ResultSet rs = DatabaseConnection.getResultFromSqlQuery(\"select discount_price from tblcart where customer_id='\" + session.getAttribute(\"id\") + \"' and product_id='\" + productId + \"'\");\r\n while (rs.next()) {\r\n \/\/Getting data\r\n discount_price = rs.getString(\"discount_price\");\r\n \/\/Converting into double from string\r\n productPrice = Double.parseDouble(discount_price);\r\n }\r\n productPrice = productPrice * quantity;\r\n \/\/Update Query for updating product quantity\r\n int updateQuantity = DatabaseConnection.insertUpdateFromSqlQuery(\"update tblcart set quantity='\" + quantity + \"',total_price='\" + productPrice + \"' where customer_id='\" + session.getAttribute(\"id\") + \"' and product_id='\" + productId + \"' \");\r\n \/\/If cart of online shopping systemis sucessfully updated\r\n if (updateQuantity > 0) {\r\n \/\/Sending response back to the user\/customer.\r\n response.sendRedirect(\"checkout.jsp\");\r\n \/\/If cart is not updated\r\n } else {\r\n \/\/Sending response back to the user\/customer.\r\n response.sendRedirect(\"checkout.jsp\");\r\n }\r\n } catch (Exception e) {\r\n e.printStackTrace();\r\n }\r\n }\r\n}\r\n<\/pre>\n12) Defining servlet for admin to get current products status<\/h4>\n
import com.connection.DatabaseConnection;\r\nimport java.io.IOException;\r\nimport java.sql.ResultSet;\r\n\r\nimport javax.servlet.ServletException;\r\nimport javax.servlet.annotation.WebServlet;\r\nimport javax.servlet.http.HttpServlet;\r\nimport javax.servlet.http.HttpServletRequest;\r\nimport javax.servlet.http.HttpServletResponse;\r\n\r\n\r\n@WebServlet(\"\/CustomerProductsOrderStatus\")\r\npublic class CustomerProductsOrderStatus extends HttpServlet {\r\n\r\n protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {\r\n try {\r\n int statusMode = 0;\r\n \/\/Taking input from admin order-id to get the order status from the database of online shopping system in Java\r\n ResultSet rs = DatabaseConnection.getResultFromSqlQuery(\"select order_status from tblorders where order_no='\" + request.getParameter(\"orderId\") + \"'\");\r\n while (rs.next()) {\r\n if (rs.getString(1).equals(\"Deliver\")) {\r\n statusMode = DatabaseConnection.insertUpdateFromSqlQuery(\"update tblorders set order_status='Pending' where order_no='\" + request.getParameter(\"orderId\") + \"'\");\r\n } else {\r\n statusMode = DatabaseConnection.insertUpdateFromSqlQuery(\"update tblorders set order_status='Deliver' where order_no='\" + request.getParameter(\"orderId\") + \"'\");\r\n }\r\n }\r\n if (statusMode > 0) {\r\n \/\/Sending response back to admin-all-orders.jsp page when sql query executed successfully\r\n response.sendRedirect(\"admin-all-orders.jsp\");\r\n } else {\r\n \/\/Sending response back to admin-all-orders.jsp page\r\n response.sendRedirect(\"admin-all-orders.jsp\");\r\n }\r\n } catch (Exception e) {\r\n e.printStackTrace();\r\n }\r\n }\r\n\r\n}\r\n<\/pre>\nJava Online Shopping System Output<\/h3>\n
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n
![\"cart\"](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/cart.png\")
<\/a><\/p>\n![\"view](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/view-orders.png\")
<\/a><\/p>\n