Hibernate Collection Mapping example


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.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/Test</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">minu</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="show_sql">true</property>
<property name="hbm2ddl.auto">update</property>
<mapping resource="com/Mapping/hibernate/hibernate.hbm.xml"/>

</session-factory>
</hibernate-configuration>



hibernate.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 package="com.Mapping.hibernate">

<class name="Student" table="student">
 <id name="sid" column="sid" type="int">
 <generator class="increment"/>
 </id>
 <property name="sname" column="sname" type="string"/>
 <property name="dob" column="dob" type="string"/>
 <property name="qualification" column="quali" type="string"/>

 <array name="courses" table="courses">

  <key column="sid"/>
  <index column="idx"/>
  <element column="cname" type="string"/>
 
 </array>
 <list name="emails" table="emails">

  <key column="sid"/>
  <index column="idx"/>
  <element column="emails" type="string"/>
 
 </list>
 <bag name="marks" table="marks">

  <key column="sid"/>
 
  <element column="marks" type="int"/>
 
 </bag>
 <set name="phones" table="phones">

  <key column="sid"/>
 
  <element column="phones" type="long"/>
 
 </set>
 <map name="refs" table="refs">

  <key column="sid"/>
  <index column="rname" type="string"/>
  <element column="rphone" type="long"/>
 
 </map>
</class>

</hibernate-mapping>

Student.java

package com.Mapping.hibernate;

import java.util.*;

public class Student {

private int sid;
private String sname;
private String dob;
private String qualification;
private String[] courses;
private List<String> emails;
private List<Integer> marks;
private Set<Long> phones;
private Map<String,Long> refs;

public Student(){}
public Student(int sid, String sname, String dob, String qualification,
String[] courses, List<String> emails, List<Integer> marks,
Set<Long> phones, Map<String, Long> refs) {
super();
this.sid = sid;
this.sname = sname;
this.dob = dob;
this.qualification = qualification;
this.courses = courses;
this.emails = emails;
this.marks = marks;
this.phones = phones;
this.refs = refs;
}

public Student(String sname, String dob, String qualification,
String[] courses, List<String> emails, List<Integer> marks,
Set<Long> phones, Map<String, Long> refs) {
super();
this.sname = sname;
this.dob = dob;
this.qualification = qualification;
this.courses = courses;
this.emails = emails;
this.marks = marks;
this.phones = phones;
this.refs = refs;
}
public int getSid() {
return sid;
}
public void setSid(int sid) {
this.sid = sid;
}
public String getSname() {
return sname;
}
public void setSname(String sname) {
this.sname = sname;
}
public String getDob() {
return dob;
}
public void setDob(String dob) {
this.dob = dob;
}
public String getQualification() {
return qualification;
}
public void setQualification(String qualification) {
this.qualification = qualification;
}
public String[] getCourses() {
return courses;
}
public void setCourses(String[] courses) {
this.courses = courses;
}
public List<String> getEmails() {
return emails;
}
public void setEmails(List<String> emails) {
this.emails = emails;
}
public List<Integer> getMarks() {
return marks;
}
public void setMarks(List<Integer> marks) {
this.marks = marks;
}
public Set<Long> getPhones() {
return phones;
}
public void setPhones(Set<Long> phones) {
this.phones = phones;
}
public Map<String, Long> getRefs() {
return refs;
}
public void setRefs(Map<String, Long> refs) {
this.refs = refs;
}


}

HibernateUtil.java

package com.Mapping.hibernate;
import org.hibernate.*;
import org.hibernate.cfg.*;
public class HibernateUtil {
static SessionFactory factory;
 static
 {
  try
  {
   Configuration cfg=new Configuration();
   cfg=cfg.configure();
   factory=cfg.buildSessionFactory();
   
  }
  catch(Exception e)
  {
   e.printStackTrace();
  }
 }
 public static SessionFactory getSessionFactory()
 {
  return factory;
 }
}

Lab.java

package com.Mapping.hibernate;
import java.util.*;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;

public class Lab {

public static void main(String[] args) {
try
{
SessionFactory sf=HibernateUtil.getSessionFactory();
Session session=sf.openSession();
Transaction tx=session.beginTransaction();
String cou[]={"JDBC","JSF","J2EE","EJB"};
List<String> ems=new ArrayList<String>();
ems.add("a1@gmail.com");
ems.add("a2@gmail.com");
ems.add("a3@gmail.com");
List<Integer> mks=new ArrayList<Integer>();
mks.add(new Integer(100));
mks.add(new Integer(89));
mks.add(new Integer(90));
Set<Long> phs=new HashSet<Long>();
phs.add(new Long(111));
phs.add(new Long(222));
phs.add(new Long(333));
Map<String,Long> refs=new HashMap<String,Long>();
refs.put("aaa",new Long(122345));
refs.put("bbb",new Long(129856));
refs.put("ccc",new Long(129978));
Student st=new Student("Minu","11-08-1988","BTech",cou,ems,mks,phs,refs);
session.save(st);
tx.commit();
session.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}


Comments

Post a Comment

Popular posts from this blog

C programming:-Files - Part 5

/*         Explain how do you create , open a file. WAP to read from a keyboard and write to a file and display its contents. Give examples.*/ #include<stdio.h> main() {             FILE *fp;             char s[30],s1[30];             printf("enter a string:");             gets(s); //read a string from terminal             fp=fopen("file1.txt","w");             fprintf(fp,"%s",s);//write string s to file1.txt             fclose(fp);             //display file contents             printf("file contents are: ");             fp=fopen("file1.txt","r");             fgets(s1,30,fp); //reads data from file to a string s1             printf("%s",s1);// display string s1 to the terminal } /*OUTPUT enter a string:hello students file contents are: hello students */ WRITE A C PROGRAM TO MERGE TWO FILES? #include<stdio.h> #include<conio.h> void main
Read more

Struts 2 Troubleshooting

Image
  How to add session in struts2 action class: You can access the session object using a jsp scriplet and set your required variables there. <% request.getSession().setAttribute("your_variable",obj) %> From the Action class , you can get access to session either by implementing the ServletRequestAware Interface within your action class or by implementing the SessionAware interface. request.getSession().getAttribute("var"); ref:   http://struts.1045723.n5.nabble.com/How-to-set-a-variable-in-session-in-the-JSP-td3499780.html OR add an attribute "private Map session;" in Action class. create getters and setters. use below code to put and get values from sesiion. session = ActionContext.getContext().getSession();  session.put("logged_in", "no"); boolean loggedIn = (Boolean) session.get("logged-in"); session.remove("selectedMatch");
Read more