Hibernate之第1解之-hibernate_demo_1

准备工作做好了，开始Hibernate：

1：建立包：package：dao、model、service、util包；

2：开始model实体类Student：id，sname生成getter/setter；

package model;

public class Student {
	private int id;
	private String name;

	public int getId() {
		return id;
	}
	private void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
}

 

3：在Hibernate源码下/project/搜索 *.xml复制以下文件：

hibernate.cfg.xml-->src下；

*.hbm.xml-->model下；

4：配置hibernate.cfg.xml

<session-factory>
		<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
		<property name="connection.url">jdbc:mysql://localhost:3306/hibnie</property>
		<property name="connection.username">root</property>
		<property name="connection.password">1234</property>
		<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
		<property name="show_sql">true</property>

		<mapping resource="model/Student.hbm.xml"/>
	</session-factory>

 

5：配置Student.hbm.xml

<hibernate-mapping package="model">
	<class name="Student" table="s" lazy="false">
		<id name="id" type="integer" column="sid">
            <generator class="identity"/>
		</id>
		<property name="name" type="string" column="sname" />
	</class>
</hibernate-mapping>

 

6：加入JUnit4 jar包，加入path；

7：写util.HibernateUtil

package util;

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

public class HibernateUtil {
	private static final SessionFactory sessionFactory=buildSessionFactory();
	
	/**	init sessionFactory	*/
	private static SessionFactory buildSessionFactory() {
		SessionFactory sessionFactory=null;
		try{
			sessionFactory=new Configuration().configure().buildSessionFactory();
		}catch(Throwable te){
			System.err.println("init sessionFactory Error:"+te);
			te.printStackTrace();
		}
		return sessionFactory;
	} 
	
	/**	get session	*/
	public static Session getSession(){
		Session stion=sessionFactory.openSession();
		return stion;
	}

}

 

8：测试HIbernateUtil

testsrc--：

        @Test
	public void testGetSession() {
		Session stion=HibernateUtil.getSession();
		System.out.println(stion);
	}

 

9：dao层-->StudentDao

package dao;

import java.util.Iterator;
import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.Restrictions;
import util.HibernateUtil;
import model.Student;

public class StudentDao {
	/**	insert;	 */
	public void addStudent(Student stu){
		Session session=HibernateUtil.getSession();
		Transaction tx=null;
		try{
			tx=session.beginTransaction();
			session.save(stu);
			tx.commit();
		}catch(HibernateException he){
			tx.rollback();
			he.printStackTrace();
		}finally{
			session.close();
		}
	}
	/**	select;	 */
	public Student getStudent(int sid){
		Session session=HibernateUtil.getSession();
		Transaction tx=null;
		Student stu=null;
		try{
			tx=session.beginTransaction();
			stu=(Student)session.load(Student.class,new Integer(sid));
//			stu=(Student)session.get(Student.class,new Integer(sid));
			tx.commit();
		}catch(HibernateException he){
			tx.rollback();
			he.printStackTrace();
		}finally{
			session.close();
		}
		return stu;
	}
	/**	update	 */
	public void updateStudent(String oldName,String newName){
		Session session=HibernateUtil.getSession();
		Transaction tx=null;
		try{
			tx=session.beginTransaction();
			Query q=session.createQuery("from Student s where s.name= ?");
			q.setParameter(0, oldName);
			Iterator<Student> it=q.list().iterator();
			while(it.hasNext()){
				Student s=it.next();
				s.setName(newName);
				session.update(s);
			}
			tx.commit();
			session.close();
		}catch(HibernateException he){
			tx.rollback();
			he.printStackTrace();
		}
	}
	/**	delete	 */
	public void deleteStudent(String str){
		Session session=HibernateUtil.getSession();
		Transaction tx=null;
		try {
			tx=session.beginTransaction();
			/*	1.Criteria查询；	*/
			Criteria criter=session.createCriteria(Student.class).add(Restrictions.like("name","%"+str+"%"));
			Iterator<Student> it=criter.list().iterator();
			/*	2.Query查询	
			Query q=session.createQuery("from Student as s where s.name like ?");
			q.setParameter(0, "%"+str+"%");	
			Iterator<Student> it=q.list().iterator();	*/
			/*	3.Native sql查询	表名和表中的列名而不是实体类的类名和属性名了
			SQLQuery sqlq=session.createSQLQuery("SELECT * FROM s WHERE sname like ?").addEntity(Student.class);
			sqlq.setParameter(0, "%"+str+"%");
			Iterator<Student> it=sqlq.list().iterator();	*/
			while(it.hasNext()){
				session.delete(it.next());
			}
			tx.commit();
		} catch (HibernateException he) {
			tx.rollback();
			he.printStackTrace();
		} finally {
			session.close();
		}
	}
}

 10.业务层-->service：StudentManager：

package service;

import dao.StudentDao;
import model.Student;

public class StudentManager {
	StudentDao dao=new StudentDao();
	public void save(Student stu){
		dao.addStudent(stu);
	}
	public Student get(int id){
		return dao.getStudent(id);
	}
	public void update(String oname,String nname){
		dao.updateStudent(oname, nname);
	}
	public void delete(String name){
		dao.deleteStudent(name);
	}
}

 11.测试业务逻辑：StudentManagerTest

package service;

import model.Student;
import org.junit.Before;
import org.junit.Test;

public class StudentManagerTest {
	StudentManager manager;
	@Before
	public void init(){
		manager=new StudentManager();
	}
	@Test public void testSave() {
		Student stu1=new Student();
		stu1.setName("John woo");
		manager.save(stu1);
	}
	@Test public void testGet(){
		Student stu=manager.get(12);
		System.out.println(stu.getName());
	}
	@Test public void testUpdate(){
		manager.update("Mary","Nie");
	}
	@Test public void testDelete(){
		manager.delete("ie");
	}
}

 

一个基本hibernate就完成了，包括基本的CRUD还有3种查询方式。

备注：lib下的jar包：

antlr-2.7.6.jar
commons-collections-3.1.jar
dom4j-1.6.1.jar
hibernate3.jar
hibernate-jpa-2.0-api-1.0.0.Final.jar
javassist-3.12.0.GA.jar
jta-1.1.jar
junit-4.9b1.jar
mysql6.jar
slf4j-api-1.6.1.jar
slf4j-simple-1.6.1.jar