Loading repository data…
Loading repository data…
Mscitsid / repository
Create a dynamic and responsive Java e-healthcare web application for ordering medicines of different categories. Background of the problem statement: Medicare is a company that supplies medicines and a couple of other healthcare essentials at an affordable price. It was established in 2012 in Delhi, India. It had been serving fine all these years, however, the business analysts noticed a decline in sales since 2017. They found out that online ordering of medicines with companies, such as 100mg and mfine are gaining more profits by eliminating middlemen from the equation. As a result, the team decided to hire a Full Stack developer to develop a healthcare web application with a rich and user-friendly interface. You are hired as the Full Stack Java developer and are asked to develop the web application. The management team has provided you with the requirements and their business model so that you can easily arrange different components of the application. Features of the application: Registration Login Payment gateway Searching Filtering Sorting Dynamic data Responsive and compatible with different devices Recommended technologies: Database management: MySQL and Oracle Backend logic: Java programming, NodeJS Frontend development: JSP, Angular, Bootstrap, HTML/CSS, and Javascript Automation and testing technologies: Selenium, Jasmine (frontend testing), and TestNG DevOps and production technologies: Git, GitHub, Jenkins, Docker, Kubernetes, and AWS Project development guidelines: The project will be delivered within four sprints with every sprint delivering a minimal viable product. It is mandatory to perform proper sprint planning with user stories to develop all the components of the project. The learner can use any technology from the above-mentioned technologies for different layers of the project. The web application should be responsive and should fetch or send data dynamically without hardcoded values. The learner must maintain the version of the application over GitHub and every new change should be sent to the repository. The learner must implement a CI/CD pipeline using Jenkins. The learner should also deploy and host the application on an AWS EC2 instance. The learner should also implement automation testing before the application enters the CI/CD pipeline. The learner should use Git branching to do basic automation testing of the application in it separately. The learner should make a rich frontend of the application, which is user-friendly and easy for the user to navigate through the application. There will be two portals in the application, namely admin and user portal. Admin Portal: The admin portal deals with all the backend data generation and product information. The admin user should be able to: Add or remove medicine details from the application to build a rich product line Edit medicine details like name, price, seller, product description, and offers to keep the product information updated with the current prices Enable or disable a medicine product User Portal: It deals with the user activities. The end-user should be able to: Sign-in to the application to maintain a record of activities Search for products based on the search keyword Apply filters and sort results based on different cuisines to get the best deals Add all the selected food items to the cart and customize the purchase at the end Perform a seamless payment gateway Get an order summary details page once the payment is complete
Simplilearn final Project - Medicare
Capstone Project Medicare
Developer Details: Name: Siddhant Mhatre Email: mhatre.sid28@gmail.com Program Name: Medicare GitHub Repository: https://github.com/Mscitsid/Medicare..git
Program Background : Medicare is a company that supplies medicines and a couple of other healthcare essentials at an affordable price. It was established in 2012 in Delhi, India. It had been serving fine all these years, however, the business analysts noticed a decline in sales since 2017. They found out that online ordering of medicines with companies, such as 100mg and mfine are gaining more profits by eliminating middlemen from the equation. As a result, the team decided to hire a Full Stack developer to develop a healthcare web application with a rich and user-friendly interface. You are hired as the Full Stack Java developer and are asked to develop the web application. The management team has provided you with the requirements and their business model so that you can easily arrange different components of the application. Program Features: ● Presenting the specification document which has the product’s capabilities, appearance, and user interactions ● Setting up Git and GitHub account to store and track your enhancements of the prototype ● Explaining the Java concepts used in the project ● Discussing the generic features of the product: ● There will be an admin to manage the website. An administrator login will be required to access the admin page.
The admin will be able to change his password if he wants, he should be able to: ● Manage the products in the store including categorizing them ● Browse the list of users who have signed up and be able to search users ● See purchase reports filtered by date and category
Tools used for development:
Sprint Table:
SPRINT WORK DONE TIME PERIOD RESULT 1 Created Databases in MySQL 20/05/2022 to 21/05/2022 Done ✓ 2 Designed HTML pages 21/05/2022 to 22/05/2022 Done ✓ 3 Server-side coding 22/05/2022 to 23/05/22 Done ✓ 4 Testing 23/05/22 to 24/05/22 Done ✓
Source codes 1.signup
<h1>Some thing Went Wrong! Try Again !</h1>
<%
}
%>
<h2>Medicare</h2>
2.Login
<%
String msg = request.getParameter("msg");
if ("notexist".equals(msg)) {
%>
<h1>Incorrect Username or Password</h1>
<%
}
if ("invalid".equals(msg)) {
%>
<h1>Some thing Went Wrong! Try Again !</h1>
<%
}
%>
<h2>Medicare</h2>
3.Signup action
<%@page import="com.project.ConnectionProvider"%> <%@ page import="java.sql.*"%>
<% String name = request.getParameter("name"); String email = request.getParameter("email"); String mobilenumber = request.getParameter("phonenumber"); String securityQuestion = request.getParameter("securityQuestion"); String answer = request.getParameter("answer"); String password = request.getParameter("password"); String address = ""; String city = ""; String state = ""; String country = "";
try { Connection con = ConnectionProvider.getCon(); PreparedStatement st = con.prepareStatement("insert into users values(?,?,?,?,?,?,?,?,?,?)"); st.setString(1, name); st.setString(2, email); st.setString(3, mobilenumber); st.setString(4, securityQuestion); st.setString(5, answer); st.setString(6, password); st.setString(7, address); st.setString(8, city); st.setString(9, state); st.setString(10, country); st.executeUpdate(); response.sendRedirect("signup.jsp?msg=valid"); } catch (Exception e) { response.sendRedirect("signup.jsp?msg=invalid"); System.out.println(e); } %>
4.Login action
<%@page import="com.project.ConnectionProvider"%> <%@ page import="java.sql.*"%>
<% String email = request.getParameter("email"); String password = request.getParameter("password");
if ("admin@gmail.com".equals(email) && "admin".equals(password)) { session.setAttribute("email", email); response.sendRedirect("admin/adminHome.jsp"); } else { int z = 0; try { Connection con = ConnectionProvider.getCon(); Statement st = con.createStatement(); ResultSet rs = st .executeQuery("select * from users where email='" + email + "' and password='" + password + "'"); while (rs.next()) { z = 1; session.setAttribute("email", email); response.sendRedirect("home.jsp"); } if (z == 0) { response.sendRedirect("login.jsp?msg=notexist"); } } catch (Exception e) { System.out.println(e); response.sendRedirect("login.jsp?msg=invalid"); } } %> 5.Home
<%@page import="com.project.ConnectionProvider"%> <%@ page import="java.sql.*"%> <%@include file="header.jsp" %> <%@include file="footer.jsp" %>
<% if("exist".equals(msg)) { %>
<% if("invalid".equals(msg)) { %>
6.Search Home
<%@page import="com.project.ConnectionProvider"%> <%@ page import="java.sql.*"%> <%@include file="header.jsp" %> <%@include file="footer.jsp" %>
7.Mycart
<%@page import="com.project.ConnectionProvider"%> <%@ page import="java.sql.*"%> <%@include file="header.jsp" %> <%@include file="footer.jsp" %>
<% if("inc".equals(msg)){ %>
<% if("dec".equals(msg)){ %>
<% if("rem".equals(msg)){ %>