增删改查模板文件

hibernate.cfg.xml

<!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.driver_class">com.mysql.jdbc.Driver</property>
		<property name="connection.url">jdbc:mysql:///test</property>
		<property name="connection.username">root</property>
		<property name="connection.password"></property>
		
		<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
		
		<property name="hbm2ddl.auto">update</property>
		<property name="show_sql">true</property>
		
		<mapping resource="cn/itcast/domain/User.hbm.xml"/>
	</session-factory>
</hibernate-configuration>

 HibernateUitl

package cn.itcast.dao;

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

public final class HibernateUitl {
	private static SessionFactory sessionFactory;

	private HibernateUitl() {
	}

	static {
		Configuration cfg = new Configuration();
		cfg.configure();
		sessionFactory = cfg.buildSessionFactory();
	}

	public static SessionFactory getSessionFactory() {
		return sessionFactory;
	}

	public static Session getSession() {
		return sessionFactory.openSession();
	}
}

 UserDao

package cn.itcast.dao;

import cn.itcast.domain.User;

public interface UserDao {
	public void saveUser(User user);

	public User findUserByName(String name);

	public User findUserById(int id);

	public void updateUser(User user);

	public void remove(User user);
}

 UserDaoHibernateImpl

package cn.itcast.dao.impl;

import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.Restrictions;

import cn.itcast.dao.HibernateUitl;
import cn.itcast.dao.UserDao;
import cn.itcast.domain.User;

public class UserDaoHibernateImpl implements UserDao {

	public User findUserById(int id) {
		Session s = null;
		try {
			s = HibernateUitl.getSession();
			User user = (User) s.get(User.class, id);
			return user;
		} finally {
			if (s != null)
				s.close();
		}
	}

	public User findUserByName(String name) {
		Session s = null;
		try {
			s = HibernateUitl.getSession();
			Criteria c = s.createCriteria(User.class);
			c.add(Restrictions.eq("name", name));
			User user = (User) c.uniqueResult();
			return user;
		} finally {
			if (s != null)
				s.close();
		}
	}

	public User findUserByName1(String name) {
		Session s = null;
		try {
			s = HibernateUitl.getSession();
			String hql = "from User as user where user.name=:n";
			Query q = s.createQuery(hql);
			q.setString("n", name);
			User user = (User) q.uniqueResult();
			return user;
		} finally {
			if (s != null)
				s.close();
		}
	}

	public void remove(User user) {
		Session s = null;
		Transaction tx = null;
		try {
			s = HibernateUitl.getSession();
			tx = s.beginTransaction();
			s.delete(user);
			tx.commit();
		} finally {
			if (s != null)
				s.close();
		}
	}

	public void saveUser(User user) {
		Session s = null;
		Transaction tx = null;
		try {
			s = HibernateUitl.getSession();
			tx = s.beginTransaction();
			s.save(user);
			tx.commit();
		} finally {
			if (s != null)
				s.close();
		}
	}

	public void updateUser(User user) {
		Session s = null;
		Transaction tx = null;
		try {
			s = HibernateUitl.getSession();
			tx = s.beginTransaction();
			s.update(user);
			tx.commit();
		} finally {
			if (s != null)
				s.close();
		}

	}

}

 User

package cn.itcast.domain;

import java.util.Date;

public class User {
	private int id;
	private String name;
	private Date birthday;

	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 Date getBirthday() {
		return birthday;
	}

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

 

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC 
	"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
	"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="cn.itcast.domain">

	<class name="User">
		<id name="id">
			<generator class="native" />
		</id>

		<property name="name" unique="true"/>
		<property name="birthday" />
	</class>

</hibernate-mapping>

 

package cn.itcast;

import java.util.Date;

import cn.itcast.dao.UserDao;
import cn.itcast.dao.impl.UserDaoHibernateImpl;
import cn.itcast.domain.User;

public class DaoTest {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		UserDao dao = new UserDaoHibernateImpl();
		User user = new User();
		user.setName("name");
		user.setBirthday(new Date());
		System.out.println("1111");
		dao.saveUser(user);

		user.setName("new name");
		System.out.println("2222");
		dao.updateUser(user);

		User u = dao.findUserByName(user.getName());

		System.out.println("3333");
		dao.remove(u);

	}

}