Hibernate基础的增删改查

Java bean：

package com.my.bean;

public class User {
	
	private Integer id;		
	private String username;
	
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	@Override
	public String toString() {
		return "User [id=" + id + ", username=" + username + "]";
	}

}

hbm, 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="com.my.bean" >
	<class name="User" table="t_user">
		<id name="id">
			<generator class="native"></generator>
		</id>
		<property name="username" ></property>
	</class>

</hibernate-mapping>

hibernate.cfg.xml:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
	"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
	"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>

<session-factory>

	<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
	<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/hibernate?useUnicode=true&amp;characterEncoding=UTF-8</property>
	<property name="hibernate.connection.username">root</property>
	<property name="hibernate.connection.password">1234</property>
	<property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property>
	
	<property name="hibernate.format_sql">true</property>
	<property name="hibernate.show_sql">true</property>
	
	<property name="hibernate.hbm2ddl.auto">update</property>
	<property name="javax.persistence.validation.mode">none</property>
	
	<mapping resource="com/my/bean/User.hbm.xml" />

</session-factory>

</hibernate-configuration>

UserDao:

package com.my.dao;

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;

import com.my.bean.User;

public class UserDao {

	public void save(User user) {
		Configuration config = new Configuration().configure();
		SessionFactory factory = config.buildSessionFactory();
		Session session = factory.openSession();
		Transaction transaction = session.beginTransaction();

		session.save(user);

		transaction.commit();
		session.close();
		factory.close();

	}

	public void update(User user) {
		Configuration config = new Configuration().configure();
		SessionFactory factory = config.buildSessionFactory();
		Session session = factory.openSession();
		Transaction transaction = session.beginTransaction();
		
		session.update(user);

		transaction.commit();
		session.close();
		factory.close();

	}

	public void delete(User user) {
		Configuration config = new Configuration().configure();
		SessionFactory factory = config.buildSessionFactory();
		Session session = factory.openSession();
		Transaction transaction = session.beginTransaction();

		session.delete(user);

		transaction.commit();
		session.close();
		factory.close();

	}

	public User findById(Integer id) {

		Configuration config = new Configuration().configure();
		SessionFactory factory = config.buildSessionFactory();
		Session session = factory.openSession();
		Transaction transaction = session.beginTransaction();

		User user = (User) session.get(User.class, id);

		transaction.commit();
		session.close();
		factory.close();

		return user;

	}

	public List<User> findAll() {
		Configuration config = new Configuration().configure();
		SessionFactory factory = config.buildSessionFactory();
		Session session = factory.openSession();
		Transaction transaction = session.beginTransaction();

		Query query = session.createQuery("from User");
		List<User> allUser = query.list();

		transaction.commit();
		session.close();
		factory.close();

		return allUser;

	}

	public List<User> findAllPage(int startIndex, int pageSize) { 
		Configuration config = new Configuration().configure();
		SessionFactory factory = config.buildSessionFactory();
		Session session = factory.openSession();
		Transaction transaction = session.beginTransaction();

		Query query = session.createQuery("from User");
		query.setFirstResult(startIndex);
		query.setMaxResults(pageSize);

		Object obj = session.createQuery("select count(*) from User").uniqueResult();
		System.out.println(obj);

		List<User> allUser = query.list();

		transaction.commit();
		session.close();
		factory.close();

		return allUser;

	}

}

UserDaoTest:

package com.my.dao;

import java.util.List;

import org.junit.Test;

import com.my.bean.User;

public class UserDaoTest {
	
	UserDao userDao = new UserDao();

	@Test
	public void testSave() {
		User user = new User();
		user.setUsername("tom");
		
		userDao.save(user);
	}

	@Test
	public void testUpdate() {
		User user = new User();
		user.setId(2);
		user.setUsername("jack");
		
		userDao.update(user);
	}

	@Test
	public void testDelete() {
		User user = new User();
		user.setId(3);
		
		userDao.delete(user);
	}

	@Test
	public void testFindById() {
		User user = userDao.findById(2);
		System.out.println(user);
	}

	@Test
	public void testFindAll() {
		List<User> allUser = userDao.findAll();
		
		for (User user : allUser) {
			System.out.println(user);
		}
	}

	@Test
	public void testFindAllPage() {
		List<User> allUser = userDao.findAllPage(0, 2);
		for (User user : allUser) {
			System.out.println(user);
		}
	}

}