6月5日 SSH 周二

<?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><!-- 每个sessionfactory连接一个数据库 -->
    <!-- 驱动 -->
    <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
    <!-- 连接路径 -->
    <property name="connection.url">jdbc:mysql:///cms09</property>
    <!-- 用户名 -->
    <property name="connection.username">root</property>
    <!-- 密码 -->
    <property name="connection.password">root</property>
    <!-- 方言 -->
    <property name="dialect">org.hibernate.dialect.MySQLDialect</property>

    <!-- 自动创建表 -->
    <!-- 
        update:如果没有表，创建表，如果有表，在原表基础上进行修改
        create:每次加载都创建新表
     -->

     <property name="hbm2ddl.auto">update</property>
     <!-- 打印sql -->
     <property name="show_sql">true</property>
     <!-- sql格式化 -->
     <property name="format_sql">true</property>
     <!-- 配置映射文件 -->
     <mapping resource="com/dto/Cat.hbm.xml"/>

    </session-factory>
</hibernate-configuration>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
    <!-- 映射配置文件 -->

<hibernate-mapping>
    <!-- 一个类和一个表的一一对应关系 -->
    <class name="com.dto.Cat" table="t_cat">
        <!-- 主键 -->
        <id name="id" column="cid" type="java.lang.Integer">
            <generator class="native"></generator>
        </id>
        <property name="name" column="cname" type="java.lang.String"></property>
        <property name="sex"></property>
        <property name="age"></property>
    </class>
</hibernate-mapping>

package com.dto;

public class Cat {
    private int id;
    private String name;
    private String sex;
    private int age;
    public Cat() {
        super();
        // TODO Auto-generated constructor stub
    }
    public Cat(int id, String name, String sex, int age) {
        super();
        this.id = id;
        this.name = name;
        this.sex = sex;
        this.age = age;
    }
    @Override
    public String toString() {
        return "Cat [id=" + id + ", name=" + name + ", sex=" + sex + ", age="
                + age + "]";
    }
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getSex() {
        return sex;
    }
    public void setSex(String sex) {
        this.sex = sex;
    }
    public int getAge() {
        return age;
    }
    public void setAge(int age) {
        this.age = age;
    }


}

package com.demo;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.classic.Session;

import com.dto.Cat;

public class Demo {
    public static void main(String[] args) {
        //加载hibernate.cfg.xml;默认加载的路径:/hibernate.cfg.xml
        Configuration config = new Configuration().configure();
        //用Confiiguration对象创建一个SessionFactory
        SessionFactory sessionFactory = config.buildSessionFactory();
        //从sessionfactory得到一个session对象
        //session是对Connection的高级封装
        Session session = sessionFactory.openSession();

        String hql = " from Cat ";
        //session创建一个Query对象
        Query query = session.createQuery(hql);
        //执行查询
        List<Cat> list = query.list();
        for (Cat c : list) {
            System.out.println(c);
        }
    }
}

耐性是天才必不可少的素质之一
——爱默生