Saturday, April 21, 2012

Hibernate Compoundkey


package com.hibernate.venkat;

import javax.persistence.Entity;
import javax.persistence.Id;



/**
 * @author vt013s
 *
 */
@Entity
public class Accounts{


private CompoundKey compoundkey;
private int accountbalance;

@Id
public CompoundKey getCompoundkey() {
return compoundkey;
}
public void setCompoundkey(CompoundKey compoundkey) {
this.compoundkey = compoundkey;
}
public int getAccountbalance() {
return accountbalance;
}
public void setAccountbalance(int accountbalance) {
this.accountbalance = accountbalance;
}




}
-------------------------------------------------------------------------
package com.hibernate.venkat;

import java.io.Serializable;

import javax.persistence.Embeddable;
@Embeddable
public class CompoundKey  implements Serializable{

/**
*/
private static final long serialVersionUID = -571031490335757858L;
private int userId;
private int accountId;
public CompoundKey(int userId, int accountId) {
super();
this.userId = userId;
this.accountId = accountId;
}
public int getUserId() {
return userId;
}
public void setUserId(int userId) {
this.userId = userId;
}
public int getAccountId() {
return accountId;
}
public void setAccountId(int accountId) {
this.accountId = accountId;
}
}
---------------------------------------------------------------------------------------------
package com.hibernate.venkat;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.AnnotationConfiguration;
import org.hibernate.tool.hbm2ddl.SchemaExport;

/**
 * @author vt013s
 *
 */
public class TestAccount {

/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
AnnotationConfiguration config=new AnnotationConfiguration();
config.addAnnotatedClass(Accounts.class);
config.configure("hibernate.cfg.xml");

new SchemaExport(config).create(true, true);

SessionFactory sf=config.buildSessionFactory();
Session s= sf.getCurrentSession();
s.beginTransaction();

CompoundKey key=new CompoundKey(100,10000);
CompoundKey key1=new CompoundKey(101,20000);

Accounts savings= new Accounts();
savings.setCompoundkey(key);
savings.setAccountbalance(8500);
s.save(savings);

Accounts checking= new Accounts();
checking.setCompoundkey(key1);
checking.setAccountbalance(9500);
s.save(checking);

s.getTransaction().commit();

}

}
---------------------------------------------------------------------------------------------

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

        <!-- Database connection settings -->
        <property name="connection.driver_class">oracle.jdbc.OracleDriver</property>
        <property name="connection.url">jdbc:oracle:thin:@localhost:1521:xe</property>
        <property name="connection.username">venkat</property>
        <property name="connection.password">venkat</property>

        <!-- JDBC connection pool (use the built-in) -->
        <property name="connection.pool_size">2</property>

        <!-- SQL dialect -->
        <property name="dialect">org.hibernate.dialect.Oracle10gDialect</property>

        <!-- Enable Hibernate's current session context -->
        <property name="current_session_context_class">thread</property>

        <!-- Disable the second-level cache  -->
        <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>

        <!-- Echo all executed SQL to stdout -->
        <property name="show_sql">true</property>

        <!-- Drop and re-create the database schema on startup -->
<!--         <property name="hbm2ddl.auto">create</property> -->

<!--         <mapping resource="org/hibernate/tutorial/domain/Event.hbm.xml"/> -->
<!--         <mapping resource="org/hibernate/tutorial/domain/Person.hbm.xml"/> -->

    </session-factory>

</hibernate-configuration>

No comments:

Post a Comment