首页 / 软件开发 / JAVA / hibernate连接mysql的例子

hibernate连接mysql的例子2015-02-09今天用了一下java的数据库持久化-业务的hibernate框架。下面给出hibernate 连接mysql数据库示例

建表结构如下

mysql> desc test;
+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| id       | int（11）      | NO   | PRI | NULL    | auto_increment |
| username | varchar（100） | NO   |     | NULL    |                |
+----------+--------------+------+-----+---------+----------------+
2 rows in set （0.00 sec）

mysql>

hibernate配置文件 hibernate.cfg.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"><hibernate-configuration><session-factory><property name="show_sql">true</property><property name="dialect">org.hibernate.dialect.MySQLDialect</property><property name="connection.driver_class">com.mysql.jdbc.Driver</property><property name="connection.url">jdbc:mysql://192.168.25.152/test</property><property name="connection.username">这里写用户名</property><property name="connection.password">密码</property><mapping resource="user.hbm.xml" /></session-factory></hibernate-configuration>

表映射 user.hbm.xml

<？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.TestDb" table="test"><id name="id" column="id"><generator class="increment" /></id><property name="username" column="username"/></class></hibernate-mapping>

表映射类

package com;/** * Created by IntelliJ IDEA. * User: Administrator * Date: 2006-2-6 * Time: 22:10:05 * To change this template use File | Settings | File Templates. */public class TestDb {private String username;private Long id;public Long getId（） {return id;}public void setId（Long id） {this.id = id;}public String getUsername（） {return username;}public void setUsername（String myname） {this.username = myname;}}