myeclipse下hibernate初步實例
Posted on 2007-03-27 21:55 javabright 閱讀(1058) 評論(0) 編輯 收藏 所屬分類: 數(shù)據(jù)庫 、編程工具myeclipse下hibernate初步實例
說明:本例采用myeclipse+sqlserver2000
hibernate版本為3.0.
數(shù)據(jù)庫驅動為:jtds-1.0.2。
1。配置myeclipse環(huán)境(eclipse-SDK-3.1.1+myeclipse4.1.1GA_E3.1)。
2.配置好sqlserver2000數(shù)據(jù)庫:建立數(shù)據(jù)庫: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 <!-- Generated by MyEclipse Hibernate Tools. --> <session-factory> </session-factory> </hibernate-configuration> import java.io.Serializable; public class Product implements Serializable { private static final long serialVersionUID = 3858043967100350732L; public Integer getAmount() { import org.hibernate.SessionFactory; public class InsertProduct { public static void main(String[] args) { <property name="aotoid" column="aotoid" type="string" length="50"/> </hibernate-mapping> 8.打開hibernate.cfg.xml.加入: <!-- Generated by MyEclipse Hibernate Tools. --> <session-factory> </session-factory> </hibernate-configuration>
4. 右單擊prodcast,加入myeclipse的hibernate.并在此工程中建立數(shù)據(jù)連結。
建立完成后,在src下自動生成hibernate.cfg.xml,內容為:
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"
<hibernate-configuration>
<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>
5。建立:Product.java:
package test.hibernate;
private Integer id;
private String aotoid;
private String username;
private Integer price;
private Integer amount;
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.Transaction;
import org.hibernate.cfg.*;
import org.hibernate.classic.Session;
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"
"
<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="username" column="username" type="string" length="50"/>
<property name="price" column="price" type="int"/>
<property name="amount" column="amount" type="int"/>
</class>
<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"
"
<hibernate-configuration>
<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" />
9.運行InsertProduct.java就可以看到數(shù)據(jù)庫goto表test_products中增加了一條記錄。