第12章编写Hibernate第一个程序【首页】杜老师

0. 创建项目

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

(2) 创建首页index.jsp

本章重点

备忘 tomcat中文乱码

1. Hibernate概述

1.1 什么是ORM

1.2 为什么要使用ORM

1.3 使用Hibernate框架的优势

1.4 开发Hibernate程序的基本步骤

2. Hibernate开发入门(学生成绩表管理)

2.1 创建数据库表

2.2 手动创建数据库连接

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

2.3 创建Hibernate配置文件、Hibernate会话工厂类

创建配置文件src\hibernate.cfg.xml

创建Hibernate会话工厂类: cn.duzhaojiang.hibernate\HibernateSessionFactory.java

package com.sanqing.hibernate;

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

public class HibernateSessionFactory {
	private static String CONFIG_FILE_LOCATION = "/hibernate.cfg.xml";//指定配置文件路径
	private static final ThreadLocal<Session> threadLocal 
					= new ThreadLocal<Session>();//定义ThreadLocal对象
    private  static Configuration configuration 
    				= new Configuration();//定义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 HibernateSessionFactory() {
    }
    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) {//设置新的配置文件
		HibernateSessionFactory.configFile = configFile;
		sessionFactory = null;
	}
	public static Configuration getConfiguration() {//获得Configuration对象
		return configuration;
	}
}

2.4 创建Student12实体类及其对象关系映射文件

src\cn.duzhaojiang.model\Student12.java

package cn.duzhaojiang.model;

/**
 * Student12 entity.
 * 
 * @author MyEclipse Persistence Tools
 */

public class Student12 implements java.io.Serializable {

// Fields

private String id;
	private String name;
	private Double result;
	private String subject;

// Constructors

/** default constructor */
	public Student12() {
	}

/** minimal constructor */
	public Student12(String id) {
		this.id = id;
	}

/** full constructor */
	public Student12(String id, String name, Double result, String subject) {
		this.id = id;
		this.name = name;
		this.result = result;
		this.subject = subject;
	}

// Property accessors

public String getId() {
		return this.id;
	}

public void setId(String id) {
		this.id = id;
	}

public String getName() {
		return this.name;
	}

public void setName(String name) {
		this.name = name;
	}

public Double getResult() {
		return this.result;
	}

public void setResult(Double result) {
		this.result = result;
	}

public String getSubject() {
		return this.subject;
	}

public void setSubject(String subject) {
		this.subject = subject;
	}

src\cn.duzhaojiang.model\Student12.hbm.xml,

2.5 完成插入数据

创建src\cn.duzhaojiang.test， InsertTest01.java，右键InsertTest01.java-->Run As -->Java Application

实训使用Hibernate查询学生列表(所有学生成绩)

创建src\cn.duzhaojiang.test， QueryTest01.java，右键InsertTest.java-->Run As -->Java Application

实训2 使用Hibernate查询学生列表(成绩<60)

创建src\cn.duzhaojiang.test， QueryTest2_01.java，右键InsertTest.java-->Run As -->Java Application

实训3 创建学生成绩管理的jsp页面文件

(1) 创建[学生成绩列表]页面文件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.HibernateSessionFactory"%>
<%@page import="cn.duzhaojiang.model.Student12"%>
<%@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 = HibernateSessionFactory.getSession();// 获得Session对象
		Query query = hsession.createQuery("from Student12");// 查询student表
		List<Student12> 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="/01JavaWeb12">返回本章目录</a>
</body>
</html>

(2) 创建[学生成绩添加]页面文件WebRoot\StudentForm01.jsp

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

(4) 创建[学生成绩<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.HibernateSessionFactory"%>
<%@page import="cn.duzhaojiang.model.Student12"%>
<%@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 = HibernateSessionFactory.getSession();// 获得Session对象
		Query query = hsession.createQuery("from Student12 as stu where stu.result < 60");// 查询student表
		List<Student12> studentList = query.list();// 查询结果保存到list中

3. 上机题

(1) 创建数据表、产生数据(在mysql中执行)

use javaweb04;
create table `flight` (
  `no` varchar(11) not null default '' comment '航班号',
  `flytime` varchar(5) default null comment '起飞时间',
  `landingtime` varchar(5) default null comment '降落时间',
  `flycity` varchar(20) default null comment '起飞城市',
  `landingcity` varchar(20) default null comment '降落城市',
  `type` varchar(11) default null comment '机型',
  `price` double(6,2) default null comment '票价',
  `airlinecom` varchar(8) default null comment '航空公司',
  primary key  (`no`)
) engine=innodb default charset=gbk comment='飞机航班信息表';

insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('06:40', '09:00', '北京首都', '上海虹桥', '南方航空', 'CZ6412', '321', '598');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('07:00', '09:15', '北京首都', '上海虹桥', '东方航空', 'MU5138', '333', '535');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('07:25', '09:45', '北京首都', '上海虹桥', '上海航空', 'FM9108', '738', '535');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('07:30', '09:40', '北京首都', '上海虹桥', '国际航空', 'CA1831', '773', '986');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('07:35', '09:40', '北京首都', '上海浦东', '东方航空', 'MU5183', '321', '568');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('07:35', '09:55', '北京首都', '上海虹桥', '海南航空', 'HU7607', '333', '1470');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('08:00', '10:15', '北京首都', '上海虹桥', '东方航空', 'MU5102', '333', '981');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('08:00', '10:15', '北京首都', '上海浦东', '国际航空', 'CA1835', '333', '986');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('08:25', '10:20', '北京南苑', '上海浦东', '联合航空', 'KN5977', '738', '648');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('08:45', '10:55', '北京首都', '上海虹桥', '海南航空', 'HU7605', '787', '927');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('09:00', '11:15', '北京首都', '上海虹桥', '东方航空', 'MU5104', '333', '3100');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('09:30', '11:35', '北京首都', '上海虹桥', '国际航空', 'CA1519', '773', '986');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('09:55', '12:10', '北京首都', '上海虹桥', '东方航空', 'MU5106', '333', '981');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('10:30', '12:35', '北京首都', '上海虹桥', '国际航空', 'CA1531', '773', '986');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('11:00', '13:15', '北京首都', '上海虹桥', '东方航空', 'MU5108', '333', '981');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('11:30', '13:45', '北京首都', '上海虹桥', '东方航空', 'MU5152', '76A', '981');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('11:30', '13:40', '北京首都', '上海虹桥', '国际航空', 'CA1557', '773', '986');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('11:55', '14:10', '北京首都', '上海虹桥', '东方航空', 'MU5110', '333', '981');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('12:55', '15:10', '北京首都', '上海虹桥', '东方航空', 'MU5112', '333', '981');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('13:30', '15:40', '北京首都', '上海虹桥', '国际航空', 'CA1517', '773', '2782');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('13:40', '15:45', '北京首都', '上海虹桥', '东方航空', 'MU5154', '76A', '981');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('14:00', '16:15', '北京首都', '上海虹桥', '东方航空', 'MU5114', '333', '981');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('07:00', '09:20', '上海虹桥', '北京首都', '东方航空', 'MU5137', '333', '568');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('07:50', '10:20', '上海虹桥', '北京首都', '国际航空', 'CA1858', '773', '1028');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('08:00', '10:20', '上海虹桥', '北京首都', '东方航空', 'MU5101', '333', '568');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('08:20', '10:45', '上海虹桥', '北京首都', '海南航空', 'HU7604', '738', '588');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('08:30', '10:40', '上海虹桥', '北京首都', '东方航空', 'MU5151', '76A', '568');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('08:55', '11:25', '上海虹桥', '北京首都', '国际航空', 'CA1590', '773', '1028');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('09:00', '11:25', '上海虹桥', '北京首都', '东方航空', 'MU5103', '773', '568');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('09:20', '11:45', '上海浦东', '北京首都', '东方航空', 'MU5129', '319', '1041');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('09:30', '12:05', '上海虹桥', '北京首都', '东方航空', 'MU5153', '76A', '568');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('10:00', '12:20', '上海虹桥', '北京首都', '东方航空', 'MU5105', '333', '568');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('10:15', '12:25', '上海虹桥', '北京首都', '南方航空', 'CZ6411', '321', '767');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('10:55', '13:10', '上海虹桥', '北京首都', '海南航空', 'HU7608', '333', '679');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('10:55', '13:25', '上海虹桥', '北京首都', '国际航空', 'CA1832', '773', '1028');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('11:00', '13:20', '上海虹桥', '北京首都', '东方航空', 'MU5107', '333', '568');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('11:30', '13:35', '上海浦东', '北京南苑', '联合航空', 'KN5978', '738', '538');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('11:50', '14:10', '上海虹桥', '北京首都', '国际航空', 'CA1502', '773', '1028');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('11:55', '14:15', '上海虹桥', '北京首都', '海南航空', 'HU7606', '787', '679');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('12:00', '14:20', '上海虹桥', '北京首都', '东方航空', 'MU5109', '333', '658');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('12:20', '14:40', '上海浦东', '北京首都', '东方航空', 'MU564', '332', '743');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('12:55', '15:20', '上海虹桥', '北京首都', '国际航空', 'CA1520', '33A', '1028');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('13:00', '15:20', '上海虹桥', '北京首都', '东方航空', 'MU5111', '333', '777');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('13:30', '15:50', '上海虹桥', '北京首都', '上海航空', 'FM9103', '73E', '881');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('13:55', '16:15', '上海虹桥', '北京首都', '国际航空', 'CA1532', '773', '1028');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('14:00', '16:25', '上海虹桥', '北京首都', '东方航空', 'MU5113', '333', '777');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('06:30', '08:55', '北京首都', '长沙黄花', '厦门航空', 'MF8192', '738', '628');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('06:35', '09:05', '北京首都', '长沙黄花', '国际航空', 'CA1343', '32A', '693');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('07:50', '10:25', '北京首都', '长沙黄花', '南方航空', 'CZ3164', '320', '3551');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('08:20', '10:45', '北京首都', '长沙黄花', '海南航空', 'HU7635', '738', '817');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('10:55', '13:35', '北京首都', '长沙黄花', '南方航空', 'CZ3124', '321', '997');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('12:35', '15:00', '北京首都', '长沙黄花', '国际航空', 'CA1373', '333', '1050');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('14:05', '16:25', '北京首都', '长沙黄花', '南方航空', 'CZ3718', '321', '997');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('14:15', '16:40', '北京首都', '长沙黄花', '海南航空', 'HU7835', '333', '635');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('15:20', '18:00', '北京首都', '长沙黄花', '南方航空', 'CZ3128', '321', '997');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('17:40', '20:15', '北京首都', '长沙黄花', '国际航空', 'CA1363', '32A', '931');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('17:55', '20:40', '北京首都', '长沙黄花', '南方航空', 'CZ3148', '321', '877');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('18:05', '20:30', '北京首都', '长沙黄花', '海南航空', 'HU7135', '767', '518');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('19:10', '21:45', '北京南苑', '长沙黄花', '联合航空', 'KN5805', '73E', '447');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('07:45', '10:05', '长沙黄花', '北京首都', '南方航空', 'CZ3123', '321', '638');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('08:35', '10:55', '长沙黄花', '北京首都', '国际航空', 'CA1350', '32A', '690');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('10:05', '12:35', '长沙黄花', '北京首都', '国际航空', 'CA1344', '32A', '927');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('10:30', '12:40', '长沙黄花', '北京首都', '南方航空', 'CZ3147', '320', '877');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('11:40', '13:50', '长沙黄花', '北京首都', '海南航空', 'HU7636', '787', '743');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('12:15', '14:25', '长沙黄花', '北京首都', '南方航空', 'CZ3127', '321', '757');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('14:20', '16:45', '长沙黄花', '北京首都', '南方航空', 'CZ3141', '320', '1171');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('16:00', '18:15', '长沙黄花', '北京首都', '国际航空', 'CA1374', '333', '1046');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('17:15', '19:40', '长沙黄花', '北京首都', '南方航空', 'CZ3717', '320', '877');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('17:45', '20:00', '长沙黄花', '北京首都', '海南航空', 'HU7836', '333', '518');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('18:00', '20:20', '长沙黄花', '北京首都', '厦门航空', 'MF8147', '738', '632');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('21:25', '23:40', '长沙黄花', '北京首都', '海南航空', 'HU7136', '767', '389');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('21:35', '00:15', '长沙黄花', '北京首都', '国际航空', 'CA1364', '32A', '444');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('21:55', '00:25', '长沙黄花', '北京首都', '厦门航空', 'MF8191', '738', '324');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('22:25', '00:45', '长沙黄花', '北京首都', '南方航空', 'CZ3163', '320', '440');
insert into flight(flytime,landingtime,flycity,landingcity,airlinecom,no,type,price) values('22:30', '00:30', '长沙黄花', '北京南苑', '联合航空', 'KN5806', '73E', '269');

select * from flight;

(2) 创建flight的实体类

在cn.duzhaojiang.model包，创建实体类Flight.java

package cn.duzhaojiang.model;

/**
 * Flight entity.
 * 
 * @author MyEclipse Persistence Tools
 */

public class Flight implements java.io.Serializable {

// Fields

private String no;
	private String flytime;
	private String landingtime;
	private String flycity;
	private String landingcity;
	private String type;
	private Double price;
	private String airlinecom;

// Constructors

/** default constructor */
	public Flight() {
	}

/** minimal constructor */
	public Flight(String no) {
		this.no = no;
	}

/** full constructor */
	public Flight(String no, String flytime, String landingtime,
			String flycity, String landingcity, String type, Double price,
			String airlinecom) {
		this.no = no;
		this.flytime = flytime;
		this.landingtime = landingtime;
		this.flycity = flycity;
		this.landingcity = landingcity;
		this.type = type;
		this.price = price;
		this.airlinecom = airlinecom;
	}

// Property accessors

public String getNo() {
		return this.no;
	}

public void setNo(String no) {
		this.no = no;
	}

public String getFlytime() {
		return this.flytime;
	}

public void setFlytime(String flytime) {
		this.flytime = flytime;
	}

public String getLandingtime() {
		return this.landingtime;
	}

public void setLandingtime(String landingtime) {
		this.landingtime = landingtime;
	}

public String getFlycity() {
		return this.flycity;
	}

public void setFlycity(String flycity) {
		this.flycity = flycity;
	}

public String getLandingcity() {
		return this.landingcity;
	}

public void setLandingcity(String landingcity) {
		this.landingcity = landingcity;
	}

public String getType() {
		return this.type;
	}

public void setType(String type) {
		this.type = type;
	}

public Double getPrice() {
		return this.price;
	}

public void setPrice(Double price) {
		this.price = price;
	}

public String getAirlinecom() {
		return this.airlinecom;
	}

public void setAirlinecom(String airlinecom) {
		this.airlinecom = airlinecom;
	}

}

(3) 创建Flight的对象关系映射文件

在cn.duzhaojiang.model包，Flight的对象关系映射文件Flight.hbm.xml

<?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="cn.duzhaojiang.model.Flight" table="flight" catalog="javaweb04">
        <id name="no" type="java.lang.String">
            <column name="no" length="11" />
            <generator class="assigned" />
        </id>
        <property name="flytime" type="java.lang.String">
            <column name="flytime" length="5">
                <comment>起飞时间</comment>
            </column>
        </property>
        <property name="landingtime" type="java.lang.String">
            <column name="landingtime" length="5">
                <comment>降落时间</comment>
            </column>
        </property>
        <property name="flycity" type="java.lang.String">
            <column name="flycity" length="20">
                <comment>起飞城市</comment>
            </column>
        </property>
        <property name="landingcity" type="java.lang.String">
            <column name="landingcity" length="20">
                <comment>降落城市</comment>
            </column>
        </property>
        <property name="type" type="java.lang.String">
            <column name="type" length="11">
                <comment>机型</comment>
            </column>
        </property>
        <property name="price" type="java.lang.Double">
            <column name="price" precision="6">
                <comment>票价</comment>
            </column>
        </property>
        <property name="airlinecom" type="java.lang.String">
            <column name="airlinecom" length="8">
                <comment>航空公司</comment>
            </column>
        </property>
    </class>
</hibernate-mapping>

(4) 查询所有航班信息

在cn.duzhaojiang.test, 创建[所有飞机航班信息列表]测试文件ShowFlightList01.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.HibernateSessionFactory;
import cn.duzhaojiang.model.Flight;

public class QueryFlight01 {
	public static void main(String[] args) {
		Session session = HibernateSessionFactory.getSession();//获得Session对象
		Query query = session.createQuery("from Flight");
		List list = query.list();//查询结果保存到list中
		Iterator iter = list.iterator();//获得list的内部迭代器
		Flight flight = null;
		System.out.println("航班号\t起飞时间\t降落时间\t起飞城市\t降落城市\t机型\t票价\t航空公司");
		while(iter.hasNext()) {		//遍历list
			flight = (Flight) iter.next();
			System.out.println(flight.getNo() + "\t\t" +
					flight.getFlytime() + "\t" +
					flight.getLandingtime() + "\t" +
					flight.getFlycity() + "\t" +
					flight.getLandingcity() + "\t" +
					flight.getType() + "\t\t" +
					flight.getPrice() + "\t" +
					flight.getAirlinecom() + "\t" 
			);
		}
		HibernateSessionFactory.closeSession();//关闭Session对象
	}
}

创建[所有飞机航班信息列表]页面文件WebRoot\ShowFlightList01.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.HibernateSessionFactory"%>
<%@page import="cn.duzhaojiang.model.Flight"%>
<%@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 = HibernateSessionFactory.getSession();// 获得Session对象
		Query query = hsession.createQuery("from Flight");// 查询student表
		List<Flight> flighttList = query.list();// 查询结果保存到list中

//将所有记录保存到page范围  
		pageContext.setAttribute("flighttList",flighttList);
	%>
	<h1>飞机航班信息列表</h1>
	<hr />
	<table border="1">
		<tr>
			<td>航班号</td>
			<td>起飞时间</td>
			<td>降落时间</td>
			<td>起飞机场</td>
			<td>降落机场</td>
			<td>飞机型号</td>
			<td>票价</td>
			<td>航空公司</td>
			<td>更新</td>
		</tr>
		<c:forEach var="f" items="${pageScope.flighttList}"><%-- 循环输出学生信息 --%>
			<tr>
				<td>${f.no }</td>
				<td>${f.flytime }</td>
				<td>${f.landingtime }</td>
				<td>${f.flycity }</td>
				<td>${f.landingcity }</td>
				<td>${f.type }</td>
				<td>${f.price }</td>
				<td>${f.airlinecom }</td>
				<td><a href="FlightUpdateForm01.jsp?no=${f.no}&flytime=${f.flytime}&landingtime=${f.landingtime}&flycity=${f.flycity}&landingcity=${f.landingcity}&type=${f.type}&price=${f.price}&airlinecom=${f.airlinecom}">更新</a></td>
			</tr>
		</c:forEach>
	</table>
	<hr/>
	<a href="/01JavaWeb12">返回本章目录</a>
</body>
</html>

(5) 查询[上海浦东]飞[北京首都]航班信息

在cn.duzhaojiang.test, 创建［查询上海浦东飞北京首都航班信息］测试文件ShowFlightList2_01.java, 右击该文件Run As --> Java Application执行

package cn.duzhaojiang.test;

public class QueryFlight2_01 {
	public static void main(String[] args) {
		Session session = HibernateSessionFactory.getSession();//获得Session对象
		Query query = session.createQuery("from Flight as fgt where fgt.flycity = '上海浦东' and fgt.landingcity = '北京首都'");
		List list = query.list();//查询结果保存到list中
		Iterator iter = list.iterator();//获得list的内部迭代器
		Flight flight = null;
		System.out.println("航班号\t起飞时间\t降落时间\t起飞城市\t降落城市\t机型\t票价\t航空公司");
		while(iter.hasNext()) {		//遍历list
			flight = (Flight) iter.next();
			System.out.println(flight.getNo() + "\t\t" +
					flight.getFlytime() + "\t" +
					flight.getLandingtime() + "\t" +
					flight.getFlycity() + "\t" +
					flight.getLandingcity() + "\t" +
					flight.getType() + "\t\t" +
					flight.getPrice() + "\t" +
					flight.getAirlinecom() + "\t" 
			);
		}
		HibernateSessionFactory.closeSession();//关闭Session对象
	}
}

创建[查询上海浦东飞北京首都航班信息]页面文件WebRoot\ShowFlightList2_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.HibernateSessionFactory"%>
<%@page import="cn.duzhaojiang.model.Flight"%>
<%@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 = HibernateSessionFactory.getSession();// 获得Session对象
		Query query = hsession.createQuery("from Flight as fgt where fgt.flycity = '上海浦东' and fgt.landingcity = '北京首都'");
		List<Flight> flighttList = query.list();// 查询结果保存到list中

//将所有记录保存到page范围  
		pageContext.setAttribute("flighttList",flighttList);
	%>
	<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="flight" items="${pageScope.flighttList}"><%-- 循环输出学生信息 --%>
			<tr>
				<td>${flight.no }</td>
				<td>${flight.flytime }</td>
				<td>${flight.landingtime }</td>
				<td>${flight.flycity }</td>
				<td>${flight.landingcity }</td>
				<td>${flight.type }</td>
				<td>${flight.price }</td>
				<td>${flight.airlinecom }</td>
			</tr>
		</c:forEach>
	</table>
	<hr/>
	<a href="/01JavaWeb12">返回本章目录</a>
</body>
</html>

(6) 查询[长沙黄花]飞[北京南苑]且票价小于800元的航班信息

在cn.duzhaojiang.test, 创建［查询长沙黄花飞北京南苑且票价小于800元航班信息］文件ShowFlightList3_01.java, 右击该文件Run As --> Java Application执行

package cn.duzhaojiang.test;

public class QueryFlight3_01 {
	public static void main(String[] args) {
		Session session = HibernateSessionFactory.getSession();//获得Session对象
		Query query = session.createQuery("from Flight as fgt where fgt.flycity = '长沙黄花' and fgt.landingcity = '北京南苑' and fgt.price < 800");
		List list = query.list();//查询结果保存到list中
		Iterator iter = list.iterator();//获得list的内部迭代器
		Flight flight = null;
		System.out.println("航班号\t起飞时间\t降落时间\t起飞城市\t降落城市\t机型\t票价\t航空公司");
		while(iter.hasNext()) {		//遍历list
			flight = (Flight) iter.next();
			System.out.println(flight.getNo() + "\t\t" +
					flight.getFlytime() + "\t" +
					flight.getLandingtime() + "\t" +
					flight.getFlycity() + "\t" +
					flight.getLandingcity() + "\t" +
					flight.getType() + "\t\t" +
					flight.getPrice() + "\t" +
					flight.getAirlinecom() + "\t" 
			);
		}
		HibernateSessionFactory.closeSession();//关闭Session对象
	}
}

创建[查询长沙黄花飞北京南苑且票价小于800元航班信息]页面文件WebRoot\ShowFlightList3_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.HibernateSessionFactory"%>
<%@page import="cn.duzhaojiang.model.Flight"%>
<%@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 = HibernateSessionFactory.getSession();// 获得Session对象
		Query query = hsession.createQuery("from Flight as fgt where fgt.flycity = '长沙黄花' and fgt.landingcity = '北京南苑' and fgt.price < 800");
		List<Flight> flighttList = query.list();// 查询结果保存到list中

//将所有记录保存到page范围  
		pageContext.setAttribute("flighttList",flighttList);
	%>
	<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="flight" items="${pageScope.flighttList}"><%-- 循环输出学生信息 --%>
			<tr>
				<td>${flight.no }</td>
				<td>${flight.flytime }</td>
				<td>${flight.landingtime }</td>
				<td>${flight.flycity }</td>
				<td>${flight.landingcity }</td>
				<td>${flight.type }</td>
				<td>${flight.price }</td>
				<td>${flight.airlinecom }</td>
			</tr>
		</c:forEach>
	</table>
	<hr/>
	<a href="/01JavaWeb12">返回本章目录</a>
</body>
</html>

(7) 更新航班信息

在cn.duzhaojiang.test, 创建［更新航班信息］文件UpdateFlight01.java, 右击该文件Run As --> Java Application执行

创建[更新航班信息]页面文件WebRoot\FlightUpdateForm01.jsp

<%@page language="java" pageEncoding="gbk"%>
<!DOCTYPE html >
<html>
<head>
	<title>更新航班信息</title>
</head>
<body>
	<form action="UpdateFlight01.jsp" method="post">
		<table>
			<tr>
				<td>航班号：</td>
				<td><input type="text" name="no" value="${param.no}" readonly="readonly"/></td>
			</tr>
			<tr>
				<td>起飞时间：</td>
				<td><input type="text" name="flytime" value="${param.flytime}"/></td>
			</tr>
			<tr>
				<td>降落时间：</td>
				<td><input type="text" name="landingtime" value="${param.landingtime}"/></td>
			</tr>
			<tr>
				<td>起飞机场：</td>
				<td><input type="text" name="flycity" value="${param.flycity}"/></td>
			</tr>
			<tr>
				<td>降落机场：</td>
				<td><input type="text" name="landingcity" value="${param.landingcity}"/></td>
			</tr>
			<tr>
				<td>飞机型号：</td>
				<td><input type="text" name="type" value="${param.type}"/></td>
	  	</tr>
			<tr>
				<td>票价：</td>
				<td><input type="text" name="price" value="${param.price}"/></td>
	  	</tr>
			<tr>
				<td>航空公司：</td>
				<td><input type="text" name="airlinecom" value="${param.airlinecom}"/></td>
	  	</tr>
			<tr>
				<td><input type="submit" value="更新"></td>
				<td><input type="reset" value="重置"></td>
			</tr>
		</table>
	</form>
</body>
</html>

创建[更新航班信息]页面文件WebRoot\UpdateFlight01.jsp, 并重部署项目进行测试

返回章节目录

第12章 编写Hibernate第一个程序【首页】杜老师

0. 创建项目

本章重点

备忘 tomcat中文乱码

1. Hibernate概述

1.1 什么是ORM

1.2 为什么要使用ORM

1.3 使用Hibernate框架的优势

1.4 开发Hibernate程序的基本步骤

2. Hibernate开发入门(学生成绩表管理)

2.1 创建数据库表

2.2 手动创建数据库连接

2.3 创建Hibernate配置文件、Hibernate会话工厂类

2.4 创建Student12实体类及其对象关系映射文件

2.5 完成插入数据

实训 使用Hibernate查询学生列表(所有学生成绩)

实训2 使用Hibernate查询学生列表(成绩<60)

实训3 创建学生成绩管理的jsp页面文件

3. 上机题

(1) 创建数据表、产生数据(在mysql中执行)

(2) 创建flight的实体类

(3) 创建Flight的对象关系映射文件

(4) 查询所有航班信息

(5) 查询[上海浦东]飞[北京首都]航班信息

(6) 查询[长沙黄花]飞[北京南苑]且票价小于800元的航班信息

(7) 更新航班信息

第12章编写Hibernate第一个程序【首页】杜老师

实训使用Hibernate查询学生列表(所有学生成绩)