eclipse下手动利用hibernate连接数据库

1.下载hibernate jar包：hibernate-release-4.3.8.Final ORM，导入必要的jar包，路径为：hibernate-release-4.3.8.Final\lib\required。 包含的jar包有    10个。

2.建立新的java项目。

3.学习自己建立User Library： 

  (a)项目右键——build path——configure build path——add library.

  (b)选择User-library,在其中新建library，命名为hibernate。

  (c)在library中加入hibernate所需要的jar包（路径为：hibernate-release-4.3.8.Final\lib\required），hello world就够了，其他的还要加。

4.引入数据库的jdbc驱动。我用的mysql：mysql-connector-java-5.1.7-bin.jar

(a)创建数据库：create  database wkh;

  (b)切换数据库：use wkh;

       (c)创建employee表：

create table EMPLOYEE (   id INT NOT NULL auto_increment,   first_name VARCHAR(20) default NULL,   last_name  VARCHAR(20) default NULL,   salary     INT  default NULL,   PRIMARY KEY (id));

5.在src目录下建立hibernate的配置文件hibernate.cfg.xml

<?xml version="1.0" encoding="utf-8"?><!DOCTYPE hibernate-configuration SYSTEM "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd"><hibernate-configuration>   <session-factory>   <property name="hibernate.dialect">      org.hibernate.dialect.MySQLDialect   </property>   <property name="hibernate.connection.driver_class">      com.mysql.jdbc.Driver   </property>   <!-- Assume test is the database name -->   <property name="hibernate.connection.url">      jdbc:mysql://localhost:3306/wkh   </property>   <property name="hibernate.connection.username">      root   </property>   <property name="hibernate.connection.password">      root   </property>   <!-- List of XML mapping files -->   <mapping resource="Employee.hbm.xml"/></session-factory></hibernate-configuration>

5、建立Employee类,Employee.java

public class Employee {   private int id;   private String firstName;    private String lastName;      private int salary;     public Employee() {}   public Employee(String fname, String lname, int salary) {      this.firstName = fname;      this.lastName = lname;      this.salary = salary;   }   public int getId() {      return id;   }   public void setId( int id ) {      this.id = id;   }   public String getFirstName() {      return firstName;   }   public void setFirstName( String first_name ) {      this.firstName = first_name;   }   public String getLastName() {      return lastName;   }   public void setLastName( String last_name ) {      this.lastName = last_name;   }   public int getSalary() {      return salary;   }   public void setSalary( int salary ) {      this.salary = salary;   }}

6、src目录下建立映射文件Employee.hbm.xml

<?xml version="1.0" encoding="utf-8"?><!DOCTYPE hibernate-mapping PUBLIC  "-//Hibernate/Hibernate Mapping DTD//EN" "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd"> <hibernate-mapping>   <class name="Employee" table="EMPLOYEE">      <meta attribute="class-description">         This class contains the employee detail.       </meta>      <id name="id" type="int" column="id">         <generator class="native"/>      </id>      <property name="firstName" column="first_name" type="string"/>      <property name="lastName" column="last_name" type="string"/>      <property name="salary" column="salary" type="int"/>   </class></hibernate-mapping>

7、建立测试类TestEmployee.java

import java.util.List; import java.util.Date;import java.util.Iterator;  import org.hibernate.HibernateException; import org.hibernate.Session; import org.hibernate.Transaction;import org.hibernate.SessionFactory;import org.hibernate.cfg.Configuration;public class ManageEmployee {   private static SessionFactory factory;       public static void main(String[] args) {      try{         factory = new Configuration().configure().buildSessionFactory();      }catch (Throwable ex) {          System.err.println("Failed to create sessionFactory object." + ex);         throw new ExceptionInInitializerError(ex);       }      ManageEmployee ME = new ManageEmployee();      /* Add few employee records in database */      Integer empID1 = ME.addEmployee("Zara", "Ali", 1000);      Integer empID2 = ME.addEmployee("Daisy", "Das", 5000);      Integer empID3 = ME.addEmployee("John", "Paul", 10000);      /* List down all the employees */      ME.listEmployees();      /* Update employee's records */      ME.updateEmployee(empID1, 5000);      /* Delete an employee from the database */      ME.deleteEmployee(empID2);      /* List down new list of the employees */      ME.listEmployees();   }   /* Method to CREATE an employee in the database */   public Integer addEmployee(String fname, String lname, int salary){      Session session = factory.openSession();      Transaction tx = null;      Integer employeeID = null;      try{         tx = session.beginTransaction();         Employee employee = new Employee(fname, lname, salary);         employeeID = (Integer) session.save(employee);          tx.commit();      }catch (HibernateException e) {         if (tx!=null) tx.rollback();         e.printStackTrace();       }finally {         session.close();       }      return employeeID;   }   /* Method to  READ all the employees */   public void listEmployees( ){      Session session = factory.openSession();      Transaction tx = null;      try{         tx = session.beginTransaction();         List employees = session.createQuery("FROM Employee").list();          for (Iterator iterator =                            employees.iterator(); iterator.hasNext();){            Employee employee = (Employee) iterator.next();             System.out.print("First Name: " + employee.getFirstName());             System.out.print("  Last Name: " + employee.getLastName());             System.out.println("  Salary: " + employee.getSalary());          }         tx.commit();      }catch (HibernateException e) {         if (tx!=null) tx.rollback();         e.printStackTrace();       }finally {         session.close();       }   }   /* Method to UPDATE salary for an employee */   public void updateEmployee(Integer EmployeeID, int salary ){      Session session = factory.openSession();      Transaction tx = null;      try{         tx = session.beginTransaction();         Employee employee =                     (Employee)session.get(Employee.class, EmployeeID);          employee.setSalary( salary ); session.update(employee);          tx.commit();      }catch (HibernateException e) {         if (tx!=null) tx.rollback();         e.printStackTrace();       }finally {         session.close();       }   }   /* Method to DELETE an employee from the records */   public void deleteEmployee(Integer EmployeeID){      Session session = factory.openSession();      Transaction tx = null;      try{         tx = session.beginTransaction();         Employee employee =                    (Employee)session.get(Employee.class, EmployeeID);          session.delete(employee);          tx.commit();      }catch (HibernateException e) {         if (tx!=null) tx.rollback();         e.printStackTrace();       }finally {         session.close();       }   }}

8、测试、运行成功