JAVA, JSF, MySql and Hibernate Login Project

This project uses MySql as database and Hibernate for Database operations.

The Project structure in Netbeans,

index.xhtml

<?xml version='1.0' encoding='UTF-8' ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
     <html xmlns="http://www.w3.org/1999/xhtml"
       xmlns:h="http://xmlns.jcp.org/jsf/html">
       <h:head>
       <title>Facelet Title</title>
       </h:head>
       <h:body>
          <h:form>
              User Name <h:inputText value="#{login_bean.user_name}"></h:inputText><br></br>
              Password <h:inputSecret value="#{login_bean.password}"></h:inputSecret><br></br>
              <h:commandButton action="#{login_bean.checkuser()}" value="Submit"></h:commandButton>
         </h:form>
       </h:body>
     </html>

success.xhtml

<?xml version='1.0' encoding='UTF-8' ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
     <html xmlns="http://www.w3.org/1999/xhtml"
     xmlns:h="http://xmlns.jcp.org/jsf/html">
           <h:head>
                <title>Facelet Title</title>
           </h:head>
           <h:body>
                SUCCESS PAGE
                <br></br>
                #{login_bean.user_name}
           </h:body>
     </html>

hibernate.cfg.xml
This config file connects with Mysql Database

<?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/test?zeroDateTimeBehavior=convertToNull</property>
            <property name="hibernate.connection.username">jinu</property>
            <property name="hibernate.connection.password">mypass</property>
            <property name="hibernate.show_sql"></property>
            <mapping class="common.Login"></mapping>
     </session-factory>
</hibernate-configuration>

package common;
import java.io.Serializable;
import java.util.List;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.SessionScoped;
import javax.persistence.Entity;
import javax.persistence.Id;
import org.hibernate.Query;
import org.hibernate.SessionFactory;
import org.hibernate.Session;
import org.hibernate.cfg.Configuration;
@ManagedBean(name = "login_bean")
@SessionScoped
@Entity
public class Login implements Serializable {
   @Id
   private int sl_no;
   private String user_name;
   private String password;
   public void setSl_no(int sl_no) {
      this.sl_no = sl_no;
   }
   public int getSl_no() {
      return sl_no;
   }
   public String getUser_name() {
      return user_name;
   }
   public String getPassword() {
      return password;
   }
   public void setUser_name(String user_name) {
      this.user_name = user_name;
   }
   public void setPassword(String password) {
      this.password = password;
   }
   public boolean checkuser(){
   try {
      System.out.println("user name "+user_name);
      System.out.println("passowrd "+password);
      SessionFactory sessionFactory=new Configuration().configure().buildSessionFactory();
      Session session=sessionFactory.openSession();
      session.beginTransaction();
      Query query=session.createQuery("from Login where user_name=:user_name and password=:password");
      query.setString("user_name", user_name);
      query.setString("password", password);
      List list=query.list();
      System.out.println("list size "+list.size());
      if(list.size()==1){
            return true;
      }else{
            return false;
      }
    } catch (Exception e) {
        System.out.println(e);
    }
    return false;
   }
    public Login() {
    }
 }

faces-config.xml

<?xml version='1.0' encoding='UTF-8'?>
<faces-config version="2.2"
 	xmlns="http://xmlns.jcp.org/xml/ns/javaee"
 	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 	xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-facesconfig_2_2.xsd">
 	<navigation-rule>
 	 	<from-view-id>index.xhtml</from-view-id>
 	 	<navigation-case>
 	 	 	<from-action>#{login_bean.checkuser()}</from-action>
 	 	 	<from-outcome>true</from-outcome>
 	 	 	<to-view-id>success.xhtml</to-view-id>
 	 	 	<redirect></redirect>
 	 	</navigation-case>
 	 	<navigation-case>
 	 	 	<from-action>#{login_bean.checkuser()}</from-action>
 	 	 	<from-outcome>false</from-outcome>
 	 	 	<to-view-id>index.xhtml</to-view-id>
 	 	 	<redirect></redirect>
 	 	</navigation-case>
 	</navigation-rule>
</faces-config>

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="3.1" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd">
 	<context-param>
 	 	<param-name>javax.faces.PROJECT_STAGE</param-name>
 	 	<param-value>Development</param-value>
 	</context-param>
 	<servlet>
 	 	<servlet-name>Faces Servlet</servlet-name>
 	 	<servlet-class>javax.faces.webapp.FacesServlet</servlet-class>
 	 	<load-on-startup>1</load-on-startup>
 	</servlet>
 	<servlet-mapping>
 	 	<servlet-name>Faces Servlet</servlet-name>
 	 	<url-pattern>/faces/*</url-pattern>
 	</servlet-mapping>
 	<session-config>
 	 	<session-timeout>
 	 	 	30
 	 	</session-timeout>
 	</session-config>
 	 <welcome-file-list>
 	 	<welcome-file>faces/index.xhtml</welcome-file>
 	 </welcome-file-list>
 </web-app>

Login Page
Success Page

Download the project here JSF_Hibernate_loginProject_1

ChillyFacts

Recent Posts

Categories

JAVA, JSF, MySql and Hibernate Login Project

Related posts:

Written By

Jinu

Tags

Comments

Leave a Comment

Cancel reply

Recent Posts

Categories