Hibernate Example

CREATE TABLE /*!32312 IF NOT EXISTS*/ `employee` (
`id` int(10) unsigned default NULL,
`empname` varchar(50) default NULL,
`date_of_joining` date default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
===================

hibernate.cfg.xml
===================
<?xml version="1.0" encoding="UTF-8"?>
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory name="myfactory">
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost/csr</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">admin</property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property>
<property name="hibernate.show_sql">true</property>
<property name="hbm2ddl.auto">update</property>
<mapping resource="com/csr/bean/Employee.hbm.xml"/>
</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 package="com.csr.bean">
<class name="Employee" >
<id name="id" column="id" type="integer">
<generator class="increment"></generator>
</id>
<property name="empname" column="employeename" type="string"/>
<property name="DOJ" column="date_of_joining" type="date"/>
</class>
</hibernate-mapping>

=============
package com.csr.bean;

import java.util.Date;

public class Employee {
private int id;
private String empname;
private Date DOJ;
public Date getDOJ() {
return DOJ;
}
public void setDOJ(Date doj) {
DOJ = doj;
}
public String getEmpname() {
return empname;
}
public void setEmpname(String empname) {
this.empname = empname;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}


}
===============
<%
SessionFactory factory=null;
Session ses=null;
Transaction trans=null;
try
{
String bookname = request.getParameter("bookname");
factory=new Configuration().configure().buildSessionFactory();
ses=factory.openSession();
trans=ses.beginTransaction();
Book book = new Book();
book.setLngBookId(4);
book.setStrBookName(bookname);
//ses.update(book);
ses.delete(book);
trans.commit();
ses.flush();
ses.close();
System.out.println("Book object persisted to the database.");
}
catch(Exception e)
{
out.println("error "+e.getMessage());
}
%>

========================================