FORM WITH STATIC & DYNAMIC DATABASE

OUTPUT

P

^RACTICAL

18 :W

^RITE

^SIMPLE

JSP

^PROGRAM

^FOR

^USER

^LOGIN

FORM

^WITH

^STATIC

&

^DYNAMIC

^DATABASE

.

SPECIFIC OBJECTIVES

After performing this practical student will be able to:

Develop a JSP Program in JAVA.

Learn How to handle static and dynamic database in Web browser.

L^EARNING O^UTCOMES

Explain & Practice how to access mysql database from JSP programme.

A^SSUMPTIONS

Oracle JDK, Apache-tomcat-8.0.15 and wampserver2.2c-x32 installed.

Editor Like notepad, Netbeans available for program development.

Environment variables like JAVA_Home, Path, and Classpath are configured and copy mysql-connector jar file to folder C:\Program

Files\Java\jdk1.8.0_25\jre\lib\ext.

C^ODE (^A)

(a) Write a simple JSP program for user login form with static database.

Login.jsp

<html>

<head>

</head>

<body>

<h1><center>Login Page</center></h1>

<h2>Signup Details</h2>

<br/>Username:<input type=“text” name=“username”>

<br/>Password:<input type=“password” name=“password”>

</form>

</center>

</body>

</html>

Logincheck.jsp

<html>

<head>

</head>

<body>

String username=request.getParameter(“username”);

String password=request.getParameter(“password”);

if((username.equals(“kdp”) && password.equals(“kdp123”))) {

session.setAttribute(“username”,username);

response.sendRedirect(“home.jsp”);

} else

response.sendRedirect(“error.jsp”);

</body>

</html>

Home.jsp

<%@page contentType=“text/html” pageEncoding=“UTF-8”

errorPage=“Error.jsp”%>

<html>

<head>

</head>

<body>

<h2>

String a=session.getAttribute(“username”).toString();

out.println(“Hello “+a);

</h2>

<br/>

<a href=“logout.jsp”>Logout</a>

</center>

</body>

</html>

Logout.jsp

<%@page contentType=“text/html” pageEncoding=“UTF-8”%>

<html>

<head>

</head>

<body>

session.removeAttribute(“username”);

session.removeAttribute(“password”);

session.invalidate();

<h1>Logout was done successfully.</h1>

</body>

</html>

Error.jsp

<%@page contentType=“text/html” pageEncoding=“UTF-8”%>

<html>

<head>

</head>

<body>

<h1>Sorry Invalid Username or Password…</h1>

</body>

</html>

OUTPUT

C^ODE (^B)

(b) Write a simple JSP program for user login form with dynamic database.

->Create logindatabase Database in MySQL.

->Create members Table under logindatabase Database.

Members:

first_name last_name email uname pass regdate

login.jsp

<%@page contentType=“text/html” pageEncoding=“UTF-8”%>

<html>

<head>

<title>JSP Example</title>

</head>

<body>

<thead>

<tr>

<th colspan=“2”>Login Here</th>

</tr>

</thead>

<tbody>

<tr>

</tr>

<tr>

<td>Password</td>

</td>

</tr>

<tr>

</tr>

<tr>

<td colspan=“2”>Not Yet Registered!! <a href=“Newregistration.jsp”>Register Here</a></td>

</tr>

</tbody>

</table>

</center>

</form>

</body>

</html>

Logincheck.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/logindatabase”, “root”, ””);

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);

response.sendRedirect(“success.jsp”);

} else {

out.println(“Invalid password <a href=‘login.jsp’>try again</a>”);

}

Newregistration.jsp

<%@page contentType=“text/html” pageEncoding=“UTF-8”%>

<html>

<head>

<title>Registration</title>

</head>

<body>

<thead>

<tr>

<th colspan=“2”>Enter Information Here</th>

</tr>

</thead>

<tbody>

<tr>

<td>First Name</td>

</tr>

<tr>

</tr>

<tr>

<td>Email</td>

</tr>

<tr>

</tr>

<tr>

<td>Password</td>

</td>

</tr>

<tr>

</tr>

<tr>

<td colspan=“2”>Already registered!! <a href=“login.jsp”>Login Here</a></td>

</tr>

</tbody>

</table>

</center>

</form>

</body>

</html>

Registrationsubmit.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”);

Class.forName(“com.mysql.jdbc.Driver”);

Connection con =

DriverManager.getConnection(“jdbc:mysql://localhost/logindatabase”, “root”, ””);

Statement st = con.createStatement();

int i = st.executeUpdate(“insert into members(first_name, last_name, email, uname, pass, regdate) values (’” + fname + ”’,’” + lname + ”’,’” + email + ”’,’” + user + ”’,’” + pwd + ”’, CURDATE())”);

if (i > 0) {

response.sendRedirect(“welcome.jsp”);

} else {

response.sendRedirect(“login.jsp”);

}

Welcome.jsp

Registration is Successful.

Please Login Here <a href=‘login.jsp’>Go to Login</a>

Success.jsp

if ((session.getAttribute(“userid”) == null) ||

(session.getAttribute(“userid”) == ””)) {

You are not logged in<br/>

<a href=“login.jsp”>Please Login</a>

<%} else {

Welcome <%=session.getAttribute(“userid”)%>

}

OUTPUT:

P

RACTICAL

19 :W

RITE

JSP

PROGRAM

DISPLAY

THE

GRADE

A STUDENT

^BY

^ACCEPTING

^THE

^MARKS

^OF

^FIVE

^SUBJECTS

.

SPECIFIC OBJECTIVES

After performing this practical student will be able to:

Develop a JSP Program in JAVA.

Learn How to handle page redirecting in web browser.

LEARNING OUTCOMES

Explain & Practice Jsp scriplet tags and HTML tags.

ASSUMPTIONS

Oracle JDK, Apache-tomcat-8.0.15 installed.

Editor Like notepad, Jcreator available for program development.

Environment variables like JAVA_Home, Path, and Classpath are configured.

CODE

<%@ page language=“java” contentType=“text/html; charset=ISO-8859-1”

pageEncoding=“ISO-8859-1”%>

<html>

<head>

<title>Student Marks</title>

</head>

<body>

<h2>Student Grading System</h2>

<table>

<tr>

<td>

Enter Five Subject Marks out of 100

</td>

</tr>

</table>

<table>

<tr>

<th>Subject</th>

<th>Obtained Marks</th>

<th>Total Marks</th>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</form>

String c = request.getParameter(“c”);

String j = request.getParameter(“java”);

String n = request.getParameter(“net”);

String v = request.getParameter(“vb”);

String d = request.getParameter(“dbms”);

if(!(c == null || c.isEmpty())) {

int cmarks = Integer.parseInt(c);

int jmarks = Integer.parseInt(j);

int nmarks = Integer.parseInt(n);

int vmarks = Integer.parseInt(v);

int dmarks = Integer.parseInt(d);

int total = cmarks+jmarks+nmarks+vmarks+dmarks;

int avg = (total)/5;

int percent = avg;

String grade =””;

if(percent < 40){

grade = “E”;

//request.setAttribute(“grade”, grade);

}

else if(percent >= 40 && percent <=44){

grade = “D”;

}

else if(percent >=45 && percent <=49){

grade = “D+”;

}

else if(percent >=50 && percent <=54){

grade = “C-“;

}

else if(percent >=55 && percent<=59){

grade = “C”;

}

else if(percent >=60 && percent <=64){

grade = “C+”;

}

else if(percent >=65 && percent<=69){

grade = “B-“;

}

else if(percent >=70 && percent <=74){

grade = “B”;

}

else if(percent >=75 && percent <=79){

grade = “B+”;

}

else if(percent >=80 && percent <=84){

grade = “A”;

}

else if (percent >=85 && percent <=100){

grade = “A+”;

}

request.setAttribute(“Grade”, grade);

<table>

<tr>

<td><b>Aggregate Marks</b></td><td></td>

</tr>

<tr>

<td><b>Grade</b></td><td></td>

</tr>

</table>

}

</body>

</html>

O^UTPUT

In document Osmora.advanced JAVA Laboratory Manual.2016%28epub%29 (Page 138-151)