{传智播客} (学习笔记)--hibernate的使用和配置

1.创建表

  create table customers(
   id int primary key ,
   name varchar(20),
   age int,
   birthday date,
   married int ,
   photo longblob,
   description text
  )
  注:
   1.oracle
    photo blob,
    description clob
   2.sqlserver:
    photo image,
    description text

2.创建java项目
3.添加类库
  hibernate:${hibernate解压目录}/lib/required/*.jar + hibernate3.jar
  Driver.jar(mysql)
  Log4j.jar和slf4j.jar

4.创建java类.

public class Customer { private Integer id; private String name; private Integer age; private Date birthday; private boolean married; private byte[] photo; private String description; public Integer getId() { return id; } ... }

5.创建映射文件Customer.hbm.xml,需要和Customer放在一起.

dtd:${hibernate3.jar}/org.hibernate/hibernate-mapping3.0.dtd/3行.

  <?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="cn.itcast.hibernate.persistence.Customer" table="customers" lazy="false"> <id name="id" column="id" type="integer"> <generator class="increment" /> </id> <property name="name" column="name" type="string" /> <property name="age" column="age" type="integer" /> <property name="birthday" column="birthday" type="date" /> <property name="married" column="married" type="boolean" /> <property name="photo" column="photo" type="binary" /> <property name="description" column="description" type="text" /> </class> </hibernate-mapping>

6.创建src/hibernate.properties

  hibernate.connection.driver_class=com.mysql.jdbc.Driver
  hibernate.connection.url=jdbc:mysql://localhost:3306/hibernate
  hibernate.connection.username=root
  hibernate.connection.password=root

  hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
  hibernate.show_sql=true

7.创建App程序.

package cn.itcast.hibernate; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import org.hibernate.cfg.Configuration; import cn.itcast.hibernate.persistence.Customer; public class App { /* 会话工厂, 相当于数据源 */ private static SessionFactory sf = null ; static{ try { //加载src/hibernate.properties Configuration conf = new Configuration(); //加载映射文件 conf.addClass(Customer.class); //初始化连接池 sf = conf.buildSessionFactory(); } catch (Exception e) { e.printStackTrace(); } } public static void main(String[] args) { Customer c = new Customer(); c.setName("tom"); insertCustomer(c); } public static void insertCustomer(Customer c){ //通过会话工厂开启会话 Session s = sf.openSession(); //开始事务acid Transaction tx = s.beginTransaction(); s.save(c); tx.commit(); s.close(); } }