在 Apache Geronimo 上创建 Hibernate 应用实例

                
CREATE TABLE CUSTOMER
(
    ID              INTEGER NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY 
                       (START WITH 1, INCREMENT BY 1),
    CUSTNAME               VARCHAR(35) NOT NULL,
    AGE                     INTEGER,
    EMAIL                   VARCHAR(35) ,
    ADDRESS                 VARCHAR(35) ,
    CITY                    VARCHAR(35) ,
    COUNTRY                 VARCHAR(3)
)

                
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration
    PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
    "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
<session-factory>
<property name="hibernate.connection.url">
     jdbc:derby:D:/geronimo-1.1/var/derby/SAMPLE;create=true</property> 
         |(1)
<property name="hibernate.connection.driver_class">
        org.apache.derby.jdbc.EmbeddedDriver</property>
<property name="hibernate.connection.username">APP</property>
<property name="hibernate.connection.password"></property>
<property name="dialect">org.hibernate.dialect.DerbyDialect</property>
<property name="myeclipse.connection.profile">MyEclipse Derby</property>
<property name="connection.password">myeclipse</property>
<property name="connection.driver_class">org.apache.derby.jdbc.EmbeddedDriver</property>
<property name="current_session_context_class">thread</property>
</session-factory>
</hibernate-configuration>

                
public class Customer implements Serializable {
private static final long serialVersionUID = 1L;
private int id;
private String custName;
private int age;
private String email;
private String address;
private String city;
private String country;

public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
    …get…
    …set…
}

                
<?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.ibm.sample.bean">
    <class name="Customer" table="CUSTOMER" lazy="true">
        <comment>customer table</comment>       
       <id name="id" column="ID" type="int">
            <generator class="identity" />           |(1)
        </id>         
        <property name="custName" column="CUSTNAME" type="string" 
        update="true" insert="true"/>
        <property name="age" column="AGE" type="int" 
        update="true" insert="true"/>
        <property name="email" column="EMAIL" type="string" 
        update="true" insert="true"/>
        <property name="address" column="ADDRESS" type="string" 
        update="true" insert="true"/>
        <property name="city" column="CITY" type="string" 
        update="true" insert="true"/>
        <property name="country" column="COUNTRY" type="string" 
        update="true" insert="true"/>
    </class>    
</hibernate-mapping>

                
<hibernate-configuration>
<session-factory>
          …………
<mapping resource="com/ibm/sample/bean/Customer.hbm.xml"/>
</session-factory>
</hibernate-configuration>

                
public void createCustomer(String custNanme, String email, int age,
String address, String city, String country) {
    Session sess = HibernateUtil.currentSession();
    Transaction trans = sess.beginTransaction();
    Customer customer = new Customer();
    customer.setCustName(custNanme);
    customer.setEmail(email);
    customer.setAge(age);
    customer.setAddress(address);
    customer.setCity(city);
    customer.setCountry(country);
    sess.save(customer);
    trans.commit();
    HibernateUtil.closeSession();
}

                
public void deleteCustomer(int id) {
    Session sess = HibernateUtil.currentSession();
    Transaction trans = sess.beginTransaction();
    Customer customer = (Customer) sess.load(Customer.class, new Integer(id));
    sess.delete(customer);
    trans.commit();
    HibernateUtil.closeSession();
}

                
public void updateCustomer(int id, String custName, 
          String email, int age, String address, String city, String country) {
    Session sess = HibernateUtil.currentSession();
    Transaction trans = sess.beginTransaction();
    Customer customer = (Customer) sess.load(Customer.class, new Integer(id));
    customer.setCustName(custName);
    customer.setEmail(email);
    customer.setAge(age);
    customer.setAddress(address);
    customer.setCity(city);
    customer.setCountry(country);
    sess.update(customer);
    trans.commit();
    HibernateUtil.closeSession();
}

                
public List getAllCustomers() {
    String queryString = "select a from Customer as a";
    Session sess = HibernateUtil.currentSession();
    Transaction trans = sess.beginTransaction();
    Query query = sess.createQuery(queryString);
    List list = query.list();
    trans.commit();
    HibernateUtil.closeSession();
    return list;
}

public Customer getCustomerByID(int id) {
    String queryString = "select c from Customer as c where c.id = :cid";
    Session sess = HibernateUtil.currentSession();
    Transaction trans = sess.beginTransaction();
    Query query = sess.createQuery(queryString);
    query.setParameter("cid", new Integer(id));
    Customer customer = (Customer) sess.load(Customer.class, new Integer(id));
    trans.commit();
    HibernateUtil.closeSession();
    return customer;
}

public List getCustomerByName(String name) {
    String queryString = "select c from Customer as c where c.custName like :name";
    Session sess = HibernateUtil.currentSession();
    Transaction trans = sess.beginTransaction();
    Query query = sess.createQuery(queryString);
    query.setParameter("name", "%"+name+"%");
    List list = query.list();
    trans.commit();
    HibernateUtil.closeSession();
    return list;
}