[go: up one dir, main page]
Scribd
Upload
132 views79 pages

Enterprise Java

The document provides code examples for several servlet programming tasks: 1) Creating a basic calculator application using a servlet to handle form submissions and perform calculations. 2) Developing servlets for a login page that displays a greeting or error message depending on the username and password. 3) Building a registration servlet that accepts user details from an HTML form and stores them in a database using JDBC. 4) Demonstrating the use of request dispatching to forward users to different servlets based on input, and using cookies to track the number of visits across pages. 5) Creating sessions to determine if a user is visiting a page for the first time or returning, and

Uploaded by

Zoya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
132 views79 pages

Enterprise Java

The document provides code examples for several servlet programming tasks: 1) Creating a basic calculator application using a servlet to handle form submissions and perform calculations. 2) Developing servlets for a login page that displays a greeting or error message depending on the username and password. 3) Building a registration servlet that accepts user details from an HTML form and stores them in a database using JDBC. 4) Demonstrating the use of request dispatching to forward users to different servlets based on input, and using cookies to track the number of visits across pages. 5) Creating sessions to determine if a user is visiting a page for the first time or returning, and

Uploaded by

Zoya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 79

CHANDRABHAN SHARMA ENTERPRISE JAVA

Practical No.1:-

1a. Create a simple calculator application using servlet.


index.html
<html>
<head>
<title>CalculatorApp</title>

</head>
<body>
<form action="CalculatorServlet" >
Enter First Number <input type="text" name="txtN1" ><br>
Enter Second Number <input type="text" name="txtN2" ><br>

Select an Operation:
<input type="radio" name="opr" value="+">ADDITION
<input type="radio" name="opr" value="-">SUBTRACTION
<input type="radio" name="opr" value="*">MULTIPLICATION
<input type="radio" name="opr" value="/">DIVISION <br>

<input type="reset">
<input type="submit" value="Calculate" >
</form>
</body>
</html>

CalculatorServlet.java
int n1 = Integer.parseInt(request.getParameter("txtN1"));
int n2 = Integer.parseInt(request.getParameter("txtN2"));
int res =0;
String opr=request.getParameter("opr");

if(opr.equals("+")) res=n1+n2; if(opr.equals("-")) res=n1-n2;

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

if(opr.equals("*")) res=n1*n2; if(opr.equals("/")) res=n1/n2;


out.println("<h1> Result = "+res);

Output:

1b. Create a servlet for a login page. If the username and password are
correct then it says message
“Hello <username>” else a message “login failed”.
index.html
<html>
<head>
<title>Login Form</title>

</head>
<form action="LoginServlet" >

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

Enter User ID<input type="text" name="txtId"><br>


Enter Password <input type="password" name="txtPass"><br>
<input type="reset">

<input type="submit" value=" Click to Login " >


</form>
</body>
</html>

LoginServlet.java
String uname = request.getParameter("txtId");
String upass = request.getParameter("txtPass");
if(uname.equals("admin") && upass.equals("12345")){
out.println("<h1> Welcome !!! "+uname+"</h1>");
}

else{
out.println("<h1> Login Fail !!! </h1>");

Output:

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

1c. Create a registration servlet in Java using JDBC. Accept the details
such as Username, Password,Email, and Country from the user using
HTML Form and store the registration details in the database.
Index.html
<html>
<body>

<form action=”Register”>
Username<input type=”text” name=”txtN1”><br>
Password<input type=”text” name=”txtN2”><br>
Email<input type=”text” name=”txtN3”><br>
Select Country:<br>
<input type=”radio” name=”cntry”>India<br>
<input type=”radio” name=”cntry”>Korea<br>
<input type=”radio” name=”cntry”>America<br>
<input type=”radio” name=”cntry”>China<br>
<input type=”submit” value=”Register”>

<input type=”reset” value=”Reset”>


</form>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

</body>
</html>

Register.java
String id = request.getParameter("txtN1");
String ps = request.getParameter("txtN2");
String em = request.getParameter("txtN3");
String co = request.getParameter("txtN4");
Class.forName("com.mysql.jdbc.Driver");
Connection con
=DriverManager.getConnection("jdbc:mysql://localhost:3306/logindb");
PreparedStatement pst = con.prepareStatement("insert into user values(?,?,?,?)");
pst.setString(1,id);
pst.setString(2,ps);
pst.setString(3,em);
pst.setString(4,co);
int row = pst.executeUpdate();
out.println("+row+ " Inserted Succesfully!");

Output:

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

Practical No.2:-

2a. Using Request Dispatcher Interface create a Servlet which will


validate the password entered by the user, if the user has entered
"Servlet" as password, then he will be forwarded to Welcome Servlet
else the user will stay on the index.html page and an error message
will be displayed.
Index.html
<html>

<body>
<form action=”LoginServlet”>
Enter UserId<input type=”text” name=”txtId” ><br>
Enter Password<input type=”text” name=”txtPass” ><br>
<input type=”submit” value=”Click to Login”>

<input type=”reset” value=”Reset”>


</form>
</body>
</html>

LoginServlet.java
String uname = request.getParameter("txtId");
String upass = request.getParameter("txtPass"); if(uname.equals("zoya") &&
upass.equals("servlet"))
{ RequestDispatcher rd = request.getRequestDispatcher("WelcomeServlet");

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

rd.forward(request, response); }
else
{ out.println("Login Fail !!! "); RequestDispatcher rd =
request.getRequestDispatcher("index.html");
rd.include(request, response);

WelcomeServlet.java
out.println("<body bgcolor= blue>"); out.println("<h1>Welcome to Servlet");

Output:

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

2b. Create a servlet that uses Cookies to store the number of times a
user has visited servlet.

index.html

<html>

<body>
<form action=”Page1”>
Enter Username<input type=”text”
name=”txtName”><br>
<input type=”submit” value=”Click to Enter”>

</form>
</body>
</html>

Page1.java:
String uname = request.getParameter("txtName"); out.println("

Welcome "+uname+");
Cookie ck1 = new Cookie("username", uname);
Cookie ck2 = new Cookie("visit","1"); response.addCookie(ck1);
response.addCookie(ck2);
out.println("a href= Page2 >Click to visit Page 2 </a></h1>");

Page2.java:

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

Cookie [] ck = request.getCookies();
for(int i=0;i<ck.length;i++){
if(ck[i].getName().equals("visit")){

int count = Integer.parseInt(ck[i].getValue())+1;


out.println("<h1>Visit No : "+count+"</h1>");
ck[i] = new Cookie("visit",count+"");
response.addCookie(ck[i]);}
else {

out.println(ck[i].getName()+ " = "+ck[i].getValue()); }


out.println("<h1><a href=Page3 >Click to visit Page 3 </a></h1>");
out.println("<h1><a href=Page4 >Click to visit Page 4 </a></h1>");
out.println("<h1><a href=Page5 >Click to visit Page 5 </a></h1>");

Page3.java
Cookie [] ck = request.getCookies();
for(int i=0;i<ck.length;i++){
if(ck[i].getName().equals("visit")){
int count = Integer.parseInt(ck[i].getValue())+1;

out.println("<h1>Visit No : "+count+"</h1>");
ck[i] = new Cookie("visit",count+"");
response.addCookie(ck[i]);}
else {
out.println(ck[i].getName()+ " = "+ck[i].getValue()); }

out.println("<h1><a href=Page3 >Click to visit Page 2</a></h1>");


out.println("<h1><a href=Page4 >Click to visit Page 4 </a></h1>");
out.println("<h1><a href=Page5 >Click to visit Page 5 </a></h1>");

Page4.java
Cookie [] ck = request.getCookies();
for(int i=0;i<ck.length;i++){

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

if(ck[i].getName().equals("visit")){
int count = Integer.parseInt(ck[i].getValue())+1;
out.println("<h1>Visit No : "+count+"</h1>");

ck[i]
(ck[i]);}
else {
out.println(ck[i].getName()+ " = "+ck[i].getValue()); }
out.println("<h1><a href=Page3 >Click to visit Page 3 </a></h1>");

out.println("<h1><a href=Page4 >Cli= new Cookie("visit",count+"");


response.addCookie ck to visit Page 4 </a></h1>");
out.println("<h1><a href=Page5 >Click to visit Page 5 </a></h1>");

Output:

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

2c. Create a servlet demonstrating the use of session creation and


destruction. Also check whether the user has visited this page first time
or has visited earlier also using sessions

index.html
<html>
<body>
<form action=”Page1”>
Enter User Id<input type=”text”
name=”txtName”><br>

<input type=”submit” value=”Click to Enter”>


</form>
</body>
</html>

Page1.java
HttpSession hs = request.getSession(true);

if(hs.isNew()){
out.println("<body bgcolor=yellow>");
String name = request.getParameter("txtName");
hs.setAttribute("uname", name);
hs.setAttribute("visit", "1");

out.println("<h1>Welcome First Time</h1>");


}

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

else{
out.println("<h1>Welcome Again</h1>");
int visit = Integer.parseInt((String)hs.getAttribute("visit"))+1;

out.println("<h1>You Visited "+visit+"Times</h1>");


hs.setAttribute("visit", ""+visit);
}
out.println("<h1>Your Session ID "+hs.getId()+"</h1>");
out.println("<h1>You Logged in at "+new
java.util.Date(hs.getCreationTime())+"</h1>");
out.println("<h1><a href=Page2>Click for Page 2 </a></h1>");

out.println("<h1><a href=Page3>Click for Page 3 </a></h1>");


out.println("<h1><a href=Page4>Click for Page 4 </a></h1>");
out.println("<h1><a href=LogoutServlet>Click to Terminate Session </a></h1>");
}

Page2.java
HttpSession hs = request.getSession(false);
out.println("<h1>Welcome Again on Page No. 2</h1>");
int visit = Integer.parseInt((String)hs.getAttribute("visit"))+1;
out.println("<h1>You Visited "+visit+"Times</h1>");
hs.setAttribute("visit", ""+visit);

out.println("<h1>Your Session ID "+hs.getId()+"</h1>");


out.println("<h1>You Logged in at "+new
java.util.Date(hs.getCreationTime())+"</h1>");
out.println("<h1><a href=Page1>Click for Page 1 </a></h1>");
out.println("<h1><a href=Page3>Click for Page 3 </a></h1>");
out.println("<h1><a href=Page4>Click for Page 4 </a></h1>");

out.println("<h1><a href=LogoutServlet>Click for Terminate Session </a></h1>");

LogoutServlet.java
javax.servlet.http.HttpSession hs = request.getSession();

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

if(hs != null)
hs.invalidate();
out.println("<h1>You are Logged out now........</h1>");

Output:

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

a) Create a Servlet application to upload and download a


file. (UPLOAD FILE).

Index.html:-

<body>
<div>
<form action="file_uploading" method="post" enctype="multipart/form-data">
Select File to upload :<input type="file" name="file" id="file"></br> Destination
:<input type="text" value="/tmp" name="destination"></br></br>
<input type="submit" value="Upload file" name="upload" id="upload">
</form>

</div>
</body>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

Output:-

Fileuploading.java:-

import javax.servlet.annotation.MultipartConfig; @MultipartConfig


public class…{ out.println("<body>");
// out.println("<h1>Servlet file_uploading at " + request.getContextPath() +
"</h1>"); String path=request.getParameter("destination");
Part filePart=request.getPart("file");
String filename=filePart.getSubmittedFileName(); out.println("<br><br><br> File
name :"+filename); OutputStreamos=null;
Input Stream is=null;

os=new FileOutputStream(new File(path+File.separator+filename));


is=filePart.getInputStream();
int read =0; while((read=is.read())!=-1)
{
os.write(read);
}

out.println("File uploaded Successfully !"); out.println("</body>");


}

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

Output:-

(DOWNLOAD FILE)

Index.html :-

<body>

<div>
<h1>File Download Application</h1>
Click <a href="file_downloading?filename=file.txt">File</a>
<br/><br/>
Click <a href="file_downloading?filename=file2.docx">File 2</a>

<br/><br/>
</div></body> Downloading.java out.println("<body>");
response.setContentType("APPLICATION/OCTET-STREAM"); String
filename=request.getParameter("filename"); ServletContext
context=getServletContext();
InputStream is=context.getResourceAsStream("/" + filename);
response.setHeader("Conetnt-Disposition","attachment; filename=\"" + filename+
"\"") int i;

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

while((i=is.read())!=-1)
{
out.write(i);

is.close();
out.close();
}
Out.println(</body>);

Output:-

a)Develop Simple Servlet Question Answer Application using Database.

index.html:-

<html>
<head>
<title>TODO supply a title</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
</head>
<body>
<h1 align="center">Welcome to the Quiz</h1>
<h1><a href="QuestionAnswerServlet">Click to Start Quiz</a></h1>
</body>
</html>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

QuestionAnswerServlet.java:-
public class QuestionAnswerServlet extends HttpServlet {
protected void processRequest(HttpServletRequest request, HttpServletResponse
response) throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
try (PrintWriter out = response.getWriter()) { out.println("<form
action=QuestionAnswerServlet2>"); try {

Class.forName("com.mysql.jdbc.Driver"); try {

Connection
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/zakjavadb","root",
"root");

Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from quiz_table"); out.println("<table
border=1>");
int qno=0; while (rs.next())
{ qno++;
out.println("<tr><td>"+rs.getString(1)+"</td>");
out.println("<td>"+rs.getString(2)+"</td></tr>"); out.println("<tr><td><input
type=radio
name="+qno+"value="+rs.getString(3)+"></td><td>"+rs.getString(3)+"</td></tr>");
out.println("<tr><td><input type=radio
name="+qno+"value="+rs.getString(4)+"></td><td>"+rs.getString(4)+"</td></tr>");
out.println("<tr><td><input type=radio
name="+qno+"value="+rs.getString(5)+"></td><td>"+rs.getString(5)+"</td></tr>");
out.println("<tr><td><input type=radio
name="+qno+"value="+rs.getString(6)+"></td><td>"+rs.getString(6)+"</td></tr>");

} out.println("</table>"); out.println("<input type=reset><br>");


out.println("<input type=submit value=submit>"); out.println("</form>");

} catch (SQLException ex) {


Logger.getLogger(QuestionAnswerServlet.class.getName()).log(Level.SEVERE, null,
ex);} } catch (ClassNotFoundException ex) {

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

Logger.getLogger(QuestionAnswerServlet.class.getName()).log(Level.SEVERE, null,
ex);}}}

QuestionAnswerServlet2.java:-

public class QuestionAnswerServlet2 extends HttpServlet {


protected void processRequest(HttpServletRequest request, HttpServletResponse
response) throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8"); try (PrintWriter out =
response.getWriter()) {
try {
Class.forName("com.mysql.jdbc.Driver"); try {
Connection
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/zakjavadb", "root",
"root");
Statement stmt=con.createStatement();

ResultSet rs=stmt.executeQuery("select answer from quiz_table"); int count=0;


int qno=0; while(rs.next())
{

if(rs.getString(1).equals(request.getParameter(""+(++qno))))

{count++; out.println("<h1>Correct!</h1>");
}
else
{
out.println("<h1>Incorrect!</h1>");

}
}
out.println("Your total score is: " +count+"</h1>");
}
catch (SQLException ex)

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

{
Logger.getLogger(QuestionAnswerServlet2.class.getName()).log(Level.SEVERE, null,
ex);
}
}

catch (ClassNotFoundException ex)


{
out.println("" +ex);
}}}

Output:-

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

c) Create simple Servlet application to demonstrate Non-


Blocking Read Operation.

Index.html:-

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

<html>
<head>
<title>Non Blocking IO</title>

<meta charset="UTF-8">
<meta http-equiv="Refresh" content="0; URL=NonBlockingServlet">
</head>
<body>
</body>

</html>

NonBlockingServlrt.java:-

package nonblkapp;

import java.io.*; import java.net.*; import javax.servlet.*;


import javax.servlet.http.*;
public class NonBlockingServlet extends HttpServlet {
protected void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8"); try (PrintWriter out =
response.getWriter()) { out.println("<h1>FileReader</h1>");
String filename="/WEB-INF/booklist.txt"; ServletContext c=getServletContext();
InputStream in=c.getResourceAsStream(filename);
String
path="http://"+request.getServerName()+":"+request.getServerPort()+request.getC
ontextPath()+"/Rea dingNonBloclingServlet";
URL url=new URL(path);

HttpURLConnection conn=(HttpURLConnection)url.openConnection();
conn.setChunkedStreamingMode(2); conn.setDoOutput(true); conn.connect();
if(in!=null)
{

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

InputStreamReader inr=new InputStreamReader(in); BufferedReader br = new


BufferedReader(inr); String text="";
System.out.println("Reading started. ");
BufferedWriter bw=new BufferedWriter(new
OutputStreamWriter(conn.getOutputStream())); while((text=br.readLine())!=null){
out.print(text+"<br>"); try{ Thread.sleep(1000); out.flush();

}
catch(InterruptedException ex){}

}out.print("reading completed. ");

bw.flush();
bw.close();
}}}}

ReadingListener.java:-

package nonblkapp;
import java.io.IOException; import java.util.logging.Level; import
java.util.logging.Logger;
import javax.servlet.AsyncContext; import javax.servlet.ReadListener; import
javax.servlet.ServletInputStream;
public class ReadingListener implements ReadListener { private ServletInputStream
input = null;
private AsyncContext ac = null;
ReadingListener(ServletInputStream in, AsyncContext c) { input = in; ac = c;
}

@Override
public void onDataAvailable() throws IOException {
}

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

public void onAllDataRead() throws IOException { ac.complete();


}

public void onError(final Throwable t) { ac.complete();


t.printStackTrace();
}}

ReadingNonBlockingServlet.java:-

package nonblkapp;
import java.io.IOException; import java.io.PrintWriter;
import javax.servlet.AsyncContext; import javax.servlet.ServletException; import
javax.servlet.ServletInputStream;
import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest; import


javax.servlet.http.HttpServletResponse;

@WebServlet (name = "ReadingNonBlockingServlet", urlPatterns =

{"/ReadingNonBlockingServlet"},asyncSupported = true )
public class ReadingNonBlockingServlet extends HttpServlet { @Override
protected void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html"); AsyncContext ac = request.startAsync();
ServletInputStream in=request.getInputStream(); in.setReadListener(new
ReadingListener(in,ac));
}}

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

Practical No.4:-
4a. Develop a simple JSP application to display values obtained from
the use of intrinsic objects of various types.

IntrinsicObject.jsp

<html><head><title>JSP Page</title></head>
<body>
<h1>Use of Intrinsic Objects in JSP</h1>
<h1>Request Object </h1>
Query String <%=request.getQueryString() %><br>

Context Path <%=request.getContextPath() %><br>


Remote Host <%=request.getRemoteHost() %><br>
<h1>Response Object </h1>
Character Encoding Type <%=response.getCharacterEncoding() %><br>
Content Type <%=response.getContentType() %><br>

Locale <%=response.getLocale() %><br>


<h1>Session Object </h1>
ID <%=session.getId() %><br>
Creation Time <%=new java.util.Date(session.getCreationTime()) %><br>
Last Access Time<%=new java.util.Date(session.getLastAccessedTime()) %><br>

</body>

</html>

Output:

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

4b. Develop a simple JSP application to pass values from one page to
another with validations. (Name-txt, age-txt, hobbies-checkbox, email-
txt, gender-radio button).
Index.html
<html><head><title>User Information Page</title>
</head>
<body>
<form action="Validate.jsp">

Enter Your Name<input type="text" name="name" ><br>


Enter Your Age<input type="text" name="age" ><br>
Select Hobbies
<input type="checkbox" name="hob" value="Singing">Singing
<input type="checkbox" name="hob" value="Reading">Reading Books

<input type="checkbox" name="hob" value="Football">Playing Football<br>


Enter E-mail<input type="text" name="email" ><br>
Select Gender
<input type="radio" name="gender" value="male">Male
<input type="radio" name="gender" value="female">Female

<input type="radio" name="gender" value="other">Other<br>


<input type="hidden" name="error" value="">
<input type="submit" value="Submit Form">

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

</form>
</body>

</html>

Validate.jsp
<%
int ageInNumbers;
String EMAIL_REGEX="^[\\w-\\+]+(\\.[\\w]+)*@[\\w-]+(\\.[\\w]+)*(\\.[a-z]{2,})$";

%>
<%
String name = request.getParameter("name");
String age = request.getParameter("age");
String email = request.getParameter("email");

String gender = request.getParameter("gender");


String hobbies[]=request.getParameterValues("hobbies");
String nothing="";
if(name.equals(nothing))
{

out.println("<font color=red> Please fill all the fields properly!</font><br>");


}
if(!email.matches(EMAIL_REGEX))
{
out.println("<font color=red> Please enter the correct age!</font><br>");

}
%>
<br><br>
<b>You entered information is</b><br>
Full Name : <%= name %><br>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

Age : <%= age %><br>


Email : <%= email %><br>
Gender : <%= gender %><br>

Hobbies :
<%
if(hobbies!=null && hobbies.length!=0)

{ for(int i=0;i<hobbies.length;i++)

{ out.println(hobbies[i]); } }
%>

Output:

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

4c. Create a registration and login JSP application to register and


authenticate the user based on username and password using JDBC.

index.html
<html><head><title>New User Registration Page</title></head>

<body>
<form action="Register.jsp" >
<h1> New User Registration Page</h1>
Enter User Name <input type="text" name="txtName" ><br>
Enter Password <input type="password" name="txtPass1" ><br>

Re-Enter Password<input type="password" name="txtPass2" ><br>

Enter Email<input type="text" name="txtEmail" ><br>


Enter Country Name <input type="text" name="txtCon" ><br>
<input type="reset" ><input type="submit" value="REGISTER" >

</form>
</body>
</html>

Register.jsp
<html><body>
<h1>Registration JSP Page</h1>
<%
String uname=request.getParameter("txtName");
String pass1 = request.getParameter("txtPass1");

String pass2 = request.getParameter("txtPass2");


String email = request.getParameter("txtEmail");
String ctry = request.getParameter("txtCon");
if(pass1.equals(pass2)){

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

try{
Class.forName("com.mysql.jdbc.Driver");
Connection con =
DriverManager.getConnection("jdbc:mysql://localhost:3306/logindb");
PreparedStatement stmt = con.prepareStatement("insert into user values (?,?,?,?)");

stmt.setString(1, uname); stmt.setString(2, pass1);


stmt.setString(3, email); stmt.setString(4, ctry);
int row = stmt.executeUpdate();
if(row==1) { out.println("Registration Successful"); }
else {

out.println("Registration Fail !!!!");


%><jsp:include page="Register.html" ></jsp:include>
<%
}
}catch(Exception e){out.println(e);}

}
else
{
out.println("<h1>Password Mismatch</h1>");
%>

<jsp:include page="Register.html" ></jsp:include>


<% }
%>
</body>
</html>

Output:

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

Practical No.5:-

a)Create an html page with fields, eno, name, age, desg, salary. Now on
submit this data to a JSP page which will update the employee table of
database with matching eno.

index.html:-

<html>
<head>
<title>TODO supply a title</title>
<meta charset="UTF-8">

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

<meta name="viewport" content="width=device-width, initial-scale=1.0">


</head>
<body>

<form action="update.jsp" method="post">


<h1>Update Page</h1>
NAME:<input type="text" name="ename"><br><br> AGE:<input type="text"
name="age"><br><br> DESG:<input type="text" name="desg"><br><br>
SALARY:<input type="text" name="salary"><br><br>
Now Enter the Employee number where you want to insert employee details
<input type="text" name="eno"><br><br>
<input type="submit" value="submit">

</form>
</body>
</html>

update.jsp:-

<%@page import="java.sql.ResultSet"%>
<%@page import="java.lang.System.* "%>
<%--@page import="java.lang.System.out" --%>
<%@page import="java.sql.PreparedStatement"%>

<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

<body>
<%
String eno=request.getParameter("eno"); String
name=request.getParameter("ename"); String age=request.getParameter("age");
String desg=request.getParameter("desg"); String
sal=request.getParameter("salary"); Class.forName("com.mysql.jdbc.Driver");

Connection
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/zakjavadb","root",
"root");
PreparedStatement ps=con.prepareStatement("update update_table set
name=?,age=?,desg=?,salary=? where eno=?");
ps.setString(1,name); ps.setString(2,age); ps.setString(3, desg); ps.setString(4, sal);
ps.setString(5,eno); ps.executeUpdate();
%>

</body>
</html>

Output:-

Table before updating:-

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

Table after updating

a) Create a JSP page to demonstrate the use of Expression language.

Index.html:
<html>
<head>
<title>(5A1)</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
</head>
<body>
<h1>Value Fetching using param variable of expression language </h1>
<form action="display.jsp">
Student Name <input type="text"
name="stuname"><br> Student Roll
Number <input type="text"
name="rollno"><br>
<input type="submit" value="submit">
</form> </body></html>

Display.jsp:-

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
Student Name is

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

${param.stuname}<
br>Student Roll
Number is
${param.rollno}
<%-- param tag is used to get the parameters --%>
</body>
</html>

Output:-

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>5A2</title>

</head>

<body>

<%

application.setAttribute("author","zak"); application.setAttribute("site","The Underrated Marvel


");

%>

<a href="display2.jsp">Click </a>

</body>

</html>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

Display2.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 Page</title>

</head>

<body>

<h1> Author Name ${applicationScope.author} <br></h1>

<h1> Book Name ${applicationScope.site}</h1>

</body>

</html>

Output:-

5c. Create a JSP application to demonstrate the use of JSTL.


Basic insert, update and delete example using core and sql tag libraries in
JSTL.
1. index.jsp
<!DOCTYPE html>
<html>
<head>
<metahttp-equiv="Content-Type"content="text/html; charset=UTF-8">

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

<title>JSP Page</title>
</head>
<body>

<h1>Choose Option</h1>
<a href="insert.jsp">Insert Record</a><p></p>
<a href="display.jsp">Display Record</a>
</body>
</html>

2. insert.jsp
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html>
<html>

<head>
<metahttp-equiv="Content-Type"content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>

<form action="insertdb.jsp" method="post">

<tableborder="0"cellspacing="2"cellpadding="5">

<thead>

<tr>
<thcolspan="2">Purchase Product</th>
</tr>
</thead>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

<tbody>
<tr>
<td><label>Product Name</label></td>

<td><input type="text" name="pname"/></td>


</tr>
<tr>
<td><label>Quantity</label></td>
<td><input type=" text" name="qty"/></td>

</tr>
<tr>
<td><input type="submit" value="Save"/></td>
<td><input type="reset" value="reset"/></td>
</tr>

</tbody>
</table>
</form>
<fontcolor="red"><c:iftest="${not empty param.errMsg}">
<c:outvalue="${param.errMsg}"/>

<ahref="index.jsp">Go Back</a>
</c:if></font>
<fontcolor="green"><c:iftest="${not empty param.susMsg}">
<c:outvalue="${param.susMsg}"/>
<ahref="index.jsp">Go Back</a>

</c:if></font>
</body>
</html>

3. insertdb.jsp
<%@ page import="java.io.*,java.util.*,java.sql.*"%>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>


<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
<html>

<head>
<title>INSERT Operation</title>
</head>
<body>
<c:iftest="${ empty param.pname or empty param.qty}">

<c:redirecturl="insert.jsp">
<c:paramname="errMsg" value="Please Enter Product and Quantity"/>
</c:redirect>
</c:if>
<sql:setDataSourcevar="dbsource"driver="com.mysql.jdbc.Driver"

url="jdbc:mysql://localhost/sampleDB"
user="root" password="pass"/>
<sql:updatedataSource="${dbsource}"var="result">
INSERT INTO product(pname, quantity) VALUES (?,?);
<sql:paramvalue="${param.pname}"/>

<sql:paramvalue="${param.qty}"/>
</sql:update>
<c:iftest="${result>=1}">
<fontsize="5" color='green'> Congratulations ! Data inserted
successfully.</font>

<c:redirecturl="insert.jsp">
<c:paramname="susMsg" value="Congratulations ! Data inserted
successfully." />
</c:redirect>
</c:if>
</body>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

</html>

4. display.jsp
<%@ page import="java.io.*,java.util.*,java.sql.*"%>

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>


<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
<html>
<head>
<title>SELECT Operation</title>

<script>
function confirmGo(m,u) {
if ( confirm(m) ) {
window.location = u;
}

}
</script>
</head>
<body>
<sql:setDataSourcevar="dbsource"driver="com.mysql.jdbc.Driver"

url="jdbc:mysql://localhost/sampleDB"
user="root" password="pass"/>
<sql:querydataSource="${dbsource}" var="result">
SELECT * from product;
</sql:query>

<center>
<form>
<tableborder="1"width="40%">
<caption>Product List</caption>
<tr>
<th>Product ID</th>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

<th>Product Name</th>
<th>Quantity</th>
<thcolspan="2">Action</th>

</tr>
<c:forEachvar="row" items="${result.rows}">
<tr>
<td><c:outvalue="${row.id}"/></td>
<td><c:outvalue="${row.pname}"/></td>

<td><c:outvalue="${row.quantity}"/></td>
<td><ahref="update.jsp?id=<c:out
value="${row.id}"/>">Update</a></td>
<td><ahref="javascript:confirmGo('Sure to delete this
record?','deletedb.jsp?id=<c:out value="${row.id}"/>')">Delete</a></td>

</tr>
</c:forEach>
</table>
</form>
<ahref="index.jsp">Go Home</a>

</center>
</body>
</html>

5. update.jsp
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page import="java.io.*,java.util.*,java.sql.*"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
<!DOCTYPE html>
<html>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

<head>
<metahttp-equiv="Content-Type"content="text/html; charset=UTF-8">
<title>JSP Page</title>

</head>
<body>
<sql:setDataSourcevar="dbsource"driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/sampleDB"
user="root" password="pass"/>

<sql:querydataSource="${dbsource}"var="result">
SELECT * from product where id=?;
<sql:paramvalue="${param.id}"/>
</sql:query>
<formaction="updatedb.jsp"method="post">

<tableborder="0"width="40%">
<caption>Update Product</caption>
<tr>
<th>Product Name</th>
<th>Quantity</th>

</tr>
<c:forEachvar="row"items="${result.rows}">
<tr>
<td><inputtype="hidden"value="${param.id}"name="id"/>
<inputtype="text"value="${row.pname}"name="pname"/></td>

<td><inputtype="text"value="${row.quantity}"name="qty"/></td>
<td><inputtype="submit"value="Update"/></td>
</tr>
</c:forEach>
</table>
<ahref="index.jsp">Go Home</a>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

</form>
</body>
</html>

6. updatedb.jsp
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page import="java.io.*,java.util.*,java.sql.*"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>

<!DOCTYPE html>
<html>
<head>
<metahttp-equiv="Content-Type"content="text/html; charset=UTF-8">
<title>JSP Page</title>

</head>
<body>
<sql:setDataSourcevar="dbsource"driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/sampleDB"
user="root" password="pass"/>

<sql:updatedataSource="${dbsource}"var="count">
UPDATE product SET pname = ?, quantity=?
WHERE id='${param.id}'
<sql:paramvalue="${param.pname}"/>
<sql:paramvalue="${param.qty}"/>

</sql:update>
<c:iftest="${count>=1}">
<fontsize="5"color='green'> Congratulations ! Data updated
successfully.</font>
<ahref="index.jsp">Go Home</a>
</c:if>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

</body>
</html>

7. deletedb.jsp
<%@ page import="java.io.*,java.util.*,java.sql.*"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
<!DOCTYPE html>
<html>
<head>
<metahttp-equiv="Content-Type"content="text/html; charset=UTF-8">

<title>JSP Page</title>
</head>
<body>
<sql:setDataSourcevar="dbsource"driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/sampleDB"

user="root" password="pass"/>
<sql:updatedataSource="${dbsource}"var="count">
DELETE FROM product
WHERE id='${param.id}'
</sql:update>

<c:iftest="${count>=1}">
<fontsize="5"color='green'> Congratulations ! Data deleted
successfully.</font>
<ahref="index.jsp">Go Home</a>
</c:if>

</body>
</html>

Output:

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

Practical No.6:-
6a. Create a Currency Converter application using EJB.

index.html
<html><head><title>Currency Converter</title></head>
<body>
<form action="CCServlet" >

Enter Amount <input type="text" name="amt"><br>


Select Conversion Type
<input type="radio" name="type" value="r2d" checked>Rupees to Dollar
<input type="radio" name="type" value="d2r" >Dollor to Rupees<br>
<input type="reset" ><input type="submit" value="CONVERT" >

</form>
</body>
</html>

CCServlet.java:
double amt = Double.parseDouble(request.getParameter("amt"));
if(request.getParameter("type").equals("r2d")) { out.println("

"+amt+ " Rupees = "+obj.r2Dollor(amt)+" Dollors


"); }
if(request.getParameter("type").equals("d2r")) { out.println("

"+amt+ " Dollors = "+obj.d2Rupees(amt)+" Rupees


"); }

CCBean:
package mypack;

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

import javax.ejb.Stateless;
@Stateless
public class CCBean {

public CCBean()
{}
public double r2Dollor(double r)
{ return r/65.65; }
public double d2Rupees(double d)

{ return d*65.65; }
}

Output:

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

b) Develop a Simple Room Reservation System Application Using EJB.

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>JSP Page</title>

</head>
<body>
<h1>Enter Details for Room Reservation </h1>
<form method="post" action="ReservServ1"> Customer Name:<input type="text"
name="cname"/> Address:<input type="text" name="cadd"/>
Phone No:<input type="text" name="cphno"/> Room Type:
<select name="roomtype">

<option id="g">General
<option id="d">Deluxe
<option id="s">Suite
</select><br>
Check-In date: <input type="text" name="chkindate"/> Check-Out date: <input type="text"
name="chkoutdate"/> Payment Mode:

<select name="paymode">
<option id="cash">Cash

<option id="credit">Credit Card


</select><br>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

<input type="submit" value="Click to Reserve"/>


<input type="reset" value="Clear All">
</form>

</body>
</html>

ReservationBean.java:-

package ejb;

import java.util.ArrayList; import javax.ejb.LocalBean; import javax.ejb.Stateless; @Stateless


@LocalBean
public class ReservationBean {
public String welcome(String customer)
{ return "Hello "+" "+customer.toUpperCase()+" "+"Welcome to our Hotel"; } public String
roomtype(String roomtype)
{

return "You have selected "+roomtype.toUpperCase()+" "+"Room";


}
public String payment(String roomtype)
{
System.out.println(roomtype); if(roomtype.equalsIgnoreCase("SUITE"))

return "You have to pay Rs 8000";


else if(roomtype.equalsIgnoreCase("DELUXE")) return "You have to pay Rs 4000";
else
return "You have to pay Rs 2000";
}

public ArrayList<String> reserv(String customer, String addr, String ph, String checkin, String
checkout, String roomtype, String paymode)
{

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

ArrayList<String> a=new ArrayList(); a.add(customer);


a.add(addr);
a.add(ph); a.add(checkin); a.add(checkout); a.add(roomtype); a.add(paymode); return a;

}
}

ReservServ1.java:-

package Servlet;

import ejb.ReservationBean; import java.io.IOException; import java.io.PrintWriter; import


java.util.ArrayList;

import javax.ejb.EJB;
import javax.servlet.ServletException; import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest; import
javax.servlet.http.HttpServletResponse; public class ReservServ1 extends HttpServlet {
@EJB ReservationBean bean;

protected void processRequest(HttpServletRequest request, HttpServletResponse response)


throws ServletException, IOException {

response.setContentType("text/html;charset=UTF-8");
String cname,cadd,cphno,roomtype,chkindate,chkoutdate,paymode;
cname=request.getParameter("cname"); cadd=request.getParameter("cadd");
cphno=request.getParameter("cphno"); roomtype=request.getParameter("roomtype");
chkindate=request.getParameter("chkindate");
chkoutdate=request.getParameter("chkoutdate");
paymode=request.getParameter("paymode");
PrintWriter out=response.getWriter(); int i=0;

ArrayList<String> list1=bean.reserv(cname, cadd, cphno, chkindate, chkoutdate,


roomtype,paymode); try

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

bean.reserv(cname, cadd, cphno, chkindate, chkoutdate, roomtype, paymode);


out.println(bean.welcome(cname)+"<br/>"); out.println(bean.roomtype(roomtype)
+"<br/>"); out.println(bean.payment(roomtype) +"<br/>");
out.println("Customer Details:"); int n=list1.size(); out.println("<table border=1>");
out.println("<tr><th>Name</th><th>Address</th><th>Phone No</th><th>Check-
Indate</th><th>Check- Out date</th><th>Room type</th><th>Payment Mode</th></tr>");
out.println("<tr>"); for(i=0;i<n;i++)
{

out.println("<td>"); out.println(list1.get(i)); out.println("</td>");


}
out.println("</tr></table>");
out.println("<br/>Click <a href='index.jsp'> here </a> to go back");
}

finally
{out.close();
}}

Output:-

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

c)Develop simple shopping cart application using EJB [Stateful Session Bean]
Source Code:-
Index.jsp:-

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

<%@page import="javax.naming.directory.InitialDirContext"%>
<%@page import="javax.naming.InitialContext"%>
<%@page import="java.util.Iterator"%>
<%@page import="java.util.List"%>
<%@page import="ejb.ShoppingCart"%>

<!DOCTYPE html>
<%!
private static ShoppingCart cart; public void jspInit()
{
try{

InitialContext ic=new InitialContext();


cart=(ShoppingCart)ic.lookup("java:global/ShoppingCart/ShoppingCart");

}
catch(Exception e)
{
System.out.println("Could not create bean");
}

cart.initialize("Guest");
}
%>
<%
if(request.getParameter("txtcustname")!=null)
cart.initialize(request.getParameter("txtcustname"));

else
cart.initialize("Guest");

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

%>
<%
if (request.getParameterValues("btnremove")!=null)

{
String books[]=request.getParameterValues("chkbook"); if(books!=null)
{
for(int i=0;i<books.length;i++) cart.removebook(books[i]);
}}

if(request.getParameter("btnadd")!=null)
{
String books[]=request.getParameterValues("chkbook");

if(books!=null)

{
for(int i=0;i<books.length;i++) cart.addbook(books[i]);
}
}
%>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>

<body>
<h1>Shopping Cart</h1>
<form name="frmbooks" method="post"> Customer:
<input type="text" name="txtcustname"
value="<%request.getParameter("txtcustname");%>"/><br/> Book Titles:<br/>
<input type="checkbox" name="chkbook" value="C Programming"/>C Programming<br/>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

<input type="checkbox" name="chkbook" value="C++ Programming"/>C++


Programming<br/>
<input type="checkbox" name="chkbook" value="Java Programming"/>Java
Programming<br/>
<input type="checkbox" name="chkbook" value="HTML"/>HTML<br/>
<input type="submit" value="Add" name="btnadd"/>

<input type="submit" value="Remove" name="btnremove"/>


<input type="submit" value="Show" name="btnshow"/>
<br/>
<table border="1">
<tr>

<td>Basket
</tr>
<%
if(request.getParameter("btnshow")!=null)
{

List<String>booklist=cart.getContents(); Iterator iterator=booklist.iterator();


while(iterator.hasNext())

{
String title=(String)iterator.next();
%>
<tr>
<td><%=title %>

</tr>
<%
}}
%>
</table>

</form>
</body>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

</html>

ShoppingCart.java:-

package ejb; import java.sql.*;


import java.util.ArrayList;

import java.util.List;

import java.util.logging.Level; import java.util.logging.Logger; import javax.ejb.Local;


import javax.ejb.Remove; import javax.ejb.Stateful;
/**
* @author PC28
*/ @Stateful

public class ShoppingCart


{
List<String>contents; String custname; Connection con=null; ResultSet rs; Statement st=null;
public void initialize(String person)
{

if(person!=null)
{
custname=person; try{
try {
Class.forName("com.mysql.jdbc.Driver"); try {

con=DriverManager.getConnection("jdbc:mysql://localhost:3306/zakdb","root","1234");

} catch (SQLException ex) {


Logger.getLogger(ShoppingCart.class.getName()).log(Level.SEVERE, null, ex);
}
} catch (ClassNotFoundException ex) {
Logger.getLogger(ShoppingCart.class.getName()).log(Level.SEVERE, null, ex);

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

}}
catch(Exception e){ System.out.println("Connection Failed");
}}

contents=new ArrayList<String>();
}
public void addbook(String title)
{
try{

st=con.createStatement();
st.executeUpdate("insert into cart values('"+custname+"','"+title+"')");
}
catch(Exception e)
{

System.out.println("Failed to insert values to the database ");


}}
public void removebook(String title)
{
try{

st=con.createStatement();
st.executeUpdate("'delete from cart where username='"+custname+"'and
itemname='"+title+"'");
}

catch(Exception e ){ System.out.println("Deletion failed");


}}

public List<String>getContents()
{
try
{
st=con.createStatement();

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

rs=st.executeQuery("select * from cart where username='"+custname+"'"); while(rs.next())


{
contents.add(rs.getString("itemname")); System.out.println(rs.getString("itemname"));

}}
catch(Exception e)
{
System.out.println("Selection Failed");
}

return contents;
}
@Remove
public void remove()
{

contents=null;
}}

Output-

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

Practical No.7:-
a)Develop simple EJB application to demonstrate Servlet Hit count using
Singleton Session Beans.

CntServletHitBeans.java(session bean):-

package ejb;
import javax.ejb.Singleton; @Singleton
public class CntServletHitsBean { private int hitcnt;
public int getHitCnt()

{
return hitcnt++;
}
}

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

ServletClient.java
The servlet client.java file should be created in the same folder as the index.jsp that is Web
pages folder package servlet;
import ejb.CntServletHitsBean; import java.io.IOException; import java.io.PrintWriter;
import static java.lang.System.out; import javax.ejb.EJB;

import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import


javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest; import
javax.servlet.http.HttpServletResponse;

@WebServlet(name = "ServletClient", urlPatterns = {"/ServletClient"}) public class


ServletClient extends HttpServlet {

@EJB CntServletHitsBean counter;


protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

response.setContentType("text/html;charset=UTF-8"); try (PrintWriter out =


response.getWriter()) {

out.println("<h1> number of times this servlet is accessed :<h1>"+counter.getHitCnt());


}
finally { out.close(); } }

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>JSP Page</title>

<meta http-equiv="Refresh" content="0;URL=ServletClient"></head><body>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

<h1>Hello World!</h1> </body></html>

Output:-

b)Develop simple visitor statistics application using Message Driven Bean


[Stateless Session Bean].

VisitorStatBean.java:-

package ejb;
import javax.ejb.Stateless; import javax.ejb.LocalBean; import java.sql.*;

import javax.annotation.PostConstruct; import javax.annotation.PreDestroy; @Stateless


@LocalBean
public class VisitorStatBean
{
Connection con=null; ResultSet rs; Statement st=null; @PostConstruct public void connect()

{
try
{

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost/tyit","root","root");
System.out.println("Database connection established successfully");
}
catch(Exception e)
{

System.out.println("Sorry!!!Failed to connect to the database");


}
}
@PreDestroy

public void disconnect()


{
try
{
con.close();

System.out.println("Database connection closed successfully")


}
catch(Exception e)
{
System.out.println("Sorry!!!Failed to close the connection");

}
}
public void addVisitor(String host)
{
try

{
st=con.createStatement(); rs=st.executeQuery("select * from userstat"); while(rs.next())
{
if(host.equals(rs.getString("hostname")))

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

st.executeUpdate("update userstat set visits = visits + 1 where hostname='"+host+"'");


}
st.executeUpdate("insert into userstat(hostname,visits)values('"+host+"','1')");

}
catch(Exception e)
{
System.out.println("Can't Update");
}

}
}

BasicMsgBean.java:-

package ejb;
import javax.ejb.ActivationConfigProperty; import javax.annotation.Resource;
import javax.ejb.EJB;
import javax.ejb.MessageDriven;
import javax.ejb.MessageDrivenContext; import javax.jms.Message;

import javax.jms.MessageListener; import javax.jms.TextMessage;


@MessageDriven(mappedName = "jms/Queue", activationConfig = {
@ActivationConfigProperty(propertyName = "acknowledgeMode", propertyValue = "Auto-
acknowledge"), @ActivationConfigProperty(propertyName = "destinationType",
propertyValue = "javax.jms.Queue")

} public class BasicMsgBean implements MessageListener


{ @EJB
VisitorStatBean vs; @Resource MessageDrivenContext mdc public BasicMsgBean() {
}
@Override

public void onMessage(Message message)

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

{
TextMessage msg=null; try
{

if(message instanceof TextMessage)


{
msg=(TextMessage)message; vs.addVisitor(msg.getText());
}
}

catch(Exception e)
{
e.printStackTrace(); mdc.setRollbackOnly();
}
catch(Throwable te)

{
te.printStackTrace();
}
}
}

index.jsp:-

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


import="javax.naming.InitialContext,javax.jms.Connection,javax.jms.ConnectionFactory,java
x.jms.Destinat
ion,javax.jms.JMSException,javax.jms.MessageProducer,javax.jms.Queue,javax.jms.Session,j
avax.jms.Text Message"%>
<!DOCTYPE html>
<%!
ConnectionFactory confact; Queue q;
Connection con=null; Session s=null; MessageProducer mp=null; TextMessage msg=null;

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

%>
<html>
<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">


<title>JSP Page</title>
</head>
<body>
<h1>Hello World!!!!</h1>

<%
try
{
InitialContext ic=new InitialContext(); q=(Queue)ic.lookup("jms/Queue");
confact=(ConnectionFactory)ic.lookup("jms/QueueFactory");
con=confact.createConnection();
s=con.createSession(false, Session.AUTO_ACKNOWLEDGE); mp=s.createProducer(q);
msg=s.createTextMessage();

msg.setText(request.getRemoteAddr()); mp.send(msg);
}
catch(Exception e)
{

System.out.println(e);
}
%>
</body>
</html>

Database tables for the Message-Driven Bean

create database tyit; use tyit;

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

create table userstat(firstvisitdt timestamp, hostname varchar(30), visits int(3));


mysql> select * from userstat;

+ + + +
| firstvisitdt | hostname | visits |
+ + + +
| 2018-06-28 22:14:36 | 127.0.0.1 | 11 |
+ + + +1 row in set (0.02 sec)

Output:-

c)Develop simple Marks Entry Application to demonstrate accessing


Database using EJB.

index.jsp:-

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


<!DOCTYPE html>
<html>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>

</head>
<body>

<form method="post" action="MarkentryServ">


<h1> enter student records</h1> student roll no:

<input type="text" name="txtno"></br> Student name :


<input type="text" name="txtname"></br> Paper 1 (software Project management):
<input type="text" name="txtp1"></br> Paper 2(Internet of Things):
<input type="text" name="txtp2"></br> Paper 3 (ad. web Programming):
<input type="text" name="txtp3"></br> Paper4 (artificial intelligence):

<input type="text" name="txtp4"></br> Paper 5(Enterprise java):


<input type="text" name="txtp5"></br>
<input type="submit" value="submit"/>
</form>
</body>

</html>

MarksEntry.java(session Bean stateless):-

package ejb; import java.sql.*;


import javax.ejb.Stateless; @Stateless
public class MarksEntry {
public void entry (String srollno,String sname,String p1,String p2,String p3,String p4,String
p5)
{

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

Connection con=null; Statement st=null; ResultSet rs=null; try{


Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/student_database","root",
"1234"); st=con.createStatement();
st.executeUpdate("insert into marks
values('"+srollno+"','"+sname+"','"+p1+"','"+p2+"','"+p3+"','"+p4+"','"+p5+"')");
}
catch(Exception e)

{System.out.println(e);
}}
public String submit(String name){
return name.toUpperCase()+" s record is submitted";}}

MarkentryServ.java(servlet page):-

package Servlet; import ejb.MarksEntry;


import java.io.IOException; import java.io.PrintWriter; import javax.ejb.EJB;
import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet;


import javax.servlet.http.HttpServletRequest; import
javax.servlet.http.HttpServletResponse; import org.jboss.weld.util.bytecode.DescriptorUtils;
@WebServlet(name = "MarkentryServ", urlPatterns = {"/MarkentryServ"}) public class
MarkentryServ extends HttpServlet {
@EJB MarksEntry bean;
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8"); try (PrintWriter out =
response.getWriter()) {
String id,name,p1,p2,p3,p4,p5; id=request.getParameter("txtno");
name=request.getParameter("txtname"); p1=request.getParameter("txtp1");
p2=request.getParameter("txtp2"); p3=request.getParameter("txtp3");

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

p4=request.getParameter("txtp4"); p5=request.getParameter("txtp5"); bean.entry(id,


name, p1, p2, p3, p4, p5);
out.println(bean.submit(name)); }} }

Output:-

After putting the values and clicking submit .”the user name will appear in upper case:

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

Practical No.9

a)Develop a Hibernate application to store Feedback of Website Visitor in


MySQL Database

Index.html:-

<html>
<head>
<title>TODO supply a title</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
</head>
<body>
<form action="insert.jsp">

<h3>Enter your name</h3>


<input type="text" name="txtName">
<h3>Enter your Feedback</h3>
<textarea cols="15" rows="15" name="txtFeed"></textarea>
<input type="submit" value="submit"/>

</form>
</body>
</html>

Insert.jsp:-

<%@page import="mypack.VisitBean"%>
<%@page import="org.hibernate.Transaction"%>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

<%@page import="org.hibernate.cfg.Configuration"%>
<%@page import="org.hibernate.SessionFactory"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>

<!DOCTYPE html>
<%!
SessionFactory sf; org.hibernate.Session hibSession;
%>
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>

<%
sf=new Configuration().configure().buildSessionFactory(); hibSession=sf.openSession();
Transaction tx=null;
VisitBean eb=new VisitBean(); try
{

tx=hibSession.beginTransaction(); eb.setName(request.getParameter("txtName"));

eb.setFeedback(request.getParameter("txtFeed")); hibSession.save(eb);
tx.commit();
out.println("<h1>record inserted successfully "); out.println("<a href='fetch.jsp'>Click
here</a>");
}

catch(Exception e)
{
out.println(e);
}
%>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

</body>
</html>

VisitBean.java:-

package mypack;
import java.io.Serializable; import javax.persistence.Entity; import javax.persistence.Id;
import javax.persistence.*;

@Entity @Table(name="visitor")
public class VisitBean implements Serializable { @Id
@GeneratedValue @Column(name="id") private String id; @Column(name="vname")
private String name; @Column(name="feedback") private String feedback;

public VisitBean(){}
public VisitBean(String name, String feedback){ this.name=name;

this.feedback=feedback;
}
public String getId()
{
return id;
}
public String getName()
{
return name;
}

public String getFeedback()


{ return feedback; } public void setId(String id1)
{ id=id1; }

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

public void setName(String name1)


{ name=name1; }
public void setFeedback(String f)

{ feedback=f; } } Fetch.jsp
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<%@page import =" javax.servlet.http.*,javax.servlet.*"contentType="text/html"
pageEncoding="UTF- 8"%>
<%@page import="java.io.*,java.util.*,java.sql.*" %>

<!DOCTYPE html>
<html> <head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head> <body>

<sql:setDataSource var="db" driver="com.mysql.jdbc.Driver"


url="jdbc:mysql://localhost/visitordb" user="root" password="1234"/>
<sql:query dataSource="${db}" var="rs"> select * from visitor;
</sql:query>
<table border="1" width="75%">
<tr>

<th>Visitor Id
<th>Visitor Name
<th>Visitor Feedback
</tr>
<c:forEach var="table" items="${rs.rows}">

<tr>
<td><c:out value="${table.id}"/>
<td><c:out value="${table.vname}"/>
<td><c:out value="${table.feedback}"/>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

</tr>
</c:forEach>
</table>

</body>
</html>

Output:-

b)Develop a Hibernate application to store and retrieve employee details in


MySQL Database.

Index.html:-

<!DOCTYPE html>
<html>
<head>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

<title>TODO supply a title</title>


<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">

</head>
<body>
<form action="insert.jsp">
<table border="1">
<tr><td>Enter Employee Name</td>

<td><input type="text" name="txtName"></td></tr>


<tr><td>Enter Employee Designation</td>
<td><input type="text" name="txtDes"></td></tr>
<tr><td>Enter Employee Department</td>
<td><input type="text" name="txtDept"></td></tr>

<tr><td>Enter Employee Salary</td>


<td><input type="text" name="txtSal"></td></tr>
<tr><td><input type="reset"></td>
<td><input type="submit" value="register"></td></tr>
</table>

</form>
</body>
</html>

Insert.jsp:-

<%@page import="mypack.EmpBean"%>
<%@page import="org.hibernate.Transaction"%>
<%@page import="org.hibernate.cfg.Configuration"%>
<%@page import="org.hibernate.SessionFactory"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

<!DOCTYPE html>
<%!
SessionFactory sf; org.hibernate.Session hibSession;

%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>

</head>
<body>
<%
sf=new Configuration().configure().buildSessionFactory(); hibSession=sf.openSession();
Transaction tx=null;

EmpBean eb=new EmpBean(); try

{
tx=hibSession.beginTransaction(); eb.setName(request.getParameter("txtName"));
eb.setDesg(request.getParameter("txtDes")); eb.setDept(request.getParameter("txtDept"));
eb.setSal(request.getParameter("txtSal")); hibSession.save(eb);
tx.commit();
out.println("<h1>record inserted successfully "); out.println("<a href='fetch.jsp'>Click
here</a>");
}

catch(Exception e)
{
out.println(e);
}
%>

</body>
</html>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

EmpBean.java:-

package mypack;
import javax.persistence.Entity; import javax.persistence.Id; import javax.persistence.*;
@Entity @Table(name="emptab")
public class EmpBean implements java.io.Serializable
{
@Id @GeneratedValue
@Column(name="EmpId") private String no;

@Column (name="EmpName") private String name;


@Column (name="EmpDesg") private String desg;
@Column (name="EmpDept") private String dept;
@Column (name="EmpSal") private String sal;
public EmpBean()

{}
public EmpBean(String en, String ed1, String ed2, String es)
{
this.name=en; this.dept=ed2; this.desg=ed1; this.sal=es;
}

public String getNo()


{ return no; }
public String getName()
{ return name;}
public String getDesg()

{ return desg; }
public String getDept()
{ return dept; } public String getSal()

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

{ return sal;}
public void setNo(String n)
{ no=n; }

public void setName(String nm)


{ name = nm; }

public void setDesg(String dg)

{ desg = dg; }

public void setDept(String dp)


{ dept = dp; }

public void setSal(String sl)


{ sal = sl; } }

Hibernate.cfg.xml:-

<mapping class="mypack.EmpBean"></mapping>

Fetch.jsp
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<%@page import =" javax.servlet.http.*,javax.servlet.*"contentType="text/html"
pageEncoding="UTF- 8"%>
<%@page import="java.io.*,java.util.*,java.sql.*" %>

<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

<title>JSP Page</title>
</head>
<body>

<sql:setDataSource var="db" driver="com.mysql.jdbc.Driver"


url="jdbc:mysql://localhost/empdb" user="root" password="1234"/>

<sql:query dataSource="${db}" var="rs"> select * from emptab;


</sql:query>
<table border="1" width="100%">
<tr>
<th>Employee Id

<th>Name
<th>Designation
<th>Department
<th>Salary
</tr>

<c:forEach var="table" items="${rs.rows}">


<tr>
<td><c:out value="${table.EmpId}"/>
<td><c:out value="${table.EmpName}"/>
<td><c:out value="${table.EmpDesg}"/>

<td><c:out value="${table.EmpDept}"/>

<td><c:out value="${table.EmpSal}"/>
</tr>
</c:forEach>

</table>
</body>
</html>

ROLL NO.14
CHANDRABHAN SHARMA ENTERPRISE JAVA

Output:-

ROLL NO.14

You might also like