Hi guys! I need some help with this Web Design mini project. Any help will be appreciated a rated. Thanks in advance!
Here is the project: (It must be implemented using JSP and MySQL) not PHP
Homework Answers
instruction :
1) your database name is dbname .
2)User is rootand password is dbpass change through the page if you want to.
3) your table name is members.
4) name of the files are written above it, it has to be the same name as mentioned.
5) there are a total of 11 files including sql file.
6) screenshots included.
sql code
CREATE TABLE `members` (
`id` int(10) unsigned NOT NULL auto_increment,
`first_name` varchar(45) NOT NULL,
`last_name` varchar(45) NOT NULL,
`email` varchar(45) NOT NULL,
`uname` varchar(45) NOT NULL,
`dob` varchar(45) NOT NULL,
`gender` varchar(45) NOT NULL,
`address` varchar(100) NOT NULL,
`pass` varchar(45) NOT NULL,
PRIMARY KEY (`id`)
index.jsp
<%@page contentType="text/html"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta
http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<title>LOGIN</title>
</head>
<body>
<form
method="post" action="login.jsp">
<legend> Login to App </legend>
<center>
<table
border="1" width="30%" cellpadding="3">
<thead>
<tr>
<th
colspan="2">Login Here</th>
</tr>
</thead>
<tbody>
<tr>
<td>User
Name</td>
<td><input
type="text" name="uname" value="" /></td>
</tr>
<tr>
<td>Password</td>
<td><input
type="password" name="pass" value="" /></td>
</tr>
<tr>
<td><input
type="submit" value="Login" /></td>
<td><input
type="reset" value="Reset" /></td>
</tr>
<tr>
<td
colspan="2">Yet Not Registered!! <a
href="reg.jsp">Register Here</a></td>
</tr>
</tbody>
</table>
</center>
</form>
</body>
</html>) ENGINE=InnoDB DEFAULT CHARSET=latin1;
reg.jsp
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Registration</title>
</head>
<body>
<form method="post" action="registration.jsp">
<center>
<table border="1" width="30%" cellpadding="5">
<thead>
<tr>
<th colspan="2">Enter Information Here</th>
</tr>
</thead>
<tbody>
<tr>
<td>First Name</td>
<td><input type="text" name="fname" value="" /></td>
</tr>
<tr>
<td>Last Name</td>
<td><input type="text" name="lname" value="" /></td>
</tr>
<tr>
<td>Email</td>
<td><input type="text" name="email" value="" /></td>
</tr>
<tr>
<td>User Name</td>
<td><input type="text" name="uname" value="" /></td>
</tr>
<tr>
<td>Date of Birth</td>
<td><input type="text" name="dob" value="" /></td>
</tr>
<tr>
<td>Gender</td>
<td><input type="text" name="gender" value="" /></td>
</tr>
<tr>
<td>Address</td>
<td><input type="text" name="address" value="" /></td>
</tr>
<tr>
<td>Password</td>
<td><input type="password" name="pass" value="" /></td>
</tr>
<tr>
<td><input type="submit" value="Submit" /></td>
<td><input type="reset" value="Reset" /></td>
</tr>
<tr>
<td colspan="2">Already registered!! <a href="index.jsp">Login Here</a></td>
</tr>
</tbody>
</table>
</center>
</form>
</body>
</html>
registration.jsp
<%@ page import ="java.sql.*" %>
<%
String user = request.getParameter("uname");
String pwd = request.getParameter("pass");
String fname = request.getParameter("fname");
String lname = request.getParameter("lname");
String email = request.getParameter("email");
String dob = request.getParameter("dob");
String gender = request.getParameter("gender");
String address = request.getParameter("address");
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/dbname",
"root", "dbpass");
Statement st = con.createStatement();
int i = st.executeUpdate("insert into members(first_name, last_name, email, uname, dob, gender, address, pass) values ('" + fname + "','" + lname + "','" + email + "','" + user + "'','" + dob + "'','" + gender + "'','" + address + "','" + pwd + "', CURDATE())");
if (i > 0) {
//session.setAttribute("userid", user);
response.sendRedirect("welcome.jsp");
// out.print("Registration Successfull!"+"<a href='index.jsp'>Go to Login</a>");
} else {
response.sendRedirect("index.jsp");
}
%>
welcome.jsp
Registration is Successful.
Please Login Here <a href='welcome.jsp'>Go to Login</a>
login.jsp
<%@ page import ="java.sql.*" %>
<%
String userid = request.getParameter("uname");
String pwd = request.getParameter("pass");
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/dbname",
"root", "dbpass");
Statement st = con.createStatement();
ResultSet rs;
rs = st.executeQuery("select * from members where uname='" + userid + "' and pass='" + pwd + "'");
if (rs.next()) {
session.setAttribute("userid", userid);
//out.println("welcome " + userid);
//out.println("<a href='logout.jsp'>Log out</a>");
response.sendRedirect("success.jsp");
} else {
out.println("Invalid password <a href='index.jsp'>try again</a>");
}
%>
<%
if (((String)session.getAttribute("userid")).equals("admin") && (session.getAttribute("userid")!=null)) {
%>
<a href="adminpage.jsp">click here admin</a>;
<%
}
%>
success.jsp
<%
if ((session.getAttribute("userid") == null) || (session.getAttribute("userid") == "")) {
%>
You are not logged in<br/>
<a href="index.jsp">Please Login</a>
<%} else {
%>
Welcome <%=session.getAttribute("userid")%>
<a href='logout.jsp'>Log out</a>
<%
}
%>
<%@page contentType="text/html"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta
http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<title>USER</title>
</head>
<body>
<form
method="post" action="remove.jsp">
<center>
<table
border="1" width="30%" cellpadding="3">
<tbody>
<tr>
<td>Enter
email to search</td>
<td><input
type="text" name="email" value="" /></td>
</tr>
<tr>
<td><input
type="submit" value="Login" /></td>
</tr>
</tbody>
</table>
</center>
</form>
</body>
</html>
<%
String value=request.getParameter("student_id");;
int v=Integer.parseInt(email);
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/dbname","root", "dbpass");
Statement st=conn.createStatement();
ResultSet rs = st.executeQuery("select * from members where email='"+v+"'");
if(rs.next()){
%>
<tr><td>Name: </td><td><input type="text" value="<%=rs.getString("first_name")%>"/> </td></tr>
<tr><td>Name: </td><td><input type="text" value="<%=rs.getString("last_name")%>"/> </td></tr>
<tr><td>Name: </td><td><input type="text" value="<%=rs.getString("uname")%>"/> </td></tr>
<tr><td>Name: </td><td><input type="text" value="<%=rs.getString("dob")%>"/> </td></tr>
<tr><td>Name: </td><td><input type="text" value="<%=rs.getString("gender")%>"/> </td></tr>
<tr><td>Name: </td><td><input type="text" value="<%=rs.getString("address")%>"/> </td></tr>
<%
}
%>
logout.jsp
<%
session.setAttribute("userid", null);
session.invalidate();
response.sendRedirect("index.jsp");
%>
adminpage.jsp
<%
if ((session.getAttribute("userid") == null) || (session.getAttribute("userid") == "")) {
%>
You are not logged in<br/>
<a href="index.jsp">Please Login</a>
<%} else {
%>
Welcome <%=session.getAttribute("userid")%>
<a href='logout.jsp'>Log out</a>
<%
}
%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Admin</title>
</head>
<body>
<a href="reg_admin.jsp">Add user</a>
<a href="remove.jsp">Remove user</a>
</body>
</html>
reg_admin.jsp
<%@page contentType="text/html"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta
http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<title>Admin
Registration</title>
</head>
<body>
<form
method="post" action="registration.jsp">
<center>
<table
border="1" width="30%" cellpadding="5">
<thead>
<tr>
<th
colspan="2">Enter Information Here</th>
</tr>
</thead>
<tbody>
<tr>
<td>First
Name</td>
<td><input
type="text" name="fname" value="" /></td>
</tr>
<tr>
<td>Last
Name</td>
<td><input
type="text" name="lname" value="" /></td>
</tr>
<tr>
<td>Email</td>
<td><input
type="text" name="email" value="" /></td>
</tr>
<tr>
<td>User
Name</td>
<td><input
type="text" name="uname" value="" /></td>
</tr>
<tr>
<td>Password</td>
<td><input
type="password" name="pass" value="" /></td>
</tr>
<tr>
<td><input
type="submit" value="Submit" /></td>
<td><input
type="reset" value="Reset" /></td>
</tr>
</tbody>
</table>
</center>
</form>
</body>
</html>
remove.jsp
<%@page contentType="text/html"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta
http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<title>JSP
Example</title>
</head>
<body>
<form
method="post" action="remove.jsp">
<center>
<table
border="1" width="30%" cellpadding="3">
<thead>
<tr>
<th
colspan="2">Login Here</th>
</tr>
</thead>
<tbody>
<tr>
<td>Enter
User Name to remove</td>
<td><input
type="text" name="rname" value="" /></td>
</tr>
<tr>
<td><input
type="submit" value="Login" /></td>
</tr>
</tbody>
</table>
</center>
</form>
</body>
</html>
<%@ page import ="java.sql.*" %>
<%
String ruserid = request.getParameter("rname");
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/dbname",
"root", "dbpass");
Statement st=conn.createStatement();
int i=st.executeUpdate("DELETE FROM members WHERE
uname="+ruserid);
out.println("Data Deleted Successfully!");
%>
Screenshots
Add Answer to:
Hi guys! I need some help with this Web Design mini project. Any help will be appreciated a rated...
1. Consider the design of a database for a web site of jokes. Each joke is...
1. Consider the design of a database for a web site of jokes. Each joke is identified by a unique joke ID, a title, a description of the joke, the date the joke is posted, and a list of tags (each tag is a single word in lower cases). Only registered users can post, read, comment on jokes. Each registered user is identified by a user ID, a password, a first name, a last name, an email, the gender, and...
I need help with a starting point for my final project. Please help and thank you...
I need help with a starting point for my final project. Please help and thank you in advance. Overview: Basic knowledge of computers is practically essential for productively engaging in twenty-first-century life. Working knowledge of computer platform technologies impacts everyone from help-desk personnel and field technicians to project managers and business executives. In order to make sound business decisions, one must have the ability to analyze business needs and compare available computer technology options for effectively meeting those needs. Scenario:...
please help!! hoose a Tool to Design Your Wireframes You may use any tool available to...
please help!! hoose a Tool to Design Your Wireframes You may use any tool available to you that will allow you to create simple skeletal sketches of each screen or page, and to label the location of the key elements described in Part B of the assignment. You should save the sketches in one of the following formats: docx, .pptx, .sketch, .psd, .pdf, .png, .jpg, .gif, .png, or .rtf. Possible tools include Paint, PowerPoint, Word, Adobe Illustrator, Visual Studio, Visio,...
Please need serious and professional help! Hello! I am working on an "object oriented analysis and...
Please need serious and professional help!
Hello! I am working on an "object oriented analysis and design"
Project. I would really need your sincere help in creating a vision
document for this project.
The Things That I require in the "vision document"
is:
1. Product Overview
[This section provides a high level view of the product
capabilities, interfaces to other applications, and system
configurations. This section usually consists of three subsections,
as follows:
• Product
perspective
• Product
functions
• ...
Question 5: Conceptual Design (25 marks) The Felicity Stillwell Hospital (FSH) is a small hospital located...
Question 5: Conceptual Design (25 marks) The Felicity Stillwell Hospital (FSH) is a small hospital located in the southern suburbs of Perth, specialising in the health care of elderly patients. As the first phase of a complete information systems redevelopment, you have been contracted to design the database that will support its data and processing requirements. Depending on how well you perform, you may be asked to implement the design at some later time. Detailed information on the data recorded,...
Can somebody help me with the Use Case Diagram . I am confused of what I...
Can somebody help me with the Use Case Diagram . I am confused of what I am suppose to do. Here are the instructions : Your team should produce a Use Case Diagram and the associated Use Case Descriptions/Narratives for all the use cases in the diagram. The resulting document should havethe “professional look” and produced by a word processor, graphics/presentation/drawing software, and/or a CASE tool (e.g., Microsoft Word, Microsoft PowerPoint, ArgoUML, Dia, Visual Paradigm, Visio, etc.). All project documentation...
i need help with a mips program to to covert roman numerals to real numbers Lab 4: Roman Numeral Conversion Part A: Due...
i need help with a mips program to to covert roman numerals to
real numbers
Lab 4: Roman Numeral Conversion Part A: Due Sunday, 19 May 2019, 11:59 PM Due Friday, 24 May 2019, 11:59 PM Part B: Minimum Submission Requirements Ensure that your Lab4 folder contains the following files (note the capitalization convention): o Diagram.pdf o Lab4. asm O README.txt Commit and push your repository Lab Objective In this lab, you will develop a more detailed understanding of how...
I need help with my very last assignment of this term PLEASE!!, and here are the instructions: After reading Chapter T...
I need help with my very last assignment of this term
PLEASE!!, and here are the instructions: After reading Chapter Two,
“Keys to Successful IT Governance,” from Roger Kroft and Guy
Scalzi’s book entitled, IT Governance in Hospitals and Health
Systems, please refer to the following assignment instructions
below.
This chapter consists of interviews with executives
identifying mistakes that are made when governing healthcare
information technology (IT). The chapter is broken down into
subheadings listing areas of importance to understand...
Please need serious and professional help!
Hello! I am working on an "object oriented analysis and design"
Project. I would really need your sincere help in creating a vision
document for this project.
The Things That I require in the "vision document"
is:
1. Product Overview
[This section provides a high level view of the product
capabilities, interfaces to other applications, and system
configurations. This section usually consists of three subsections,
as follows:
• Product
perspective
• Product
functions
• ...
i need help with a mips program to to covert roman numerals to
real numbers
Lab 4: Roman Numeral Conversion Part A: Due Sunday, 19 May 2019, 11:59 PM Due Friday, 24 May 2019, 11:59 PM Part B: Minimum Submission Requirements Ensure that your Lab4 folder contains the following files (note the capitalization convention): o Diagram.pdf o Lab4. asm O README.txt Commit and push your repository Lab Objective In this lab, you will develop a more detailed understanding of how...
I need help with my very last assignment of this term
PLEASE!!, and here are the instructions: After reading Chapter Two,
“Keys to Successful IT Governance,” from Roger Kroft and Guy
Scalzi’s book entitled, IT Governance in Hospitals and Health
Systems, please refer to the following assignment instructions
below.
This chapter consists of interviews with executives
identifying mistakes that are made when governing healthcare
information technology (IT). The chapter is broken down into
subheadings listing areas of importance to understand...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 11 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 11 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 11 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 11 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 11 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 11 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 11 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 11 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 11 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 11 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 11 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 11 months ago