<?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, we use jndi here -->                   
        <property name="hibernate.connection.datasource">               
			jdbc/localdb</property>                                                           
        <property name="connection.pool_size">1</property>        
        <!-- SQL dialect -->                                                      
        <property name="dialect">                                       
			org.hibernate.dialect.DB2Dialect</property>                                       
        <!-- Enable Hibernate's automatic session context management -->          
        <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>                 
        <mapping resource=                                                           
			"/gen/src/module/stock/implementation/Stock.hbm.xml"/>                     
        <mapping resource=                                                           
			"/gen/src/module/stock/implementation/StockType.hbm.xml"/>                 
        <mapping resource=                                                           
			"/gen/src/module/stock/implementation/StockAccount.hbm.xml"/>              
        <mapping resource=                                                           
			"/gen/src/module/stock/implementation/StockHolder.hbm.xml"/>               
        <mapping resource=                                                           
			"/gen/src/module/stock/implementation/StockMemo.hbm.xml"/>                 
    </session-factory>                                                            
</hibernate-configuration>                                                        

                
CREATE TABLE stockType(
  id                VARCHAR(10) NOT NULL,
  typeName          VARCHAR(20),
  CONSTRAINT pk_stockType PRIMARY KEY(id)
);

                
package module.stock.implementation;
import java.io.Serializable;
public class StockType implements Serializable {
    private String id;
    private String typeName;
    //Getters and setters…
    … …
}

                
<?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="module.stock.implementation">        
    <class name="StockType" table="StockType" 
        lazy="true">       
        <comment>Stock Type table</comment>                      
        <id name="id">                                           
            <generator class="assigned" />                       
        </id>                                                    
        <property name="typeName"/>                              
    </class>                                                     
</hibernate-mapping> 

                
CREATE TABLE stock(
  id                  VARCHAR(10) NOT NULL,
  stkName             VARCHAR(40),
  stkTypeId           VARCHAR(10),
  CONSTRAINT pk_stock PRIMARY KEY (id)
);

                
package module.stock.implementation;
import java.io.Serializable;
public class Stock implements Serializable {
    private String id;
    private String stkName;
    private String stkTypeId;
    private StockType stkType;
    //Getters and setters
    ……
}

                
<?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="module.stock.implementation">
    <class name="Stock" table="Stock" lazy="true">
        <comment>Stock table</comment>      
        <id name="id">
            <generator class="assigned" />
        </id>       
        <property name="stkName"/>
        <property name="stkTypeId" />
        <many-to-one name="stkType" class="StockType"
            insert="false" update="false">
            <column name="stkTypeId"/>
        </many-to-one>
    </class>    
</hibernate-mapping>

                
CREATE TABLE StockHolder(
  id                INTEGER NOT NULL, 
  name              VARCHAR(40), 
  gender            CHAR(2),     
  idCardNum         VARCHAR(18), 
  email             VARCHAR(50), 
  address           VARCHAR(100),
  CONSTRAINT pk_stockHolder PRIMARY KEY (id)
);
CREATE SEQUENCE stockHolder_seq
    START WITH 1005
    INCREMENT BY 1
    NOMAXVALUE
    NOCYCLE
    CACHE 24 ;

                
public class StockHolder implements Serializable {
    private String id;
    private String name;
    private String gender;
    private String idCardNum;
    private String email;
    private String address;
//Getters and setters
……
}

                
<?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="module.stock.implementation">
    <class name="StockHolder" table="StockHolder" 
        lazy="true">
        <comment>Stock Holder table</comment>       
        <id name="id">
            <generator class="sequence">
                <param name="sequence">stockHolder_seq</param>
            </generator>
        </id>       
        <property name="name"/>
        <property name="gender"/>
        <property name="idCardNum"/>
        <property name="email"/>
        <property name="address"/>
    </class>    
</hibernate-mapping>

                
CREATE TABLE stockMemo(
  id                INTEGER NOT NULL
                    GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1),
  stockId           VARCHAR(10) NOT NULL, 
  currentPrice      DECIMAL(17,3),
  highestPrice      DECIMAL(17,3),
  lowestPrice       DECIMAL(17,3),
  tradeDate         VARCHAR(10) default char(current date),
  FOREIGN KEY fk_stockMemeo (stockId)
          REFERENCES Stock ON DELETE NO ACTION
);

                
public class StockMemo implements Serializable {
    private String id;
    private String stockId;
    private String currentPrice;
    private String highestPrice;
    private String tradeDate;
private Stock stock;
//Getters and setters
……
}

                
<?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="module.stock.implementation">
    <class name="StockMemo" table="StockMemo" 
        lazy="true">
        <comment>Stock memo table</comment>     
        <id name="id">
            <generator class="native" />
        </id>
        <property name="stockId"/>
        <property name="currentPrice"/>
        <property name="highestPrice"/>
        <property name="lowestPrice"/>
        <property name="tradeDate"/>
        <many-to-one name="stock" class="Stock"
            insert="false" update="false">
            <column name="stockId"/>
        </many-to-one>
    </class>    
</hibernate-mapping>

                
CREATE TABLE account(
  stockHolderId INTEGER NOT NULL,
  stockId           VARCHAR(10) NOT NULL,
  balance           INT,
  profit            DECIMAL(17,3),
  FOREIGN KEY fk_account1 (stockHolderId)
          REFERENCES StockHolder ON DELETE NO ACTION,
  FOREIGN KEY fk_account2 (stockId)
          REFERENCES stock ON DELETE NO ACTION
);

                
public class StockAccount implements Serializable {
    private String stockHolderId;
    private String stockId;
    private int balance;
    private float profit;
    private StockHolder stockHolder;
    private Stock stock;
    private StockMemo stockMemo;
    //Getters and setters
	......
    public boolean equals(StockAccount sa){
        boolean isEquals=false;
        if(sa!=null){
            if(stockHolder.getId().equals(sa.getStockHolder().getId()) &&
                    stockHolder.getIdCardNum().equals(
                        sa.getStockHolder().getIdCardNum()) &&
                        stock.getId().equals(sa.getStock().getId()) &&
                        stock.getStkName().equals(sa.getStock().getStkName())       
                )
                isEquals = true;
        }
        return isEquals;
    }
    public int hashCode() {
        int h=0;
        h = stockHolder.hashCode()+19*stock.hashCode();
        return h;
    }
}

                
<a name="<?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="module.stock.implementation">
	<class name="StockAccount" table="Account" lazy="true">
		<comment>Stock Account table</comment>		
		<composite-id >
			<key-property name="stockHolderId"/>
			<key-property name="stockId"/>
		</composite-id>		
		<many-to-one name="stockHolder" class="StockHolder"
			insert="false" update="false">
			<column name="stockHolderId"/>
		</many-to-one>
		<many-to-one name="stock" class="Stock"
			insert="false" update="false">
			<column name="stockId"/>
		</many-to-one>		
		<many-to-one name="stockMemo" class="StockMemo"
			insert="false" update="false">
			<column name="stockId"/>
		</many-to-one>		
		<property name="balance"/>
		<property name="profit"/>
	</class>	
</hibernate-mapping>
"></a>

                
public class HibernateUtil {
    private static final SessionFactory sessionFactory;
    static {
        try {
            // Create the SessionFactory from hibernate.cfg.xml
            sessionFactory = new Configuration()
                .configure("/gen/src/module/stock/implementation/hibernate.cfg.xml")
                .buildSessionFactory();
        } catch (Throwable ex) {
            System.err.println("Initial SessionFactory creation failed." + ex);
            throw new ExceptionInInitializerError(ex);
        }
    }
    public static SessionFactory getSessionFactory() {
        return sessionFactory;
    }
}

                
public String addStockAccount(DataObject stockHolder, DataObject stock,Integer qty) {
    String message = null;
    if (stockHolder != null && stock != null) {
        try {//得到SessionFactory的实例
            Session session = HibernateUtil.getSessionFactory().getCurrentSession();
            //这一句是必需的，表明Transaction的开始
            session.beginTransaction();
            //将输入参数DataObject分别转换为JavaBean
            StockHolder sh = convertToStockHolder(stockHolder);
            Stock st = convertToStock(stock);
            //新建一个StockAccount Bean对象
            StockAccount sa = new StockAccount();
            //把入参都set进去
            sa.setStock(st);
            sa.setStockHolder(sh);
            sa.setStockHolderId(sh.getId());
            sa.setStockId(st.getId());
            sa.setBalance(qty.intValue());
            sa.setProfit(0); //初始化为0
            //调用session.persist()方法，指定StockAccount将被持久化
            session.persist("StockAccount", sa);
            //调用session.flush()方法将memory中的数据保存到数据库中
            session.flush();
            //关闭session
            session.close();
            message = "StockAccount saved successfully!";
        } catch (Exception e) {
            e.printStackTrace();
            message = "Faile to save StockAccount to database: "+ e.getMessage();
        }
    }
    return message;
}

                
private StockHolder convertToStockHolder(DataObject stockHolderBO) {
    StockHolder stockHolder = null;
    if (stockHolderBO != null) {
        try {
            stockHolder = new StockHolder();
            stockHolder.setId(stockHolderBO.getString("id"));
            stockHolder.setName(stockHolderBO.getString("name"));
            stockHolder.setGender(stockHolderBO.getString("gender"));
            stockHolder.setIdCardNum(stockHolderBO.getString("idCardNum"));
            stockHolder.setEmail(stockHolderBO.getString("email"));
            stockHolder.setAddress(stockHolderBO.getString("address"));
        } catch (Exception e) {
            e.printStackTrace();
            stockHolder = null;
        }
    }
    return stockHolder;
}

                
1     Session session = HibernateUtil.getSessionFactory().getCurrentSession();
2     session.beginTransaction();
3     StockAccount sa = new StockAccount();
…     sa.setXXX(…)
4     session.persist("StockAccount", sa);
5     session.flush();
6     session.close();

                
    public DataObject getStockList(String idNum) {
        DataObject stockListBO = null;
        DataObject stockBO = null;
        ArrayList stockList = new ArrayList();
        if (idNum != null) {
            try {
                stockListBO = boFactory.create("http://StockModule/sdo", "StockList");
                Session session = HibernateUtil.getSessionFactory().getCurrentSession();
                session.beginTransaction();
                Iterator iter;
                iter = session.createQuery(
                   "select sa.stock from StockAccount sa where sa.stockHolder.id = ?")
                   .setString(0, idNum).iterate();
                while (iter.hasNext()) {
                    Stock stock = (Stock) iter.next();
                    stockBO = convertToStockBO(stock);
                    stockList.add(stockBO);
                }
                stockListBO.setList("stocks", stockList);
                session.close();
            } catch (Exception e) {
                e.printStackTrace();
                stockListBO = null;
            }
        }
        return stockListBO;
    }