说明:本例采用myeclipse+sqlserver2000
hibernate版本为3.0.
数据库驱动为:jtds-1.0.2。
1。配置myeclipse环境(eclipse-SDK-3.1.1+myeclipse4.1.1GA_E3.1)。
2.配置好sqlserver2000数据库:建立数据库:goto . 表 test_products
CREATE TABLE [dbo].[test_products] ( [id] [int] IDENTITY (1, 1) NOT NULL , [aotoid] [char] (50) COLLATE Chinese_PRC_CI_AS NULL , [username] [char] (50) COLLATE Chinese_PRC_CI_AS NULL , [price] [int] NULL , [amount] [int] NULL )
id为自动编号。
3。新建项目--myeclipse--Web Project 。本例为:prodcast
4. 右单击prodcast,加入myeclipse的hibernate.并在此工程中建立数据连结。
建立完成后,在src下自动生成hibernate.cfg.xml,内容为:
<?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"> <!-- Generated by MyEclipse Hibernate Tools. --> <hibernate-configuration> <session-factory> <property name="connection.username">sa</property> <property name="connection.url">jdbc:jtds:sqlserver://192.168.1.88:1433;DatabaseName=goto
</property> <property name="dialect">org.hibernate.dialect.SQLServerDialect</property> <property name="connection.password">hcsys</property> <property name="connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property> </session-factory> </hibernate-configuration>
5。建立:Product.java:
package test.hibernate; import java.io.Serializable; public class Product implements Serializable { private static final long serialVersionUID = 3858043967100350732L; private Integer id; private String aotoid; private String username; private Integer price; private Integer amount; public Integer getAmount() { return amount; } public void setAmount(Integer amount) { this.amount = amount; } public String getAotoid() { return aotoid; } public void setAotoid(String aotoid) { this.aotoid = aotoid; } public Integer getPrice() { return price; } public void setPrice(Integer price) { this.price = price; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } }
6.建立InsertProduct.java
package test.hibernate; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import org.hibernate.cfg.*; import org.hibernate.classic.Session; public class InsertProduct { public static void main(String[] args) { SessionFactory sf = new Configuration().configure() .buildSessionFactory(); Session session = sf.openSession(); Transaction tx = session.beginTransaction(); Product p = new Product(); p.setAotoid("1"); p.setUsername("zhang"); p.setAmount(new Integer(10)); p.setPrice(new Integer(10)); System.out.println(p+"_______________1"); try{ session.save(p); tx.commit(); session.close(); System.out.println(p+"_______________2"); }catch(Exception ex){ ex.printStackTrace(); } } }
7.在test.hibernate包下建立:Product.hbm.xml.
<?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" > <hibernate-mapping package="test.hibernate"> <class table="test_products" name="Product"> <!--自动编号--> <id name="id" type="int" column="id" unsaved-value="0"> <generator class="identity"/> </id> <property name="aotoid" column="aotoid" type="string" length="50"/> <property name="username" column="username" type="string" length="50"/> <property name="price" column="price" type="int"/> <property name="amount" column="amount" type="int"/> </class> </hibernate-mapping>
8.打开hibernate.cfg.xml.加入:
<mapping resource="hibernate.cfg.xml" />
<mapping resource="test/hibernate/Product.hbm.xml" />
形成完整的config:
<?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"> <!-- Generated by MyEclipse Hibernate Tools. --> <hibernate-configuration> <session-factory> <property name="connection.username">sa</property> <property name="connection.url">jdbc:jtds:sqlserver://192.168.1.88:1433;DatabaseName=goto
</property> <property name="dialect">org.hibernate.dialect.SQLServerDialect</property> <property name="connection.password">hcsys</property> <property name="connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property> <mapping resource="hibernate.cfg.xml" /> <mapping resource="test/hibernate/Product.hbm.xml" /> </session-factory> </hibernate-configuration>