Hibernate3.5.3 之 CRUD

最新推荐文章于 2012-03-11 21:48:15 发布
最新推荐文章于 2012-03-11 21:48:15 发布
阅读量471 收藏
点赞数
分类专栏： J2EE 文章标签： hibernate user session null string class
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/EthanQ/article/details/7330144
版权

Hibernate配置文件：

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

<hibernate-configuration>

	<session-factory>

		<!-- Database connection settings -->
		<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
		<property name="connection.url">jdbc:mysql://localhost:3306/hibernate_db?characterEncoding=UTF-8</property>
		<property name="connection.username">root</property>
		<property name="connection.password"></property>

		<!-- JDBC connection pool (use the built-in) -->
		<property name="connection.pool_size">1</property>

		<!-- SQL dialect -->
		<property name="dialect">org.hibernate.dialect.MySQLDialect</property>

		<!-- Enable Hibernate's automatic session context management -->
		<property name="current_session_context_class">thread</property>

		<!-- Disable the second-level cache -->
		<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>

		<!-- Echo all executed SQL to stdout -->
		<property name="show_sql">true</property>
		<property name="format_sql">true</property>
		<!-- Drop and re-create the database schema on startup -->
		<property name="hbm2ddl.auto">update</property>

		<mapping resource="com/ethan/domain/User.hbm.xml" />

	</session-factory>

</hibernate-configuration>

User.hbm.xml

<?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="com.ethan.domain">
	<class name="User">
		<id name="id">
			<generator class="native"></generator>
		</id>
		<!-- name unique -->
		<property name="name" unique="true"/>
		<property name="birthday"/>
		
	</class>
</hibernate-mapping>

package com.ethan.domain;

import java.util.Date;

public class User {
	private Integer id;
	private String name;
	private Date birthday;
	public Integer getId() {
		return id;
	}
	public void setId(Integer 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;
	}
	@Override
	public String toString() {
		// TODO Auto-generated method stub
		return "id="+id+"\tname="+name;
	}
}


package com.ethan.dao;

import com.ethan.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);
}


package com.ethan.dao.impl;


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

import com.ethan.dao.UserDao;
import com.ethan.domain.User;
import com.ethan.hibernate.util.HibernateUtil;

public class UserDaoHibernateImpl implements UserDao {

	@Override
	public void saveUser(User user) {
		
	}

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

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

	@Override
	public void updateUser(User user) {

	}

	//效率上有浪费，id传过来再去数据库查得到user对象
	@Override
	public void remove(User user) {
		Session s = null;
		Transaction tx = null;
		try {
			s = HibernateUtil.getSession();
			tx = s.beginTransaction();
			s.delete(user);
			tx.commit();
		} finally {
			if(s!=null) {
				s.close();
			}
		}
	}

}


package com.ethan.hibernate.util;

import java.io.Serializable;

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

public final class HibernateUtil {
	private static SessionFactory sf = null;
	private HibernateUtil(){}
	
	//当虚拟机加载类的时候执行，保证执行一次
	static {
		Configuration cfg = new Configuration();
		cfg.configure();
		
		sf = cfg.buildSessionFactory();
	}

	public static SessionFactory getSessionFactory() {
		return sf;
	}
	
	public static Session getSession() {
		return sf.openSession();
	}
	
	/**
	 * 保存各种对象
	 * @param entity
	 */
	public static void add(Object entity) {
		Session s = null;
		Transaction tx = null;
		try {
			s = HibernateUtil.getSession();
			tx = s.beginTransaction();
			s.save(entity);
			tx.commit();
		} finally {
			if(s!=null) {
				s.close();
			}
		}
	}
	
	public static void update(Object entity) {
		Session s = null;
		Transaction tx = null;
		try {
			s = HibernateUtil.getSession();
			tx = s.beginTransaction();
			s.update(entity);
			tx.commit();
		} finally {
			if(s!=null) {
				s.close();
			}
		}
	}
	
	public static void delete(Object entity) {
		Session s = null;
		Transaction tx = null;
		try {
			s = HibernateUtil.getSession();
			tx = s.beginTransaction();
			s.delete(entity);
			tx.commit();
		} finally {
			if(s!=null) {
				s.close();
			}
		}
	}
	
	public static Object get(Class clazz,Serializable id) {
		Session s = null;
		try {
			s = HibernateUtil.getSession();
			Object obj = s.get(clazz, id);
			return obj;
		} finally {
			if(s!=null) {
				s.close();
			}
		}
	}
}


package com.ethan.hibernate;

import java.util.Date;

import javax.transaction.HeuristicMixedException;
import javax.transaction.HeuristicRollbackException;
import javax.transaction.RollbackException;
import javax.transaction.SystemException;

import org.hibernate.Hibernate;
import org.hibernate.HibernateException;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.Session;

import com.ethan.domain.User;
import com.ethan.hibernate.util.HibernateUtil;

/**
 * sessionFactory--->driverManager
 * session -----> connection
 * @author ETHAN
 *
 */
public class Base {
	private static SessionFactory sf = null;
	public static void main(String args[]) {
		Session s = HibernateUtil.getSession();
		
		//开启事务,jdbc自动提交，hibernate必须手动提交
		
			User user = new User();
			user.setBirthday(new Date());
			user.setName("aaa");
			
			addUser2(user);
		
	}
	
	public static void addUser(User user) {
		Session s = null;
		Transaction tx = null;
		try {
			s = HibernateUtil.getSession();
			tx = s.beginTransaction();
			s.save(user);
			
			//持久态
			user.setName("持久态");
			
			tx.commit();
		} catch (HibernateException e) {
			if(tx!=null) {
				tx.rollback();
			} 
			//必须抛出异常 让上层处理，不要吞没
			throw e;
		} finally {
			if(s!=null) {
				s.close();
			}
		}
		
	}
	
	//如果有异常会抛出，效果同上
	public static void addUser2(User user) {
		Session s = null;
		Transaction tx = null;
		try {
			s = HibernateUtil.getSession();
			tx = s.beginTransaction();
			s.save(user);
			tx.commit();
		} finally {
			if(s!=null) {
				s.close();
			}
		}
		
	}
	
	public static User getUser(int id) {
		Session s = null;
		try {
			s = HibernateUtil.getSession();
			User user = (User) s.get(User.class, id);
			return user;
		} finally {
			if(s!=null) {
				s.close();
			}
		}
	}
	
	public static User loadUser(int id) {
		Session s = null;
		try {
			s = HibernateUtil.getSession();
			//产生代理对象，user永远不会为null
			User user = (User) s.load(User.class, id);
			//懒加载，初始化对象数据
			Hibernate.initialize(user);
			return user;
		} finally {
			if(s!=null) {
				s.close();
			}
		}
	}
}


package com.ethan.hibernate;

import java.util.Date;
import java.util.List;

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

import com.ethan.domain.User;
import com.ethan.hibernate.util.HibernateUtil;

public class HibernateQuery {
	public static void query(String name) {
		Session s = null;
		try {
			s = HibernateUtil.getSession();
//			String hql = "from User as user where user.name=?";
			String hql = "from User as user where user.name=:name";
			Query query = s.createQuery(hql);
			
			//query.setString(0, name);
			//不依赖位置
			query.setString("name", "aaa");
			
			//分页,跨数据库可移植
			query.setFirstResult(0);
			query.setMaxResults(4);
			List<User> list = query.list();
			//唯一结果
			//query.uniqueResult();
			for(User user:list) {
				System.out.println(user);
			}
		} finally {
			if(s!=null) {
				s.close();
			}
		}
	}
	
	public static void cri(String name) {
		Session s = null;
		try {
			s = HibernateUtil.getSession();
			
			Criteria c = s.createCriteria(User.class);
			//c.add(Restrictions.eq("name", name));
			c.add(Restrictions.or(Restrictions.eq("name", name), Restrictions.eq("birthday", new Date())));
			
			c.setFirstResult(0);
			c.setMaxResults(4);
			
			List<User> list = c.list();
			//唯一结果
			//c.uniqueResult();
			for(User user:list) {
				System.out.println(user);
			}
		} finally {
			if(s!=null) {
				s.close();
			}
		}
	}
}

测试类： 

package com.ethan.test;

import static org.junit.Assert.*;

import java.util.Date;

import org.junit.Test;

import com.ethan.domain.User;
import com.ethan.hibernate.Base;

public class TestHibernate {

	
	@Test
	public void getUser() {
		System.out.println(Base.getUser(6));
	}

	@Test
	public void loadUser() {
		System.out.println(Base.loadUser(6));
	}
	
	@Test
	public void addUser() {
		User user = new User();
		user.setBirthday(new Date());
		user.setName("aaa");
		Base.addUser(user);
	}
}


package com.ethan.test;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.junit.Test;

import com.ethan.domain.User;
import com.ethan.hibernate.HibernateQuery;
import com.ethan.hibernate.util.HibernateUtil;

public class QueryTest {

	@Test
	public void query() {
		HibernateQuery.query("aaa");
	}

	@Test
	public void cri() {
		HibernateQuery.cri("aaa");
	}
}

hibernate3.5.3 jar包下载地址：http://115.com/file/dp5ki6tx#hibernate3.5.3.zip

EthanQ
关注
专栏目录
hibernate3.5.3
09-02
hibernate 3.5 最终版本，修复了以前hibernate3.4的漏洞，是目前最稳定的版本
hibernate3.5.3源码
07-26
hibernate3.5.3源码 hibernate3.5.3源码 hibernate3.5.3源码
spring3.0.5_hibernate3.5.3_struts2.2.1整合jar包
11-02
标题中的"spring3.0.5_hibernate3.5.3_struts2.2.1整合jar包"指的是一个集合了Spring 3.0.5、Hibernate 3.5.3和Struts 2.2.1框架的整合包。这个资源是经过作者亲自测试的，被认为是最优的选择。它不仅提供了这三个...
spring3.0.5_hibernate3.5.3_struts2.2.1整合jar包.rar
11-03
经过本人一天调试通过，ssh全部是从...解决了最新hibernate3.5自带annotation与原版本的冲突问题，解决基本上能遇到的ClassNotFoundException 这个资源纯手工调试，非copy。人格担保，此jar包绝对是同类中最好资源！
Spring 之 编码实现 @Resource注解属性注入
ETHAN IN IT
03-01 3023
下边只给出 key code: package com.ethan.annotation; import java.lang.annotation.ElementType; import java.lang.annotation.Retention; import java.lang.annotation.RetentionPolicy; import java.lang.annotation
SSH 报异常Cannot locate the chosen ObjectFactory implementation: spring
ETHAN IN IT
03-11 2781
struts2 和 spring2.5整合： 报异常：Cannot locate the chosen ObjectFactory implementation: spring 原因是：没有加入struts2-spring-plugin-2.1.8.1.jar
J2EE 之 邮箱激活示例(二)
ETHAN IN IT
02-22 2141
修改信息： package com.ethan.accountactivate.servlets; import java.io.IOException; import java.io.PrintWriter; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import ja
ibatis2.3.4 学习笔记（CRUD)
ETHAN IN IT
03-06 2045
SqlMap.properties: 数据库的配置信息 driver=com.mysql.jdbc.Driver url=jdbc\:mysql\://localhost/ibatis_db?characterEncoding\=UTF-8 username=root password=SqlMapConfig.xml <!DOCTYPE sqlMapConfig PUBLIC "-//ib
java 之 权限模块
ETHAN IN IT
03-10 2012
sql: -- phpMyAdmin SQL Dump -- version 3.3.9 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2012 年 03 月 10 日 09:14 -- 服务器版本: 5.5.8 -- PHP 版本: 5.3.5 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
J2EE 之 邮箱激活示例(一)
ETHAN IN IT
02-22 1204
直接上代码了： com.ethan.accountactivate.domain package com.ethan.accountactivate.domain; public class User { private int id; private String name; private String password; private String email; p
java 之 编码实现Filter学习示例
ETHAN IN IT
03-09 1022
public interface Filter { void doFilter(Request request,Response response,FilterChain chain); } public class HTMLFilter implements Filter { @Override public void doFilter(Request request, Response
struts2.1.8 Hibernate3.5.3 Spring2.5整合需要的jar包
ETHAN IN IT
03-11 904
struts2 学习笔记（一）
ETHAN IN IT
02-28 807
比较零碎： struts2读取到struts.xml的内容后，以javabean形式存放在内存中， 以后struts2对用户的每次请求处理将使用内存中的数据，而不是每次都读取 struts.xml文件 StrutsPrepareAndExecuteFilter的init()方法中将会读取类路径下默认 的配置文件struts.xml完成初始化操作。 包可以通过abstra
spring2.5 之 编码实现 IOC和依赖注入
ETHAN IN IT
02-29 741
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://w
struts2 输入校验
ETHAN IN IT
02-28 739
1.使用手工编写代码校验：package com.ethan.action; import java.util.regex.Pattern; import com.opensymphony.xwork2.ActionContext; import com.opensymphony.xwork2.ActionSupport; public class PersonAction extends
Struts1.x/2.x 与 Spring集成方式
ETHAN IN IT
10-10 730
struts1.x与spring集成方式 方式一:Action交给spring管理,将业务类注入action struts配置: forward name="success"path="/result.jsp"/> /action spring配置: !--这里SearchAction继承了DelegatingActionProxy--
Hibernate3.5.3 之 多对多 关联映射
ETHAN IN IT
03-10 680
package com.ethan.domain; import java.util.HashSet; import java.util.Set; public class Student { private Integer id; private String name; private Set teachers; public Integer getId() { return
Hibernate3.5.3 学习笔记（一)
ETHAN IN IT
03-07 676
hbm2ddl.auto: create-drop:启动重建，程序关闭后删除表 create:启动重建，但关闭后不会删除 update:跟新表结构 validate:映射文件和表结构字段是否一致，否则不更新，报错 mysql: show engines;#查看引擎# MyISAM:不支持事务和外键 /etc目录下有配置文件： C:\Users\ETHAN\dev\hib
Hibernate 3.5.3中文版：入门与配置详解
Hibernate 3.5.3用户手册中文版是一份详尽的文档，它介绍了如何在Java应用中使用Hibernate进行对象/关系型数据库映射。该手册主要分为四个部分： 1. **教程**：以实践为导向，从创建第一个Hibernate应用程序开始，...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值