A-Z About Java: integrating hibernate in web application for insertion, updation, selection and deletion

Project Structure

Create a database with name retailer

create database retailer;
use retailer;

Create a table with name users

DROP TABLE IF EXISTS `retailer`.`users`;
CREATE TABLE `retailer`.`users` (
`uid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uname` varchar(45) DEFAULT NULL,
`upassword` varchar(45) DEFAULT NULL,
PRIMARY KEY (`uid`)
);

index.jsp

<%--
Document : index
Created on : Nov 18, 2015, 4:04:04 PM
Author : Aravind Sankaran Nair
--%>

<%@page import="bean.Users"%>
<%@page import="java.util.Iterator"%>
<%@page import="org.hibernate.Query"%>
<%@page import="org.hibernate.cfg.Configuration"%>
<%@page import="org.hibernate.SessionFactory"%>
<%@page import="org.hibernate.Session"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%

Session ses=null;
SessionFactory sessionFactory=sessionFactory=new Configuration().configure().buildSessionFactory();
%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<center>
<table>
<tr>
<td>Login</td>
<td>Registration</td>
</tr>
<tr>
<td>
<table bgcolor="yellow">
<form method="post" action="<%=request.getContextPath()%>/Login">
<tr>
<td>User Name </td>
<td><input type="text" name="un"></td>
</tr>
<tr>
<td>Password </td>
<td><input type="text" name="pw"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="login"></td>
</tr>
</form>
</table>
</td>
<td>
<table bgcolor="red">
<form method="post" action="<%=request.getContextPath()%>/Register">
<tr>
<td>User Name </td>
<td><input type="text" name="un"></td>
</tr>
<tr>
<td>Password </td>
<td><input type="text" name="pw"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="Register"></td>
</tr>
</form>
</table>
</td>
</tr>
</table>
<table bgcolor="#819FF7">

<tr>
<td>User Name</td>
<td>User Password</td>
<td>Update</td>
</tr>

<%

ses=sessionFactory.openSession();
String SQL_QUERY = "FROM Users users ";
Query query = (Query) ses.createQuery(SQL_QUERY);
for(Iterator it=query.iterate();it.hasNext();){
Users user=(Users)it.next();%>
<tr>
<td><%=user.getUNAME()%></td>
<td><%=user.getUPASSWORD()%></td>
<td>
<a href="userdetails.jsp?uid=<%=user.getUID()%>"><%=user.getUID()%></a></td>
</tr>
<%}%>

</table>

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

userhome.jsp

<%--

Document : userhome

Created on : Nov 19, 2015, 11:59:22 AM

Author : Aravind Sankaran Nair

--%>

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

<% String id=request.getParameter("id");

String un=request.getParameter("uname");

<!DOCTYPE html>

<html>

<head>

</head>

<body>

<tr>

<td><h1>Welcome</h1></td>

</tr>

<tr>

</tr>

</table>

</center>

</body>

</html>

userdetails.jsp

<%--

Document : userdetails

Created on : Nov 19, 2015, 2:04:59 PM

Author : Aravind Sankaran Nair

--%>

<%@page import="bean.Users"%>

<%@page import="java.util.Iterator"%>

<%@page import="org.hibernate.Query"%>

<%@page import="org.hibernate.cfg.Configuration"%>

<%@page import="org.hibernate.SessionFactory"%>

<%@page import="org.hibernate.Session"%>

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

<%String uid=request.getParameter("uid");%>

<% Session ses=null;

SessionFactory sessionFactory=sessionFactory=new Configuration().configure().buildSessionFactory();

<!DOCTYPE html>

<html>

<head>

</head>

<body>

<form method="post" action="<%=request.getContextPath()%>/Update">

<tr>

ses=sessionFactory.openSession();

String SQL_QUERY1 = "FROM Users users where users.UID="+uid;

Query query1 = (Query) ses.createQuery(SQL_QUERY1);

for(Iterator it=query1.iterate();it.hasNext();){

Users user=(Users)it.next();%>

</tr>

<tr>

<td>User Password</td>

</tr>

<%} ses.flush();

ses.close();

<tr>

</tr>

</table>

</center>

</form>

</body>

</html>

failure.jsp

<%--

Document : failure

Created on : Nov 19, 2015, 12:23:55 PM

Author : Aravind Sankaran Nair

--%>

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

<!DOCTYPE html>

<html>

<head>

</head>

<body>

<h1>Operation failed</h1>

</body>

</html>

Users.java

* To change this template, choose Tools | Templates

* and open the template in the editor.

package bean;

/**

* @author Aravind Sankaran Nair

public class Users {

private int UID;

private String UNAME;

private String UPASSWORD;

boolean valid;

public boolean isValid() {

return valid;

}

public void setValid(boolean valid) {

this.valid = valid;

}

public int getUID() {

return UID;

}

public void setUID(int UID) {

this.UID = UID;

}

public String getUNAME() {

return UNAME;

}

public void setUNAME(String UNAME) {

this.UNAME = UNAME;

}

public String getUPASSWORD() {

return UPASSWORD;

}

public void setUPASSWORD(String UPASSWORD) {

this.UPASSWORD = UPASSWORD;

}

hibernate.cfg.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

<session-factory>

<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>

<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>

<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/retailer</property>

<property name="hibernate.current_session_context_class">thread</property>

<property name="hibernate.cache.provider_class">org.hibernate.cache.NoCacheProvider</property>

<property name="hibernate.hbm2ddl.auto">update</property>

</session-factory>

</hibernate-configuration>

usermapping.hbm.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>

</id>

</property>

</property>

</class>

</hibernate-mapping>

Register.java (Servlet)

package controller;

import bean.Users;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import operations.CommonOperations;

/**
*
* @author Aravind Sankaran Nair
*/
public class Register extends HttpServlet {

@Override

protected void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

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

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

Users user=new Users();

user.setUNAME(un);

user.setUPASSWORD(pw);

CommonOperations commonOperations=new CommonOperations();

user=commonOperations.registerUser(user);

if(user.isValid()){

HttpSession session=request.getSession();

session.setAttribute("currentsession", user);

response.sendRedirect("index.jsp");

}else{

response.sendRedirect("failure.jsp");

}

Login.java (Servlet)

package controller;

import bean.Users;

import java.io.IOException;

import java.io.PrintWriter;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

import operations.CommonOperations;

/**

* @author Aravind Sankaran Nair

public class Login extends HttpServlet {

@Override

protected void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

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

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

Users user=new Users();

CommonOperations co=new CommonOperations();

user.setUNAME(un);

user.setUPASSWORD(pw);

user=co.getLoginDetails(user);

if(user.isValid()){

HttpSession session=request.getSession();

session.setAttribute("currentsession", user);

response.sendRedirect("userhome.jsp?id="+user.getUID()+"&uname="+user.getUNAME());

}else{

response.sendRedirect("index.jsp");

}

Update.java (Servlet)

package controller;

import bean.Users;

import java.io.IOException;

import java.io.PrintWriter;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

import operations.CommonOperations;

/**

* @author Aravind Sankaran Nair

public class Update extends HttpServlet {

@Override

protected void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

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

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

int id=Integer.parseInt(request.getParameter("id"));

if(request.getParameter("update")!=null){

Users user=new Users();

CommonOperations commonOperations=new CommonOperations();

user.setUID(id);

user.setUNAME(un);

user.setUPASSWORD(pw);

user= commonOperations.updateUserDetails(user);

if(user.isValid()){

HttpSession ses=request.getSession();

ses.setAttribute("", user);

response.sendRedirect("index.jsp");

}else{

response.sendRedirect("failure.jsp");

}

}else if(request.getParameter("delete")!=null){

Users user=new Users();

CommonOperations commonOperations=new CommonOperations();

user.setUID(id);

user.setUNAME(un);

user.setUPASSWORD(pw);

user= commonOperations.removeUserDetails(user);

if(user.isValid()){

HttpSession ses=request.getSession();

ses.setAttribute("", user);

response.sendRedirect("index.jsp");

}else{

response.sendRedirect("failure.jsp");

}

CommonOperations.java

/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package operations;

import bean.Users;
import java.util.Iterator;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

/**
*
* @author Aravind Sankaran Nair
*/
public class CommonOperations {
Session session=null;
SessionFactory sessionFactory=sessionFactory=new Configuration().configure().buildSessionFactory();
public Users getLoginDetails(Users user){
session=sessionFactory.openSession();
session.beginTransaction();
String UNAME=user.getUNAME();
String UPASSWORD=user.getUPASSWORD();
String SQL_QUERY = "FROM Users users WHERE users.UNAME = '"+UNAME+"' AND users.UPASSWORD= '"+UPASSWORD+"'";
Query query = (Query) session.createQuery(SQL_QUERY);
for(Iterator it=query.iterate();it.hasNext();)
{
Users u = (Users)it.next();
user.setUID(u.getUID());
user.setUNAME(u.getUNAME());
user.setUPASSWORD(u.getUPASSWORD());
user.setValid(true);
}
session.getTransaction().commit();
session.close();
return user;
}
public Users registerUser(Users user){
session=sessionFactory.openSession();
session.beginTransaction();
session.save(user);
user.setValid(true);
session.getTransaction().commit();
session.flush();
session.close();
return user;
}
public Users updateUserDetails(Users user){
int UID=user.getUID();
String UNAME=user.getUNAME();
String UPASSWORD=user.getUPASSWORD();
session=sessionFactory.openSession();
session.beginTransaction();

String SQL_QUERY="FROM Users users where users.UID= :uid";
Query query = (Query) session.createQuery(SQL_QUERY);
query.setParameter("uid", UID);
user.setUNAME(UNAME);
user.setUPASSWORD(UPASSWORD);

session.update(user);
user.setValid(true);

session.getTransaction().commit();
session.flush();
session.close();
return user;
}
public Users removeUserDetails(Users user){
int UID=user.getUID();
session=sessionFactory.openSession();
session.beginTransaction();
String SQL_QUERY="From Users users where users.UID= :uid";
Query query=session.createQuery(SQL_QUERY);
query.setParameter("uid", UID);
user.setUID(UID);
session.delete(user);
user.setValid(true);
session.getTransaction().commit();
session.flush();
session.close();
return user;
}
}

web.xml

<?xml version="1.0" encoding="UTF-8"?>

<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">

<servlet-name>Login</servlet-name>

<servlet-class>controller.Login</servlet-class>

</servlet>

<servlet-name>Register</servlet-name>

<servlet-class>controller.Register</servlet-class>

</servlet>

<servlet-name>Update</servlet-name>

<servlet-class>controller.Update</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>Login</servlet-name>

<url-pattern>/Login</url-pattern>

</servlet-mapping>

<servlet-mapping>

<servlet-name>Register</servlet-name>

<url-pattern>/Register</url-pattern>

</servlet-mapping>

<servlet-mapping>

<servlet-name>Update</servlet-name>

<url-pattern>/Update</url-pattern>

</servlet-mapping>

<session-config>

<session-timeout>

</session-timeout>

</session-config>

<welcome-file-list>

<welcome-file>index.jsp</welcome-file>

</welcome-file-list>

</web-app>

Jar Needed:

Hibernate 3.2.5

ejb3-persistence.jar

derbyclient.jar

mysql-connector-java-5.1.18-bin.jar

Output:

A-Z About Java

Choose Your Language

Thursday 19 November 2015

integrating hibernate in web application for insertion, updation, selection and deletion

Create a database with name retailer

Create a table with name users

index.jsp

userhome.jsp

userdetails.jsp

failure.jsp

Users.java

hibernate.cfg.xml

usermapping.hbm.xml

Register.java (Servlet)

Login.java (Servlet)

Update.java (Servlet)

CommonOperations.java

web.xml

Jar Needed:

No comments:

Post a Comment