一个使用hibernate的示例

1.创建一个表

create table Students(
ID int primary key,
name varchar(20),
gender varchar(20),
birthday date,
address varchar(100)
);

2.在Eclipse中创建一个工程,导入相关的类库,Hibernate需要hibernate3.jar,访问数据库的驱动包mysql-connector-java-5.0.8-bin.jar和

操作XML文件用到的jar包。接着创建一个持久化类。

//学生类
public class Students {
	/*
	 * 1.公有类
	 * 2.提供公有的不带参数的默认构造方法
	 * 3.属性私有
	 * 4.属性setter/getter封装
	 */
	private int id;//学号
	private String name;//姓名
	private String gender;//性别
	private Date birthday;//出生日期
	private String address;//地址
	
	public Students(){
		
	}

	public Students(int id, String name, String gender, Date birthday,
			String address) {
		super();
		this.id = id;
		this.name = name;
		this.gender = gender;
		this.birthday = birthday;
		this.address = address;
	}

	public int getId() {
		return id;
	}

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

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getGender() {
		return gender;
	}

	public void setGender(String gender) {
		this.gender = gender;
	}

	public Date getBirthday() {
		return birthday;
	}

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

	public String getAddress() {
		return address;
	}

	public void setAddress(String address) {
		this.address = address;
	}

	public String toString() {
		return "Students [id=" + id + ", name=" + name + ", gender=" + gender
				+ ", birthday=" + birthday + ", address=" + address + "]";
	}
	
}
3.创建一个目录hibernate,其中包含两个配置文件:hibernate.cfg.xml和students.hdm.xml,其中

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.username">root</property>
    	<property name="connection.password">123</property>
    	<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
    	<property name="connection.url">jdbc:mysql:///hibernate?useUnicode=true&charactreEncoding=UTF-8</property>
    	<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
   
   		<property name="show_sql">true</property>
   		<property name="format_sql">true</property>
   		<property name="hbm2ddl.auto">create</property>
   		
   		<mapping resource="Students.hbm.xml"/>
   		
    </session-factory>
</hibernate-configuration>
students.hdm.xml的文件内容为:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2015-6-25 11:15:21 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
    <class name="Students" table="STUDENTS">
        <id name="id" type="int">
            <column name="ID" />
            <generator class="assigned" />
        </id>
        <property name="name" type="java.lang.String">
            <column name="NAME" />
        </property>
        <property name="gender" type="java.lang.String">
            <column name="GENDER" />
        </property>
        <property name="birthday" type="java.sql.Date">
            <column name="BIRTHDAY" />
        </property>
        <property name="address" type="java.lang.String">
            <column name="ADDRESS" />
        </property>
    </class>
</hibernate-mapping>
4.编写访问数据库的代码

import java.util.Date;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.Service;
import org.hibernate.service.ServiceRegistry;
import org.hibernate.service.ServiceRegistryBuilder;
public class Test {
	public static void main(String[] args) {
		//创建配置对象
		Configuration config=new Configuration().configure();
		//创建服务注册对象
		ServiceRegistry serviceRegistry=new ServiceRegistryBuilder().applySettings(config.getProperties()).buildServiceRegistry(); 
		//创建会话工厂对象
		SessionFactory sessionFactory=config.buildSessionFactory(serviceRegistry);
		//会话对象
		Session session=sessionFactory.openSession();
		//开启事务
		Transaction transaction=session.beginTransaction();
		Students s=new Students(2,"陈峰","男",new Date(),"武当山");
		try {
			session.save(s);//保存持久类对象
			transaction.commit();//提交到数据库
			//从数据库中查找刚才保存的数据
			Query q=session.createSQLQuery("select * from Students").addEntity(Students.class);
			List<Students> rs=q.list();
			for(int i=0;i<rs.size();i++){
				Students s1=rs.get(i);
				System.out.println(s1.toString());
			}
			session.close();
		} catch (Exception s1) {
			// TODO Auto-generated catch block
			s1.printStackTrace();
			transaction.rollback();
		}
	}
}

程序运行结果为:

Hibernate: 
    insert 
    into
        STUDENTS
        (NAME, GENDER, BIRTHDAY, ADDRESS, ID) 
    values
        (?, ?, ?, ?, ?)
Hibernate: 
    select
        * 
    from
        Students
Students [id=2, name=陈峰, gender=男, birthday=Sun Jul 05 10:26:49 CST 2015, address=武当山]

前面是Hibernate框架打印出的信息,最后一行是从数据库中查找到的信息。



评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值