struts2 + hibernate整合小项目

最近在做一个Struts2 + hibernate的项目,之前了解过但是没有做过,为了联系一下,写了一个简单的登录验证熟悉一下。

前期准备

界面没有美化,也就是简单的表单,比较丑,就这样将就着用吧。以下是整个项目的结构:
比较简单,前期需要把相应的包给建好,然后还有jsp页面写好。
按照下图所示将所需要的包给建立好,
在该包结构中,action代表对页面进行处理的action,dao包内的为数据库相关操作所需要的接口,dao.impl包内为数据库操作相关接口的实现,model包内为数据库中表所对应的实体类以及User.hbm.xml文件,util为所使用到的相关工具类。
下图是本工程所需要用到的jar包,需要准备一下,

另外还需要新建一个数据库,我这里数据库名字为hibernate,

页面

页面比较简单,登录页面代码如下所示,
  
<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!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>登录</title>
</head>
<body>
 <form action="userlogin">
    用户名 : <input name="username" type="text"><br>
    密码 : <input name="password" type="password"><br>
    <input type="submit" value="提交"><br>
    <input type="reset" value="重置"><br>
 </form>
</body>
</html>
登录页面成功界面代码如下所示,
<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!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>登录成功</title>
</head>
<body>
<h1>欢迎你,登录成功!</h1>
</body>
</html>
web.xml中的内容如下,
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
  <display-name>practice</display-name>
  <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>
  <welcome-file-list>
    <welcome-file>index.html</welcome-file>
    <welcome-file>index.htm</welcome-file>
    <welcome-file>index.jsp</welcome-file>
    <welcome-file>default.html</welcome-file>
    <welcome-file>default.htm</welcome-file>
    <welcome-file>default.jsp</welcome-file>
  </welcome-file-list>
</web-app>

包内的具体类,

用户的实体类,
package hpu.edu.model;

public class User {
      private String username;//用户名
      private String password;//密码
      private Integer id;//id
	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;
	}
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
      
}

实体类所对应的User.hbm.xml,
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2014-12-14 14:51:48 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
    <class name="hpu.edu.model.User" table="TABLE_USER">
        <id name="id" type="java.lang.Integer">
            <column name="ID" />
            <generator class="uuid" />
        </id>
        <property name="password" type="java.lang.String">
            <column name="PASSWORD" />
        </property>
        <property name="username" type="java.lang.String">
            <column name="USERNAME" />
        </property>
    </class>
</hibernate-mapping>

dao包内的接口,
package hpu.edu.dao;

import java.util.List;

import org.hibernate.Session;

public interface BaseDao {
       public Session getSession();
       public void closeSession();
       public List search(String hql);
}

package hpu.edu.dao;

import java.util.List;

import hpu.edu.model.User;

public interface UserDao{
    public void saveUser(User user);
    public List<User> getAll(Class clazz);
    public User isValidAdmin(String username,String password);
}

实现接口,
package hpu.edu.dao.impl;

import java.util.List;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import org.hibernate.service.ServiceRegistryBuilder;

import hpu.edu.dao.BaseDao;

public class BaseDaoImpl implements BaseDao{
	private SessionFactory sessionFactory;
	private Session session;
	private Transaction transaction;
	
	public void init(){
		Configuration configuration = new Configuration().configure();
		ServiceRegistry serviceRegistry = new ServiceRegistryBuilder().applySettings(configuration.getProperties()).buildServiceRegistry();
		sessionFactory = configuration.buildSessionFactory(serviceRegistry);
		
		session = sessionFactory.openSession();
		transaction = session.beginTransaction();
	}
	@Override
	public Session getSession() {
		init();
		return session;
	}

	@Override
	public void closeSession() {
		session.close();
	}

	@Override
	public List search(String hql) {
		Session session = null;
		session = getSession();
		List alist = null;
		alist = session.createQuery(hql).list();
		session.close();
		return alist;
	}

}

package hpu.edu.dao.impl;

import java.util.List;

import hpu.edu.dao.UserDao;
import hpu.edu.model.User;

public class UserDaoImpl extends BaseDaoImpl implements UserDao{

	@Override
	public void saveUser(User user) {
		// TODO Auto-generated method stub
		
	}

	@Override
	public List<User> getAll(Class clazz) {
		// TODO Auto-generated method stub
		return null;
	}

	@Override
	public User isValidAdmin(String username, String password) {
		User user = null;
		System.out.println("AAAAAAAAAAAAAAAA");
		@SuppressWarnings("unchecked")
		List<User> list = super.search("FROM User where username = '" + username + "' and password = '"+ password + "'");
		if(list != null && list.size() > 0){
			user = list.get(0);             
			System.out.println(user.getUsername());
			System.out.println(user.getPassword());
		}
		return user;
	}

}

action中的操作,
package hpu.edu.action;

import java.util.Map;

import org.apache.struts2.interceptor.SessionAware;

import com.opensymphony.xwork2.ActionSupport;

import hpu.edu.dao.UserDao;
import hpu.edu.dao.impl.UserDaoImpl;
import hpu.edu.model.User;

public class LoginAction extends ActionSupport implements SessionAware{

	private static final long serialVersionUID = 1L;
	UserDao dao = new UserDaoImpl();
	private String username;
	private String password;
	private Map<String,Object> session;
	
	public String execute(){
		User user = dao.isValidAdmin(username, password);
		if(user != null){
			session.put("user", user);
			return SUCCESS;
		}else{
			addActionError("你没有该权限");
			return INPUT;
		}
	}
	
	public UserDao getDao() {
		return dao;
	}

	public void setDao(UserDao dao) {
		this.dao = dao;
	}

	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;
	}

	public static long getSerialversionuid() {
		return serialVersionUID;
	}

	public Map<String, Object> getSession() {
		return session;
	}

	@Override
	public void setSession(Map session) {
		this.session = session;
	}

}

配置文件

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">
<hibernate-configuration>
    <session-factory>
        <property name="connection.username">root</property>
        <property name="connection.password">root</property>
        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
    	<property name="connection.url">jdbc:mysql://localhost:3306/hibernate</property>
    	
    	<property name="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>
        <property name="show_sql">true</property>
        <property name="hibernate.format_sql">true</property>
        <property name="hibernate.hbm2ddl.auto">update</property>
        
        <mapping resource="hpu/edu/model/User.hbm.xml" />
    </session-factory>
</hibernate-configuration>

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" extends="struts-default">
    	
    	<action name="index">
    		<result>/index.jsp</result>
    	</action>
    	
    	<action name="userlogin" class="hpu.edu.action.LoginAction">
    		<result name="success">/success.jsp</result>
    		<result name="input">/index.jsp</result>
    	</action>
    </package>

</struts>

到这里基本上已经完成。

错误

在这里说一下我出错的地方,在User.hbm.xml中设置id为自增时,使用了错误的类型,正确的使用方法为, <generator class="uuid" />,
在实现接口的时候,hql语句中,super.search("FROM User where username = '" + username + "' and password = '"+ password + "'");与数据库表所对应的应写实体类名,而我写的是数据库表名。


评论 7
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值