<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0"

         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

    <modelVersion>4.0.0</modelVersion>

    <groupId>testHiberate</groupId>

    <artifactId>testHiberate</artifactId>

    <version>1.0-SNAPSHOT</version>

    <dependencies>

        <dependency>

            <groupId>junit</groupId>

            <artifactId>junit</artifactId>

            <version>3.8.1</version>

            <scope>test</scope>

        </dependency>

        <!-- 添加Hibernate依赖 -->

        <dependency>

            <groupId>org.hibernate</groupId>

            <artifactId>hibernate-core</artifactId>

            <version>3.6.10.Final</version>

        </dependency>

        <!-- 添加Log4J依赖 -->

        <dependency>

            <groupId>log4j</groupId>

            <artifactId>log4j</artifactId>

            <version>1.2.16</version>

        </dependency>

        <dependency>

            <groupId>org.slf4j</groupId>

            <artifactId>slf4j-nop</artifactId>

            <version>1.6.4</version>

        </dependency>

        <!-- 添加javassist -->

        <dependency>

            <groupId>javassist</groupId>

            <artifactId>javassist</artifactId>

            <version>3.12.0.GA</version>

        </dependency>

        <!-- mysql数据库的驱动包 -->

        <dependency>

            <groupId>mysql</groupId>

            <artifactId>mysql-connector-java</artifactId>

            <version>5.1.6</version>

        </dependency>

    </dependencies>

</project>

package com.demo;

import java.util.Date;

public class Event {

    private Long id;//id

    private String title;//标题

    private Date date;//日期

    public Long getId() {

        return id;

    }

    public void setId(Long id) {

        this.id = id;

    }

    public String getTitle() {

        return title;

    }

    public void setTitle(String title) {

        this.title = title;

    }

    public Date getDate() {

        return date;

    }

    public void setDate(Date date) {

        this.date = date;

    }

}

<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC

        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"

        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="com.demo">

    <class name="com.demo.Event" table="EVENTS">

        <id name="id" column="EVENT_ID">

            <generator class="assigned"/>

        </id>

        <property name="date" type="timestamp" column="EVENT_DATE"/>

        <property name="title"/>

    </class>

</hibernate-mapping

>

<?xml version='1.0' encoding='utf-8'?>

<!DOCTYPE hibernate-configuration PUBLIC

        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"

        "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

    <session-factory>

        <!-- Database connection settings -->

        <property name="connection.driver_class">org.gjt.mm.mysql.Driver</property>

        <property name="connection.url">jdbc:mysql://192.168.32.95:3306/db2</property>

        <property name="connection.username">DB_WX_APP</property>

        <property name="connection.password">LH_longfor</property>

        <!-- JDBC connection pool (use the built-in) -->

        <property name="connection.pool_size">1</property>

        <!-- SQL dialect -->

        <property name="dialect">org.hibernate.dialect.MySQLDialect</property>

        <!-- Enable Hibernate's automatic session context management -->

        <property name="current_session_context_class">thread</property>

        <!-- Disable the second-level cache  -->

        <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>

        <!-- Echo all executed SQL to stdout -->

        <property name="show_sql">true</property>

        <property name="format_sql">true</property>

        <!-- Drop and re-create the database schema on startup -->

        <property name="hbm2ddl.auto">update</property>

        <mapping resource="mapper/Event.hbm.xml"/>

    </session-factory>

</hibernate-configuration>

package com.demo;

import org.hibernate.SessionFactory;

import org.hibernate.cfg.Configuration;

public class HibernateUtil {

    //定义静态的SessionFactory，产生单例，只生成一个SessionFactory

    private static final SessionFactory sessionFactory = buildSessionFactory();

    //用来初始化SessionFactory

    private static SessionFactory buildSessionFactory() {

        try {

            // Create the SessionFactory from hibernate.cfg.xml

            return new Configuration().configure().buildSessionFactory();

        }

        catch (Throwable ex) {

            // Make sure you log the exception, as it might be swallowed

            System.err.println("Initial SessionFactory creation failed." + ex);

            throw new ExceptionInInitializerError(ex);

        }

    }

    //得到SessionFactory

    public static SessionFactory getSessionFactory() {

        return sessionFactory;//返回SessionFactory的对象

    }

}

package com.demo;

import java.util.Date;

import java.util.List;

import org.hibernate.Session;

public class Test {

    /**

     * @param args

     */

    public static void main(String[] args) {

        // TODO Auto-generated method stub

        Test mgr = new Test();

        //if (args[0].equals("store")) {

        //mgr.createAndStoreEvent("My Event1", new Date());//调用函数插入数据

        //}

mgr.getList();

       // mgr.Get();//单个查询

        HibernateUtil.getSessionFactory().close();

    }

    private void createAndStoreEvent(String title, Date theDate) {

        //得到目前运行的session

        Session session = HibernateUtil.getSessionFactory().getCurrentSession();

        session.beginTransaction();//开始事务

        Event theEvent = new Event();//创建bean对象

        theEvent.setTitle(title);//设置标题

        theEvent.setId(100002L);

        theEvent.setDate(theDate);//设置日期

        session.save(theEvent);//保存对象

        session.getTransaction().commit();//提交事务

    }

    private void Get() {

        //得到目前运行的session

        Session session = HibernateUtil.getSessionFactory().getCurrentSession();

session.beginTransaction();

        Event theEvent = new Event();//创建bean对象

        theEvent.setId(100001L);

        Event e=(Event) session.get(Event.class,100001L);

        System.out.println(e.getTitle());

session.getTransaction().commit();

    }

    void getList(){

        Session session=HibernateUtil.getSessionFactory().getCurrentSession();

        session.beginTransaction();

       List<Event> list= session.createSQLQuery("select * from EVENTS").addEntity(Event.class).list();

  for(Event e:list){

      System.out.println(e.getTitle());

  }

  session.getTransaction().commit();

    }

}