hubernate 的配置使用

1，下载hubernate，http://hibernate.org/选择hubernate orm 选择release，下载后解压，主要用到lib下的required和jpa-..下的所有jar，或者maven引用远程jar包

    <properties>
         <hibernate.version>5.2.12.Final</hibernate.version>
    </properties>
    <dependency>
        <groupId>org.hibernate</groupId>
        <artifactId>hibernate-core</artifactId>
        <version>${hibernate.version}</version>
    </dependency>

2，下载mysql连接jar包，https://dev.mysql.com/downloads/mysql/，或者maven引用

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>${mysql.version}</version>
</dependency>

3，测试是否可连接操作（执行数据插入）

   （1）创建库和表：创建usersystem库和user表字段包括：id，username，userpwd

   （2）创建model对应表的字段

public class User {
	private long id;
	private String username;
	private String userpwd;
	private Usermes usermes;

	public Usermes getUsermes() {
		return usermes;
	}

	public void setUsermes(Usermes usermes) {
		this.usermes = usermes;
	}

	public long getId() {
		return id;
	}

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

	public String getUsername() {
		return username;
	}

	public void setUsername(String username) {
		this.username = username;
	}

	public String getUserpwd() {
		return userpwd;
	}

	public void setUserpwd(String userpwd) {
		this.userpwd = userpwd;
	}

}

   （3）src下建立user.hbm.xml配置如下：class 对应model，table对应表名。id,username,userpwd分别对应user表字段名

<?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.test.vo.User" table="user">
		<id name="id">
			<generator class="assigned"></generator>
		</id>
		<property name="username"></property>
		<property name="userpwd"></property>
	</class>
</hibernate-mapping>

  （4）src目录下创建hibernate.cfg.xml配置如下<mapping resource="user.hbm.xml"/>  为映射文件路径

<?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">
	<!-- Generated by MyEclipse Hibernate Tools. -->
	<hibernate-configuration>
		<session-factory>
			<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
			<property name="connection.url">jdbc:mysql://localhost:3306/usersystem?characterEncoding=utf8&
                              useSSL=true</property>
			<property name="connection.username">root</property>
			<property name="connection.password">wys123</property>
			<property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>
			<property name="show_sql">true</property>
			<mapping resource="user.hbm.xml"/>
		</session-factory>
	</hibernate-configuration>

  （5）创建一个类执行插入语句：

           Configuration cfg=new Configuration().configure();
	   cfg.addClass(User.class);
           SessionFactory factory = cfg.buildSessionFactory();
	   Session session = factory.openSession();
	   Transaction t=session.beginTransaction();
	   User user=new User();
	   user.setId(0);
	   user.setUsername("小李");
	   user.setUserpwd("123");
	   session.save(user);
	   t.commit();
	   session.close();