主程序:
package hibernateTest;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.classic.Session;
/**
* @author Jangle jangle@jangle.xyz:
* @date 创建时间:2016年8月20日 下午4:50:00
* @version 1.0
*/
public class M {
public static void main(String[] args) {
//实例化 Configuration
Configuration conf = new Configuration().configure();
//创建工厂
SessionFactory sessionFactory = conf.buildSessionFactory();
//创建Session
Session session = sessionFactory.openSession();
System.out.println(session);
Transaction tx = session.beginTransaction();
TableN t = new TableN();
t.setColumn1((long)8);
t.setColumn2("c2");
t.setColumn3("c3");
t.setColumn4("c4");
session.save(t);
tx.commit();
session.close();
sessionFactory.close();
}
}
hibernate.cfg.xml配置文件:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<!-- 默认配置 -->
<!-- <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="connection.url">jdbc:oracle:thin:@localhost:1521:orcl</property>
<property name="connection.username">jangle</property>
<property name="connection.password">jangle</property>
<property name="dialect"></property>
<property name="hbm2ddl.auto"></property> -->
<!-- C3P0配置 -->
<!-- <property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider
</property>
<property name="hibernate.c3p0.max_size">20</property>
<property name="hibernate.c3p0.min_size">5</property>
<property name="hibernate.c3p0.timeout">120</property>
<property name="hibernate.c3p0.max_statements">100</property>
<property name="hibernate.c3p0.idle_test_period">120</property>
<property name="hibernate.c3p0.acquire_increment">2</property> -->
<!-- 配置proxool连接池 -->
<property name="hibernate.connection.provider_class">org.hibernate.connection.ProxoolConnectionProvider</property>
<property name="hibernate.proxool.pool_alias">DBPool</property>
<property name="hibernate.proxool.xml">proxool.xml</property>
<!-- 映射文件 -->
<mapping resource="hibernateTest/table1.hbm.xml"/>
</session-factory>
</hibernate-configuration>
proxool.xml配置文件:
<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
<proxool>
<!--连接池的别名-->
<alias>DBPool</alias>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver-url>jdbc:oracle:thin:@localhost:1521:orcl</driver-url>
<driver-properties>
<property name="user" value="jangle" />
<property name="password" value="jangle" />
</driver-properties>
<house-keeping-sleep-time>90000</house-keeping-sleep-time>
<maximum-new-connections>20</maximum-new-connections>
<prototype-count>5</prototype-count>
<maximum-connection-count>100</maximum-connection-count>
<minimum-connection-count>10</minimum-connection-count>
</proxool>
</something-else-entirely>
table1.hbm.xml映射文件和Model:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="hibernateTest">
<class name="TableN" table="table1">
<id name="column1">
</id>
<property name="column2"></property>
<property name="column3"></property>
<property name="column4"></property>
</class>
</hibernate-mapping>
package hibernateTest;
/**
* @author Jangle jangle@jangle.xyz:
* @date 创建时间:2016年8月20日 下午8:51:35
* @version 1.0
*/
public class TableN {
private Long column1;
private String column2;
private String column3;
private String column4;
public Long getColumn1() {
return column1;
}
public void setColumn1(Long column1) {
this.column1 = column1;
}
public String getColumn2() {
return column2;
}
public void setColumn2(String column2) {
this.column2 = column2;
}
public String getColumn3() {
return column3;
}
public void setColumn3(String column3) {
this.column3 = column3;
}
public String getColumn4() {
return column4;
}
public void setColumn4(String column4) {
this.column4 = column4;
}
}