hibernate配置

hibernate配置

首先，建立实体类

package com.jimmyqin.bean;

import java.sql.Date;

public class UserBean {
    private Integer id;
    private String userName;
    private String sex;
    private Date birthday;

    public UserBean() {

    }

    public UserBean(Integer id, String userName, String sex, Date birthday) {
        super();
        this.id = id;
        this.userName = userName;
        this.sex = sex;
        this.birthday = birthday;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public Date getBirthday() {
        return birthday;
    }

    public void setBirthday(Date birthday) {
        this.birthday = birthday;
    }


}

然后建立实体类的映射文件UserBean.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">

<hibernate-mapping>
    <class name="com.jimmyqin.bean.UserBean" table="user" catalog="test">
        <id name="id" type="java.lang.Integer">
            <column name="id" />
        </id>
        <property name="userName" type="java.lang.String">
            <column name="userName" length="10" not-null="true"  />
        </property>
        <property name="sex" type="java.lang.String">
            <column name="sex" length="2" />
        </property>
        <property name="birthday" type="java.util.Date">
            <column name="birthday" length="10" />
        </property>
    </class>
</hibernate-mapping>

使用maven添加jar包依赖

<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/maven-v4_0_0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>com.jimmyqin</groupId>
  <artifactId>newssh</artifactId>
  <packaging>war</packaging>
  <version>0.0.1-SNAPSHOT</version>
  <name>newssh Maven Webapp</name>
  <url>http://maven.apache.org</url>
  <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>
  <build>
    <finalName>newssh</finalName>
    <plugins>  
            <plugin>  
                <groupId>org.apache.maven.plugins</groupId>  
                <artifactId>maven-compiler-plugin</artifactId>  
                <version>3.1</version>  
                <configuration>  
                    <source>1.8</source>  
                    <target>1.8</target>  
                </configuration>  
            </plugin>  
        </plugins>  
  </build>
</project>

添加bibernate配置文件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">  
<hibernate-configuration>  
    <session-factory>  
        <!-- Database connection settings -->  
        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>  
        <property name="connection.url">jdbc:mysql://localhost:3306/test</property>  
        <property name="connection.username">root</property>  
        <property name="connection.password">root</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="com/jimmyqin/bean/UserBean.xml"/>  
    </session-factory>  
</hibernate-configuration>