使用Struts2+Hibernate开发学生信息管理功能1

第一章：Struts2与Hibernate整合

1.课程简介

2.界面原型演示

3.Struts2与Hibernate整合

4.创建实体类

5.生成实体映射文件

6.生成表结构

1.课程简介

• Struts2+Hibernate4实现的简单的CRUD案例
• 完成功能：

　　后台登录

　　学生表的增删改查

环境：Struts2.3.4+Hibernate4.2.4+MySQL6.0

2.界面原型演示

• 界面演示

3.Struts2与Hibernate整合

• 创建struts2和hibernate用户类库
• 导入struts2与hibernate的jar包
• 配置web.xml
• 创建struts.xml
• 配置hibernate.cfg.xml

配置web.xml

 创建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>
    <package name="default" namespace="/" extends="struts-default">

       
    </package>
</struts>

 配置hibernate.cfg.xml

<!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="connection.username">root</property>
		<property name="connection.password">123456</property>
	    <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
		<property name="connection.url">jdbc:mysql:///test?useUnicode=true&characterEncoding=UTF-8</property>
		<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
		<property name="show_sql">true</property>
		<property name="format_sql">true</property>
		<property name="hbm2ddl.auto">update</property>
		<property name="hibernate.current_session_context_class">thread</property>		
		
	</session-factory>
</hibernate-configuration>

4.创建实体类

创建两个实体类：用户类、学生类，对应两个表

• 用户表
• 学生表

用户类

package entity;
//用户类
public class Users {

	private int uid;
	private String username;
	private String password;
	//保留不带参数的构造方法
	public Users() {
		
	}	
	
	public Users(int uid, String username, String password) {
		//super();
		this.uid = uid;
		this.username = username;
		this.password = password;
	}

	public int getUid() {
		return uid;
	}
	
	public void setUid(int uid) {
		this.uid = uid;
	}
	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;
	}
	
	
}

 学生类

package entity;

import java.util.Date;

//学生类
public class Students {

	private String sid;//学号
	private String sname;//姓名
	private String gender;//性别
	private Date birthday;//出生日期
	private String address;//地址
	
	public Students() {
		
	}
	
		
	public Students(String sid, String sname, String gender, Date birthday,
			String address) {
		//super();
		this.sid = sid;
		this.sname = sname;
		this.gender = gender;
		this.birthday = birthday;
		this.address = address;
	}


	public String getSid() {
		return sid;
	}
	public void setSid(String sid) {
		this.sid = sid;
	}
	public String getSname() {
		return sname;
	}
	public void setSname(String sname) {
		this.sname = sname;
	}
	public String getGender() {
		return gender;
	}
	public void setGender(String gender) {
		this.gender = gender;
	}
	public Date getBirthday() {
		return birthday;
	}
	public void setBirthday(Date birthday) {
		this.birthday = birthday;
	}
	public String getAddress() {
		return address;
	}
	public void setAddress(String address) {
		this.address = address;
	}


	@Override
	public String toString() {
		return "Students [sid=" + sid + ", sname=" + sname + ", gender="
				+ gender + ", birthday=" + birthday + ", address=" + address
				+ "]";
	}	
	
}

5.生成实体映射文件

• Users.hbm.xml
• Students.hbm.xml

Users.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping>

    <class name="entity.Users" table="USERS">
        <id name="uid" type="int">
            <generator class="native"/>
        </id>
        <property name="username" type="java.lang.String"/>
		<property name="password" type="java.lang.String"/>
    </class>

</hibernate-mapping>

 Students.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping>

    <class name="entity.Students" table="STUDENTS">
    <!-- 学号长度8位 -->
        <id name="sid" type="java.lang.String" length="8">
        <!-- assigned手工赋值 -->
            <generator class="assigned"/>
        </id>
        <property name="sname" type="java.lang.String"/>
		<property name="gender" type="java.lang.String"/>
		<property name="birthday" type="date"/>
		<property name="address" type="java.lang.String"/>
    </class>

</hibernate-mapping>

6.生成表结构

• 使用SchemaExport生成表结构

　　把刚才生成的两个对象关系映射文件加到主配置文档hibernate.cfg.xml当中

<!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="connection.username">root</property>
		<property name="connection.password">123456</property>
	    <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
		<property name="connection.url">jdbc:mysql:///test?useUnicode=true&characterEncoding=UTF-8</property>
		<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
		<property name="show_sql">true</property>
		<property name="format_sql">true</property>
		<property name="hbm2ddl.auto">update</property>
		<property name="hibernate.current_session_context_class">thread</property>		
		
		<mapping resource="entity/Students.hbm.xml"/>
		<mapping resource="entity/Users.hbm.xml"/>
	</session-factory>
</hibernate-configuration>

使用SchemaExport生成表结构

TestStudents.java

package entity;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import org.hibernate.service.ServiceRegistryBuilder;
import org.hibernate.tool.hbm2ddl.SchemaExport;
import org.junit.Test;

public class TestStudents {

	@Test
	public void testSchemaExport(){
		
		//创建配置对象
		Configuration config=new Configuration().configure();
		//创建服务注册对象
		ServiceRegistry serviceRegistry=new ServiceRegistryBuilder().applySettings(config.getProperties()).buildServiceRegistry();
		//创建sessionFactory
		SessionFactory sessionFactory=config.buildSessionFactory(serviceRegistry);
		//创建session对象
		Session session = sessionFactory.getCurrentSession();
		//创建SchemaExport对象
		SchemaExport export = new SchemaExport(config);
		export.create(true, true);//第一个参数表示生成表结构，第二个参数表示输出sql语句
	}
}