myeclipse下hibernate入門實例介紹

myeclipse下hibernate初步實例

說明：本例采用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.8 8:1433;DatabaseName=goto
　 </property>
<property name="dialect">org.hibernate.dialect.SQLServerDialect&l t;/property>
<property name="connection.password">hcsys</property>
<property name="connection.driver_class">net.sourceforge.jtds.jdb c.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.8 8:1433;DatabaseName=goto
</property>
<property name="dialect">org.hibernate.dialect.SQLServerDialect&l t;/property>
<property name="connection.password">hcsys</property>
<property name="connection.driver_class">net.sourceforge.jtds.jdb c.Driver</property>
<mapping resource="hibernate.cfg.xml" />
<mapping resource="test/hibernate/Product.hbm.xml" />
</session-factory>
</hibernate-configuration>

9.運行InsertProduct.java就可以看到數據庫goto表 test_products中增加了一條記錄。