<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:aop="http://www.springframework.org/schema/aop"
  xmlns:tx="http://www.springframework.org/schema/tx"
  xmlns:context="http://www.springframework.org/schema/context"
  xsi:schemaLocation="
  http://www.springframework.org/schema/beans 
  http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
  http://www.springframework.org/schema/aop 
  http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
  http://www.springframework.org/schema/tx 
  http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
  http://www.springframework.org/schema/context   
  http://www.springframework.org/schema/context/spring-context-3.0.xsd">
 
  <bean name="c" class="com.lc.pojo.Category">
    <property name="name" value="yyy" />
  </bean>
  
  <bean name="dao" class="com.lc.dao.CategoryDAO">
    <property name="sessionFactory" ref="sf" />
  </bean>

  <bean name="sf"
    class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
    <property name="dataSource" ref="ds" />
    <property name="mappingResources">
      <list>
        <value>com/lc/pojo/Category.hbm.xml</value>
      </list>
    </property>
    <property name="hibernateProperties">
      <value>
        hibernate.dialect=org.hibernate.dialect.MySQLDialect
        hibernate.show_sql=true
        hbm2ddl.auto=update
        </value>
    </property>
  </bean>  
    
<!--  數(shù)據(jù)源-->
  <bean name="ds"
    class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="com.mysql.jdbc.Driver" />
    <property name="url" value="jdbc:mysql://localhost:3306/test?characterEncoding=GBK" />
    <property name="username" value="root" />
    <property name="password" value="123456" />
  </bean>  
 
</beans>

ApplicationContext context=new ClassPathXmlApplicationContext("applicationContext.xml");
    CategoryDAO bean =(CategoryDAO) context.getBean("dao");

    DetachedCriteria criteria = DetachedCriteria.forClass(Category.class);

//    List<Category> list = bean.findByCriteria(criteria, 0, 5); //分頁--取0-5個(gè)返回
//    System.out.println(list);

<?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.lc.pojo">
  <class name="Category" table="category_">
    <id name="id" column="id">
      <generator class="native">
      </generator>
    </id>
    <property name="name" />
  </class>
</hibernate-mapping>