第一个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) );