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 。本例为:prodcast4. 右单击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.javapackage 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>9.运行InsertProduct.java就可以看到数据库goto表test_products中增加了一条记录。