AJAVA Practicals-Meet
AJAVA Practicals-Meet
Practical 3
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
}
catch(ClassNotFoundException e) {
System.out.println("ClassNot:"+e.getMessage());
e.printStackTrace();
}
catch(SQLException e) {
System.out.println("SQL:"+e.getMessage());
e.printStackTrace();
}
}
}
Output:
import java.io.BufferedReader;
1|Page
Patel Meet B 200280107101
import java.io.IOException;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
ps.setString(1, name);
ps.setInt(2, price);
ps.setString(3, author);
ps.setString(4, lan);
int result = ps.executeUpdate();
if (result != 0) {
System.out.println("Values inserted in the table");
} else {
System.out.println("Values are not inserted in table");
}
}
conn.close();
} catch (ClassNotFoundException e) {
System.out.println("ClassNot:" + e.getMessage());
e.printStackTrace();
} catch (SQLException e) {
System.out.println("SQL:" + e.getMessage());
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
}
Output:
2|Page
Patel Meet B 200280107101
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
3|Page
Patel Meet B 200280107101
try {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/info", "root",
"1234");
System.out.println("Conection Successful");
BufferedReader inputReader = new BufferedReader(new InputStreamReader(System.in));
System.out.println("Name of book which price you want to change?");
String name = inputReader.readLine();
System.out.println("New Price:");
} catch (ClassNotFoundException e) {
System.out.println("ClassNot:" + e.getMessage());
e.printStackTrace();
} catch (SQLException e) {
System.out.println("SQL:" + e.getMessage());
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
Output:
4|Page
Patel Meet B 200280107101
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
} catch (ClassNotFoundException e) {
System.out.println("ClassNot:" + e.getMessage());
e.printStackTrace();
} catch (SQLException e) {
System.out.println("SQL:" + e.getMessage());
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
}
Output:
5|Page
Patel Meet B 200280107101
5) Create a GUI window Application using JDialog(java class) to search a book by title and/or author.
This GUI window has a search button and two text fields to search a book by title and/or author.
➢ Input:
package practicals1_5;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import javax.swing.JButton;
import javax.swing.JDialog;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JTextField;
Practical1_5() {
JFrame f = new JFrame();
d = new JDialog(f, "Dialog Example", true);
d.setLayout(new FlowLayout());
JButton b = new JButton("Search");
b.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
Practical1_5.d.setVisible(false);
6|Page
Patel Meet B 200280107101
if (author.length() > 0) {
// Title & Author
String query = "SELECT * FROM Books " + "WHERE author = ?&&”
+”name = ? ";
try {
pstmt = conn.prepareStatement(query);
pstmt.setString(1, author);
pstmt.setString(2, title);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
System.out.println("Book name: " + rs.getString(2) +
"\nBook Price: " + rs.getString(3)
+ "\nBook Author: " +
rs.getString(4) + "\nBook Language: " + rs.getString(5)
+ "\n");
}
} catch (SQLException e1) {
e1.printStackTrace();
}
} else {
// Title
String query = "SELECT * FROM Books " + "WHERE name =?";
try {
pstmt = conn.prepareStatement(query);
pstmt.setString(1, title);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
System.out.println("Book name: " + rs.getString(2) +
"\nBook Price: " + rs.getString(3)
+ "\nBook Author: " +
rs.getString(4) + "\nBook Language: " + rs.getString(5)
+ "\n");
}
} catch (SQLException e1) {
e1.printStackTrace();
}
}
} else {
if (author.length() > 0) {
// Author
String query = "SELECT * FROM Books " + "WHERE author = ?";
try {
pstmt = conn.prepareStatement(query);
pstmt.setString(1, author);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
System.out.println("Book name: " + rs.getString(2) +
"\nBook Price: " + rs.getString(3)
+ "\nBook Author: " +
rs.getString(4) + "\nBook Language: " + rs.getString(5)
+ "\n");
}
} catch (SQLException e1) {
e1.printStackTrace();
}
}
}
}
});
7|Page
Patel Meet B 200280107101
d.add(new JLabel("Title"));
d.add(searchBox_title);
d.add(new JLabel("Author"));
d.add(searchBox_author);
d.add(b);
d.setSize(300, 300);
d.setVisible(true);
}
}
Output:
8|Page
Patel Meet B 200280107101
9|P age
Patel Meet B 200280107101
Practical 4
➢ Input:
Index.html:
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Date</title>
</head>
<body>
<form action="DateServlet " method="get">
<input type="submit" value="Print Current date and time">
</form>
</body>
</html>
DateServlet.java:
import java.io.IOException;
import java.io.PrintWriter;
import java.util.Date;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet("/DateServlet")
public class DateServlet extends HttpServlet {
PrintWriter pWriter;
try {
res.setContentType("text/html");
pWriter = res.getWriter();
Date date = new Date();
pWriter.print("Current date and time is: " + date.toString());
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
Web.xml:
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
id="WebApp_ID" version="3.1">
<display-name>practical4</display-name>
</web-app>
10 | P a g e
Patel Meet B 200280107101
Output:
11 | P a g e
Patel Meet B 200280107101
Practical 5
concept of session
Index.html:
<!DOCTYPEhtml>
<html>
<head>
<metacharset="ISO-8859-1">
<title>Shopping Cart</title>
</head>
<bodybackground="https://encrypted-
tbn0.gstatic.com/images?q=tbn:ANd9GcSIT3xETG2JrdTxbIRh1tflPoqK2AuCl5- hEQ&usqp=CAU">
<h1style="font-family: verdana;background-color: red;text-align:center">Welcome to
Mall</h1>
<pstyle="font-family: courier;background-color: green;text-align:center">Login for
continue</p>
<formaction="login.html">
<buttontype="submit"formaction="login.html"style="margin-left:
550px">Login</button>
</form>
</body>
</html>
Login.html:
<!DOCTYPEhtml>
<html>
<head>
<metacharset="ISO-8859-1">
<title>Login</title>
</head>
<bodystyle="background-color: powderblue;">
<formaction="SessionDemo"method="POST">
Username: <inputtype="text"name="username"placeholder="username">
<br><br>
Password: <inputtype="password"name="pass"placeholder="password">
<br><br>
<inputtype="submit"name="submit"value="submit">
</form>
12 | P a g e
Patel Meet B 200280107101
</body>
</html>
Books.html
<!DOCTYPEhtml>
<html>
<head>
<metacharset="ISO-8859-1">
<title>Books</title>
</head>
<bodybackground="https://encrypted-
tbn0.gstatic.com/images?q=tbn:ANd9GcSIT3xETG2JrdTxbIRh1tflPoqK2AuCl5- hEQ&usqp=CAU">
<h1style="font-family: verdana;background-color: red;text-align:center">Welcome to Modi
Shopping Mall</h1>
<formaction="SessionManagement">
</body>
</html>
Headphones.html
<!DOCTYPEhtml>
13 | P a g e
Patel Meet B 200280107101
<html>
<head>
<metacharset="ISO-8859-1">
<title>Headphones</title>
</head>
<bodybackground="https://encrypted-
tbn0.gstatic.com/images?q=tbn:ANd9GcSIT3xETG2JrdTxbIRh1tflPoqK2AuCl5- hEQ&usqp=CAU">
<h1style="font-family: verdana;background-color: red;text-align:center">Welcome to
Mall</h1>
<formaction="SessionManagement">
Clothes.html
<!DOCTYPEhtml>
<html>
<head>
<metacharset="ISO-8859-1">
<title>Clothes</title>
</head>
<bodybackground="https://encrypted-
tbn0.gstatic.com/images?q=tbn:ANd9GcSIT3xETG2JrdTxbIRh1tflPoqK2AuCl5- hEQ&usqp=CAU">
<h1style="font-family: verdana;background-color: red;text-align:center">Welcome to
Mall</h1>
<formaction="SessionManagement">
14 | P a g e
Patel Meet B 200280107101
</body>
</html>
SessionDemo.java
package practical5;
importjava.io.IOException;
importjava.io.PrintWriter;
importjavax.servlet.ServletException;
importjavax.servlet.annotation.WebServlet;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
importjavax.servlet.http.HttpSession;
@WebServlet("/SessionDemo")
publicclassSessionDemoextendsHttpServlet {
privatestaticfinallongserialVersionUID = 1L;
publicSessionDemo() {
super();
// TODO Auto-generated constructor stub
15 | P a g e
Patel Meet B 200280107101
protectedvoiddoGet(HttpServletRequestrequest, HttpServletResponseresponse)
throwsServletException, IOException {
// TODO Auto-generated method stub
protectedvoiddoPost(HttpServletRequestrequest, HttpServletResponseresponse)
throwsServletException, IOException {
// TODO Auto-generated method stub
String username=request.getParameter("username");String
pass=request.getParameter("pass"); if(username.isBlank() ||
pass.isBlank())
{
PrintWriterout=response.getWriter();
response.setContentType("text/html");
out.println("<h3>Enter username and
password...</h3>");
response.sendRedirect("login.html");
}
else
{
HttpSessionsession=request.getSession();
session.setAttribute("username",username);
response.setContentType("text/html"); PrintWriterout=
response.getWriter(); out.println("<html>");
out.println("<body background=\"https://encrypted-
tbn0.gstatic.com/images?q=tbn:ANd9GcSIT3xETG2JrdTxbIRh1tflPoqK2AuCl5
-hEQ&usqp=CAU\">");
out.println("<h1 style=\"font-family: cursive;background-color:powderblue;text-
align: center\">Modi Shopping Website</h1><br><hr><br><br><br>");
out.println("<div style=\"font-family:
verdana;background-color: red;text-align: center\">");
out.println("<a
href=\"headphones.html\">Headphones</a><br><br>");
out.println("<a
href=\"clothes.html\">Clothes</a><br><br>");
out.println("<a
href=\"books.html\">Books</a><br><br>");
out.println("</div>");
16 | P a g e
Patel Meet B 200280107101
out.println("</body>");
out.println("</html>");
}
}
SessionManagement.java
package practical5;
importjava.io.IOException;
importjava.io.PrintWriter;
importjava.util.ArrayList;
importjavax.servlet.ServletException;
importjavax.servlet.annotation.WebServlet;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
importjavax.servlet.http.HttpSession;
importpractical5.Product;
@WebServlet("/SessionManagement")
publicclassSessionManagementextendsHttpServlet {
privatestaticfinallongserialVersionUID = 1L;
publicSessionManagement() {
super();
// TODO Auto-generated constructor stub
}
protectedvoiddoGet(HttpServletRequestrequest, HttpServletResponseresponse)
throwsServletException, IOException
{
String productType=request.getParameter("product");String[]
selectedProduct =
request.getParameterValues("product"); HttpSessionsession =
request.getSession();
17 | P a g e
Patel Meet B 200280107101
ArrayList<Product>items = (ArrayList<Product>)
session.getAttribute("items");
if(items != null) {
if(selectedProduct.length> 0) {
for (String product : selectedProduct) { Product item =
newProduct(product, 2000);items.add(item);
}
}
}else {
items = newArrayList<Product>();
if(selectedProduct.length> 0) {
for (String product : selectedProduct) { Product item =
newProduct(product, 2000);items.add(item);
}
}
session.setAttribute("items", items);
}
session.setAttribute("items", items);
// response.sendRedirect("SessionDemo");
//request.getRequestDispatcher("SessionDemo").forward(request,response);
response.setContentType("text/html");
PrintWriterout= response.getWriter();
out.println("<html>");
out.println("<body background=\"https://encrypted-
tbn0.gstatic.com/images?q=tbn:ANd9GcSIT3xETG2JrdTxbIRh1tflPoqK2AuCl5
-hEQ&usqp=CAU\">");
out.println("<h1 style=\"font-family: cursive;background-color:powderblue;text-
align: center\">Modi Shopping Website</h1><br><hr><br><br><br>");
out.println("<div style=\"font-family:
verdana;background-color: red;text-align: center\">");
out.println("<a
href=\"headphones.html\">Headphones</a><br><br>");
out.println("<a
href=\"clothes.html\">Clothes</a><br><br>");
out.println("<a href=\"books.html\">Books</a><br><br>");
out.println("<form action=\"Checkout\">"); out.println("<input
type=\"submit\" name=\"Checkout\"
value=\"Checkout\">");
out.println("</form>");
18 | P a g e
Patel Meet B 200280107101
out.println("</div>");
out.println("</body>");
out.println("</html>");
}
protectedvoiddoPost(HttpServletRequestrequest, HttpServletResponseresponse)
throwsServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}
Checkout.java
package practical5;
importjava.io.IOException;
importjava.io.PrintWriter;
importjava.util.ArrayList;
importjavax.servlet.ServletException;
importjavax.servlet.annotation.WebServlet;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
importjavax.servlet.http.HttpSession;
importpractical5.Product;
@WebServlet("/Checkout")
publicclass Checkout extendsHttpServlet {
privatestaticfinallongserialVersionUID = 1L;
public Checkout() {
super();
// TODO Auto-generated constructor stub
}
protectedvoiddoGet(HttpServletRequestrequest, HttpServletResponseresponse)
throwsServletException, IOException {
// TODO Auto-generated method stub
19 | P a g e
Patel Meet B 200280107101
intcounter = 0;
HttpSessionsession = request.getSession(); ArrayList<Product>items =
(ArrayList<Product>)
session.getAttribute("items");
response.setContentType("text/html");
PrintWriterout = response.getWriter();
out.println("<html>");
out.println("<head><title>Checkout page</title></head>"); out.println("<body
background=\"https://encrypted-
tbn0.gstatic.com/images?q=tbn:ANd9GcSIT3xETG2JrdTxbIRh1tflPoqK2AuCl5
-hEQ&usqp=CAU\">");
out.println("<table style=\"background-color: orange;margin-left:550px;padding: 20px
20px20px 20px\">");
out.println("<tr>"); out.println("<th>Serial
no</th>"); out.println("<th>Product
Name</th>");out.println("<th>Price</th>");
out.println("</tr>");
for (Product product : items) {
out.println("<tr>");
out.println("<td>"+ (counter++) +"</td>");out.println("<td>"+
product.getProductName()+"</td>");
out.println("<td>"+ product.getProductPrice()
+"</td>");
out.println("</tr>");
}
out.println("</table>");
out.println("</body>");
out.println("</html>");
protectedvoiddoPost(HttpServletRequestrequest, HttpServletResponseresponse)
throwsServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}
Product.java
20 | P a g e
Patel Meet B 200280107101
package practical5;
publicclass Product {
Output:
21 | P a g e
Patel Meet B 200280107101
<!DOCTYPEhtml>
<html>
<head>
<metacharset="ISO-8859-1">
<title>Cookie Demo</title>
</head>
<body>
<formaction="Servlet1"method="post">
First Name:<inputtype="text"name="firstname"/><br/>Last
Name:<inputtype="text"name="lastname"/><br/>
<inputtype="submit"value="submit"/>
</form>
</body>
</html>
Servlet1.java
package practical5;
importjava.io.IOException;
importjava.io.PrintWriter;
importjavax.servlet.ServletException;
importjavax.servlet.annotation.WebServlet;
importjavax.servlet.http.Cookie;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
22 | P a g e
Patel Meet B 200280107101
@WebServlet("/Servlet1")
publicclass Servlet1 extendsHttpServlet {
privatestaticfinallongserialVersionUID = 1L;
public Servlet1() {
super();
// TODO Auto-generated constructor stub
}
protectedvoiddoPost(HttpServletRequestrequest, HttpServletResponseresponse)
throwsServletException, IOException
{
try{
response.setContentType("text/html"); PrintWriterout =
response.getWriter();
String firstname=request.getParameter("firstname");String
lastname=request.getParameter("lastname");
out.print("Welcome "+firstname+" "+lastname);
Cookie fn=newCookie("firstname",firstname);//creating
cookie object
Cookie ln=newCookie("lastname",lastname);
response.addCookie(fn);//adding cookie in the response
response.addCookie(ln);
out.close();
}catch(Exception e){System.out.println(e);}
}
Servlet2.java
23 | P a g e
Patel Meet B 200280107101
package practical5;
importjava.io.IOException;
importjava.io.PrintWriter;
importjavax.servlet.ServletException;
importjavax.servlet.annotation.WebServlet;
importjavax.servlet.http.Cookie;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
@WebServlet("/Servlet2")
publicclass Servlet2 extendsHttpServlet {
privatestaticfinallongserialVersionUID = 1L;
public Servlet2() {
super();
// TODO Auto-generated constructor stub
}
protectedvoiddoGet(HttpServletRequestrequest, HttpServletResponseresponse)
throwsServletException, IOException
{
try{
response.setContentType("text/html"); PrintWriterout =
response.getWriter();
out.close();
}catch(Exception e){System.out.println(e);}
}
}
Output:
24 | P a g e
Patel Meet B 200280107101
25 | P a g e
Patel Meet B 200280107101
Practical 6
➢ Input:
Index.html:
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<form action="add" method="get">
Enter 1st no. <input type="text" name="num1">
Enter 2nd no. <input type="text" name="num2"><br><br>
<input type="submit" value="submit">
</form>
</body>
</html>
Filter_1.java:
package practical6;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.annotation.WebFilter;
@WebFilter({"/Filter_1","/add"} )
public class Filter_1 implements Filter {
/**
* Default constructor.
*/
26 | P a g e
Patel Meet B 200280107101
public Filter_1() {
// TODO Auto-generated constructor stub
}
Filter_2.java:
package practical6;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.annotation.WebFilter;
27 | P a g e
Patel Meet B 200280107101
AddServlet.java:
package practical6;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet("/AddServlet")
public class AddServlet extends HttpServlet {
28 | P a g e
Patel Meet B 200280107101
29 | P a g e
Patel Meet B 200280107101
Practical 7
Input-
FILE : TagDemonstrate.jsp
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ page import="java.util.Date" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
Scriptlet tag: <br><% out.print("welcome to jsp"); %>
<br>
<br>
Expression tag: <br> Today is: <%= new Date() %>
<br>
<br>
Declaration tag: <br>
<%! int data=50; %>
<%= "Value of the variable is:"+data %>
</body>
</html>
Output-
30 | P a g e
Patel Meet B 200280107101
Input-
FILE: Request.jsp
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Echoing HTML Request Parameters</title>
</head>
<body>
<h3>Choose an author:</h3>
<form method="get">
<input type="checkbox" name="author" value="Tan Ah Teck">Tan
<input type="checkbox" name="author" value="Mohd Ali">Ali
<input type="checkbox" name="author" value="Kumar">Kumar
<input type="submit" value="Query">
</form>
<%
String[] authors = request.getParameterValues("author");
if (authors != null) {
%>
<h3>You have selected author(s):</h3>
<ul>
<%
for (int i = 0; i < authors.length; ++i) {
%>
<li><%= authors[i] %></li>
<%
}
%>
</ul>
<a href="<%= request.getRequestURI() %>">BACK</a>
<%
}
31 | P a g e
Patel Meet B 200280107101
%>
</body>
</html>
Output-
32 | P a g e
Patel Meet B 200280107101
33 | P a g e