Hibernate的索引

hibernate.cfg.xml文件

<?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"><!-- Generated by MyEclipse Hibernate Tools.                   --><hibernate-configuration>    <session-factory>        <property name="hbm2ddl.auto">update</property>        <property name="dialect">            org.hibernate.dialect.MySQLDialect        </property>        <property name="connection.url">            jdbc:mysql://localhost:3306/db01        </property>        <property name="connection.username">chen</property>        <property name="connection.password">chen</property>        <property name="connection.driver_class">            com.mysql.jdbc.Driver        </property>        <property name="myeclipse.connection.profile">            conect_1        </property>        <mapping resource="com/csl/entity/Message.hbm.xml" />    </session-factory></hibernate-configuration>

entity.hbm.xml文件配置

<?xml version="1.0" encoding="utf-8"?><!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN""http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd"><!-- Mapping file autogenerated by MyEclipse Persistence Tools --><hibernate-mapping>    <class name="com.csl.entity.Message" table="message" catalog="db01">        <id name="id" type="java.lang.String">            <column name="id" length="32" />            <generator class="native" />        </id>        <property name="createDate" type="java.sql.Timestamp">            <column name="createDate" length="19" />        </property>        <property name="modifyDate" type="java.sql.Timestamp">            <column name="modifyDate" length="19" />        </property>        <property name="content" type="java.lang.String">            <column name="content" length="65535" not-null="true" />        </property>        <property name="deleteStatus" type="java.lang.Integer">            <column name="deleteStatus" not-null="true" />        </property>        <property name="isRead" type="java.lang.Boolean">            <column name="isRead" not-null="true" />        </property>        <property name="isSaveDraftbox" type="java.lang.Boolean">            <column name="isSaveDraftbox" not-null="true" />        </property>        <property name="title" type="java.lang.String">            <column name="title" not-null="true" />        </property>        <property name="fromMemberId" type="java.lang.String">            <column name="fromMember_id" length="32" />        </property>        <property name="toMemberId" type="java.lang.String">            <column name="toMember_id" length="32" />        </property>    </class>    <sql-query name="all">            select m.* from message m        <return alias="m" class="com.csl.entity.Message"/>    </sql-query></hibernate-mapping>

测试类代码

package com.csl.test;import java.util.List;import org.hibernate.Criteria;import org.hibernate.Query;import org.hibernate.SQLQuery;import org.hibernate.Session;import org.hibernate.criterion.Example;import org.hibernate.criterion.Restrictions;import org.junit.Test;import sun.awt.geom.AreaOp.AddOp;import com.csl.entity.Message;import com.csl.util.HibernateSessionFactory;public class TestHibernate {        private Session session = HibernateSessionFactory.getSession();        @Test        public void show1(){            //HQL索引//          String Hql = "from Message";//          List<Message> list = session.createQuery(Hql).list();            //Criteria类//          List<Message> list =  session.createCriteria(Message.class)//          .add(Example.create(new Message()))  //添加查询实例//          .list();            //本地SQL语句//          List<Message> list = session.createSQLQuery("select m.* from message m").addEntity("m", Message.class).list();            //XXX.hbm.xml自定义sql，命名索引//          List<Message> list = session.getNamedQuery("all").list();            //直接调用存储过程            SQLQuery query = session.createSQLQuery("{Call proc(?)}");                 Query q = query.setInteger(0, 1);            List<Message> list = q.list();            session.close();            for (Message m : list) {                System.out.println(m);            }        }}