2:19 am - Tuesday November 13, 2018

Hibernate createCriteria Restriction isNull() Example Program in Eclipse

CANDID INDUSTRIAL TRAINING -- CHENNAI
Corporate Training for Experienced Candidate
Struts | Hibernate | Spring | Java / J2EE
SOAP | RestFull | Design Pattern | more...
Ph: +91 72000 69003
137b, 2nd st, shanthi nagar, Chrompet, Chennai -600044

ProjectStructure:

 

    

 

 

 

 

  

 

 

 

JarFiles:

 

 

 

 

 

 

 

 

 

  

 

IsNull.java:

package com.candidjava;

import java.util.*;
import org.hibernate.*;
import org.hibernate.cfg.*;
import org.hibernate.criterion.*;
import java.io.*;
import org.hibernate.Transaction;

public class IsNull {
	public static void main(String[] args) throws Exception {
		try {
			StudentControl uc = new StudentControl();
			uc.isNull(args);
		} catch (Exception e) {
			System.out.println(e.getMessage());
		}
	}
}

Student.java:

package com.candidjava;

import java.io.*;

public class Student implements Serializable {
 private long id;
 private String stuid;
 private String sturegno;
 private String stuname;
 private String stumark1;
 private String stumark2;
 private String degree;
 private String mobileno;
 private String mailid;

 public long getId() {
 return id;
 }

 public String getStuid() {
 return stuid;
 }

 public String getSturegno() {
 return sturegno;
 }

 public String getStuname() {
 return stuname;
 }

 public String getStumark1() {
 return stumark1;
 }

 public String getStumark2() {
 return stumark2;
 }

 public String getDegree() {
 return degree;
 }

 public String getMobileno() {
 return mobileno;
 }

 public String getMailid() {
 return mailid;
 }

 public void setId(long string) {
 id = string;
 }

 public void setStuid(String string) {
 stuid = string;
 }

 public void setSturegno(String string) {
 sturegno = string;
 }

 public void setStuname(String string) {
 stuname = string;
 }

 public void setStumark1(String string) {
 stumark1 = string;
 }

 public void setStumark2(String string) {
 stumark2 = string;
 }

 public void setDegree(String string) {
 degree = string;
 }

 public void setMobileno(String string) {
 mobileno = string;
 }

 public void setMailid(String string) {
 mailid = string;
 }

}

 

StudentControl.java:

package com.candidjava;

import java.sql.*;
import java.util.Iterator;
import java.util.List;
import java.io.*;
import org.hibernate.*;
import org.hibernate.cfg.*;
import org.hibernate.criterion.Restrictions;

public class StudentControl {

	private static SessionFactory sessionFactory;

	private Session getSession() {
		Session s = null;
		try {
			sessionFactory = new Configuration().configure(
					"com\\xml\\hibernate.cfg.xml").buildSessionFactory();
			s = sessionFactory.openSession();
		} catch (HibernateException e) {
			System.out.println(e.getMessage());
		}
		return s;
	}

	public void isNull(String[] args) throws Exception {
		try {
			Session s = getSession();
			Transaction tx = s.beginTransaction();
			DataInputStream ds = new DataInputStream(System.in);
			System.out.println("*******************************");
			System.out
					.println("Enter Column name to find weather it has Null Value or not");
			String col = ds.readLine();
			Criteria c = s.createCriteria(Student.class).add(
					Restrictions.isNull(col));
			List li = c.list();
			Iterator it = li.iterator();
			System.out.print("\n");
			if (it.hasNext() == true) {

				while (it.hasNext()) {
					Student u = (Student) it.next();
					System.out.println("ID:" + u.getId());
					System.out.println("StuID:" + u.getStuid());
					System.out.println("RegNo:" + u.getSturegno());
					System.out.println("Name:" + u.getStuname());
					System.out.println("Mark1:" + u.getStumark1());
					System.out.println("Mark2:" + u.getStumark2());
					System.out.println("Degree:" + u.getDegree());
					System.out.println("Mobile no:" + u.getMobileno());
					System.out.println("Mail ID:" + u.getMailid());
					System.out.println();
				}
			} else {
				System.out.println("It doesn't have null values");
			}
		} catch (HibernateException e) {
			System.out.println(e.getMessage());
			System.out.println("error");
		}

	}

}// end of class</pre>

web.xml:

<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4"
	xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
	<display-name>RestrictionIsNull</display-name>
	<welcome-file-list>
		<welcome-file>index.html</welcome-file>
		<welcome-file>index.htm</welcome-file>
		<welcome-file>index.jsp</welcome-file>
		<welcome-file>default.html</welcome-file>
		<welcome-file>default.htm</welcome-file>
		<welcome-file>default.jsp</welcome-file>
	</welcome-file-list>
</web-app>

hibernate.cfg.xml:

<!DOCTYPE hibernate-configuration PUBLIC
	"-//Hibernate/Hibernate Configuration DTD//EN"
	"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
	<session-factory name="studentFactory">
		<property name="connection.driver_class">
			oracle.jdbc.OracleDriver
	        </property>
		<property name="connection.url">
			jdbc:oracle:thin:@localhost:1521:XE
		</property>
		<property name="connection.username">
			system
		</property>
		<property name="connection.password">
			system
		</property>
		<property name="connection.pool_size">5</property>
		<!-- SQL dialect -->
		<property name="dialect">
			org.hibernate.dialect.OracleDialect
	        </property>
		<!-- Echo all executed SQL to stdout -->
		<property name="show_sql">false</property>
		<property name="hbm2ddl.auto">update</property>
		<mapping resource="\com\\xml\\Student.hbm.xml" />
	</session-factory>
</hibernate-configuration>

Student.hbm.xml:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
	"-//Hibernate/Hibernate Mapping DTD//EN"
	"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
	<class name="com.candidjava.Student" table="Student">
		<id name="id" type="long" column="Id">
			<generator class="increment" />
		</id>
		<property name="stuid" column="StuId" not-null="true" />
		<property name="sturegno" column="StuRegNO" />
		<property name="stuname" column="StuName" />
		<property name="stumark1" column="StuMark1" />
		<property name="stumark2" column="StuMark2" />
		<property name="degree" column="Degree" />

		<property name="mobileno" column="MobileNo" />
		<property name="mailid" column="MailId" />
	</class>
</hibernate-mapping>

OUTPUT:

 DOWNLOAD+SOURCECODE 

BACK 

                                    

Filed in: Z-A Hibernate codes

No comments yet.

Leave a Reply