准备工作做好了,开始Hibernate:
1:建立包:package:dao、model、service、util包;
2:开始model实体类Student:id,sname生成getter/setter;
Java代码
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
@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
注意:
1.原作者:学不可以已
2.我做完之后发现一个问题;就是update不成功,不知道是什么原因
3.junit是进行单元测试用到的,可以去我的微博搜素相关资料,输入关键字“junit”,输入下图中的“查询框中”
4:附带我的代码,跟这文章的上一篇章0中分享的我自己修改的代码是一样的。链接:http://pan.baidu.com/s/1nt65KgD 密码:6uac