第13章 Hibernate配置和会话【首页】杜老师

0. 创建项目

(1) 创建项目01JavaWeb13, 01学号 web project, Java EE 5.0 复制mysql-connector-java-5.1.22-bin.jar共1个jar包到WEB-INF\lib

(2) 准备数据库javaweb13、数据表(student、tb_employee、vip)和数据，其中13表示第13章

create database `javaweb13` default character set gbk collate gbk_chinese_ci;
use javaweb13;

create table `student` (
  `id` varchar(32) not null default '' comment '学号',
  `name` varchar(20) default null comment '姓名',
  `subject` varchar(10) default null comment '课程',
  `result` double default null comment '分数',
  primary key  (`id`)
) engine=innodb default charset=gbk row_format=compact;
insert into `student` values('01','杜老师','大学英语',88);
insert into `student` values('02','拉毛才旦','大学英语',89);
insert into `student` values('05','李莉','大学英语',86);
insert into `student` values('07','廖菲','大学英语',90);
insert into `student` values('28','满娅','大学英语',78);

create table tb_employee
(  employeeid varchar(36) not null primary key comment '员工编号', 
   employeename varchar(36) not null comment '员工姓名',
   employeesex boolean  comment '性别',
   employeebirth date  comment '生日',
   employeephone varchar(11) comment '手机号码',
   employeeplace varchar(20) comment '住址',
   jointime date comment '进入公司日期' 
)engine=innodb default charset=gbk ;
insert into `tb_employee` values('01','杜老师',1,'1963-11-30','13903510001','太原','2014-11-28');
insert into `tb_employee` values('02','拉毛才旦',1,'1994-11-30','13903510002','拉萨','2014-11-29');
insert into `tb_employee` values('05','李莉',0,'1993-11-30','13903510003','北京','2014-11-20');
insert into `tb_employee` values('07','廖菲',0,'1992-11-30','13903510004','上海','2014-11-22');
insert into `tb_employee` values('28','满娅',0,'1995-11-30','13903510005','广州','2014-11-30');

create table `vip` (
  `vipid` varchar(36) not null default '' comment 'vip编号',
  `name` varchar(10) not null default '' comment '姓名',
  `age` int(11) default null comment '年龄',
  `professional` varchar(10) not null default '' comment '职业',
  `jointime` date default null comment '注册时间',
  primary key  (`vipid`)
) engine=innodb default charset=gbk row_format=compact;
insert into `vip` values('01','杜老师',51,'教师','2014-11-28');
insert into `vip` values('02','拉毛才旦',21,'学生','2014-11-29');
insert into `vip` values('05','李莉',20,'班长','2014-11-20');
insert into `vip` values('07','廖菲',19,'书记','2014-11-22');
insert into `vip` values('28','满娅',18,'学生','2014-11-30');

(3) 创建首页index.jsp

Window --> Openerspective --> MyEclipse Database Explore，Window --> Show view --> DB Browse，右击 new

本章重点

作者心得

1. 配置Hibernate

1.1 使用XML文件配置Hibernate

知识点：文件名 src/hibernate.cfg.xml, 主要内容：根节点，根节点之子节点只有一个，主要内容定义如下。

操作：在src创建hibernate.cfg.xml

1.2 使用资源文件配置Hibernate

知识点：
(1) src/hibernate.properties资源文件只配置属性，不能配置orm映射文件;
(2) src/hibernate.cfg.xml和src/hibernate.properties可同时使用。当同时使用两种类型的配置文件时，XML配置文件中的设置会覆盖properties配置文件的相同的属性。
(3) 一般建议优先使用hibernate.cfg.xml配置文件，hibernate.cfg.xml可配置orm映射文件。

文件名：src/hibernate.properties的例题

1.3 代码动态配置Hibernate

需要运行时动态配置Hibernate时，可以下列java源程序动态配置Hibernate

1.4 手动创建数据库连接(备忘)

Window --> Open erspective --> MyEclipse Database Explore，Window --> Show view --> DB Browse，右击 new

1.5 手动创建Hibernate配置文件、Hibernate会话工厂类(备忘)

右击项目 --> MyEclipse --> Add Hibernate ...

1.6 手动反向创建数据表的.hbm.xml 映像文件(备忘)

在DB Browse，右击[数据表] --> Hibernate Reverse Engineeing ...

2. 配置映射文件

2.1 创建实体类及其映射配置文件

(1) 创建实体类: private属性及其set/get方法

在cn.duzhaojiang.model，创建Student01.java实体类，实体类文件夹：bean,model,po,entity

(2) ORM映射配置文件(.hbm.xml)

在cn.duzhaojiang.model, 创建Student01.java的映射配置文件 Student01.hbm.xml

(3) 查询数据测试类(含main方法)

创建cn.duzhaojiang.test，参照QueryTest.java创建QueryStudentTest01.java测试类，右键该文件-->Run As -->Java Application测试

(4) 添加数据测试

创建cn.duzhaojiang.test，参照InsertTest.java创建InsertStudentTest01.java测试类，右键该文件-->Run As -->Java Application测试

2.2 .映射配置文件知识点

(1) hibernate-mapping元素

(2) class元素

(3) id元素

(4) property元素

2.3 创建Employee实体类及其对象关系映射文件(备忘：训练完毕为下一练习要删除)

src\cn.duzhaojiang.model\Employee01.java

package cn.duzhaojiang.model;

public class Employee01 {
	private String employeeID;			//employeeID属性，实体类标识
	private String employeeName;		//职员姓名
	private boolean employeeSex;		//职员性别
	private Date employeeBirth;			//出生日期
	private String employeePhone;		//手机号码
	private String employeePlace;		//居住地址
	private Date joinTime;					//进公司时间
	
	public String getEmployeeID() {		//获得employeeID属性值
		return employeeID;
	}
	public void setEmployeeID(String employeeID) {//设置employeeID属性值
		this.employeeID = employeeID;
	}

public String getEmployeeName() {
		return employeeName;
	}
	public void setEmployeeName(String employeeName) {
		this.employeeName = employeeName;
	}
	public boolean isEmployeeSex() {
		return employeeSex;
	}
	public void setEmployeeSex(boolean employeeSex) {
		this.employeeSex = employeeSex;
	}
	public Date getEmployeeBirth() {
		return employeeBirth;
	}
	public void setEmployeeBirth(Date employeeBirth) {
		this.employeeBirth = employeeBirth;
	}
	public String getEmployeePhone() {
		return employeePhone;
	}
	public void setEmployeePhone(String employeePhone) {
		this.employeePhone = employeePhone;
	}
	public String getEmployeePlace() {
		return employeePlace;
	}
	public void setEmployeePlace(String employeePlace) {
		this.employeePlace = employeePlace;
	}
	public Date getJoinTime() {
		return joinTime;
	}
	public void setJoinTime(Date joinTime) {
		this.joinTime = joinTime;
	}
}

在cn.duzhaojiang.model, 创建Employee01.java的映射配置文件 Employee01.hbm.xml

3. 使用Annotations配置映射

3.1 在实体类中注解映射信息

(1) 在src\cn.duzhaojiang.model创建带映射注解信息的实体类Employee01.java，并在src\hibernate.cfg.xml增加<mapping class="cn.duzhaojiang.model.Employee01" />

package cn.duzhaojiang.model;

import java.util.Date;
import javax.persistence.Entity;
import javax.persistence.Table;
import javax.persistence.Id;
import javax.persistence.Column;
import javax.persistence.GeneratedValue;

import org.hibernate.annotations.GenericGenerator;
@Entity
@Table(name = "tb_employee", catalog = "javaweb13")
public class Employee01 {
	@Id
	@GenericGenerator(name="myuuid",strategy="uuid")
	@GeneratedValue(generator="myuuid")
	private String employeeID;			//employeeID属性，实体类标识
	@Column(name="employeeName")
	private String employeeName;		//employeeName属性，职员姓名
	@Column(name="employeeSex")
	private boolean employeeSex;		//employeeSex属性，职员性别
	@Column(name="employeeBirth")
	private Date employeeBirth;			//employeeBirth属性，职员出生日期
	@Column(name="employeePhone")
	private String employeePhone;		//employeePhone属性，职员手机号码
	@Column(name="employeePlace")
	private String employeePlace;		//employeePlace属性，职员居住地址
	@Column(name="joinTime")
	private Date joinTime;				//joinTime属性，职员进公司时间
	
	public String getEmployeeID() {		//获得employeeID属性值
		return employeeID;
	}
	public void setEmployeeID(String employeeID) {//设置employeeID属性值
		this.employeeID = employeeID;
	}

(2) 在cn.duzhaojiang.hibernate，定义AnnotationSessionFactory.java类用来获得Session对象

package cn.duzhaojiang.hibernate;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.cfg.AnnotationConfiguration;

public class AnnotationSessionFactory {
	private static String CONFIG_FILE_LOCATION = "/hibernate.cfg.xml";// 指定配置文件路径
	private static final ThreadLocal<Session> threadLocal = new ThreadLocal<Session>();// 定义ThreadLocal对象
	private static AnnotationConfiguration configuration = new AnnotationConfiguration();// 定义Configuration对象
	private static org.hibernate.SessionFactory sessionFactory;// 定义SessionFactory对象
	private static String configFile = CONFIG_FILE_LOCATION;

static {
		try {
			configuration.configure(configFile);// 读取配置文件
			sessionFactory = configuration.buildSessionFactory();// 根据配置文件创建sessionFactory对象
		} catch (Exception e) {
			System.err.println("%%%% Error Creating SessionFactory %%%%");
			e.printStackTrace();
		}
	}

private AnnotationSessionFactory() {
	}

public static Session getSession() throws HibernateException {
		Session session = (Session) threadLocal.get();// 从ThreadLocal对象中获得Session对象

if (session == null || !session.isOpen()) {// 判断获得的Session对象是否为空或者没有打开
			if (sessionFactory == null) {// 如果没有创建SessionFactory对象，则首先创建
				rebuildSessionFactory();
			}
			session = (sessionFactory != null) ? sessionFactory.openSession()
					: null;// 如果SessionFactory对象不为空，则调用其openSession方法创建session对象
			threadLocal.set(session);// 在ThreadLocal对象中保存该Session对象
		}
		return session;
	}

public static void rebuildSessionFactory() {
		try {
			configuration.configure(configFile);// 读取配置文件
			sessionFactory = configuration.buildSessionFactory();// 根据配置文件创建sessionFactory对象
		} catch (Exception e) {
			System.err.println("%%%% Error Creating SessionFactory %%%%");
			e.printStackTrace();
		}
	}

public static void closeSession() throws HibernateException {
		Session session = (Session) threadLocal.get();// 从ThreadLocal对象中获得Session对象
		threadLocal.set(null);// 将当前线程Session对象从ThreadLocal对象中移除

if (session != null) {
			session.close();
		}
	}

public static org.hibernate.SessionFactory getSessionFactory() {// 取得SessionFactory对象
		return sessionFactory;
	}

public static void setConfigFile(String configFile) {// 设置新的配置文件
		AnnotationSessionFactory.configFile = configFile;
		sessionFactory = null;
	}

public static AnnotationConfiguration getConfiguration() {// 获得Configuration对象
		return configuration;
	}
}

(3) 测试Annotations注释是否成功完成映射

创建src\cn.duzhaojiang.test， TestAnnotation01.java，右键该文件-->Run As -->Java Application测试

package cn.duzhaojiang.test;

import java.util.Iterator;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import cn.duzhaojiang.hibernate.AnnotationSessionFactory;
import cn.duzhaojiang.model.Employee01;
import cn.duzhaojiang.model.Student01;

public class TestAnnotation01 {
	public static void main(String[] args) {
		Session session = AnnotationSessionFactory.getSession();//获得Session对象
		Query query = session.createQuery("from Employee01");//查询Employee
		List list = query.list();//查询结果保存到list中
		Iterator iter = list.iterator();//获得list的内部迭代器
		Employee01 employee = null;
		System.out.println("职员编号\t职员姓名\t职员性别\t职员出生日期\t\t职员手机号码" +
				"\t职员居住地址\t职员进公司时间");
		while(iter.hasNext()) {		//遍历list
			employee = (Employee01) iter.next();
			System.out.println(employee.getEmployeeID()+"\t"
				+ employee.getEmployeeName()+"\t"+(employee.isEmployeeSex()?"男":"女")+"\t" 
				+ employee.getEmployeeBirth()+"\t" + employee.getEmployeePhone()+"\t"
				+ employee.getEmployeePlace()+"\t\t"+ employee.getJoinTime()
			);
		}
		AnnotationSessionFactory.closeSession();//关闭Session对象
	}
}

(4) 创建[查询所有员工]页面文件WebRoot\ShowEmployeeList01.jsp

<%@page language="java" pageEncoding="gbk"%>
<%@page import="java.util.List"%>
<%@page import="org.hibernate.Query"%>
<%@page import="org.hibernate.Session"%>
<%@page import="cn.duzhaojiang.hibernate.AnnotationSessionFactory"%>
<%@page import="cn.duzhaojiang.model.Employee01"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<html>
<head>
	<title>员工列表</title>  
</head>
<body>
	<%
		Session hsession = AnnotationSessionFactory.getSession();// 获得Session对象
		Query query = hsession.createQuery("from Employee01");// 查询
		List<Employee01> empList = query.list();// 查询结果保存到list中

//将所有记录保存到page范围  
		pageContext.setAttribute("empList",empList);
	%>
	<h1>员工列表</h1>
	<hr />
	<table border="1">
		<tr>
			<td>职员编号</td>
			<td>职员姓名</td>
			<td>职员性别</td>
			<td>出生日期</td>
			<td>手机号码</td>
			<td>居住地址</td>
			<td>入职时间</td>
			<td>操作</td>
		</tr>
		<c:forEach var="emp" items="${pageScope.empList}"><%-- 循环输出信息 --%>
			<tr>
				<td>${emp.employeeID }</td>
				<td>${emp.employeeName }</td>
				<td>${emp.employeeSex }</td>
				<td><fmt:formatDate value="${emp.employeeBirth}" type="date"/></td>
				<td>${emp.employeePhone }</td>
				<td>${emp.employeePlace }</td>
				<td><fmt:formatDate value="${emp.joinTime}" type="date"/></td>
				<td><a href="DelEmployee01.jsp?employeeID=${emp.employeeID }">删除</a></td>
			</tr>
		</c:forEach>
	</table>
	<hr/>
	<a href="EmployeeForm01.jsp">添加员工信息</a>
	<a href="/01JavaWeb13">返回本章目录</a>
</body>
</html>

(5) 创建[添加员工信息]页面文件WebRoot\EmployeeForm01.jsp

(6) 创建[添加员工处理]页面文件WebRoot\AddEmployee01.jsp

<%@page language="java" pageEncoding="gbk"%>
<%@page import="java.util.List"%>
<%@page import="java.util.Date"%>
<%@page import="org.hibernate.Transaction"%>
<%@page import="org.hibernate.Session"%>
<%@page import="cn.duzhaojiang.hibernate.AnnotationSessionFactory"%>
<%@page import="cn.duzhaojiang.model.Employee01"%>
<html>
<head>
	<title>添加员工处理</title>	
</head>
<body>
	<%
		request.setCharacterEncoding("gbk");		//设置参数编码格式
	%>
	<jsp:useBean id="emp" scope="page" class="cn.duzhaojiang.model.Employee01"></jsp:useBean>		
	<jsp:setProperty name="emp"  property="*"/><%-- 设置JavaBean实例化对象的属性--%>
	<%
		Session hsession = AnnotationSessionFactory.getSession();// 获得Session对象
		Transaction transaction = null;// 声明一个事务对象
		try {
			transaction = hsession.beginTransaction();// 开启事务
			hsession.save(emp);// 保存信息
			transaction.commit();// 提交事务
			System.out.println("添加记录成功!");
		} catch (Exception ex) {
			ex.printStackTrace();
			transaction.rollback();// 事务回滚
		}
		AnnotationSessionFactory.closeSession();		//通过DAO工厂类获得DAO实现类实例
		response.sendRedirect("ShowVipList01.jsp");
	%>
</body>
</html>

(7) 创建[删除员工处理]页面文件WebRoot\DelEmployee01.jsp

3.2 在实体类中注解映射信息知识点

3.3 Annotation注解映射和.hbm.xml映射混合定义存在的问题

(1) 在cn.duzhaojiang.test，右击QueryStudentTest01.java测试类-->Run As -->Java Application测试将发生错误提示；将QueryStudentTest01.java复制粘贴为QueryStudentTest2_01.java，将QueryStudentTest2_01.java文件中HibernateSessionFactory --> AnnotationSessionFactory, 右键该文件-->Run As -->Java Application测试

(2) 在cn.duzhaojiang.test，右击InsertStudentTest01.java测试类-->Run As -->Java Application测试将发生错误提示；将InsertStudentTest01.java复制粘贴为InsertStudentTest2_01.java，将InsertStudentTest2_01.java文件中HibernateSessionFactory --> AnnotationSessionFactory, 右键该文件-->Run As -->Java Application测试

(3) 查询所有学生成绩信息，WebRoot/ShowStudentList01.jsp

<%@page language="java" pageEncoding="gbk"%>
<%@page import="java.util.List"%>
<%@page import="org.hibernate.Query"%>
<%@page import="org.hibernate.Session"%>
<%@page import="cn.duzhaojiang.hibernate.AnnotationSessionFactory"%>
<%@page import="cn.duzhaojiang.model.Student01"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<html>
<head>
	<title>学生列表</title>  
</head>
<body>
	<%
		Session hsession = AnnotationSessionFactory.getSession();// 获得Session对象
		Query query = hsession.createQuery("from Student01");// 查询student表
		List<Student01> studentList = query.list();// 查询结果保存到list中

//将所有记录保存到page范围  
		pageContext.setAttribute("studentList",studentList);
	%>
	<h1>学生列表</h1>
	<hr />
	<table border="1">
		<tr>
			<td>学号</td>
			<td>姓名</td>
			<td>课程名称</td>
			<td>成绩</td>
		</tr>
		<c:forEach var="student" items="${pageScope.studentList}"><%-- 循环输出学生信息 --%>
			<tr>
				<td>${student.id }</td>
				<td>${student.name }</td>
				<td>${student.subject }</td>
				<td>${student.result }</td>
			</tr>
		</c:forEach>
	</table>
	<hr/>
	<a href="StudentForm01.jsp">添加学生成绩</a>
	<a href="/01JavaWeb13">返回本章目录</a>
</body>
</html>

(4) 添加学生成绩页面，WebRoot/StudentForm01.jsp

(5) 添加学生成绩处理，WebRoot/AddStudent01.jsp

<%@page language="java" pageEncoding="gbk"%>
<%@page import="java.util.List"%>
<%@page import="org.hibernate.Transaction"%>
<%@page import="org.hibernate.Session"%>
<%@page import="cn.duzhaojiang.model.Student01"%>
<%@page import="cn.duzhaojiang.hibernate.AnnotationSessionFactory;"%>
<html>
<head>
	<title>添加学生处理</title>	
</head>
<body>
	<%
		request.setCharacterEncoding("gbk");		//设置参数编码格式
	%>
	<jsp:useBean id="stu" scope="page" class="cn.duzhaojiang.model.Student01"></jsp:useBean>		
	<jsp:setProperty name="stu"  property="*"/><%-- 设置JavaBean实例化对象的属性--%>
	<%
		Session hsession = AnnotationSessionFactory.getSession();// 获得Session对象
		Transaction transaction = null;// 声明一个事务对象
		try {
			transaction = hsession.beginTransaction();// 开启事务
			hsession.save(stu);// 保存学生信息
			transaction.commit();// 提交事务
			System.out.println("添加记录成功!");
		} catch (Exception ex) {
			ex.printStackTrace();
			transaction.rollback();// 事务回滚
		}
		AnnotationSessionFactory.closeSession();		//通过DAO工厂类获得DAO实现类实例
		response.sendRedirect("ShowStudentList01.jsp");
	%>
</body>
</html>

(6) 查询分数80分以上的学生成绩，WebRoot/ShowStudentList2_01.jsp

<%@page language="java" pageEncoding="gbk"%>
<%@page import="java.util.List"%>
<%@page import="org.hibernate.Query"%>
<%@page import="org.hibernate.Session"%>
<%@page import="cn.duzhaojiang.hibernate.AnnotationSessionFactory"%>
<%@page import="cn.duzhaojiang.model.Student01"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<html>
<head>
	<title>学生列表</title>  
</head>
<body>
	<%
		Session hsession = AnnotationSessionFactory.getSession();// 获得Session对象
		Query query = hsession.createQuery("from Student01 as stu where stu.result > 80");// 查询student表
		List<Student01> studentList = query.list();// 查询结果保存到list中

//将所有记录保存到page范围  
		pageContext.setAttribute("studentList",studentList);
	%>
	<h1>学生列表</h1>
	<hr />
	<table border="1">
		<tr>
			<td>学号</td>
			<td>姓名</td>
			<td>课程名称</td>
			<td>成绩</td>
		</tr>
		<c:forEach var="student" items="${pageScope.studentList}"><%-- 循环输出学生信息 --%>
			<tr>
				<td>${student.id }</td>
				<td>${student.name }</td>
				<td>${student.subject }</td>
				<td>${student.result }</td>
			</tr>
		</c:forEach>
	</table>
	<hr/>
	<a href="/01JavaWeb13">返回本章目录</a>
</body>
</html>

4. 会话(Session)的应用

4.1 Hibernate对象状态

三种状态和Session方法：save, saveOrUpdate, delete, load, get, resresh, setFlushMode, isDirty、clear、flush、evict

三种状态
	临时、瞬时状态(Transient)：由new创建并未与Session关联的对象。
	持久状态(Persistent)：持久状态的对象在数据库中存在相应的记录，并和Session缓存中一个session实例对象相关联，且拥有一个持久化标识。
	游离、脱管状态(Detached)：已经被持久化，但不再处于Session的缓存中。
save方法(插入数据)
	public Seralizble save(Object object) throws HibernateException;
	public Seralizble save(String entityName, Object object) throws HibernateException;
saveOrUpdate方法(插入或更新数据)
	public void saveOrUpdate(Object object) throws HibernateException;
	public void saveOrUpdate(String entityName, Object object) throws HibernateException;
delete方法(删除数据)
	public void delete(Object object) throws HibernateException;
	public void delete(String entityName, Object object) throws HibernateException;
load方法(根据id在装载数据库数据)
	public Object load(Class thClass, Seralizble id) throws HibernateException;
	public Object load(String entityName, Seralizble id) throws HibernateException;
	public void load(Object object, Seralizble id) throws HibernateException;
	public Object load(String entityName, Seralizble id, LockMode lockMode) throws HibernateException;
	public Object load(Class thClass, Seralizble id, LockMode lockMode) throws HibernateException;
		id: 标识值需Seralizble序列化
get方法(根据id在获取数据库数据，无需事先确定获取id对象是否存在)
	public Object get(Class thClass, Seralizble id) throws HibernateException;
	public Object get(String entityName, Seralizble id) throws HibernateException;
	public Object get(String entityName, Seralizble id, LockMode lockMode) throws HibernateException;
	public Object get(Class thClass, Seralizble id, LockMode lockMode) throws HibernateException;
resresh方法(从数据库中重载或刷新持久化对象)
	public Seralizble resresh(Object object) throws HibernateException;
	public Seralizble resresh(Object object, LockMode lockMode) throws HibernateException;
setFlushMode/getFlushMode方法(设置或获取事务提交模式)
	public void setFlushMode(Object object) throws HibernateException;
	public FlushMode getFlushMode();
	FlushMode：FlushMode.MANUAL(手动, 运行flush才提交), FlushMode.COMMIT(提交更新模式), FlushMode.AUTO(自动, 默认模式)
isDirty、clear、flush、evict方法
	session.isDirty();  //判断是否是脏数据----没有持久化的数据
	session.clear();  //清除缓存
	session.flush();  //强制进行从内存到数据库的同步
	session.evict(obj);  //会把指定的缓冲对象进行清除

4.2 使用save方法持久化对象

在cn.duzhaojiang.test包，创建[save方法持久化对象]测试类TestSave01.java，右键该文件-->Run As -->Java Application

4.3 使用saveOrUpdate方法持久化对象

4.4 使用load方法装载对象

在cn.duzhaojiang.test包，创建[load方法装载对象]测试类TestLoad01.java，右键该文件-->Run As -->Java Application

package cn.duzhaojiang.test;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Iterator;
import java.util.List;
import org.hibernate.Session;
import cn.duzhaojiang.hibernate.AnnotationSessionFactory;
import cn.duzhaojiang.model.Employee01;

public class TestLoad01 {
	public static void main(String[] args) throws ParseException {
		Session session = AnnotationSessionFactory.getSession();//获得Session对象
		Object obj = session.load(								//装载对象
				cn.duzhaojiang.model.Employee01.class, 
				new String("02"));
		Employee01 employee = (Employee01) obj;
		System.out.println("职员编号：" + employee.getEmployeeID());
		System.out.println("职员姓名：" + employee.getEmployeeName());
		System.out.println("职员性别：" + (employee.isEmployeeSex()?"男":"女"));
		System.out.println("职员出生日期：" + employee.getEmployeeBirth());
		System.out.println("职员手机号码：" + employee.getEmployeePhone());
		System.out.println("职员居住地址：" + employee.getEmployeePlace());
		System.out.println("职员进公司时间：" + employee.getJoinTime());
		AnnotationSessionFactory.closeSession();//关闭Session对象
	}
}

4.5 使用get方法装载对象

4.6 使用refresh方法刷新对象

在cn.duzhaojiang.test包，创建[refresh方法刷新对象]测试类TestRefresh01.java，右键该文件-->Run As -->Java Application

4.7 使用setFlushMode方法设置更新模式

4.8 使用isDirty方法判断数据是否一致

在cn.duzhaojiang.test包，创建[使用isDirty方法判断数据是否一致]测试类TestIsDirty01.java，右键该文件-->Run As -->Java Application

package cn.duzhaojiang.test;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Iterator;
import java.util.List;
import org.hibernate.Session;
import org.hibernate.Transaction;
import cn.duzhaojiang.hibernate.AnnotationSessionFactory;
import cn.duzhaojiang.model.Employee01;

public class TestIsDirty01 {
	public static void main(String[] args) throws ParseException {
		Session session = AnnotationSessionFactory.getSession();//获得Session对象
		Object obj = session.load(								//装载对象
				cn.duzhaojiang.model.Employee01.class, 
				new String("02"));
		Employee01 employee = (Employee01) obj;
		employee.setEmployeeName("张鲁");
		System.out.println("当前持久对象和数据库中数据是否不同：" + session.isDirty());
		Transaction transaction = null;							//声明事务
		transaction=session.beginTransaction();					//开启事务
		transaction.commit();									//提交事务
		System.out.println("当前持久对象和数据库中数据是否不同：" + session.isDirty());
		AnnotationSessionFactory.closeSession();//关闭Session对象
	}
}

4.9 使用delete方法删除记录

在cn.duzhaojiang.test包，创建[使用delete方法删除记录]测试类TestDelete01.java，右键该文件-->Run As -->Java Application

package cn.duzhaojiang.test;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Iterator;
import java.util.List;
import org.hibernate.Session;
import org.hibernate.Transaction;
import cn.duzhaojiang.hibernate.AnnotationSessionFactory;

public class TestDelete01 {
	public static void main(String[] args) throws ParseException {
		Session session = AnnotationSessionFactory.getSession();//获得Session对象
		Object obj1 = session.get(								//装载对象
				cn.duzhaojiang.model.Employee01.class, 
				new String("01"));
		System.out.println("持久对象是否为空：" + (obj1 == null));
		Transaction transaction = null;							//声明事务
		transaction=session.beginTransaction();					//开启事务
		session.delete(obj1);
		transaction.commit();									//提交事务
		Object obj2 = session.get(								//装载对象
				cn.duzhaojiang.model.Employee01.class, 
				new String("01"));
		System.out.println("持久对象是否为空：" + (obj2 == null));
		AnnotationSessionFactory.closeSession();//关闭Session对象
	}
}

实训模拟商场VIP系统

(1) 创建实体类VIP01.java

在cn.duzhaojiang.model, 创建带映射注解的VIP01.java, 其中01代表学号

package cn.duzhaojiang.model;

import java.util.Date;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;
import org.hibernate.annotations.GenericGenerator;

@Entity
@Table(name = "vip", catalog = "javaweb13")
public class VIP01 {
	@Id
	@GenericGenerator(name = "myuuid", strategy = "uuid")
	@GeneratedValue(generator = "myuuid")
	private String vipId; // VIP编号
	@Column(name = "name")
	private String name; // 姓名
	@Column(name = "age")
	private int age; // 年龄
	@Column(name = "professional")
	private String professional;// 职业
	@Column(name = "joinTime")
	private Date joinTime; // 注册时间

public String getVipId() {
		return vipId;
	}
	public void setVipId(String vipId) {
		this.vipId = vipId;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}
	public String getProfessional() {
		return professional;
	}
	public void setProfessional(String professional) {
		this.professional = professional;
	}
	public Date getJoinTime() {
		return joinTime;
	}
	public void setJoinTime(Date joinTime) {
		this.joinTime = joinTime;
	}
}

(2) 创建测试类VIPMain01.java

在cn.duzhaojiang.test, 创建带映射注解的VIP01.java, 其中01代表学号

package cn.duzhaojiang.test;

import java.util.Date;
import java.util.Scanner;
import org.hibernate.Session;
import org.hibernate.Transaction;
import cn.duzhaojiang.hibernate.AnnotationSessionFactory;
import cn.duzhaojiang.model.VIP01;

public class VIPMain01 {
	public static void main(String[] args) {
		System.out.println("------------------------");
		System.out.println("欢迎进行鸿鹏商城VIP消费信息");
		System.out.println("\t1.注册VIP");
		System.out.println("\t2.更新VIP");
		System.out.println("\t3.删除VIP");
		System.out.println("\t4.查询VIP");
		System.out.println("------------------------");
		System.out.print("请选择操作序号...");
		Scanner scanner = new Scanner(System.in);
		int oper = scanner.nextInt();
		Session session = AnnotationSessionFactory.getSession();
		if(oper == 1) {							//如果选择注册VIP
			System.out.print("请输入VIP姓名：");
			String name = scanner.next();
			System.out.print("请输入VIP年龄：");
			int age = scanner.nextInt();
			System.out.print("请输入VIP职业：");
			String professional = scanner.next();
			VIP01 vip = new VIP01();
			vip.setName(name);
			vip.setJoinTime(new Date());
			vip.setAge(age);
			vip.setProfessional(professional);
			Transaction transaction = null;			//声明事务
			transaction=session.beginTransaction();	//开启事务
			session.save(vip);						//持久化对象
			transaction.commit();					//提交事务
			AnnotationSessionFactory.closeSession();//关闭Session
			System.out.println("注册VIP记录成功!");
		}else if(oper == 2) {						//如果选择更新VIP
			System.out.print("请输入VIP编号：");
			String vipID = scanner.next();
			Object obj = session.get(cn.duzhaojiang.model.VIP01.class, vipID);
			System.out.print("请输入VIP姓名：");
			String name = scanner.next();
			System.out.print("请输入VIP年龄：");
			int age = scanner.nextInt();
			System.out.print("请输入VIP职业：");
			String professional = scanner.next();
			VIP01 vip = (VIP01)obj;
			vip.setName(name);
			vip.setAge(age);
			vip.setProfessional(professional);
			Transaction transaction = null;			//声明事务
			transaction=session.beginTransaction();	//开启事务
			session.update(vip);
			transaction.commit();					//提交事务
			AnnotationSessionFactory.closeSession();//关闭Session
			System.out.println("更新VIP记录成功!");
		}else if(oper == 3) {						//如果选择删除VIP
			System.out.print("请输入VIP编号：");
			String vipID = scanner.next();
			Object obj = session.get(cn.duzhaojiang.model.VIP01.class, vipID);
			Transaction transaction = null;			//声明事务
			transaction=session.beginTransaction();	//开启事务
			session.delete(obj);
			transaction.commit();					//提交事务
			AnnotationSessionFactory.closeSession();//关闭Session
			System.out.println("删除VIP记录成功!");
		}else if(oper == 4) {
			System.out.print("请输入VIP编号：");
			String vipID = scanner.next();
			Object obj = session.get(cn.duzhaojiang.model.VIP01.class, vipID);
			VIP01 vip = (VIP01)obj;
			System.out.println("VIP编号：" + vip.getVipId());
			System.out.println("姓名：" + vip.getName());
			System.out.println("年龄：" + vip.getAge());
			System.out.println("职业：" + vip.getProfessional());
			System.out.println("注册时间：" + vip.getJoinTime());
		}
	}
}

(3) 查询所有vip信息，WebRoot/ShowVipList01.jsp

<%@page language="java" pageEncoding="gbk"%>
<%@page import="java.util.List"%>
<%@page import="org.hibernate.Query"%>
<%@page import="org.hibernate.Session"%>
<%@page import="cn.duzhaojiang.hibernate.AnnotationSessionFactory"%>
<%@page import="cn.duzhaojiang.model.VIP01"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<html>
<head>
	<title>VIP列表</title>  
</head>
<body>
	<%
		Session hsession = AnnotationSessionFactory.getSession();// 获得Session对象
		Query query = hsession.createQuery("from VIP01");//
		List<VIP01> vipList = query.list();// 查询结果保存到list中

//将所有记录保存到page范围  
		pageContext.setAttribute("vipList",vipList);
	%>
	<h1>VIP列表</h1>
	<hr />
	<table border="1">
		<tr>
			<td>VIP编号</td>
			<td>姓名</td>
			<td>年龄</td>
			<td>职业</td>
			<td>注册时间</td>
			<td>删除</td>
			<td>更新</td>
		</tr>
		<c:forEach var="v" items="${pageScope.vipList}"><%-- 循环输出信息 --%>
			<tr>
				<td>${v.vipId}</td>
				<td>${v.name}</td>
				<td>${v.age}</td>
				<td>${v.professional}</td>
				<td><fmt:formatDate value="${v.joinTime}" type="date"/></td>
				<td><a href="DelVip01.jsp?vipId=${v.vipId }">删除</a></td>
				<td><a href="VipUpdateForm01.jsp?vipId=${v.vipId}&name=${v.name}&age=${v.age}&professional=${v.professional}&joinTime=${v.joinTime}">更新</a></td>
			</tr>
		</c:forEach>
	</table>
	<hr/>
	<a href="VipAddForm01.jsp">添加Vip信息</a>
	<a href="/01JavaWeb13">返回本章目录</a>
</body>
</html>

(4) 删除vip信息处理， WebRoot/DelVip01.jsp

(5) 更新vip页面， WebRoot/VipUpdateForm01.jsp

(6) 更新vip信息处理， WebRoot/VipUpdate01.jsp

<%@page language="java" pageEncoding="gbk"%>
<%@page import="java.util.List"%>
<%@page import="java.util.Date"%>
<%@page import="org.hibernate.Transaction"%>
<%@page import="org.hibernate.Session"%>
<%@page import="cn.duzhaojiang.hibernate.AnnotationSessionFactory"%>
<%@page import="cn.duzhaojiang.model.VIP01"%>
<html>
<head>
	<title>更新vip处理</title>	
</head>
<body>
	<%
		request.setCharacterEncoding("gbk");		//设置参数编码格式
	%>
	<jsp:useBean id="v" scope="page" class="cn.duzhaojiang.model.VIP01"></jsp:useBean>		
	<jsp:setProperty name="v" property="*"/><%-- 设置JavaBean实例化对象的属性--%>
	<%
		Session hsession = AnnotationSessionFactory.getSession();// 获得Session对象
		Object obj = hsession.get(cn.duzhaojiang.model.VIP01.class, v.getVipId());
		VIP01 vip = (VIP01)obj;
		vip.setName(v.getName());
		vip.setAge(v.getAge());
		vip.setProfessional(v.getProfessional());
		Transaction transaction = null;// 声明一个事务对象
		try {
			transaction = hsession.beginTransaction();// 开启事务
			hsession.update(vip);// 保存信息
			transaction.commit();// 提交事务
			System.out.println("更新记录成功!");
		} catch (Exception ex) {
			ex.printStackTrace();
			transaction.rollback();// 事务回滚
		}
		AnnotationSessionFactory.closeSession();		//通过DAO工厂类获得DAO实现类实例
		response.sendRedirect("ShowVipList01.jsp");
	%>
</body>
</html>

(7) 添加Vip页面， WebRoot/VipAddForm01.jsp

(8) 添加Vip信息， WebRoot/VipAdd01.jsp

<%@page language="java" pageEncoding="gbk"%>
<%@page import="java.util.List"%>
<%@page import="java.util.Date"%>
<%@page import="org.hibernate.Transaction"%>
<%@page import="org.hibernate.Session"%>
<%@page import="cn.duzhaojiang.hibernate.AnnotationSessionFactory"%>
<%@page import="cn.duzhaojiang.model.VIP01"%>
<html>
<head>
	<title>添加vip处理</title>	
</head>
<body>
	<%
		request.setCharacterEncoding("gbk");		//设置参数编码格式
	%>
	<jsp:useBean id="v" scope="page" class="cn.duzhaojiang.model.VIP01"></jsp:useBean>		
	<jsp:setProperty name="v"  property="*"/><%-- 设置JavaBean实例化对象的属性--%>
	<%
		v.setJoinTime(new Date());
		Session hsession = AnnotationSessionFactory.getSession();// 获得Session对象
		Transaction transaction = null;// 声明一个事务对象
		try {
			transaction = hsession.beginTransaction();// 开启事务
			hsession.save(v);// 保存信息
			transaction.commit();// 提交事务
			System.out.println("添加记录成功!");
		} catch (Exception ex) {
			ex.printStackTrace();
			transaction.rollback();// 事务回滚
		}
		AnnotationSessionFactory.closeSession();		//通过DAO工厂类获得DAO实现类实例
		response.sendRedirect("ShowVipList01.jsp");
	%>
</body>
</html>

5. 上机题

(1) 知识点：src/hibernate.cfg.xml

(2) 知识点：src/hibernate.properties

(3) 创建[个人支出表]payout

在MySql中，创建[个人支出表]payout并添加测试数据，库名javaweb13、13表示第13章，表名payout，库名表名不变便于发布

(4) 创建实体类PayOut01.java

在cn.duzhaojiang.model, 创建PayOut01.java, 其中01代表学号

(5) 创建实体类PayOut01的的PayOut01.hbm.xml

在cn.duzhaojiang.model, 创建实体类PayOut01.java的hibernate的映射文件PayOut01.hbm.xml, 并在hibernate.cfg.xml中插入一条<mapping resource="cn/duzhaojiang/model/PayOut01.hbm.xml" />

(6) 插入[外出旅游]支出信息

在cn.duzhaojiang.test, 创建【插入[外出旅游]支出信息】文件InsertPayOut01.java, 右击该文件Run As --> Java Application执行, 出错...

在cn.duzhaojiang.test, 创建【插入[外出旅游]支出信息】文件InsertPayOut01.java, 右击该文件Run As --> Java Application执行

(7) 更新支出信息

在cn.duzhaojiang.test, 创建［更新支出信息］文件UpdatePayOut01.java, 右击该文件Run As --> Java Application执行，出错...

package cn.duzhaojiang.test;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import org.hibernate.Session;
import org.hibernate.Transaction;
import cn.duzhaojiang.hibernate.HibernateSessionFactory;
import cn.duzhaojiang.model.PayOut01;

public class UpdatePayOut01 {
	public static void main(String[] args) {
		PayOut01 payout = new PayOut01();
		payout.setId(2);
		payout.setPayoutName("外出旅游");
		payout.setPayoutMoney(2500);
		try {
			payout.setPayoutTime(new SimpleDateFormat("yyyy-MM-dd")
					.parse("2009-8-12"));
		} catch (ParseException e) {
			e.printStackTrace();
		}
		Session session = HibernateSessionFactory.getSession();// 获得Session对象
		Transaction transaction = null;// 声明一个事务对象
		try {
			transaction = session.beginTransaction();// 开启事务
			session.saveOrUpdate(payout);// 保存学生信息
			transaction.commit();// 提交事务
			System.out.println("更新记录成功!");
		} catch (Exception ex) {
			ex.printStackTrace();
			transaction.rollback();// 事务回滚
		}
		HibernateSessionFactory.closeSession();
	}
}

在cn.duzhaojiang.test, 创建［更新支出信息］文件UpdatePayOut01.java, 右击该文件Run As --> Java Application执行，出错..., 修改payout.setId(2) 为 payout.setId(7)

package cn.duzhaojiang.test;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import org.hibernate.Session;
import org.hibernate.Transaction;
import cn.duzhaojiang.hibernate.AnnotationSessionFactory;
import cn.duzhaojiang.model.PayOut01;

public class UpdatePayOut01 {
	public static void main(String[] args) {
		PayOut01 payout = new PayOut01();
		payout.setId(2);
		payout.setPayoutName("外出旅游");
		payout.setPayoutMoney(2500);
		try {
			payout.setPayoutTime(new SimpleDateFormat("yyyy-MM-dd")
					.parse("2009-8-12"));
		} catch (ParseException e) {
			e.printStackTrace();
		}
		Session session = AnnotationSessionFactory.getSession();// 获得Session对象
		Transaction transaction = null;// 声明一个事务对象
		try {
			transaction = session.beginTransaction();// 开启事务
			session.saveOrUpdate(payout);// 保存学生信息
			transaction.commit();// 提交事务
			System.out.println("更新记录成功!");
		} catch (Exception ex) {
			ex.printStackTrace();
			transaction.rollback();// 事务回滚
		}
		AnnotationSessionFactory.closeSession();
	}
}

(8) 提取支出信息

在cn.duzhaojiang.test, 创建［提取支出信息］GetPayOut01.java, 右击该文件Run As --> Java Application执行

(9) 查询指定月份的支出总额

在cn.duzhaojiang.test, 创建［查询指定月份的支出总额］QueryPayOut01.java, 右击该文件Run As --> Java Application执行

package cn.duzhaojiang.test;

//import java.text.ParseException;
//import java.text.SimpleDateFormat;
//import java.util.Date;
import java.util.Iterator;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
//import cn.duzhaojiang.hibernate.HibernateSessionFactory;
import cn.duzhaojiang.hibernate.AnnotationSessionFactory;
import cn.duzhaojiang.model.PayOut01;

public class QueryPayOut01 {
	public static void main(String[] args) {
		Session session = AnnotationSessionFactory.getSession();//获得Session对象
//		Session session = HibernateSessionFactory.getSession();//获得Session对象
		Query query = session.createQuery("from PayOut01 as po where po.payoutTime between '2014-12-1' and  '2014-12-31'");//查询student表
		List list = query.list();//查询结果保存到list中
		Iterator iter = list.iterator();//获得list的内部迭代器
		PayOut01 payOut = null;
		double allMoney = 0.0;
		while(iter.hasNext()) {		//遍历list
			payOut = (PayOut01) iter.next();
			allMoney += payOut.getPayoutMoney();
		}
		System.out.println("总金额为" + allMoney);
		AnnotationSessionFactory.closeSession();
//		HibernateSessionFactory.closeSession();
	}
}

(10) 实体类中注入映射信息(备忘知识点)

知识点：Annotation定义实体类PayOut的映射信息, 在cn.duzhaojiang.model创建PayOut.java

package cn.duzhaojiang.model;

@Entity
@Table(name = "payout", catalog = "javaweb13")
public class PayOut {
	@Id
	@GeneratedValue(strategy=javax.persistence.GenerationType.IDENTITY)
	private int id;
	@Column(name="payoutName")
	private String payoutName;
	@Column(name="payoutMoney")
	private double payoutMoney;
	@Column(name="payoutTime")
	private Date payoutTime;

public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getPayoutName() {
		return payoutName;
	}
	public void setPayoutName(String payoutName) {
		this.payoutName = payoutName;
	}
	public double getPayoutMoney() {
		return payoutMoney;
	}
	public void setPayoutMoney(double payoutMoney) {
		this.payoutMoney = payoutMoney;
	}
	public Date getPayoutTime() {
		return payoutTime;
	}
	public void setPayoutTime(Date payoutTime) {
		this.payoutTime = payoutTime;
	}
}

(11) 上机题web发布

(1) 查询所有支信息， ShowPayOutList01.jsp

<%@page language="java" pageEncoding="gbk"%>
<%@page import="java.util.List"%>
<%@page import="org.hibernate.Query"%>
<%@page import="org.hibernate.Session"%>
<%@page import="cn.duzhaojiang.hibernate.AnnotationSessionFactory"%>
<%@page import="cn.duzhaojiang.model.PayOut01"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<html>
<head>
	<title>支出列表</title>  
</head>
<body>
	<%
		Session hsession = AnnotationSessionFactory.getSession();// 获得Session对象
		Query query = hsession.createQuery("from PayOut01");// 查询
		List<PayOut01> payoutList = query.list();// 查询结果保存到list中

//将所有记录保存到page范围  
		pageContext.setAttribute("payoutList",payoutList);
	%>
	<h1>支出列表</h1>
	<hr />
	<table border="1">
		<tr>
			<td>支出编号</td>
			<td>支出名称</td>
			<td>支出额(元)</td>
			<td>支出时间</td>
		</tr>
		<c:forEach var="p" items="${pageScope.payoutList}"><%-- 循环输出信息 --%>
			<tr>
				<td>${p.id}</td>
				<td>${p.payoutName}</td>
				<td>${p.payoutMoney}</td>
				<td><fmt:formatDate value="${p.payoutTime}" type="date"/></td>
			</tr>
		</c:forEach>
	</table>
	<hr/>
	<a href="/01JavaWeb13">返回本章目录</a>
</body>
</html>

(2) 添加指定内容的支出信息， InsertPayOut01.jsp

<%@page language="java" pageEncoding="gbk"%>
<%@page import="java.text.SimpleDateFormat"%>
<%@page import="org.hibernate.Transaction"%>
<%@page import="org.hibernate.Session"%>
<%@page import="cn.duzhaojiang.hibernate.AnnotationSessionFactory;"%>
<%@page import="cn.duzhaojiang.model.PayOut01"%>
<html>
<head>
	<title>添加支出处理</title>	
</head>
<body>
	<%
		request.setCharacterEncoding("gbk");		//设置参数编码格式
		PayOut01 pay = new PayOut01();
//		pay.setId(Integer.parseInt(request.getParameter("id")));
		pay.setPayoutMoney(Double.parseDouble(request.getParameter("payoutMoney")));
		pay.setPayoutName(request.getParameter("payoutName"));
		pay.setPayoutTime(new SimpleDateFormat("yyyy-MM-dd").parse(request.getParameter("payoutTime")));
		Session hsession = AnnotationSessionFactory.getSession();// 获得Session对象
		Transaction transaction = null;// 声明一个事务对象
		try {
			transaction = hsession.beginTransaction();// 开启事务
			hsession.save(pay);// 保存信息
			transaction.commit();// 提交事务
			System.out.println("添加记录成功!");
		} catch (Exception ex) {
			ex.printStackTrace();
			transaction.rollback();// 事务回滚
		}
		AnnotationSessionFactory.closeSession();		
		response.sendRedirect("ShowPayOutList01.jsp");
	%>
</body>
</html>

(3) 更新指定编号的支出信息， UpdatePayOut01.jsp

<%@page language="java" pageEncoding="gbk"%>
<%@page import="java.text.SimpleDateFormat"%>
<%@page import="org.hibernate.Transaction"%>
<%@page import="org.hibernate.Session"%>
<%@page import="cn.duzhaojiang.hibernate.AnnotationSessionFactory;"%>
<%@page import="cn.duzhaojiang.model.PayOut01"%>
<html>
<head>
	<title>更新支出处理</title>	
</head>
<body>
	<%
		request.setCharacterEncoding("gbk");		//设置参数编码格式
		PayOut01 pay = new PayOut01();
//		pay.setId(Integer.parseInt(request.getParameter("id")));
		pay.setId(8);
		pay.setPayoutMoney(Double.parseDouble(request.getParameter("payoutMoney")));
		pay.setPayoutName(request.getParameter("payoutName"));
		pay.setPayoutTime(new SimpleDateFormat("yyyy-MM-dd").parse(request.getParameter("payoutTime")));
		Session hsession = AnnotationSessionFactory.getSession();// 获得Session对象
		Transaction transaction = null;// 声明一个事务对象
		try {
			transaction = hsession.beginTransaction();// 开启事务
			hsession.update(pay);// 保存信息
			transaction.commit();// 提交事务
			System.out.println("更新记录成功!");
		} catch (Exception ex) {
			ex.printStackTrace();
			transaction.rollback();// 事务回滚
		}
		AnnotationSessionFactory.closeSession();		
		response.sendRedirect("ShowPayOutList01.jsp");
	%>
</body>
</html>

(4) 提取支出指定编号的支出信息， GetPayOut01.jsp

返回章节目录

第13章 Hibernate配置和会话【首页】杜老师

0. 创建项目

本章重点

作者心得

1. 配置Hibernate

1.1 使用XML文件配置Hibernate

1.2 使用资源文件配置Hibernate

1.3 代码动态配置Hibernate

1.4 手动创建数据库连接(备忘)

1.5 手动创建Hibernate配置文件、Hibernate会话工厂类(备忘)

1.6 手动反向创建数据表的.hbm.xml 映像文件(备忘)

2. 配置映射文件

2.1 创建实体类及其映射配置文件

(1) 创建实体类: private属性及其set/get方法

(2) ORM映射配置文件(.hbm.xml)

(3) 查询数据测试类(含main方法)

(4) 添加数据测试

2.2 .映射配置文件知识点

2.3 创建Employee实体类及其对象关系映射文件(备忘：训练完毕为下一练习要删除)

3. 使用Annotations配置映射

3.1 在实体类中注解映射信息

3.2 在实体类中注解映射信息知识点

3.3 Annotation注解映射和.hbm.xml映射混合定义存在的问题

4. 会话(Session)的应用

4.1 Hibernate对象状态

4.2 使用save方法持久化对象

4.3 使用saveOrUpdate方法持久化对象

4.4 使用load方法装载对象

4.5 使用get方法装载对象

4.6 使用refresh方法刷新对象

4.7 使用setFlushMode方法设置更新模式

4.8 使用isDirty方法判断数据是否一致

4.9 使用delete方法删除记录

实训 模拟商场VIP系统

(1) 创建实体类VIP01.java

(2) 创建测试类VIPMain01.java

5. 上机题

(1) 知识点：src/hibernate.cfg.xml

(2) 知识点：src/hibernate.properties

(3) 创建[个人支出表]payout

(4) 创建实体类PayOut01.java

(5) 创建实体类PayOut01的的PayOut01.hbm.xml

(6) 插入[外出旅游]支出信息

(7) 更新支出信息

(8) 提取支出信息

(9) 查询指定月份的支出总额

(10) 实体类中注入映射信息(备忘知识点)

(11) 上机题web发布

实训模拟商场VIP系统