Hibernate Archives

Struts1 Spring and Hibernate Integration

June 30, 2023June 30, 2023 by manish

&lt;%@ taglib uri="http://jakarta.apache.org/struts/tags-bean" prefix="bean" %&gt;
&lt;%@ taglib uri="http://jakarta.apache.org/struts/tags-html" prefix="html" %&gt;
&lt;%@ taglib uri="http://jakarta.apache.org/struts/tags-logic" prefix="logic" %&gt;


<html:form action="/RegisterForm">
	<center>
<h1><u>
		Registration Screen
	</u></h1>


<h2>

<table border="0" width="100%" align="center">

<tbody>
<tr>

<td><bean:message key="registration.id"></bean:message></td>


<td><html:text property="id"></html:text></td>

</tr>


<tr>

<td><bean:message key="registration.name"></bean:message></td>


<td><html:text property="name"></html:text></td>

</tr>


<tr>

<td><bean:message key="registration.address"></bean:message></td>


<td><html:text property="address"></html:text></td>

</tr>


<tr>

<td><bean:message key="registration.doj"></bean:message></td>


<td><html:text property="doj"></html:text></td>

</tr>


<tr>

<td><bean:message key="registration.age"></bean:message></td>


<td><html:text property="age"></html:text></td>

</tr>


<tr>

<td><bean:message key="registration.email"></bean:message></td>


<td><html:text property="email"></html:text></td>

</tr>

</tbody>
</table>


<center>
	<html:submit value="Register">
	</html:submit></center></h2>


</center></html:form>

<%@ taglib uri="http://jakarta.apache.org/struts/tags-bean" prefix="bean" %>

<%@ taglib uri="http://jakarta.apache.org/struts/tags-html" prefix="html" %>

<%@ taglib uri="http://jakarta.apache.org/struts/tags-logic" prefix="logic" %>

<html:form action="/RegisterForm">

<h1><u>

Registration Screen

</u></h1>

<h2>

<tbody>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</tbody>

</table>

<html:submit value="Register">

</html:submit></center></h2>

</center></html:form>

Failure.jsp

&lt;%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %&gt;

	
		<center>
<h2>
			The following error(s) were encountered :
				
			<html:errors>
				

			<a href="Register.jsp">Try Again ? </a>
		</html:errors></h2>
</center>

<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %>

<h2>

The following error(s) were encountered :

<html:errors>

<a href="Register.jsp">Try Again ? </a>

</html:errors></h2>

</center>

Success.jsp

&lt;%@page contentType="text/html" pageEncoding="UTF-8"%&gt;



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

<h1>Registration seccess Hello World!</h1>

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

<title>JSP success Page</title>

<h1>Registration seccess Hello World!</h1>

web.xml

<web-app>
  <servlet>
	<servlet-name>action</servlet-name>
	<servlet-class>org.apache.struts.action.ActionServlet</servlet-class>
	<init-param>
		<param-name>config</param-name>
		<param-value>/WEB-INF/struts-config.xml</param-value>
	</init-param>
 	<load-on-startup>1</load-on-startup>
       </servlet>
       <servlet-mapping>
	<servlet-name>action</servlet-name>
	<url-pattern> *.do </url-pattern>
       </servlet-mapping>
      <welcome-file-list>
	<welcome-file>index.jsp</welcome-file>
      </welcome-file-list>
      <taglib>
	<taglib-uri>struts-html</taglib-uri>
	<taglib-location>/WEB-INF/struts-html.tld</taglib-location>
      </taglib>
      <taglib>
	<taglib-uri>struts-bean</taglib-uri>
	<taglib-location>/WEB-INF/struts-bean.tld</taglib-location>
      </taglib>
      <taglib>
	<taglib-uri>struts-logic</taglib-uri>
	<taglib-location>/WEB-INF/struts-logic.tld</taglib-location>
      </taglib>
      <taglib>
	<taglib-uri>struts-tiles</taglib-uri>
	<taglib-location>/WEB-INF/struts-tiles.tld</taglib-location>
      </taglib>
</web-app>

<web-app>

<servlet-name>action</servlet-name>

<servlet-class>org.apache.struts.action.ActionServlet</servlet-class>

<init-param>

<param-name>config</param-name>

<param-value>/WEB-INF/struts-config.xml</param-value>

</init-param>

<load-on-startup>1</load-on-startup>

</servlet>

<servlet-mapping>

<servlet-name>action</servlet-name>

<url-pattern> *.do </url-pattern>

</servlet-mapping>

<welcome-file-list>

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

</welcome-file-list>

<taglib-uri>struts-html</taglib-uri>

<taglib-location>/WEB-INF/struts-html.tld</taglib-location>

</taglib>

<taglib-uri>struts-bean</taglib-uri>

<taglib-location>/WEB-INF/struts-bean.tld</taglib-location>

</taglib>

<taglib-uri>struts-logic</taglib-uri>

<taglib-location>/WEB-INF/struts-logic.tld</taglib-location>

</taglib>

<taglib-uri>struts-tiles</taglib-uri>

<taglib-location>/WEB-INF/struts-tiles.tld</taglib-location>

</taglib>

</web-app>

struts-config.xml

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




<struts-config>
    <form-beans>
       
        <form-bean name="RegisterForm" type="com.myapp.struts.form.RegisterForm">
    
    </form-bean></form-beans>
    
    <global-exceptions>
    
    </global-exceptions>

    <global-forwards>
        <forward name="welcome" path="/Welcome.do">
    </forward></global-forwards>

    <action-mappings>
        <action input="/Failure.jsp" name="RegisterForm" path="/RegisterForm" scope="session" validate="true" type="com.myapp.struts.action.RegisterAction">
        <action path="/Welcome" forward="/Register.jsp">
    </action></action></action-mappings>
    
    <controller processorclass="org.apache.struts.tiles.TilesRequestProcessor">

    <message-resources parameter="com/myapp/struts/ApplicationResource">    
    
    <!-- ========================= Tiles plugin ===============================-->
    
    <plug-in classname="org.apache.struts.tiles.TilesPlugin">
        <set-property property="definitions-config" value="/WEB-INF/tiles-defs.xml">      
        <set-property property="moduleAware" value="true">
    </set-property></set-property></plug-in>
    
    <!-- ========================= Validator plugin ================================= -->
    <plug-in classname="org.apache.struts.validator.ValidatorPlugIn">
        <set-property property="pathnames" value="/WEB-INF/validator-rules.xml,/WEB-INF/validation.xml">
    </set-property></plug-in>
  
</message-resources></controller></struts-config>

<struts-config>

<form-beans>

<form-bean name="RegisterForm" type="com.myapp.struts.form.RegisterForm">

</form-bean></form-beans>

<global-exceptions>

</global-exceptions>

<global-forwards>

</forward></global-forwards>

<action-mappings>

</action></action></action-mappings>

<message-resources parameter="com/myapp/struts/ApplicationResource">

<plug-in classname="org.apache.struts.tiles.TilesPlugin">

<set-property property="definitions-config" value="/WEB-INF/tiles-defs.xml">

<set-property property="moduleAware" value="true">

</set-property></set-property></plug-in>

<plug-in classname="org.apache.struts.validator.ValidatorPlugIn">

<set-property property="pathnames" value="/WEB-INF/validator-rules.xml,/WEB-INF/validation.xml">

</set-property></plug-in>

</message-resources></controller></struts-config>

applicationContext.xml

<!--?xml version="1.0" encoding="UTF-8"?-->
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemalocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
       http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
       http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">
    
    <!--bean id="propertyConfigurer"
          class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"
          p:location="/WEB-INF/jdbc.properties" />
    
    <bean id="dataSource"
          class="org.springframework.jdbc.datasource.DriverManagerDataSource"
          p:driverClassName="${jdbc.driverClassName}"
          p:url="${jdbc.url}"
          p:username="${jdbc.username}"
          p:password="${jdbc.password}" /-->
    
    <!-- ADD PERSISTENCE SUPPORT HERE (jpa, hibernate, etc) -->
    <!-- Database Configuration -->
	 <!--import resource="spring-hibernate.xml"/>
    <import resource="spring-services.xml"/-->
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver">
        <property name="url" value="jdbc:mysql://localhost:3306/ebhor">
        <property name="username" value="root">
        <property name="password" value="root">
    </property></property></property></property></bean>
    <!-- Hibernate session factory -->
    <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">

        <property name="dataSource">
            <ref bean="dataSource">
        </ref></property>

        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
                <prop key="hibernate.show_sql">true</prop>
            </props>
        </property>

        <property name="mappingResources">
             	<list>
                <value>com/myapp/hibernate/Register.hbm.xml</value>
            </list>
        </property>

    </bean>
    <bean id="registerBo" class="com.myapp.bo.impl.RegisterBoImpl">
   		<property name="registerDao" ref="registerDao">
   	</property></bean>

   	<bean id="registerDao" class="com.myapp.dao.impl.RegisterDaoImpl">
   		<property name="sessionFactory" ref="sessionFactory"></property>
   	</bean>
    
</beans>

<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemalocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd

http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd

http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">

<!--bean id="propertyConfigurer"

class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"

p:location="/WEB-INF/jdbc.properties" />

<bean id="dataSource"

class="org.springframework.jdbc.datasource.DriverManagerDataSource"

p:driverClassName="${jdbc.driverClassName}"

p:url="${jdbc.url}"

p:username="${jdbc.username}"

p:password="${jdbc.password}" /-->

<!--import resource="spring-hibernate.xml"/>

</property></property></property></property></bean>

</ref></property>

<props>

<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>

</props>

</property>

<list>

<value>com/myapp/hibernate/Register.hbm.xml</value>

</list>

</property>

</bean>

</property></bean>

</bean>

</beans>

RegisterForm.java

package com.myapp.struts.form;

import javax.servlet.http.HttpServletRequest;

import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionMessage;

public class RegisterForm extends org.apache.struts.action.ActionForm {

    private String name;
    private String age;
    private String address;
    private String email;
    private String doj;
    private String id;

    
    public String getName() {
        return name;
    }

  
    public void setName(String string) {
        name = string;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getAge() {
        return age;
    }

    public void setAge(String age) {
        this.age = age;
    }

    public String getDoj() {
        return doj;
    }

    public void setDoj(String doj) {
        this.doj = doj;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public RegisterForm() {
        super();
       }

    public ActionErrors validate(ActionMapping mapping, HttpServletRequest request) {
        ActionErrors errors = new ActionErrors();
        if (getName() == null || getName().length() &lt; 1) {
            errors.add("name", new ActionMessage("error.name.required"));
         }
        if (getAddress() == null || getAddress().length() &lt;= 10) {
            errors.add("address", new ActionMessage("error.address.required"));
          }
        if (getAge() == null || getAge().length() &lt;= 1) {
            errors.add("age", new ActionMessage("error.age.required"));
        }
        if (doj == null || doj.length() &lt;= 4) {
            errors.add("doj", new ActionMessage("error.doj.required"));
        }
        if (email == null || email.equals("")) {
            errors.add("email", new ActionMessage("error.email.required"));
         }
        return errors;
    }
}

package com.myapp.struts.form;

import javax.servlet.http.HttpServletRequest;

import org.apache.struts.action.ActionErrors;

import org.apache.struts.action.ActionMapping;

import org.apache.struts.action.ActionMessage;

public class RegisterForm extends org.apache.struts.action.ActionForm {

private String name;

private String age;

private String address;

private String email;

private String doj;

private String id;

public String getName() {

return name;

}

public void setName(String string) {

name = string;

}

public String getAddress() {

return address;

}

public void setAddress(String address) {

this.address = address;

}

public String getAge() {

return age;

}

public void setAge(String age) {

this.age = age;

}

public String getDoj() {

return doj;

}

public void setDoj(String doj) {

this.doj = doj;

}

public String getEmail() {

return email;

}

public void setEmail(String email) {

this.email = email;

}

public String getId() {

return id;

}

public void setId(String id) {

this.id = id;

}

public RegisterForm() {

super();

}

public ActionErrors validate(ActionMapping mapping, HttpServletRequest request) {

ActionErrors errors = new ActionErrors();

if (getName() == null || getName().length() < 1) {

errors.add("name", new ActionMessage("error.name.required"));

}

if (getAddress() == null || getAddress().length() <= 10) {

errors.add("address", new ActionMessage("error.address.required"));

}

if (getAge() == null || getAge().length() <= 1) {

errors.add("age", new ActionMessage("error.age.required"));

}

if (doj == null || doj.length() <= 4) {

errors.add("doj", new ActionMessage("error.doj.required"));

}

if (email == null || email.equals("")) {

errors.add("email", new ActionMessage("error.email.required"));

}

return errors;

}

RegisterAction.java

package com.myapp.struts.action;

import com.myapp.bo.RegisterBo;
import com.myapp.hibernate.Register;
import com.myapp.struts.form.RegisterForm;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.springframework.context.ApplicationContext;
import org.springframework.web.context.support.WebApplicationContextUtils;

import org.apache.commons.beanutils.BeanUtils;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForward;

public class RegisterAction extends org.apache.struts.action.Action {

    private final static String SUCCESS = "success";
   public ActionForward execute(ActionMapping mapping, ActionForm form,
            HttpServletRequest request, HttpServletResponse response)
            throws Exception {

        RegisterBo registerBo = (RegisterBo) Plugin.getContext(request).getBean("registerBo");
        System.out.println("aaaaaaaa");
        RegisterForm registerForm = (RegisterForm) form;
        System.out.println("aaaaaaaa");

        Register register = new Register();
        BeanUtils.copyProperties(register, registerForm);
        registerBo.addRegister(register);
        return mapping.findForward(SUCCESS);
    }
}

package com.myapp.struts.action;

import com.myapp.bo.RegisterBo;

import com.myapp.hibernate.Register;

import com.myapp.struts.form.RegisterForm;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.springframework.context.ApplicationContext;

import org.springframework.web.context.support.WebApplicationContextUtils;

import org.apache.commons.beanutils.BeanUtils;

import org.apache.struts.action.Action;

import org.apache.struts.action.ActionForm;

import org.apache.struts.action.ActionMapping;

import org.apache.struts.action.ActionForward;

public class RegisterAction extends org.apache.struts.action.Action {

private final static String SUCCESS = "success";

public ActionForward execute(ActionMapping mapping, ActionForm form,

HttpServletRequest request, HttpServletResponse response)

throws Exception {

RegisterBo registerBo = (RegisterBo) Plugin.getContext(request).getBean("registerBo");

System.out.println("aaaaaaaa");

RegisterForm registerForm = (RegisterForm) form;

System.out.println("aaaaaaaa");

BeanUtils.copyProperties(register, registerForm);

registerBo.addRegister(register);

return mapping.findForward(SUCCESS);

}

<!--?xml version="1.0"?-->

<!-- Generated Oct 7, 2011 5:54:08 PM by Hibernate Tools 3.2.1.GA -->
<hibernate-mapping>
    <class name="com.myapp.hibernate.Register" table="register" catalog="ebhor">
        <id name="id" type="java.lang.Integer">
            <column name="id">
            <generator class="identity">
        </generator></column></id>
        <property name="name" type="string">
            <column name="name" length="45" not-null="true">
        </column></property>
        <property name="age" type="string">
            <column name="age" length="45" not-null="true">
        </column></property>
        <property name="doj" type="string">
            <column name="doj" length="45" not-null="true">
        </column></property>
        <property name="email" type="string">
            <column name="email" length="45" not-null="true">
        </column></property>
        <property name="address" type="string">
            <column name="address" length="45" not-null="true">
        </column></property>
    </class>
</hibernate-mapping>

<hibernate-mapping>

</generator></column></id>

</column></property>

</column></property>

</column></property>

</column></property>

</column></property>

</class>

</hibernate-mapping>

package com.myapp.hibernate;
public class Register  implements java.io.Serializable {

     private Integer id;
     private String name;
     private String age;
     private String doj;
     private String email;
     private String address;

    public Register() {
    }

    public Register(String name, String age, String doj, String email, String address) {
       this.name = name;
       this.age = age;
       this.doj = doj;
       this.email = email;
       this.address = address;
    }
   
    public Integer getId() {
        return this.id;
    }
    
    public void setId(Integer id) {
        this.id = id;
    }
    public String getName() {
        return this.name;
    }
    
    public void setName(String name) {
        this.name = name;
    }
    public String getAge() {
        return this.age;
    }
    
    public void setAge(String age) {
        this.age = age;
    }
    public String getDoj() {
        return this.doj;
    }
    
    public void setDoj(String doj) {
        this.doj = doj;
    }
    public String getEmail() {
        return this.email;
    }
    
    public void setEmail(String email) {
        this.email = email;
    }
    public String getAddress() {
        return this.address;
    }
    
    public void setAddress(String address) {
        this.address = address;
    }
}

package com.myapp.hibernate;

public class Register implements java.io.Serializable {

private Integer id;

private String name;

private String age;

private String doj;

private String email;

private String address;

public Register() {

}

public Register(String name, String age, String doj, String email, String address) {

this.name = name;

this.age = age;

this.doj = doj;

this.email = email;

this.address = address;

}

public Integer getId() {

return this.id;

}

public void setId(Integer id) {

this.id = id;

}

public String getName() {

return this.name;

}

public void setName(String name) {

this.name = name;

}

public String getAge() {

return this.age;

}

public void setAge(String age) {

this.age = age;

}

public String getDoj() {

return this.doj;

}

public void setDoj(String doj) {

this.doj = doj;

}

public String getEmail() {

return this.email;

}

public void setEmail(String email) {

this.email = email;

}

public String getAddress() {

return this.address;

}

public void setAddress(String address) {

this.address = address;

}

RegisterDao.java

package com.myapp.dao;

import com.myapp.hibernate.Register;
import java.util.List;

public interface RegisterDao {
    void addRegister(Register register);

	List<register> findAllRegister();

}
</register>

package com.myapp.dao;

import com.myapp.hibernate.Register;

import java.util.List;

public interface RegisterDao {

void addRegister(Register register);

List<register> findAllRegister();

}

</register>

RegisterDao.Impl.java

package com.myapp.dao.impl;

import com.myapp.dao.RegisterDao;
import com.myapp.hibernate.Register;
import java.util.List;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

public class RegisterDaoImpl extends HibernateDaoSupport implements RegisterDao{

    public void addRegister(Register register) {
        //register.setAddress("address");
        getHibernateTemplate().save(register);
    }

    public List<register> findAllRegister() {
        return getHibernateTemplate().find("from Register");
    }

}
</register>

package com.myapp.dao.impl;

import com.myapp.dao.RegisterDao;

import com.myapp.hibernate.Register;

import java.util.List;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

public class RegisterDaoImpl extends HibernateDaoSupport implements RegisterDao{

public void addRegister(Register register) {

//register.setAddress("address");

getHibernateTemplate().save(register);

}

public List<register> findAllRegister() {

return getHibernateTemplate().find("from Register");

}

</register>

RegisterBoImpl.java

package com.myapp.bo.impl;

import com.myapp.bo.RegisterBo;
import com.myapp.dao.RegisterDao;
import com.myapp.hibernate.Register;
import java.util.List;

public class RegisterBoImpl implements RegisterBo {

        RegisterDao registerDao;
        public void setRegisterDao(RegisterDao registerDao){
            this.registerDao=registerDao;
        }
    public void addRegister(Register register) {
       registerDao.addRegister(register);
    }

    public List<register> findAllRegister() {
       return registerDao.findAllRegister();
    }

}
</register>

package com.myapp.bo.impl;

import com.myapp.bo.RegisterBo;

import com.myapp.dao.RegisterDao;

import com.myapp.hibernate.Register;

import java.util.List;

public class RegisterBoImpl implements RegisterBo {

RegisterDao registerDao;

public void setRegisterDao(RegisterDao registerDao){

this.registerDao=registerDao;

}

public void addRegister(Register register) {

registerDao.addRegister(register);

}

public List<register> findAllRegister() {

return registerDao.findAllRegister();

}

</register>

RegisterBo.java

package com.myapp.bo;

import com.myapp.hibernate.Register;
import java.util.List;

public interface RegisterBo {
    void addRegister(Register register);

	List<register> findAllRegister();

}
</register>

package com.myapp.bo;

import com.myapp.hibernate.Register;

import java.util.List;

public interface RegisterBo {

void addRegister(Register register);

List<register> findAllRegister();

}

</register>

Hibernate mapping files detail

January 29, 2023January 28, 2023 by Manish Sahu

Mapping Declaration Object/relational mappings are usually defined in XML document. The mapping language is Java-centric, meaning that mappings are constructed around persistent class declarations, not table declarations. Mapping Document

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

<hibernate-mapping package="pojo">
<class name="Employee" table=”Employee”>
<id name="id" type=”java.lang.Long”>
<generator class=”sequence”/>
</id>
</class>
</hibernate-mapping>

<strong><class>  </strong>element

<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC

"-//Hibernate/Hibernate Mapping DTD 3.0//EN"

"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="pojo">

</id>

</class>

</hibernate-mapping>

<strong><class> </strong>element

The element maps the domain object with corresponding entity in the database. hibernate-mapping element allows you to nest several persistent mappings, as shown above. It … Read more

Detail of program

January 29, 2023January 28, 2023 by Manish Sahu

Hibernate client application is the actual application who wants to intrect with database software. In the client application development two important roles are involved. get hibernate session object from a pool called hibernate seassionFactory. Use hibernate session object to perform curd operation on the database table. Persistance operation single row operations, Bulk operations. Single row … Read more

Hibernet first program

January 29, 2023January 28, 2023 by Manish Sahu

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/ebhor</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">root</property>
<mapping resource="Pojo/Employee.hbm.xml"/>
</session-factory>
</hibernate-configuration>

<?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.connection.driver_class">com.mysql.jdbc.Driver</property>

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

</session-factory>

</hibernate-configuration>

Employee.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="Pojo.Employee" table="employee" catalog="ebhor">
<id name="id" type="java.lang.Integer">
<column name="id" />
<generator />
</id>
<property name="firstName" type="string">
<column name="FirstName" length="45" not-null="true" />
</property>
<property name="lastName" type="string">
<column name="LastName" length="45" not-null="true" />
</property>
<property name="email" type="string">
<column name="Email" length="45" not-null="true" />
</property>
</class>
</hibernate-mapping>

<?xml version="1.0"?>

<!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>

</property>

</class>

</hibernate-mapping>

Employee.java

package Pojo;
public class Employee implements java.io.Serializable {

private Integer id;
private String firstName;
private String lastName;
private String email;

public Employee() {
}

public Employee(String firstName, String lastName, String email) {
this.firstName = firstName;
this.lastName = lastName;
this.email = email;
}

public Integer getId() {
return this.id;
}

public void setId(Integer id) {
this.id = id;
}
public String getFirstName() {
return this.firstName;
}

public void setFirstName(String firstName) {
this.firstName = firstName;
}
public String getLastName() {
return this.lastName;
}

public void setLastName(String lastName) {
this.lastName = lastName;
}
public String getEmail() {
return this.email;
}

public void setEmail(String email) {
this.email = email;
}
}

package Pojo;

public class Employee implements java.io.Serializable {

private Integer id;

private String firstName;

private String lastName;

private String email;

public Employee() {

}

public Employee(String firstName, String lastName, String email) {

this.firstName = firstName;

this.lastName = lastName;

this.email = email;

}

public Integer getId() {

return this.id;

}

public void setId(Integer id) {

this.id = id;

}

public String getFirstName() {

return this.firstName;

}

public void setFirstName(String firstName) {

this.firstName = firstName;

}

public String getLastName() {

return this.lastName;

}

public void setLastName(String lastName) {

this.lastName = lastName;

}

public String getEmail() {

return this.email;

}

public void setEmail(String email) {

this.email = email;

}

EmpInsert.java

package HibClient;

import Pojo.Employee;
import org.hibernate.cfg.Configuration;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.Session;
import org.hibernate.HibernateException;

public class EmpInsert
{
public static void main(String args[])
{
try
{
// This step will read hibernate.cfg.xml and prepare hibernate for use
Configuration conf = new Configuration();
Configuration cf = conf.configure();
SessionFactory factory = cf.buildSessionFactory();
Session session = factory.openSession();
System.out.println("++++++++++++++");
//Create new instance of Contact and set values in it

Employee emp = new Employee();

emp.setFirstName("anurag");
emp.setLastName("Singh");
emp.setEmail("anuragsingh11ls@gmail.com");
System.out.println("insertion");
Transaction tx=session.beginTransaction();
session.save(emp);
tx.commit();

session.close();
}
catch (HibernateException e)
{

System.out.println(" "+e.getMessage());
e.printStackTrace();
}
} 
}

package HibClient;

import Pojo.Employee;

import org.hibernate.cfg.Configuration;

import org.hibernate.SessionFactory;

import org.hibernate.Transaction;

import org.hibernate.Session;

import org.hibernate.HibernateException;

public class EmpInsert

{

public static void main(String args[])

{

try

{

// This step will read hibernate.cfg.xml and prepare hibernate for use

Configuration conf = new Configuration();

Configuration cf = conf.configure();

SessionFactory factory = cf.buildSessionFactory();

Session session = factory.openSession();

System.out.println("++++++++++++++");

//Create new instance of Contact and set values in it

Employee emp = new Employee();

emp.setFirstName("anurag");

emp.setLastName("Singh");

emp.setEmail("[email protected]");

System.out.println("insertion");

Transaction tx=session.beginTransaction();

session.save(emp);

tx.commit();

session.close();

}

catch (HibernateException e)

{

System.out.println(" "+e.getMessage());

e.printStackTrace();

}

Whenever this program get compiled and run this application as simple java application run same this client application insert the records in database.

Components using hibernate based application

January 28, 2023January 27, 2023 by Manish Sahu

Pojo class. Hbm.xml file. Hibernate configuration . xml file. Client class of hibernate. Pojo class It is an ordinary java class having member variable.the pojo class will be mapped with table and member variable will be mapped with table columns in the process of o-r mapping.this class will used by hibernate client application to developed … Read more

Hibernate Architecture

January 28, 2023January 27, 2023 by Manish Sahu

Hibernate support all layer architecture single layer,2 layer,n layer High level architecture of Hibernate can be described as shown in following illustration. Hibernate configuration file In earlier version it was a properties file from hibernate 2.2x it is change if no file is explicitly specified it becomes a hibernate-cfg.xml file as the hibernate configuration file … Read more

Features of Hibernate

January 28, 2023January 27, 2023 by Manish Sahu

Transparent persistence without byte code processing Object-oriented query language Powerful object-oriented query language Full support for polymorphic queries New Criteria queries Native SQL queries Object / Relational mappings Three different O/R mapping strategies Multiple-objects to single-row mapping Polymorphic associations Bidirectional associations Automatic primary key generation Multiple synthetic key generation strategies Support for application assigned identifiers … Read more

Date range query on Timestamp field in HQL

January 18, 2023January 18, 2023 by manish

Suppose we want to make query between two dates in a timestamp field for example We have a table colors to store different colors

create table colors(
color_id bigint(10)NOT NULL AUTO_INCREMENT,
color varchar(50),
add_date timestamp DEFAULT 0,
status varchar(20),
primary Key(color_id));

create table colors(

color_id bigint(10)NOT NULL AUTO_INCREMENT,

color varchar(50),

add_date timestamp DEFAULT 0,

status varchar(20),

primary Key(color_id));

Pojo class for color table is

public class Color  implements java.io.Serializable {
     private Long colorId;
     private String color;
     private Timestamp addDate;
     private String status;
//getter setter and constructor

public class Color implements java.io.Serializable {

private Long colorId;

private String color;

private Timestamp addDate;

private String status;

//getter setter and constructor

Above class shows that addDate is timestamp field and we want to query it as date for that we have casted timestamp field … Read more