环境:jdk 1.5, eclipse 3.1, hibernate3,sqlserver2000
1。在eclipse中新建一个java project
2。把hibernate和sqlserver driver加入该project的libraries中
完成即可
3。在sqlserver中创建数据库test,创建表customer
4。创建customer.java,保存在src的zb目录下
package zb;
public class Customer {
private String id;
private String username;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
}
5。创建customer.hbm.xml,和customer.java放在一起
<?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>
<class name="zb.Customer" table="CUSTOMER" >
<id name="id" column="id" type="java.lang.String">
<generator class="assigned"/>
</id>
<property name="username" column="username" type="java.lang.String" not-null="true" />
</class>
</hibernate-mapping>
6创建hibernate.cfg.xml,保存在src目录下
<?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 name="HibernateSessionFactory">
<property name="hibernate.connection.driver_class">com.microsoft.jdbc.sqlserver.SQLServerDriver</property>
<property name="hibernate.connection.password">tzc</property>
<property name="hibernate.connection.url">jdbc:microsoft:sqlserver://127.0.0.1;DatabaseName=test;SelectMethod=cursor</property>
<property name="hibernate.connection.username">sa</property>
<property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
<mapping resource="zb/Customer.hbm.xml"/>
</session-factory>
</hibernate-configuration>
6。创建test文件,HibernateTest.java,和customer.java放在一起
package zb;
import org.hibernate.*;
import org.hibernate.cfg.Configuration;
public class HibernateTest{
public static void main(String[] args){
try{
Session session = null;
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
session = sessionFactory.openSession();
Transaction ts=session.beginTransaction();
for(int i=1;i<100;i++){
Customer customer = new Customer();
customer.setId(String.valueOf(i));
customer.setUsername("zb");
session.save(customer);
session.flush();
}
ts.commit();
session.close();
}
catch(HibernateException e){
e.printStackTrace();
}
}
}
整个目录结构如下:
在src下创建log4j.properties文件,把hibernate/etc/log4j.properties的内容拷贝到该文件中
7.然后对HibernateTest.java run as/ java application