hibernate使用日志
设计步骤:
1:从数据库做映射,编辑数据库连接
c:\Middlegen\config\database\oracle.xml
<property environment="env"/>
<property name="database.script.file" value=""/>
<property name="database.driver.file" value="${lib.dir}/classes12.jar"/>
<property name="database.driver.classpath" value="${database.driver.file}"/>
<property name="database.driver" value="oracle.jdbc.driver.OracleDriver"/>
<property name="database.url" value="jdbc:oracle:thin:@10.1.1.33:1521:oradb"/>
<property name="database.userid" value="bms"/>
<property name="database.password" value="bms"/>
<property name="database.schema" value="bms"/>
<property name="database.catalog" value=""/>
<!--property name="jboss.datasource.mapping" value="Oracle7"/-->
<property name="jboss.datasource.mapping" value="Oracle8"/>
<!--property name="jboss.datasource.mapping" value="Oracle9i"/-->
2:改build.xml
<fileset dir="${build.gen-src.dir}/com/hibernate" includes="*.xml" />
3: 在c:\Middlegen运行ant,导出映射文件在build下
4:生成java代码,用extention工具
C:\hibernate- extensions-2.1.2\tools\bin运行hbm2java a.xml
5:运行hibernate。
配置 hibernate.cfg.xml和映射文件,javabean放到classes目录
<?xml version='1.0' encoding='GBK'?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="hibernate.dialect">net.sf.hibernate.dialect.Oracle9Dialect</property>
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.connection.url">jdbc:oracle:thin:@10.1.1.33:1521:oradb</property>
<property name="hibernate.connection.username">bms</property>
<property name="hibernate.connection.password">bms</property>
<property name="dialect">net.sf.hibernate.dialect.Oracle9Dialect</property>
<property name="show_sql">true</property>
<mapping resource="RBmsDevice.hbm.xml"/>
</session-factory>
</hibernate-configuration>
运行TestHibernate.java代码测试。
package test;
import java.io.*;
import java.util.*;
import net.sf.hibernate.*;
import net.sf.hibernate.cfg.*;
import com.hibernate.RBmsDevice;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
public class TestHibernate {
Log loger = LogFactory.getLog("TestHibernate");
public TestHibernate() {
}
public void Test() throws HibernateException,IOException {
//File files = new File("c:\\hibernate.cfg.xml");//默认是放到classes目录
Configuration config = new Configuration().configure();
//config.addClass(com.hibernate.RBmsDevice.class);
SessionFactory sessionFactory = config.buildSessionFactory();
Session session = sessionFactory.openSession();
String sql="from com.hibernate.RBmsDevice a";
loger.info("sql语句:"+sql);
try {
List lst = session.find(sql);
for (int i = 0; i < lst.size(); i++) {
RBmsDevice personne = (RBmsDevice) lst.get(i);
System.out.println("字段是:" + personne.getColumndesc());
}
} finally {
session.close();
}
sessionFactory.close();
}
public static void main(String[] args) throws HibernateException, IOException,
HibernateException {
TestHibernate testHibernate1 = new TestHibernate();
testHibernate1.Test();
}
}