hibernate连接mysql数据库

1.首先导入hibernate的lib包

2.导入mysql的驱动

3建立mysql的配置hibernate.cfg.xml,内容如下

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration SYSTEM   
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">


<hibernate-configuration>
<session-factory>
<!-- SQL dialect 方言 -->
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<!--mysql 驱动 -->
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>


<!-- 数据库连接配置 -->
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/数据库的表名</property>
<property name="hibernate.connection.username">账号</property>
<property name="hibernate.connection.password">密码</property>
<!-- show_sql 生成SQL语句输出到日志以供调式 -->
<property name="hibernate.show_sql">true</property>

<!-- 指定session通过当前执行的线程来跟踪和界定 -->
<property name="hibernate.current_session_contecxt_class">thread</property>


<!-- List of XML mapping files -->
<mapping resource="com/yyf/domain/user.hbm.xml" />
</session-factory>
</hibernate-configuration>  

4.建立model

public class UserModel {
private Integer uid;
private String uname;
private String upwd;


public Integer getUid() {
return uid;
}
public void setUid(Integer uid) {
this.uid = uid;
}
public String getUname() {
return uname;
}
public void setUname(String uname) {
this.uname = uname;
}
public String getUpwd() {
return upwd;
}
public void setUpwd(String upwd) {
this.upwd = upwd;
}

}

5.使用hibernate配置model

<?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 package="com.yyf.domain">
<class name="UserModel" table="user">
<id name="uid" type="java.lang.Integer">
<generator class="native"></generator>
</id>
<property name="uname" type="java.lang.String" />
<property name="upwd" type="java.lang.String" />
</class>
</hibernate-mapping> 

6.测试

public class Test {
public static void main(String[] args) {
UserModel user=new UserModel();
user.setUname("ddd");
user.setUpwd("123");

Configuration cfg=new Configuration();
SessionFactory sf=cfg.configure().buildSessionFactory();
Session session=sf.openSession();
session.beginTransaction();
session.save(user);
session.getTransaction().commit();
session.close();
sf.close();
}
}

亲测成功,

注意事项:

1.在配置model时要注意大小写

2.在表有主外键的时候要在XXX.hbm.xml中声明

3.在hibernate.cfg.xml中配置model时如有com.test.test的包结构下resource写成com/test/test/XXX.hbm.xml