第一个Hibernate程序

Hibernate is a powerful, high performance object/relational persistence and query service. Hibernate lets you develop persistent classes following object-oriented idiom - including association, inheritance, polymorphism, composition, and collections. Hibernate allows you to express queries in its own portable SQL extension (HQL), as well as in native SQL, or with an object-oriented Criteria and Example API.

Hibernate是一个强大高效的对象/关系持久层查询服务器。 Hibernate可以让你开发遵循面向对象风格的持久化类-包括关联，继承，多态，构成和集合。 Hibernate可以让你表达查询自己的便携式的SQL扩展名（即HQL ） ，以及在本地SQL ，或面向对象的API标准和范例。（引用官方）www.hhibernate.org

运行第一个hibernate程序

1.设计持久化类(UserInfo)

对应的映射文件 UserInfo.hbm.xml

package com.lycn.demo;

public class UserInfo {
	private int id;
	private String username;
	private String password;
	
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	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;
	}
}

建立对应UserInfo类的映射文件 userinfo.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">
<!-- 
    Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
    <class name="com.lycn.demo.UserInfo" table="userinfo" catalog="hibernate">
        <id name="id" type="java.lang.Integer">
            <column name="id" />
            <generator class="identity" />
        </id>
        <property name="username" type="java.lang.String">
            <column name="username" length="20" not-null="true" />
        </property>
        <property name="password" type="java.lang.String">
            <column name="password" length="20" />
        </property>
    </class>
</hibernate-mapping>

2. 配置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">

<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>

	<session-factory>
		<property name="connection.username">root</property>
		<property name="connection.url">
			jdbc:mysql://localhost:3306/hibernate
		</property>
		<property name="dialect">
			org.hibernate.dialect.MySQLInnoDBDialect
		</property>
		<property name="myeclipse.connection.profile">MySQL</property>
		<property name="connection.password">123456</property>
		<property name="connection.driver_class">
			com.mysql.jdbc.Driver
		</property>
		<mapping resource="com/lycn/demo/Userinfo.hbm.xml" />

	</session-factory>

</hibernate-configuration>

3.操作类

package com.lycn.demo;

import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

public class UserOperate {

	private Session session = null;
	public UserOperate()
	{
		SessionFactory sf = new Configuration().configure().buildSessionFactory();
		session = sf.openSession();	
	}
	public void insert(String username, String password)
	{
		Transaction tx = session.beginTransaction();
		UserInfo user = new UserInfo();
		user.setUsername(username);
		user.setPassword(password);
		session.save(user);
		tx.commit();
	}
	
	public List<UserInfo> getAllUserInfo()
	{
		List<UserInfo> list = new ArrayList<UserInfo>();
		Transaction tx = session.beginTransaction();
		String hql = "from UserInfo as u";
		Query query = session.createQuery(hql);
		list = query.list();
		tx.commit();
		return list;
	}
	
	public UserInfo getUserInfoById(int id)
	{
		UserInfo user = new UserInfo();
		Transaction tx = session.beginTransaction();
		
		String hql = "from UserInfo as u where u.id=?";
		Query query = session.createQuery(hql);
		query.setInteger(0, id);
		List<UserInfo> temp = query.list();
		tx.commit();
		Iterator<UserInfo> it = temp.iterator();
		if(it.hasNext())
		{
			user = it.next();
		}
		return user;
	}
	
	public void delete(int id)
	{
		UserInfo user = new UserInfo();
		Transaction tx = session.beginTransaction();
		String hql = "delete UserInfo as u where u.id=?";
		Query query = session.createQuery(hql);
		query.setInteger(0, id);
		query.executeUpdate();
		tx.commit();
	}
	
	public void update(UserInfo user)
	{
		Transaction tx = session.beginTransaction();
		this.session.update(user);
		tx.commit();
	}
	
}

4. 测试类

package com.lycn.demo;

import java.util.Iterator;
import java.util.List;

public class HibernateTest {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		UserOperate uo = new UserOperate();
//		uo.insert("lycn2", "123456");

		List<UserInfo> list = uo.getAllUserInfo();
		for(UserInfo user : list)
		{
			System.out.println("~~~~~~~~~~~~~~~~~~~~");
			System.out.println("Id: " + user.getId());
			System.out.println("UserName: " + user.getUsername());
			System.out.println("Password: " + user.getPassword());
		}
		
		UserInfo u = new UserInfo();
		u = uo.getUserInfoById(1);
		System.out.println();
		System.out.println("查询操作按ID");
		System.out.println("~~~~~~~~~~~~~~~~~~~~");
		System.out.println("Id: " + u.getId());
		System.out.println("UserName: " + u.getUsername());
		System.out.println("Password: " + u.getPassword());
		
		
		
	}

注：数据库是MySQL

数据库设计如下:

drop database hibernate;
create database hibernate;
use hibernate;

create table userinfo
(
	id    	   int(11) not null auto_increment,
	username    varchar(20) not null,
	password    varchar(20),
	primary key(id)
);