hibernate.cfg.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="hibernate.connection.driver_class">oracle.jdbc.OracleDriver</property>
<property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:ORCL</property>
<property name="hibernate.connection.username">scott</property>
<property name="hibernate.connection.password">123</property>
<!-- 配置数据库发言 -->
<property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
<!-- 将执行的sql语句输出到控制台上 -->
<property name="show_sql" />
<!-- 将输出的sql语句进行格式化 -->
<property name="format_sql" />
<!-- 配置hbm.xml文件 -->
<mapping resource="com/mingde/po/Classes.hbm.xml"/>
<mapping resource="com/mingde/po/Students.hbm.xml"/>
<mapping resource="com/mingde/po/UserInfo.hbm.xml"/>
</session-factory>
</hibernate-configuration>
创建实体类
Classes.java
package com.mingde.po;
import java.sql.Date;
public class Classes {
private int cid;
private String cname;
private Date copendate;
public Classes() {
super();
}
public Classes(int cid, String cname, Date copendate) {
super();
this.cid = cid;
this.cname = cname;
this.copendate = copendate;
}
public int getCid() {
return cid;
}
public void setCid(int cid) {
this.cid = cid;
}
public String getCname() {
return cname;
}
public void setCname(String cname) {
this.cname = cname;
}
public Date getCopendate() {
return copendate;
}
public void setCopendate(Date copendate) {
this.copendate = copendate;
}
@Override
public String toString() {
return "Classes [cid=" + cid + ", cname=" + cname + ", copendate=" + copendate + "]";
}
}
Students.java
package com.mingde.po;
import java.sql.Date;
public class Students {
private int sid;
private String sname;
private String ssex;
private Date sdate;
private int cid;
//在学生实体类中可查询出其对应的账户信息
private UserInfo userinfo;
public Students() {
super();
}
public Students(int sid, String sname, String ssex, Date sdate, int cid) {
super();
this.sid = sid;
this.sname = sname;
this.ssex = ssex;
this.sdate = sdate;
this.cid = cid;
}
public Students(int sid, String sname, String ssex, Date sdate, int cid, UserInfo userinfo) {
super();
this.sid = sid;
this.sname = sname;
this.ssex = ssex;
this.sdate = sdate;
this.cid = cid;
this.userinfo = userinfo;
}
public int getSid() {
return sid;
}
public void setSid(int sid) {
this.sid = sid;
}
public String getSname() {
return sname;
}
public void setSname(String sname) {
this.sname = sname;
}
public String getSsex() {
return ssex;
}
public void setSsex(String ssex) {
this.ssex = ssex;
}
public Date getSdate() {
return sdate;
}
public void setSdate(Date sdate) {
this.sdate = sdate;
}
public int getCid() {
return cid;
}
public void setCid(int cid) {
this.cid = cid;
}
public UserInfo getUserinfo() {
return userinfo;
}
public void setUserinfo(UserInfo userinfo) {
this.userinfo = userinfo;
}
@Override
public String toString() {
return "Students [sid=" + sid + ", sname=" + sname + ", ssex=" + ssex + ", sdate=" + sdate + ", cid=" + cid
+ ", userinfo=" + userinfo + "]";
}
}
UserInfo.java
package com.mingde.po;
public class UserInfo {
private int userid;
private String username;
private String password;
//关联学生类
private Students students;
public UserInfo() {
super();
}
public UserInfo(int userid, String username, String password) {
super();
this.userid = userid;
this.username = username;
this.password = password;
}
public Students getStudents() {
return students;
}
public void setStudents(Students students) {
this.students = students;
}
public int getUserid() {
return userid;
}
public void setUserid(int userid) {
this.userid = userid;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
@Override
public String toString() {
return "Userinfo [userid=" + userid + ", username=" + username + ", password=" + password + "]";
}
}
hbm.xml文件配置
Classes.hbm.xml
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2017-8-4 15:41:45 by Hibernate Tools 3.5.0.Final -->
<hibernate-mapping>
<class name="com.mingde.po.Classes" table="CLASSES">
<id name="cid" type="int">
<column name="CID" />
<generator class="assigned" />
</id>
<property name="cname" type="java.lang.String">
<column name="CNAME" />
</property>
<property name="copendate" type="java.sql.Date">
<column name="COPENDATE" />
</property>
</class>
</hibernate-mapping>
Students.hbm.xml
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2017-8-4 15:51:26 by Hibernate Tools 3.5.0.Final -->
<hibernate-mapping>
<class name="com.mingde.po.Students" table="STUDENTS">
<!-- 定义主键 -->
<id name="sid" type="int">
<column name="SID" />
<generator class="sequence" >
<param name="sequence">sequ06</param>
</generator>
</id>
<!-- 定义除主键外的其它字段，用property标签定义 -->
<property name="sname" type="java.lang.String">
<column name="SNAME" />
</property>
<property name="ssex" type="java.lang.String">
<column name="SSEX" />
</property>
<property name="sdate" >
<column name="SDATE" />
</property>
<property name="cid" type="int">
<column name="CID" />
</property>
<!-- 定义一对一的共享主键关联关系 -->
<!--
cascade:代表级联，即对当前的对象作增、删、改操作时，也会对其级联的对象作相应的操作，可取值：
1、save-update:代表对当前对象添加、修改时，也会对关联的对象作添加、修改操作
2、delete:代表对当前对象删除时，也会对关联的对象作删除操作
3、all:相当于save-update+delete两个操作
4、delete-oraph:删除孤儿对象，就是代表对某个多方对象对应的一方对象删除后，那么其余的多方对象
就会失去对一方对象的关联，也就是相当于孤儿，使用此选项，当删除一方对象时会主动删除这些多余的孤儿对象。
5、all-delete-orpah:相当于前面的四项之和。
lazy="false":默认是false，所以不用写，这里是查询时会自动去加载查询所关联的类的信息
fetch="join":默认的，所以不用写，这里是查询关联的表时，使用连接查询
-->
<!-- 配置一对一关联映射 -->
<one-to-one name="userinfo" class="com.mingde.po.UserInfo" cascade="all" fetch="join" lazy="false" ></one-to-one>
</class>
</hibernate-mapping>
UserInfo.hbm.xml
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2017-8-4 15:51:26 by Hibernate Tools 3.5.0.Final -->
<hibernate-mapping>
<class name="com.mingde.po.UserInfo" table="USERINFO">
<id name="userid" type="int">
<column name="USERID" />
<!-- 这里的主键启用了外键，其主键值为students的主键值，这里使用了共享主键 -->
<generator class="foreign" >
<param name="property">students</param>
</generator>
</id>
<property name="username" type="java.lang.String">
<column name="USERNAME" />
</property>
<property name="password" type="java.lang.String">
<column name="PASSWORD" />
</property>
<!-- 配置一对一关联映射 -->
<one-to-one name="students" class="com.mingde.po.Students"></one-to-one>
</class>
</hibernate-mapping>
配置Utils包中的HibernateSessionFactory.java
package com.mingde.utils;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import org.hibernate.service.ServiceRegistryBuilder;
public class HibernateSessionFactory {
/** 引入sessionFactory (sessionFactory:session工厂) */
private static SessionFactory sessionFactory;
/**构造Configuration配置 */
private static Configuration config=new Configuration();
/**定义一个ThreadLocal(本地路线)对象用于存放session (仅仅用于存放session，好来判断SessionFactory是否为空)*/
private static ThreadLocal<Session> threadLocal=new ThreadLocal<>();
static{
//1.读取放在classpath下的全局文件hibernate.cfg.xml
config.configure();
//2.构造ServiceRegistry对象（注册服务） 通过在classpath下的全局文件hibernate.cfg.xml的配置建立起注册服务
ServiceRegistry sr=new ServiceRegistryBuilder()
.applySettings(config.getProperties())
.buildServiceRegistry();
//3.生成一个sessionFactory
sessionFactory =config.buildSessionFactory(sr);
}
//获取session对象
public static Session getSession(){
Session session=threadLocal.get();
//threadLocal（本地路线）是用来存放sessioin的，是用来判断session里面是否有已经有打开了的工厂，以确保可以正常开工，
//如果session里面没有工厂,那么就进行重新创注册服务的sessionFactory（sessioin工厂）工厂（sessionFactory）,如果有那就进行下面的操作，打开session进行工作
if(null==session || !session.isOpen()){
if(sessionFactory == null){
//重新创建起session工厂
rebuildSessionFactory();
}
}
//如果sessionFactory工厂不为空，那么就让sessionFactory工厂将session打开,然后将其赋给session，打开了的sessionFactory工厂可以进行开工；（比如：开启事务，执行命令，提交事务，回滚事务）
session=(sessionFactory!=null)?sessionFactory.openSession():null;
//将session设置到threadLocal中
threadLocal.set(session);
return session;
}
//重建sessionFactory
private static void rebuildSessionFactory() {
//1.读取hibernate.cfg.xml
config.configure();
//2.构造ServiceRegistry对象（注册服务） 先new一个注册服务对象，然后请求设置安装配置性能，接着建立起服务注册对象
ServiceRegistry serviceRegistry =new ServiceRegistryBuilder()
.applySettings(config.getProperties())
.buildServiceRegistry();
//3.利用配置建立生成一个注册服务的sessionFactory（sessioin工厂）
sessionFactory =config.buildSessionFactory(serviceRegistry);
}
//关闭session
public static void closeSession(){
//将threadLocal的值session值赋给sessioin，然后将threadLocal的值设置为空，如果session的值不为空，那么就关闭清空session
Session session=threadLocal.get();
threadLocal.set(null);
if(session!=null){
session.close();
}
}
}
Struts.xml文件配置
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 2.3//EN"
"http://struts.apache.org/dtds/struts-2.3.dtd">
<struts>
<constant name="struts.enable.DynamicMethodInvocation" value="true"></constant>
<constant name="struts.devMode" value="true"></constant>
<package name="struts" extends="struts-default" >
<action name="*_*" class="com.mingde.action.StudentsAction" method="{2}" >
<result name="{2}">/WEB-INF/{1}/{2}.jsp</result>
<result name="to_list" type="redirect">{1}_list</result>
</action>
</package>
</struts>
Action类
package com.mingde.action;
import java.util.ArrayList;
import java.util.List;
import com.mingde.dao.IBaseDao;
import com.mingde.dao.impl.BaseDaoImpl;
import com.mingde.po.Classes;
import com.mingde.po.Students;
import com.opensymphony.xwork2.ActionSupport;
@SuppressWarnings("serial")
public class StudentsAction extends ActionSupport {
private List<Students> slist=new ArrayList<>();
private IBaseDao bd=new BaseDaoImpl();
private List<Classes> clist=new ArrayList<>();
private Students st=new Students();
public String list() throws Exception {
//因为关联了一对一，所以会将其用户表一同查询
slist=bd.findAll("from Students");
return "list";
}
public String toAdd() throws Exception {
clist=bd.findAll("from Classes");
return "toAdd";
}
public String toUpdate() throws Exception {
clist=bd.findAll("from Classes");
//因为关联了一对一，所以会将其用户表一同查询
st=(Students) bd.findOne(Students.class,st.getSid());
return "toUpdate";
}
public String add() throws Exception {
st.getUserinfo().setStudents(st); //建立起学生→用户→学生关联关系，保持一对一的连接
bd.add(st);
return "to_list";
}
public String update() throws Exception {
st.getUserinfo().setStudents(st); //建立起学生→用户→学生关联关系，保持一对一的连接
bd.update(st);
return "to_list";
}
public String del() throws Exception {
//根据学生编号查询学生和该学生的用户
//(因为该将关联在一起的用户和一同删除，所以必须通过查询一同查询，
//若不查询直接删除的话，只会删除学生信息，而不会删除对应的用户)
st=(Students) bd.findOne(Students.class,st.getSid());
bd.del(st);
return "to_list";
}
/*********** get 和 set 方法 ****************/
public List<Students> getSlist() {
return slist;
}
public Students getSt() {
return st;
}
public void setSt(Students st) {
this.st = st;
}
public List<Classes> getClist() {
return clist;
}
public void setClist(List<Classes> clist) {
this.clist = clist;
}
public void setSlist(List<Students> slist) {
this.slist = slist;
}
}
Dao层
package com.mingde.dao.impl;
import java.util.List;
import org.hibernate.Session;
import org.hibernate.Transaction;
import com.mingde.dao.IBaseDao;
import com.mingde.po.Students;
import com.mingde.utils.HibernateSessionFactory;
public class BaseDaoImpl implements IBaseDao {
@Override
public List findAll(String hql) {
List list=null;
Session session =HibernateSessionFactory.getSession();
Transaction tx=null;
try {
//开启事务
tx=session.beginTransaction();
//执行命令
list=session.createQuery(hql).list();
//提交事务
tx.commit();
} catch (Exception e) {
e.printStackTrace();
//事务回滚
tx.rollback();
}finally{
//关闭事务
HibernateSessionFactory.closeSession();
}
return list;
}
@Override
public void add(Students st) {
Session session =HibernateSessionFactory.getSession();
Transaction tx=null;
try {
//开启事务
tx=session.beginTransaction();
//执行命令
session.save(st);
//提交事务
tx.commit();
} catch (Exception e) {
e.printStackTrace();
//事务回滚
tx.rollback();
}finally{
//关闭事务
HibernateSessionFactory.closeSession();
}
}
@Override
public Object findOne(Class<?> clazz, int sid) {
Students st=null;
//构造Session对象来存放工厂
Session session=HibernateSessionFactory.getSession();
//创建事务
Transaction tx=null;
try {
//开启事务
tx=session.beginTransaction();
//执行命令
st = (Students) session.get(clazz, sid);
//提交事务
tx.commit();
} catch (Exception e) {
e.printStackTrace();
//事务回滚
tx.rollback();
}finally{
//关闭事务
HibernateSessionFactory.closeSession();
}
return st;
}
@Override
public void update(Students st) {
//创建Session对象
Session session=HibernateSessionFactory.getSession();
//创建事务对象
Transaction tx=null;
try {
//开启事务
tx=session.beginTransaction();
//执行命令
session.update(st);
//提交事务
tx.commit();
} catch (Exception e) {
e.printStackTrace();
//数据回滚
tx.rollback();
}finally{
//关闭事务
HibernateSessionFactory.closeSession();
}
}
@Override
public void del(Students st) {
Session session=HibernateSessionFactory.getSession();
//创建事务
Transaction tx=null;
try {
//开启事务
tx=session.beginTransaction();
//执行命令
session.delete(st);
//提交事务
tx.commit();
} catch (Exception e) {
e.printStackTrace();
//事务回滚
tx.rollback();
}finally{
//关闭事务
HibernateSessionFactory.closeSession();
}
}
}
JSP页面
list.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<h2>列表</h2>
<table width=800 align="center" border=1 cellspacing=0 >
<tr>
<td colspan="8"><s:a href="students_toAdd">添加</s:a></td>
</tr>
<tr>
<th>编号</th><th>姓名</th><th>性别</th><th>生日</th><th>班级</th><th>用户名</th><th>密码</th><th>操作</th>
</tr>
<s:iterator value="slist">
<tr align='center'>
<td><s:property value="sid" /></td>
<td><s:property value="sname" /></td>
<td><s:property value="ssex" /></td>
<td><s:date format="yyyy-MM-dd" name="sdate" /></td>
<td><s:property value="cid" /></td>
<td><s:property value="userinfo.username" /></td>
<td><s:property value="userinfo.password" /></td>
<td>
<a href="students_toUpdate?st.sid=${sid}">修改</a>
<s:a href="students_del?st.sid=%{sid }" οnclick="return confirm('确定删除？')">删除</s:a>
</td>
</tr>
</s:iterator>
</table>
</body>
</html>
toAdd.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib prefix='s' uri="/struts-tags" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<h2>添加</h2>
<s:form action="students_add" >
<s:textfield name="st.sname" label="姓名" ></s:textfield>
<s:radio name="st.ssex" list="#{'M':'男','F':'女' }" value="'M'" label="性别" ></s:radio>
<s:textfield name="st.sdate" label="生日" ></s:textfield>
<s:select name="st.cid" list="clist" listKey="cid" listValue="cname" label="班级" ></s:select>
<s:textfield name="st.userinfo.username" label="用户名" ></s:textfield>
<s:password name="st.userinfo.password" label="密码"></s:password>
<s:submit value="添加"></s:submit>
</s:form>
</body>
</html>
toUpdate.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib prefix='s' uri="/struts-tags" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<h2>修改</h2>
<s:form action="students_update" >
<s:hidden name="st.sid"></s:hidden>
<s:hidden name="st.userinfo.userid"></s:hidden>
<s:textfield name="st.sname" label="姓名" ></s:textfield>
<s:radio name="st.ssex" list="#{'M':'男','F':'女' }" label="性别" ></s:radio>
<s:textfield name="st.sdate" label="生日" ></s:textfield>
<s:select name="st.cid" list="clist" listKey="cid" listValue="cname" label="班级" ></s:select>
<s:textfield name="st.userinfo.username" label="用户名" ></s:textfield>
<s:password name="st.userinfo.password" label="密码" showPassword="true"></s:password>
<s:submit value="修改"></s:submit>
</s:form>
</body>
</html>
