import org.hibernate.session;
import org.hibernate.sessionfactory;
import org.hibernate.transaction;
import org.hibernate.cfg.annotationconfiguration;
import org.hibernate.cfg.environment;

import com.hb.pack_01.model.p01_customer;


public class businessservice ...{

    public static sessionfactory sessionfactory;

    static ...{
        try ...{
            annotationconfiguration cfg = new annotationconfiguration();
            cfg.configure("hibernate.cfg.xml");
            cfg.setproperty(environment.hbm2ddl_auto, "create-drop");
            cfg.addpackage("com.hb.pack_01.model");
            cfg.addannotatedclass(p01_customer.class );
            sessionfactory = cfg.buildsessionfactory();
        } catch (exception e) ...{
            e.printstacktrace();
        }
    }
    
    public void savecustomer(p01_customer customer) throws exception ...{
        session session = sessionfactory.opensession();
        transaction tx = null;
        try ...{
            tx = session.begintransaction();
            session.save(customer);
            tx.commit();
        } catch (exception e) ...{
            if (tx != null) ...{
                tx.rollback();
            }
            throw e;
        } finally ...{
            session.close();
        }
    }
    
    public void test() throws exception ...{

        p01_customer customer = new p01_customer();
        customer.setname("laosan zhang");
        customer.setsex('m');
        customer.setcustomerdescription("a good citizen!");
        savecustomer(customer);
    }
    
    public static void main(string[] args) throws exception ...{
        
        new businessservice().test();
        sessionfactory.close();
    }
}

<?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="hibernate.connection.provider_class">
            org.hibernate.connection.proxoolconnectionprovider
        </property>
        <property name="hibernate.proxool.pool_alias">mssql2000pool</property>
        <property name="hibernate.proxool.xml">proxool.xml</property>
        <!-- sql dialect -->
        <property name="dialect">
            org.hibernate.dialect.sqlserverdialect
        </property>
        <!-- echo all executed sql to stdout -->
        <property name="show_sql">false</property>
        <!-- drop and re-create the database schema on startup -->
        <property name="hbm2ddl.auto">create</property>

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

<?xml version="1.0" encoding="utf-8"?>

<something-else-entirely>
    <proxool>
        <alias>mssql2000pool</alias>
        <driver-url>jdbc:jtds:sqlserver://localhost:1433/hibernate3</driver-url>
        <driver-class>net.sourceforge.jtds.jdbc.driver</driver-class>
        <driver-properties>
            <property name="user" value="sa" />
            <property name="password" value="sa" />
        </driver-properties>
        <maximum-connection-count>10</maximum-connection-count>
        <house-keeping-test-sql>
            select current_date
        </house-keeping-test-sql>
    </proxool>
</something-else-entirely>