HibernateORM操作类..

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="myeclipse.connection.profile">Oracle 9</property>
 <property name="connection.url">jdbc:oracle:thin:@localhost:1521:MLDN</property>
 <property name="connection.username">root</property>
 <property name="connection.password">rockie</property>
 <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
 <property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
 <property name="show_sql">true</property>
 <mapping resource="org/rockie/Person.hbm.xml" />
</session-factory>

</hibernate-configuration>

---

 

Person.hbm.xml

<?xml version="1.0" encoding='UTF-8'?>
<!DOCTYPE hibernate-mapping PUBLIC
                            "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
                            "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >

<!-- DO NOT EDIT: This is a generated file that is synchronized -->
<!-- by MyEclipse Hibernate tool integration.                   -->
<hibernate-mapping package="org.rockie">

    <class name="Person" table="PERSON">
        <id name="id" column="ID" type="string">
            <generator class="uuid.hex"/>
        </id>
 
        <property name="name" column="NAME" type="string"  not-null="true" />
        <property name="password" column="PASSWORD" type="string"  not-null="true" />
        <property name="sex" column="SEX" type="string" />
        <property name="email" column="EMAIL" type="string" />
    </class>
   
</hibernate-mapping>

---

 

Person.java

package org.lxh.hibernate.demo01;
// POJO类
public class Person {
 // 写入若干属性
 private String id ;
 private String name ;
 private String password ;
 private String sex ;
 private String email ;
 public String getEmail() {
  return email;
 }
 public void setEmail(String email) {
  this.email = email;
 }
 public String getId() {
  return id;
 }
 public void setId(String id) {
  this.id = id;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public String getPassword() {
  return password;
 }
 public void setPassword(String password) {
  this.password = password;
 }
 public String getSex() {
  return sex;
 }
 public void setSex(String sex) {
  this.sex = sex;
 }
}

---

 

PersonOperate.java

package org.rockie;

import java.util.Iterator;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

public class PersonOperate {

 private Session session = null ;
 
 // 在构造方法之中实例化session对象
 public PersonOperate()
 {
  // 找到Hibernate配置
  Configuration config = new Configuration().configure() ;
  // 从配置中取出SessionFactory
  SessionFactory factory = config.buildSessionFactory() ;
  // 从SessionFactory中取出一个Session
  this.session = factory.openSession() ;
 }
 

 // 向数据库中增加数据
 public void insert(Person p)
 {

  Transaction tran = this.session.beginTransaction() ;

  this.session.save(p) ;
  tran.commit() ;

  this.session.close() ;
 }
 
 // 修改
 public void update(Person p)
 {

  Transaction tran = this.session.beginTransaction() ;

  this.session.update(p) ;
  
  tran.commit() ;
 }
 
 // 按ID查询：推荐使用HQL —— 是Hibernate官方推荐的查询语言
 public Person queryById(String id)
 {
  Person p = null ;
  // 使用Hibernate查询语言
  String hql = "FROM Person as p WHERE p.id=?" ;
  // 通过Query接口查询
  Query q = this.session.createQuery(hql) ;
  q.setString(0,id) ;
  List l = q.list() ;
  Iterator iter = l.iterator() ;
  if(iter.hasNext())
  {
   p = (Person)iter.next() ;
  }
  return p ;
 }
 
 // 删除数据
 // Hibernate2、Hibernate 3通用的删除
 // 使用此方法删除数据之前，必须先查找到数据对象
 public void delete(Person p)
 {
  Transaction tran = this.session.beginTransaction() ;

  this.session.delete(p) ;

  tran.commit() ;
 }
 
 // 在Hibernate 3之中根据HQL中的语句进行了修改，增加了删除指令
 public void delete(String id)
 {
  String hql = "DELETE Person WHERE id=?" ;
  Query q = this.session.createQuery(hql) ;

  q.setString(0,id) ;

  q.executeUpdate() ;

  this.session.beginTransaction().commit() ;
 }
 
 // 查询全部数据，写HQL
 public List queryAll()
 {
  List l = null ;
  String hql = "FROM Person as p" ;
  Query q = this.session.createQuery(hql) ;
  l = q.list() ;
  return l ;
 }
 
 // 模糊查询
 public List queryByLike(String cond)
 {
  List l = null ;
  String hql = "FROM Person as p WHERE p.name like ?" ;
  Query q = this.session.createQuery(hql) ;
  q.setString(0,"%"+cond+"%") ;
  l = q.list() ;
  return l ;
 }
}

---

 

TestPO.java

package org.rockie;

import java.util.Iterator;
import java.util.List;

public class TestPO {

 /**
  * @param args
  */
 public static void main(String[] args) {
  // TODO 自动生成方法存根
  // 生成POJO类实例化对象
  Person p = new Person() ;
  // p.setId("rockie") ;
  p.setName("kipen") ;
  p.setPassword("abc") ;
  p.setSex("男") ;
  p.setEmail(rockie1984@163.com) ;
  PersonOperate po = new PersonOperate() ;
  po.insert(p) ;
  // Person p = po.queryById("rockie") ;
  // System.out.println(p.getName()) ;
  // po.delete("rockie") ;
  /*
  List l = po.queryByLike("k") ;
  Iterator iter = l.iterator() ;
  while(iter.hasNext())
  {
   Person p = (Person)iter.next() ;
   System.out.println(p.getName()) ;
  }
  */
 }

}