Hibernate 基础

1.创建java项目，添加相应jar包

2.编写hibernate.cfg.xml配置文件

3.连接数据库，根据数据库表，写相应实体类

4.操作数据库

1.创建java项目，添加相应jar包

下载hibernate-release-4.3.11.Final，将lib->required目录下的jar包全拷进工程，另外还需要加mysql-connector-java-5.1.6.jar包

2.在resources目录下编写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">
<hibernate-configuration>
    <session-factory>
        <!--连接字符串-->
        <property name="connection.url">jdbc:mysql://localhost:3306/java_base?useUnicode=true&amp;characterEncoding=UTF-8</property>
        <!--连接数据库的用户名-->
        <property name="connection.username">root</property>
        <!--数据库用户密码-->
        <property name="connection.password">leiwenkang</property>
        <!--数据库驱动-->
        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
        <!--选择使用的方言-->
        <property name="dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
        <!--在启动时不自动创建数据库-->
        <property name="hbm2ddl.auto">none</property>
        <!--显示执行的SQL语句-->
        <property name="show_sql">true</property>
         <!--格式化SQL语句-->
        <property name="format_sql">true</property>
        
        <mapping class="com.eshore.hibernate_base.pojo.Student"/>
    </session-factory>
</hibernate-configuration>

3.连接数据库，根据数据库表，写相应实体类

package com.eshore.hibernate_base.pojo;


import java.io.Serializable;


import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;


import org.hibernate.annotations.GenericGenerator;


@Entity
@Table(name="student")
public class Student implements Serializable {

@Id
@GenericGenerator(name="uuidGen",strategy="uuid")
@GeneratedValue(generator="uuidGen")
@Column(name="id")
    private String id;

@Column(name="name")
    private String name;

@Column(name="login_name")
    private String loginName;

@Column(name="pwd")
    private String pwd;
   
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 getLoginName() {
return loginName;
}
public void setLoginName(String loginName) {
this.loginName = loginName;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
}

4.操作数据库

 public static void main(String[] args) {
   Configuration cfg = new Configuration().configure();
   ServiceRegistry sr = new StandardServiceRegistryBuilder().applySettings(cfg.getProperties()).build();
   SessionFactory sf = cfg.buildSessionFactory(sr);
   Session session = sf.openSession();
   
   /*操作数据库*/
   queryStudentByParams(session);
   
   /*操作数据库*/
   session.close();
   sf.close();
   }

   //条件查询
   public static void queryStudentByParams(Session session){
//   Query query = session.createQuery("from Student where loginName = ?");
//   query.setString(0,"lwk");
//   Query query = session.createQuery("from Student where loginName = :ln");
//   query.setString("ln","lwk");
  Criteria criteria = session.createCriteria(Student.class);
  criteria.add(Restrictions.eq("loginName", "lwk"));
  List<Student> list =  criteria.list();
  for(Student student : list){
  System.out.println(student.getId() + "   " + student.getName());
  }
   }