Java Servlet Login and Registration
Uploaded by
niteshsemwal15Java Servlet Login and Registration
Uploaded by
niteshsemwal15SYCS22 Practical 1 Date:
ADVANCED JAVA PROGRAMMING
PRACTICAL 1
AIM: Write a Java application to demonstrate servlet life cycle.
[Link]
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
public class NewServlet implements Servlet{
@Override
public void destroy()
{ [Link]("Servlet is
destroyed");
}
@Override
public ServletConfig getServletConfig()
{ return null;
}
@Override
public void init(ServletConfig arg) throws ServletException{
[Link]("Server");
}
@Override
public void service(ServletRequest arg, ServletResponse arg1) throws
ServletException{ [Link]("Servlet service is invoked");
}
@Override
public String getServletInfo()
{ return null;
}
}
OUTPUT:
pg. 1
PRACTICAL 2
Aim: Crete a servlet for login Page
[Link]
Code:
<html>
<head>
<title>Login | Page</title>
<link rel="stylesheet" type="text/css" href="[Link]">
</head>
<body>
<div class="container">
<h2>Sign in</h2>
<form action="Login_Servlet" method="post">
<div class="inputbox">
<input type="text" name="myname" id="name" required="required" />
<span>Full Name</span>
</div>
<div class="inputbox">
<input type="text" name="mypwd" id="email" required="required" />
<span>Password</span>
</div>
<div class="inputbox">
<input type="submit" value="sign in" id="mybtn" />
</div>
</form>
</div>
</body>
</html>
[Link] (Servlet for Login Page)
Code:
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
public class Login_Servlet extends HttpServlet {
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
[Link]("text/html;charset=UTF-8");
try ( PrintWriter out = [Link]()) {
String n = [Link]("myname");
String p = [Link]("mypwd");
[Link]("UserName: " + n + "\nPassword: " + p);
if("Furkan123".equals(n) && "pass123".equals(p)){
RequestDispatcher rd = [Link]("finalservlet");
[Link](request, response);
2
}
else{
[Link]("UserName or Password is invalid...");
RequestDispatcher rd = [Link]("[Link]"); // For
Sending the o to another page
[Link](request, response);
}
}
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
@Override
public String getServletInfo()
{ return "Short description";
}
Final [Link] (for redirection serverlet)
Code:
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
public class finalservlet extends HttpServlet {
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
[Link]("text/html;charset=UTF-8");
try ( PrintWriter out = [Link]()) {
[Link]("<!DOCTYPE html>");
[Link]("<html>");
[Link]("<head>");
[Link]("<title>Servlet finalservlet</title>");
[Link]("</head>");
[Link]("<body>");
String n = [Link]("myname");
[Link]("<h1>");
[Link]("Welcome " + n);
[Link]("</h1>");
[Link]("<h1>Servlet finalservlet at " + [Link]() + "</h1>");
[Link]("</body>");
[Link]("</html>");
}
}
3
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response) }
@Override
public String getServletInfo() { return "Short description";
}
Output:
If Login Credentials are correct then:
If Login Credentials are
invalid:
4
PRACTICAL 3:
[Link]
Code:
<html>
<head>
<title>Login | Page</title>
<link rel="stylesheet" href="[Link]">
</head>
<body>
<div class="container">
<h2>Sign Up</h2>
<form action="registration" method="post">
<div class="inputbox">
<input type="text" name="myname" id="name" required="required" />
<span>Full Name</span>
</div>
<div class="inputbox">
<input type="email" name="myemail" id="email" required="required" />
<span>Email Address</span>
</div>
<div class="inputbox">
<input type="tel" name="myphone" id="getphone" required="required" />
<span>Contact</span>
</div>
<div style="margin-bottom: 25px">
<input type="radio" name="myradio" id="getgender" value="male" />Male
<input type="radio" name="myradio" id="getgender" style="margin-left: 5px"
value="female"/>Female
<input type="radio" name="myradio" id="getgender" style="margin-left: 5px"
value="other" />Other
</div>
<div class="inputbox">
<p>Course</p>
<select name="getcourse">
<option value="select">select</option>
<option value="CS">CS</option>
<option value="IT">IT</option>
<option value="Data Science">Data Science</option>
<option value="BlockChain">BlockChain</option>
</select>
</div>
<div class="inputbox">
<input type="submit" value="sign up" id="mybtn" />
</div>
</form>
5
</div>
</body>
</html>
6
[Link] (servlet for [Link])
Code:
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
[Link]("text/html;charset=UTF-8");
try ( PrintWriter out =
[Link]()) { String n =
[Link]("myname"); String eml =
[Link]("myemail"); String phn =
[Link]("myphone"); String gnd =
[Link]("myradio"); String cur =
[Link]("getcourse");
if ([Link]() || [Link]() || [Link]() || "select".equals(cur) ||
[Link]()) {
[Link]("<h2 style='color: red;'>Please Fill Complete Form...</h2>");
RequestDispatcher rd = [Link]("[Link]"); // For
Sending the object to another page
[Link](request, response);
}
else{
[Link]("<center>");
[Link]("<h2 style='color: red;'>Registration Succssesful</h2>");
[Link]("<i>Your Details...</i>");
[Link]("<h3>Name: " + n + "</h3>");
[Link]("<h3>Contact: " + phn + "</h3>");
[Link]("<h3>E-mail: " + eml + "</h3>");
[Link]("<h3>Gender: " + gnd + "</h3>");
[Link]("<h3>Field: " + cur + "</h3>");
}
}
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
7
}
@Override
public String getServletInfo()
{ return "Short description";
}
Output:
If all the fields are filled:
8
If any of field is missing
[Link]
Code:
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="4.0"
xmlns="[Link]
xmlns:xsi="[Link]
xsi:schemaLocation="[Link]
[Link]
<servlet>
<servlet-name>NewServlet</servlet-name>
<servlet-class>NewServlet</servlet-class>
</servlet>
<servlet>
<servlet-name>My_Server</servlet-name>
<servlet-class>My_Server</servlet-class>
</servlet>
<servlet>
<servlet-name>Login_Servlet</servlet-name>
<servlet-class>Login_Servlet</servlet-class>
</servlet>
<servlet>
<servlet-name>finalservlet</servlet-name>
<servlet-class>finalservlet</servlet-class>
</servlet>
<servlet>
<servlet-name>registration</servlet-name>
<servlet-class>registration</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>NewServlet</servlet-name>
<url-pattern>/NewServlet</url-pattern>
9
</servlet-mapping>
<servlet-mapping>
<servlet-name>My_Server</servlet-name>
<url-pattern>/My_Server</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>Login_Servlet</servlet-name>
<url-pattern>/Login_Servlet</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>finalservlet</servlet-name>
<url-pattern>/finalservlet</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>registration</servlet-name>
<url-pattern>/registration</url-pattern>
</servlet-mapping>
<session-config>
<session-timeout>
30
</session-timeout>
</session-config>
</web-app>
10
SYCS22 Practical 5 Date:
PRACTICL 4
Aim: Create a registration and login JSP application
[Link]
<!DOCTYPE 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>
<div>TODO write content</div>
<a href="[Link]">Login</a> <br> <br>
<a href="[Link]">Register</a>
</body>
</html>
Output:
11
SYCS22 Practical 5 Date:
[Link]
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Register JSP Page</title>
<link rel="stylesheet" href="[Link]">
</head>
<body>
<div class="container">
<h2>Sign Up</h2>
<form action="[Link]" method="post">
<div class="inputbox">
<input type="text" name="myname" id="name" required="required" />
<span>Full Name</span>
</div>
<div class="inputbox">
<input type="email" name="myemail" id="email" required="required" />
<span>Email Address</span>
</div>
<div class="inputbox">
<input type="tel" name="myphone" id="getphone" required="required" />
<span>Contact</span>
</div>
<div style="margin-bottom: 25px">
<input type="radio" name="myradio" id="getgender1" value="male" />Male
12
SYCS22 Practical 5 Date:
<input type="radio" name="myradio" id="getgender2" style="margin-left: 5px"
value="female"/>Female
<input type="radio" name="myradio" id="getgender3" style="margin-left: 5px"
value="other" />Other
</div>
<div class="inputbox">
<p>Course</p>
<select name="getcourse">
<option value="select">select</option>
<option value="CS">CS</option>
<option value="IT">IT</option>
<option value="Data Science">Data Science</option>
<option value="BlockChain">BlockChain</option>
</select>
</div>
<div class="inputbox">
<input type="submit" value="sign up" id="mybtn" />
</div>
</form>
</div>
</body>
</html>
SQL Table
13
SYCS22 Practical 5 Date:
[Link]
<%@page import="[Link]"%>
<%@page import="[Link]"%>
<%@page import="[Link]"%>
<%@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>
<%
try {
String n = [Link]("myname");
String eml = [Link]("myemail");
String phn = [Link]("myphone");
String gnd = [Link]("myradio");
String cur = [Link]("getcourse");
[Link]("[Link]");
Connection con = [Link]("jdbc:mysql://localhost:3306/myschool?
zeroDateTimeBehavi or=CONVERT_TO_NULL", "root", "Furkan123");
[Link]("Connecsion is done");
PreparedStatement ps = [Link]("insert into students(Name, Email,
contact, Gender, Course) values (?,?,?,?,?);");
[Link](1, n);
[Link](2, eml);
14
SYCS22 Practical 5 Date:
[Link](3, phn);
[Link](4, gnd);
[Link](5, cur);
[Link]();
[Link]("<h1>Registration Success. </h1>");
} catch (Exception e) {
%>
</body>
</html>
Output:
15
SYCS22 Practical 5 Date:
[Link]
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Log in JSP Page</title>
<link rel="stylesheet" href="[Link]">
</head>
<body>
<div class="container">
<h2>Sign in</h2>
<form action="[Link]" method="post">
<div class="inputbox">
<input type="text" name="myemail" id="name" required="required" />
<span>E-Mail</span>
</div>
<div class="inputbox">
<input type="text" name="myphone" id="email" required="required" />
<span>Contact</span>
</div>
<div class="inputbox">
<input type="submit" value="sign in" id="mybtn" />
</div>
</form>
</div>
</body>
</html>
16
SYCS22 Practical 5 Date:
[Link]
<%@page import="[Link]"%>
<%@page import="[Link]"%>
<%@page import="[Link]"%>
<%@page import="[Link]"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<body>
<h2>Welcome to login backend</h2>
<%
try {
String eml = [Link]("myemail");
String phn = [Link]("myphone");
[Link]("[Link]");
Connection con = [Link]("jdbc:mysql://localhost:3306/myschool?
zeroDateTimeBehavior=CON VERT_TO_NULL", "root", "Furkan123");
[Link]("Connecsion is done");
PreparedStatement ps = [Link]("select * from students where Email=? and
contact=?");
[Link](1, eml);
[Link](2, phn);
boolean status = false;
ResultSet rs = [Link]();
status = [Link]();
if (status == false)
{ [Link]("<h1>Login
Failed...</h1>");
} else {
[Link]("<h1>Login Success...</h1>");
17
SYCS22 Practical 5 Date:
}
} catch (Exception c) {
%>
</body>
</html>
Output:
If credentials are valid:
If credentials are Invalid:
18
SYCS22 Practical 5 Date:
PRACTICAL 5
Aim: Write a Java application to access JavaBeans Properties.
[Link]
<!DOCTYPE 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>
<a href='[Link]'> Redirect Me</a>
</body>
</html>
Output:
[Link]
<%@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>
<form action="[Link]" method="POST">
<input type ="text" placeholder="Enter Students Roll No.." name='roll'>
19
SYCS22 Practical 5 Date:
<input type="text" placeholder="Enter Student's Name" name="name">
<input type="text" placeholder="Enter Student's Age" name='age'>
<input type="submit" value="Submit">
</form>
</center>
</body>
</html>
[Link]
<%@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>
<jsp:useBean id="students" class="[Link]">
<jsp:setProperty name="students" property="*"/>
</jsp:useBean>
<p> Student Roll No:
<jsp:getProperty name="students" property="roll"/>
</p>
<p>Student Name
<jsp:getProperty name="students" property="name" />
</p>
<p>Student Age:
<jsp:getProperty name="students" property="age"/>
</p>
</body>
20
SYCS22 Practical 5 Date:
</html>
[Link] (JavaBeans Class)
package MyPack;
import [Link];
public class Students implements Serializable
{ private static final long serialVersionUID = 1L;
public String roll = null;
public String name = null;
public int age = 0;
public Students(){ }
public String getroll(){
return roll;
}
public String getName()
{ return name;
}
public int getAge()
{ return age;
}
public void setRoll(String roll)
{ [Link] = roll;
}
public void setName(String name)
{ [Link] = name;
}
public void setAge(int age){
[Link] = age;
}
}
Output:
21
SYCS22 Practical 6 Date:
Practical 6
Aim: Write Java application to encoding and decoding JSON in Java.
Using HaspMap
[Link]
import [Link];
import [Link];
import [Link];
import [Link];
public class jsonEncode {
public static void main(String args[]) throws
FileNotFoundException{ HashMap io = new HashMap();
[Link]("FirstName", "Furkan");
[Link]("LastName", "Sayyed");
[Link]("Roll No.", "SYCS36");
[Link]("Age", 20);
PrintWriter pw = new PrintWriter("D:\\SYCS36\\[Link]");
[Link]([Link](io));
[Link]("Done Wrting to File...");
[Link]();
[Link]();
Output:
22
SYCS22 Practical 6 Date:
[Link]
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
public class jsonDecode {
public static void main(String[] args) throws FileNotFoundException, IOException, ParseException
{ Object obj = new JSONParser().parse(new FileReader("D:\\SYCS\\[Link]"));
JSONObject jo = (JSONObject) obj;
String firstName = (String )[Link]("FirstName");
String lastName = (String )[Link]("LastName");
String rollno = (String )[Link]("Roll No.");
long Age = (long ) [Link]("Age");
[Link](firstName);
[Link](lastName);
[Link](rollno);
[Link](Age);
23
SYCS22 Practical 6 Date:
}
Output:
Using Array
[Link]
import [Link];
import [Link];
import [Link];
import [Link];
public class jsonWithArrayEncode {
public static void main(String[] args) throws FileNotFoundException
{ ArrayList arr = new ArrayList();
[Link]("Tony");
[Link]("Stark");
[Link]("Mark 85");
[Link](2025);
PrintWriter pw = new PrintWriter("D:\\SYCS36\\[Link]");
[Link]([Link](arr));
[Link]("Writing Done Using ArrayList");
[Link]();
[Link]();
Output:
24
SYCS22 Practical 6 Date:
[Link]
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
public class jsonWithArrayDecode {
public static void main(String[] args) throws FileNotFoundException, IOException,
ParseException{ Object obj = new JSONParser().parse(new FileReader("D:\\SYCS36\\
[Link]")); JSONArray arr = (JSONArray) obj;
String firstName = (String) [Link](0);
String lastName = (String) [Link](1);
String roll = (String) [Link](2);
long age = (long) [Link](3);
[Link]("First Name: " + firstName);
[Link]("Last Name: " +lastName);
[Link]("Mark: "+ roll);
[Link]("Year: " + age);
} Output:
25
SYCS22 Practical no.7 Date:
Practical 7
Aim: Create a simple JPA application to store and retrieve Book details.
26
SYCS22 Practical no. Date:
28
SYCS22 Practical no. Date:
Creating a session bean to manage database.
28
SYCS22 Practical no. Date:
Creating a class to collect data from the webform.
28
SYCS22 Practical no. Date:
[Link]
import [Link];
import [Link];
import [Link];
@Singleton
@Startup
@DataSourceDefinition(name="java:global/jdbc/MYSQLTEST",
className="[Link]",
url="jdbc:mysql://localhost:3306/SYCS46",
user="root",
password="BHAVANS"
)
public class DataSourceBean {
}
[Link]
package Entity;
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
@Entity
@Table(name = "book")
@XmlRootElement
@NamedQueries({
@NamedQuery(name = "[Link]", query = "SELECT b FROM Book b"),
@NamedQuery(name = "[Link]", query = "SELECT b FROM Book b WHERE [Link] = :id"),
@NamedQuery(name = "[Link]", query = "SELECT b FROM Book b WHERE [Link] =
:name"),
@NamedQuery(name = "[Link]", query = "SELECT b FROM Book b WHERE [Link] =
:price")})
public class Book implements Serializable
{ private static final long serialVersionUID =
1L; @Id
@Basic(optional = false)
@Column(name = "id")
private String id;
@Column(name = "name")
private String name;
@Column(name = "price")
private String price;
public Book() {
}
public Book(String id, String name, String price)
{ [Link] = id;
[Link] = name;
[Link] = price;
}
public String getId()
28
SYCS22 Practical no. Date:
{ return id;
}
public void setId(String id) {
[Link] = id;
}
public String getName()
{ return name;
}
public void setName(String name)
{ [Link] = name;
}
public String getPrice()
{ return price;
}
public void setPrice(String price)
{ [Link] = price;
}
@Override
public int hashCode()
{ int hash = 0;
hash += (id != null ? [Link]() : 0);
return hash;
}
@Override
public boolean equals(Object object) {
// TODO: Warning - this method won't work in the case the id fields are not set
if (!(object instanceof Book)) {
return false;
}
Book other = (Book) object;
if (([Link] == null && [Link] != null) || ([Link] != null && ))
{ return false;
}
return true;
}
@Override
public String toString() {
return "[Link][ id=" + id + " ]";
}
}
[Link]
package View;
import [Link];
//import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
@ManagedBean(name="webData")
@Named
@SessionScoped
public class WebData {
28
SYCS22 Practical no. Date:
@EJB
private BookFacade bf;
private String id;
private String name;
private String price;
public String getId() {
return id;
}
public void setId(String id) {
[Link] = id;
}
public String getName()
{ return name;
}
public void setName(String name)
{ [Link] = name;
}
public String getPrice() {
return price;
}
public void setPrice(String price)
{ [Link] = price;
}
public void save(){
try{
[Link](id, name, price);
}
catch(Exception e){
[Link]([Link]());
}
}
}
[Link]
package Session;
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
@Stateless
public class BookFacade extends AbstractFacade<Book> {
@PersistenceContext(unitName = "BookJPAPU")
private EntityManager em;
@Override
protected EntityManager getEntityManager()
{ return em;
28
SYCS22 Practical no. Date:
}
public BookFacade() {
super([Link]);
}
public void Save(String id, String name, String price)
{
try{
Book myBook = new Book(id, name, price);
[Link](myBook);
}
catch(Exception e) {
throw new EJBException([Link]());
}
}
}
[Link]
package Session;
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
@Stateless
public class BookFacade extends AbstractFacade<Book> {
@PersistenceContext(unitName = "BookJPAPU")
private EntityManager em;
@Override
protected EntityManager getEntityManager()
{ return em;
}
public BookFacade() {
super([Link]);
}
public void Save(String id, String name, String price)
{
try{
Book myBook = new Book(id, name, price);
[Link](myBook);
}
catch(Exception e) {
throw new EJBException([Link]());
}
}
}
[Link]
<persistence version="2.1" xmlns="[Link]
xmlns:xsi="[Link]
xsi:schemaLocation="[Link]
[Link]
71
SYCS22 Practical no. Date:
<persistence-unit name="BookJPAPU" transaction-type="JTA">
<jta-data-source>java:global/jdbc/Mysql_Test</jta-data-source>
<exclude-unlisted-classes>false</exclude-unlisted-classes>
</persistence-unit>
</persistence>
[Link]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
xmlns:h="[Link]
xmlns:f="[Link]
<h:head>
<title>Facelet Title</title>
</h:head>
<h:body>
<f:view>
<h:form>
<table border="1">
<thead>
<tr>
<th>Data:</th> <th>Data:</th>
</tr>
</thead>
<tbody>
<tr>
<td>Id:</td> <td><h:inputText value="#{[Link]}"></h:inputText></td>
</tr>
<tr>
<td>Name:</td> <td><h:inputText value="#{[Link]}"></h:inputText></td>
</tr>
<tr>
<td>Price:</td> <td><h:inputText value="#{[Link]}"></h:inputText></td>
</tr>
</tbody>
</table>
<h:commandButton value="submit" action="#{[Link]()}"></h:commandButton>
</h:form>
</f:view>
</h:body>
</html>
72
SYCS22 Practical no. Date:
Output:
73
SYCS22 Practical No.8 Date:
Practical 8
AIM: Develop a hibernate application to store and retrieve employee details in mysql database.
74
SYCS22 Practical No.8 Date:
CODE ([Link]) :
<%@page import="[Link]"%>
<%@page import="[Link]"%>
<%@page import="[Link]"%>
<%@page import="[Link]"%>
<%@page import="[Link]"%>
<%@page import="[Link]"%>
<%@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>
<form>
Insert Details<br><br>
Emp Name <input type="text" name="ename"><br>
Emp City <input type="text" name="ecity"><br>
<input type="submit" name="eins" value="Submit"><br>
<hr>
</form>
<form>
<hr>
Retrieve Details<br><br>
Emp ID <input type="text" name="eid"><br>
<input type="submit" name="eret" value="Show Emp"><br>
</form>
<form>
<hr><hr>
Update Details <br><br>
75
SYCS22 Practical No.8 Date:
Emp ID <input type="text" name="eid"><br>
Emp Name <input type="text" name="ename"><br>
Emp City <input type="text" name="ecity"><br>
<input type="submit" name="eupd" value="Update"><br>
<hr>
</form>
<form>
<hr>
Delete Details <br><br>
Emp ID <input type="text" name="eid"><br>
<input type="submit" name="edel" value="Show Emp"><br>
</form>
<%!
SessionFactory sf;
Session session;
Transaction tx;
%>
<%
if([Link]("eins")!=null)
{
sf = new Configuration().configure().buildSessionFactory();
[Link]= [Link]();
tx= [Link]();
TblEmp emp = new TblEmp();
[Link]([Link]("ename"));
[Link]([Link]("ecity"));
[Link]();
[Link](emp);
[Link]();
[Link]();
[Link]("Data Inserted");
}
else if([Link]("eret")!=null)
{
sf = new Configuration().configure().buildSessionFactory();
[Link]= [Link]();
try{
TblEmp emp=(TblEmp)[Link]([Link],
[Link]([Link]("eid")));
[Link]([Link]()+" "+[Link]());
}
catch(ObjectNotFoundException e)
{ [Link]("No Data Found");
}
[Link]();
}
else if([Link]("eupd")!=null)
{
sf = new Configuration().configure().buildSessionFactory();
[Link]= [Link]();
76
SYCS22 Practical No.8 Date:
tx= [Link]();
try{
TblEmp emp = new TblEmp();
[Link]([Link]([Link]("eid")));
[Link]([Link]("ename"));
[Link]([Link]("ecity"));
[Link]();
[Link](emp);
[Link]();
}
catch(ObjectNotFoundException e)
{ [Link]("No Data Found");
}
[Link]();
[Link]("Data Inserted");
}
else if([Link]("edel")!=null)
{
sf = new Configuration().configure().buildSessionFactory();
[Link]= [Link]();
tx= [Link]();
TblEmp emp = new TblEmp();
[Link]([Link]([Link]("eid")));
[Link]();
[Link](emp);
[Link]();
[Link]();
[Link]("Data Inserted");
}
%>
</body>
</html>
[Link]
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"[Link]
<hibernate-configuration>
<session-factory>
<property name="[Link]">[Link]</property>
<property name="[Link].driver_class">[Link]</property>
<property name="[Link]">jdbc:mysql://localhost:3306/library?
zeroDateTimeBehavior=conv ertToNull</property>
<property name="[Link]">root</property>
<property name="[Link]">Furkan123</property>
<mapping resource="view/[Link]"/>
</session-factory>
77
SYCS22 Practical No.8 Date:
</hibernate-configuration>
[Link]
<hibernate-reverse-engineering>
<schema-selection match-catalog="library"/>
<table-filter match-name="tbl_emp"/>
</hibernate-reverse-engineering>
[Link]
<hibernate-mapping>
<class name="[Link]" table="tbl_emp" catalog="library" optimistic-lock="version">
<id name="id" type="[Link]">
<column name="id" />
<generator class="identity" />
</id>
<property name="name" type="string">
<column name="name" length="200" />
</property>
<property name="city" type="string">
<column name="city" length="200" />
</property>
</class>
</hibernate-mapping>
[Link]
package view;
public class TblEmp implements [Link]
{ private Integer id;
private String name;
private String city;
public TblEmp() {
public TblEmp(String name, String city)
{ [Link] = name;
[Link] = city;
78
SYCS22 Practical No.8 Date:
}
public Integer getId()
{ return [Link];
}
public void setId(Integer id)
{ [Link] = id;
}
public String getName()
{ return [Link];
}
public void setName(String name)
{ [Link] = name;
}
public String getCity() {
return [Link];
}
public void setCity(String city)
{ [Link] = city;
}
}
Output:
79
SYCS22 Practical No.8 Date:
80
SYCS22 Practical no. Date:
81
You might also like
- Java Servlet Login and Validation GuideNo ratings yetJava Servlet Login and Validation Guide32 pages
- Servlet Testing and State Management GuideNo ratings yetServlet Testing and State Management Guide15 pages
- Java Servlet and JSP Application ExamplesNo ratings yetJava Servlet and JSP Application Examples67 pages
- Java Servlet Calculator and Login GuideNo ratings yetJava Servlet Calculator and Login Guide12 pages
- Java Servlet Login and Registration GuideNo ratings yetJava Servlet Login and Registration Guide14 pages
- Servlet User Authentication with HTML FormsNo ratings yetServlet User Authentication with HTML Forms27 pages
- User Input Handling with Servlets and JSPNo ratings yetUser Input Handling with Servlets and JSP6 pages
- Java Servlet Applications for Login and CalculatorNo ratings yetJava Servlet Applications for Login and Calculator45 pages
- Servlet-Based Login and Registration SystemNo ratings yetServlet-Based Login and Registration System34 pages
- Servlet Examples for User Input HandlingNo ratings yetServlet Examples for User Input Handling14 pages
- Java Servlet and JSP Employee ManagementNo ratings yetJava Servlet and JSP Employee Management9 pages
- Java Servlet Login and Data Sharing ExampleNo ratings yetJava Servlet Login and Data Sharing Example24 pages
- JDBC Overview and Driver Types ExplainedNo ratings yetJDBC Overview and Driver Types Explained51 pages
- B.Sc. Computer Science Syllabus 2024-25No ratings yetB.Sc. Computer Science Syllabus 2024-2528 pages
- Java Programming Certificate - MCA I Sem INo ratings yetJava Programming Certificate - MCA I Sem I41 pages
- Kamineni Rasagna: Java Developer ProfileNo ratings yetKamineni Rasagna: Java Developer Profile7 pages
- Cloud Engineer Resume: AWS & DevOps ExpertNo ratings yetCloud Engineer Resume: AWS & DevOps Expert5 pages
- Effective Prompt Engineering for Java WebNo ratings yetEffective Prompt Engineering for Java Web8 pages