Hibernate连接MySQL数据

来源:互联网 发布:mac必下的软件 编辑:程序博客网 时间:2024/06/16 05:32
1.从hibernate官网下载jar包

http://hibernate.org/orm/downloads/


2.从lib/required文件中复制出来到eclipse中你所用的那个项目的目录下,然后右键add build to path,这样包就导入完成了。


3.在项目的SRC目录下创建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="connection.driver_class">com.mysql.jdbc.Driver</property><property name="connection.url">jdbc:mysql://localhost:3306/wudeqin</property><property name="connection.username">root</property><property name="connection.password">123456</property><property name="dialect">org.hibernate.dialect.MySQLDialect</property><property name="show_sql">true</property><mapping resource="cn/date0802/model/User.hbm.xml"/></session-factory></hibernate-configuration>


这里的映射路径是我创建的包名cn.date0802.model。

4.创建好包名之后,在包的目录创建三个文件,User.class,HibernateTest.class和User.hbm.xml。在MySQL的数据库中创建一个tb_user的表,字段分别为  username,password,sex,age。除了age是int类型,其他都是varchar


User.class--------------------------------------------其实就是一个带有无参构造方法的Javabean


package cn.date0802.model;public class User {private String username;private String password;private String sex;private int age;public User(){}public String getUsername() {return username;}public void setUsername(String username) {this.username = username;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}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;}}

HibernateTest.class--------------------------------测试是否连接成功的测试类


package cn.date0802.model;import org.hibernate.Session;import org.hibernate.SessionFactory;import org.hibernate.cfg.Configuration;public class HibernateTest {public static void main(String[] args) {User u=new User();u.setUsername("吴大大");u.setPassword("123");u.setSex("女");u.setAge(20);Configuration cfg=new Configuration();SessionFactory sf=cfg.configure().buildSessionFactory();Session session=sf.openSession();session.beginTransaction();session.save(u);session.getTransaction().commit();session.close();sf.close();System.out.println("成功");}}


User.hbm.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 package="cn.date0802.model"><class name="User" table="tb_user"><id name="username" column="username" type="java.lang.String"><generator class="assigned"></generator></id><property name="password" type="java.lang.String" not-null="true" length="50"><column name="password"></column></property><property name="sex" type="java.lang.String"><column name="sex"></column></property><property name="age" type="int"><column name="age"></column></property></class></hibernate-mapping>

5.在HibernateTest中开始运行测试。测试结果如下:

原创粉丝点击