利用idea开发工具hibernate工具包实现后台对Oracle数据库的增删改查

hibernate.cfg.xml文件的配置：

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <!DOCTYPE hibernate-configuration PUBLIC
 3         "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
 4         "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
 5 <hibernate-configuration>
 6     <session-factory>
 7     <!-- 首先设定jdbc链接相关的信息（驱动，url，用户名，密码） -->与数据库连接的信息
 8         <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
 9         <property name="connection.url">jdbc:oracle:thin:@localhost:1521:orcl</property>
10         <property name="connection.username">hbm</property>
11         <property name="connection.password">123</property>
12         
13         <!-- 设定方言 -->
14         <property name="dialect">org.hibernate.dialect.Oracle10gDialect</property>
15         
16         <!-- 设定让hibernate帮我们自动创建表，不设定可以吗？ -->
17 <!--          <property name="hbm2ddl.auto">create</property>  -->
18         <property name="show_sql">true</property>
19         <property name="format_sql">true</property>
20         
21         <mapping resource="entity/StudentMapper.xml"/>
22     </session-factory>
23 
24 </hibernate-configuration>

hibernateUtil.java文件：

 1 package util;
 2 
 3 import org.hibernate.SessionFactory;
 4 import org.hibernate.boot.MetadataSources;
 5 import org.hibernate.boot.registry.StandardServiceRegistry;
 6 import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
 7 
 8 public class HibernateUtil {
 9     private static  SessionFactory sf;
10     //静态代码块，是类加载的时候会执行
11     //整个项目，它只执行一次
12     static{
13         
14         StandardServiceRegistry registry =
15                 new StandardServiceRegistryBuilder()
16                 .configure()//实验方法给个参数，看配置文件名能否不是hibernate.cfg.xml
17                 .build();
18         
19          sf = new MetadataSources(registry)
20                 .buildMetadata()
21                 .buildSessionFactory();
22     }
23     //为什么要创建一个返回SessionFactory的方法
24     //而不是创建一个返回Session的方法
25     //是为了让别人有选择的机会，让它选择OpenSession
26     //还是getCurrentSession来创建Session
27     public static  SessionFactory getSessionFactory(){
28         return sf;
29     }
30     
31     //在此hibernateUtil中，你还可以创建一些返回Session的方法
32     
33 }

studentMapper.,xml对实体文件的配置：

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <!DOCTYPE hibernate-mapping PUBLIC
 3         "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
 4         "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
 5         
 6 <hibernate-mapping package="entity">
 7     <class name="Student" table="students">
 8         <id name="sno" >
 9             <generator class="assigned"></generator>
10         </id>
11         <property name="sname" column="name"></property>
12     </class>
13 </hibernate-mapping>

student.xml实体文件：

 1 package entity;
 2 
 3 public class Student {
 4     private String sno;
 5     private String sname;
 6     public String getSno() {
 7         return sno;
 8     }
 9     public void setSno(String sno) {
10         this.sno = sno;
11     }
12     public String getSname() {
13         return sname;
14     }
15     public void setSname(String sname) {
16         this.sname = sname;
17     }
18 }

studentDao.java文件：

 1 package dao;
 2 
 3 import java.util.List;
 4 
 5 
 6 
 7 import org.hibernate.Session;
 8 import org.hibernate.SessionFactory;
 9 import org.hibernate.Transaction;
10 
11 import entity.Student;
12 import util.HibernateUtil;
13 
14 public class StudentDao {
15 
16     private SessionFactory sf ;
17     
18     public StudentDao(){
19         sf = HibernateUtil.getSessionFactory();
20     }
21     
22     public void insert(Student s){
23         Session session = sf.openSession();
24         
25         Transaction tx = session.beginTransaction();
26         session.save(s);
27         tx.commit();
28         session.close();
29     }
30     
31     public void update(Student s){
32         Session session = sf.openSession();
33         Transaction tx = session.beginTransaction();
34         session.update(s);
35         tx.commit();
36         session.close();
37     }
38     
39     public void delete(String sno){
40         Session session = sf.openSession();
41         Transaction tx = session.beginTransaction();
42         Student stu = session.get(Student.class, sno);
43         session.delete(stu);
44         tx.commit();
45         session.close();
46     }
47     
48     
49     public List<Student> getAll(){
50         String hql = "from Student";
51         Session s = sf.openSession();
52         List<Student> list =  s.createQuery(hql).list();
53         s.close();
54         return list;
55     }
56 }

main.java文件：

 1 package com.nf;
 2 
 3 
 4 import java.util.List;
 5 
 6 import org.hibernate.Session;
 7 import org.hibernate.SessionFactory;
 8 import org.hibernate.Transaction;
 9 import org.hibernate.boot.MetadataSources;
10 import org.hibernate.boot.registry.StandardServiceRegistry;
11 import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
12 
13 import dao.StudentDao;
14 import entity.Student;
15 import util.HibernateUtil;
16 
17 public class Main {
18 
19     public static void main(String[] args) {
20         //insertTest(); 
21         //getAllTest();
22         
23         StudentDao dao = new StudentDao();
24     /*    Student s = new Student();
25         s.setSno("22");//因为主键是assigned的策略，所以需要我们自己赋值
26         s.setSname("222name");
27         dao.insert(s);*/
28         
29 /*        Student s = new Student();
30         s.setSno("22");//因为主键是assigned的策略，所以需要我们自己赋值
31         s.setSname("2xxname");
32         dao.update(s);
33         */
34         
35         /*List<Student> list = dao.getAll();
36         for(Student s: list){
37             System.out.println(s.getSname());
38         }*/
39         
40         dao.delete("22");
41     }
42     private static void insertTest() {
43         // TODO Auto-generated method stub
44         StandardServiceRegistry registry =
45                 new StandardServiceRegistryBuilder()
46                 .configure()//实验方法给个参数，看配置文件名能否不是hibernate.cfg.xml
47                 .build();
48         
49         SessionFactory sf = new MetadataSources(registry)
50                 .buildMetadata()
51                 .buildSessionFactory();
52         
53         
54         Session s = sf.openSession();
55         
56         Transaction tx = s.beginTransaction();
57         Person p = new Person();
58         p.setPid(100);
59         p.setName("cj");
60         s.save(p);
61         tx.commit();
62         s.close();
63         sf.close();
64     }
65     private static void getAllTest() {
66         
67         // TODO Auto-generated method stub
68                 SessionFactory sf = HibernateUtil.getSessionFactory();
69                 
70                 //sf.getCurrentSession()
71                 Session s = sf.openSession();
72                 String hql ="from Person";
73                 List<Person> list = s.createQuery(hql).list();
74                 for(Person p: list){
75                     System.out.println(p.getName());
76                 }
77                 
78                 
79                 s.close();
80                 sf.close();
81     }
82 }

hardDream!!