由MyEclipse下导入的Hibernate的jar包
Struts2基本jar包和MySql驱动jar包
源代码文件
数据库脚本
create database hibernate;
use hibernate;
create table if not exists user (
id int primary key,
name varchar(20),
pass varchar(20)
};
web.xml 配置文件
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5"
xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
<filter>
<filter-name>struts2</filter-name>
<filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>struts2</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
</web-app>
struts2的配置文件 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="struts2" extends="struts-default">
<action name="submitAction" class="org.zbq.struts.SubmitAction" method="save">
<result name="success">/list.jsp</result>
</action>
</package>
</struts>
Hibernate配置文件hibernate.cfg.xml
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<!-- Generated by MyEclipse Hibernate Tools. -->
<hibernate-configuration>
<session-factory>
<property name="connection.driver_class">org.gjt.mm.mysql.Driver</property>
<property name="connection.url">jdbc:mysql://localhost:3306/hibernate</property>
<property name="connection.username">root</property>
<property name="connection.password">mysqladmin</property>
<property name="show_sql">true</property>
<mapping resource="org/zbq/bean/User.hbm.xml"/>
</session-factory>
</hibernate-configuration>
package org.zbq.bean;
public class User {
private int id;
private String name;
private String pass;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPass() {
return pass;
}
public void setPass(String pass) {
this.pass = pass;
}
}
<?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="org.zbq.bean.User" table="user">
<id name="id" column="id" type="int">
<generator class="increment"></generator>
</id>
<property name="name" column="name" type="string"/>
<property name="pass" column="pass" type="string"/>
</class>
</hibernate-mapping>
package org.zbq.struts;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import org.apache.struts2.ServletActionContext;
import org.zbq.bean.User;
import org.zbq.util.HibernateUtil;
import com.opensymphony.xwork2.Action;
public class SubmitAction implements Action {
private User user;
public User getUser() {
return user;
}
public void setUser(User user) {
this.user = user;
}
public String save() throws Exception {
HibernateUtil.save(user);
List<User> list = HibernateUtil.list();
HttpServletRequest request = ServletActionContext.getRequest();
request.setAttribute("list", list);
return SUCCESS;
}
public String execute() throws Exception {
return SUCCESS;
}
}
HibernateUtil.java
package org.zbq.util;
import java.util.ArrayList;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.zbq.bean.User;
public class HibernateUtil {
private static SessionFactory sessionFactory;
static {
try {
Configuration conf = new Configuration().configure();
// conf.addClass(User.class);
sessionFactory = conf.buildSessionFactory();
} catch (Exception e) {
e.printStackTrace();
}
}
public static void save(User user) throws Exception {
Session session = sessionFactory.openSession();
Transaction tx = null;
try {
tx = session.beginTransaction();
tx.begin();
session.save(user);
tx.commit();
} catch (Exception e) {
if (null != tx){
tx.rollback();
}
e.printStackTrace();
} finally {
session.close();
}
}
@SuppressWarnings("unchecked")
public static List<User> list() throws Exception{
List<User> list = new ArrayList<User>();
Session session = sessionFactory.openSession();
Transaction tx = null;
try {
tx = session.beginTransaction();
tx.begin();
Query query = session.createQuery("from User");
list = query.list();
tx.commit();
} catch (Exception e) {
e.printStackTrace();
} finally {
session.close();
}
return list;
}
}
index.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body>
<form action="submitAction">
Name:<input type="text" name="user.name"/><br/>
Pass:<input type="text" name="user.pass"/><br/>
<input type="submit" value="submit">
</form>
</body>
</html>
list.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body>
<table border="1">
<tr>
<td>Name</td>
<td>Pass</td>
</tr>
<s:iterator value="#request.list" id="user">
<tr>
<td><s:property value="name"/></td>
<td><s:property value="pass"/></td>
</tr>
</s:iterator>
</table>
</body>
</html>