Hibernate例子(添加,修改,删除,获得结果集)

关键词: Hibernate,添加,修改,删除,结果集

1.添加

public int insertNewOneUser(UserVo user) {
		Session session = sessionFactory.openSession();
		Transaction tx = null;
		try {
			tx = session.beginTransaction();
			session.save(user);
			tx.commit();
		} catch (Exception e) {
			tx.rollback();
			e.printStackTrace();
		} finally {
			session.close();
		}
		return 0;
	}

2.修改

public int updateUser(UserVo user) {
		Session session = sessionFactory.openSession();
		Transaction tx = null;
		try {
			tx = session.beginTransaction();
			session.update(user);
			tx.commit();
		} catch (Exception e) {
			tx.rollback();
			e.printStackTrace();
		} finally {
			session.close();
		}
		return 0;
	}

3.删除

public int deleteUser(UserVo user) {
		Session session = sessionFactory.openSession();
		Transaction tx = null;
		try {
			tx = session.beginTransaction();
			session.delete(user);
			tx.commit();
		} catch (Exception e) {
			tx.rollback();
			e.printStackTrace();
		} finally {
			session.close();
		}
		return 0;
	}

4.获得结果集

public UserVo selectUserFromId(int id) {
		Session session = sessionFactory.openSession();
		Transaction tx = null;
		try {
			tx = session.beginTransaction();
			Query query = session.createQuery("from UserVo where id = :id");
			query.setInteger("id", id);
			return (UserVo) query.list().get(0);
		} catch (Exception e) {
			tx.rollback();
			e.printStackTrace();
		} finally {
			session.close();
		}
		return null;
	}

5.Hibernate配置

<?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">

<hibernate-mapping>
	<class name="com.zakisoft.hib.UserVo" table="user2">
		<id name="id" column="ID" type="int">
			<generator class="increment"/>
		</id>
		<property name="name" column="NAME" type="string" not-null="true"/>
		<property name="password" column="PASSWORD" type="string" not-null="true"/>
	</class>
</hibernate-mapping>

6.源码和例子下载
http://www.zakisoft.com/?p=95

评论

1 楼 ljf184463552 2012-12-29  

例子链接下载不了，能邮件发给我吗？