SSH2框架实现登陆功能

傷城~ 2021-09-28 03:40 322阅读 0赞

### SSH2实现登陆功能 ###

*   *   *  一、框架的搭建
         *  二、数据库设计
         *  三、各配置文件更新
         *   *   *  1、applicationContext.xml
                 *  2、struts.xml
         *  四、各层级代码
         *   *   *  1、dao层
                 *  2、service层
                 *  3、action层
                 *  4、entity层
         *  五、页面展示
         *   *   *  1、index.jsp
                 *  2、success.jsp
                 *  3、404.jsp
         *  六、结果展示

### 一、框架的搭建 ###

该功能是基于spring4+hibernate4+struts2框架下实现的，具体框架的搭建可以参考：[https://blog.csdn.net/lxw983520/article/details/85704506][https_blog.csdn.net_lxw983520_article_details_85704506]  
SSH框架分为四层：表示层、业务逻辑层、数据持久层和域模块层（实体层）。  
spring：负责查找、定位、创建和管理对象及对象之间的依赖关系；  
Struts：系统的整体基础架构，负责MVC的分离，在Struts框架的模型部分，控制业务跳转，利用Hibernate框架对持久层提供支持；  
Hibernate：对象关系映射框架，对JDBC进行了非常轻量级的对象封装。

### 二、数据库设计 ###

这边设计一个简单的用户表，主要包含用户名称(userName)，用户密码(password)，用户Id(id**主键**)三个字段。sql脚本如下：

SET NAMES utf8mb4;
    SET FOREIGN_KEY_CHECKS = 0;
    
    -- ----------------------------
    -- Table structure for user
    -- ----------------------------
    DROP TABLE IF EXISTS `sys_user`;
    CREATE TABLE `sys_user`  (
      `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
      `userName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用户名称',
      `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用户密码',
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
    
    SET FOREIGN_KEY_CHECKS = 1;

### 三、各配置文件更新 ###

##### 1、applicationContext.xml #####

<?xml version="1.0" encoding="UTF-8"?>
    <beans
    	xmlns="http://www.springframework.org/schema/beans"
    	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    	xmlns:p="http://www.springframework.org/schema/p"
    	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.1.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd" xmlns:tx="http://www.springframework.org/schema/tx">
    	
    	<bean id="dataSource"
    		class="org.apache.commons.dbcp.BasicDataSource">
    		<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
    		<property name="url"
    			value="jdbc:mysql://localhost:3306/liuxw?characterEncoding=utf8">
    		</property>
    		<property name="username" value="root"></property>
    		<property name="password" value="123456"></property>
    	</bean>
    	
    	<bean id="sessionFactory"
    		class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
    		
    		<property name="dataSource">
    			<ref bean="dataSource" />
    		</property>
    		
    		<property name="hibernateProperties">
    			<props>
    				<prop key="hibernate.dialect">
    					org.hibernate.dialect.MySQLDialect
    				</prop>
    				
    				<prop key="hibernate.show_sql">
    					true
    				</prop>
    			</props>
    		</property>
    		
    		<property name="mappingResources">
    			<list>
    				<value>ssh2/com/entity/SysUser.hbm.xml</value></list>
    		</property>
    	</bean>
    	
    	
    	<bean id="transactionManager"
    		class="org.springframework.orm.hibernate4.HibernateTransactionManager">
    		<property name="sessionFactory" ref="sessionFactory" />
    	</bean>
    	<tx:annotation-driven transaction-manager="transactionManager" />
    	
    	
    	<bean id="userAction" class="ssh2.com.action.UserAction" scope="prototype">
    		<property name="userService">
    		<ref bean="userService" />
    		</property>
    	</bean>
    	
    	
    	<bean id="userService" class="ssh2.com.service.UserService">
    		<property name="userDao">
    		<ref bean="userDao" />
    		</property>
    	</bean>
    	
    	
    	<bean id="userDao" class="ssh2.com.dao.UserDao">
    		<property name="sessionFactory">
    		<ref bean="sessionFactory" />
    		</property>
    	</bean>	
    </beans>

##### 2、struts.xml #####

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.1//EN" "http://struts.apache.org/dtds/struts-2.1.dtd">
    <struts>
    <constant name="struts.i18n.encoding" value="UTF-8"/>
    
    	<package name="ssh2" extends="struts-default" namespace="/">
    		<action name="login" class="userAction" method="login">
    		
    			<result name="loginSuccess">/success.jsp</result>
    			<result name="404">/404.jsp</result>
    		</action>		
    	</package>
    </struts>

### 四、各层级代码 ###

##### 1、dao层 #####

该层主要是使用hibernate来进行数据库操作。

package ssh2.com.dao;
    
    import java.util.List;
    
    import org.hibernate.SQLQuery;
    import org.hibernate.SessionFactory;
    
    import ssh2.com.entity.SysUser;
    
    /**
     * @author lxw
     */
    public class UserDao {
    	private SessionFactory sessionFactory;
    	
    	public SessionFactory getSessionFactory() {
    		return sessionFactory;
    	}
    
    	public void setSessionFactory(SessionFactory sessionFactory) {
    		this.sessionFactory = sessionFactory;
    	}
    	
    	//用户登陆
    	public SysUser login(String name,String password) {
    		System.out.println("用户登录Dao");
    		String sql = "select * from sys_user where userName=? and password=?";
    		SQLQuery sqlQuery = this.sessionFactory.getCurrentSession().createSQLQuery(sql);
    		//获取第一个参数
    		sqlQuery.setParameter(0, name);
    		//获取第二个参数
    		sqlQuery.setParameter(1, password);
    		sqlQuery.addEntity(SysUser.class);
    		return (SysUser) sqlQuery.list().get(0);
    	}		
    }

##### 2、service层 #####

调用dao层。

package ssh2.com.service;
    
    import java.util.List;
    
    import org.springframework.transaction.annotation.Transactional;
    
    import ssh2.com.dao.UserDao;
    import ssh2.com.entity.SysUser;
    
    /**
     * @author lxw
     */
    @Transactional       	//事务注解
    public class UserService {
    	private UserDao userDao;
    
    	public UserDao getUserDao() {
    		return userDao;
    	}
    
    	public void setUserDao(UserDao userDao) {
    		this.userDao = userDao;
    	}
    	
    	//用户登陆，主要调用Dao层
    	public SysUser login(String name,String password) {
    		System.out.println("用户登录Service");
    		return userDao.login(name,password);
    	}
    }

##### 3、action层 #####

调用service层。

package ssh2.com.action;
    import com.opensymphony.xwork2.ActionContext;
    import com.opensymphony.xwork2.ActionSupport;
    
    import ssh2.com.entity.SysUser;
    import ssh2.com.service.UserService;
    
    /**
     * @author lxw
     */
    public class UserAction extends ActionSupport {
    
    	private static final long serialVersionUID = 1L;
    
    	private SysUser sysUser;
    	
    	private UserService userService;
    	
    	public static long getSerialversionuid() {
    		return serialVersionUID;
    	}
    	
    	//用户登录信息
    	public String login(){
    		System.out.println("保存用户信息Action");
    		sysUser = userService.login(sysUser.getUserName(),sysUser.getPassword());
    		if(sysUser != null){
    			return "loginSuccess";
    		}
    		return "404";
    	}	
    		
    	public SysUser getSysUser() {
    		return sysUser;
    	}
    	public void setSysUser(SysUser sysUser) {
    		this.sysUser = sysUser;
    	}
    	
    	public UserService getUserService() {
    		return userService;
    	}
    	public void setUserService(UserService userService) {
    		this.userService = userService;
    	}
    }

##### 4、entity层 #####

该层的实体类以及映射关系文件主要是利用myeclipse中的hibernate工具生成。主要操作如下：  
![获取数据库][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x4dzk4MzUyMA_size_16_color_FFFFFF_t_70]  
![工具使用][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x4dzk4MzUyMA_size_16_color_FFFFFF_t_70 1]  
![选择生成位置][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x4dzk4MzUyMA_size_16_color_FFFFFF_t_70 2]  
接下来一直next即可，生成后的文件有：  
![结果展示][20190127094155342.png]

### 五、页面展示 ###

##### 1、index.jsp #####

该文件为登陆界面，项目启动的时候默认会进入该页面，也可以根据自己的喜好新建新的页面名称。页面采用form表单提交账号密码，并且页面引入s便签进行传参。

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
    <%
    String path = request.getContextPath();
    String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
    %>
    <%@ taglib prefix="s" uri="/struts-tags" %>
    
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html>
      <head>
        <base href="<%=basePath%>">
        
        <title>用户登录</title>
    	<meta http-equiv="pragma" content="no-cache">
    	<meta http-equiv="cache-control" content="no-cache">
    	<meta http-equiv="expires" content="0">    
    	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    	<meta http-equiv="description" content="首页">
    	
      </head>
      
      <body>
        <h1>欢迎使用</h1>
     		<s:form action="login" method="post">
       		<table>
       			<tr>
       				<s:textfield name="sysUser.userName" label="用户名"/>
       				<s:password name="sysUser.password" label="密码"/>
       			</tr>
       			<tr>
       				<s:submit value="sumbit"/><s:reset value="reset"/>
       			</tr>
       		</table>
    	</s:form>
      </body>
    </html>

##### 2、success.jsp #####

该页面为登陆成功页面，也就是校验账号密码成功后会跳转到该页面。

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
    <%
    String path = request.getContextPath();
    String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
    %>
    
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html>
      <head>
        <base href="<%=basePath%>">
        
        <title>登陆成功</title>
        
    	<meta http-equiv="pragma" content="no-cache">
    	<meta http-equiv="cache-control" content="no-cache">
    	<meta http-equiv="expires" content="0">    
    	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    	<meta http-equiv="description" content="成功页面">
    	
    
      </head>
      
      <body>
        <h1>登陆成功</h1>
      </body>
    </html>

##### 3、404.jsp #####

该页面是登陆账号密码校验失败返回的页面。

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
    <%
    String path = request.getContextPath();
    String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
    %>
    
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html>
      <head>
        <base href="<%=basePath%>">
        
        <title>No Find</title>
        
    	<meta http-equiv="pragma" content="no-cache">
    	<meta http-equiv="cache-control" content="no-cache">
    	<meta http-equiv="expires" content="0">    
    	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    	<meta http-equiv="description" content="错误页面">
    	
    
      </head>
      
      <body>
        <h1>404</h1>
      </body>
    </html>

**备注：** jsp页面都是简单的输入框和显示，如果需要可以换成自己想要的样式页面。

> 这边简单展示各层代码，主要难点在于jsp和action之间的参数传递，如何利用form表单提交，并在action中获取jsp提交的值。

### 六、结果展示 ###

![登陆页面][20190127094558360.png]  
输入数据库相关账号密码就可以获取成功或者404页面。

[https_blog.csdn.net_lxw983520_article_details_85704506]: https://blog.csdn.net/lxw983520/article/details/85704506
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x4dzk4MzUyMA_size_16_color_FFFFFF_t_70]: /images/20210923/d88432a89ad64c42895e97504543200b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x4dzk4MzUyMA_size_16_color_FFFFFF_t_70 1]: /images/20210923/ee981905c8a940ef9034d91b670b7b61.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x4dzk4MzUyMA_size_16_color_FFFFFF_t_70 2]: /images/20210923/1efb85cde3b447a09e55b595b7bed900.png
[20190127094155342.png]: /images/20210923/59b4372053e345259d8512ff36c73792.png
[20190127094558360.png]: /images/20210923/935b5cc069c043cf9de0e92b6413ca52.png