SSH2实现登陆功能
一、框架的搭建
该功能是基于spring4+hibernate4+struts2框架下实现的,具体框架的搭建可以参考: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>
<!--Hibernate相关配置:这边主要是spring4和hibernate4 -->
<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>
<!-- 打印sql语句 -->
<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" />
<!--配置Action -->
<bean id="userAction" class="ssh2.com.action.UserAction" scope="prototype">
<property name="userService">
<ref bean="userService" />
</property>
</bean>
<!--配置Service -->
<bean id="userService" class="ssh2.com.service.UserService">
<property name="userDao">
<ref bean="userDao" />
</property>
</bean>
<!-- 配置Dao -->
<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"/>
<!-- Action的类由spring去维护 -->
<package name="ssh2" extends="struts-default" namespace="/">
<action name="login" class="userAction" method="login">
<!-- 登陆成功进入成功页面,失败进入404页面-->
<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工具生成。主要操作如下:
接下来一直next即可,生成后的文件有:
五、页面展示
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="首页">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</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="成功页面">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</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="错误页面">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<h1>404</h1>
</body>
</html>
备注: jsp页面都是简单的输入框和显示,如果需要可以换成自己想要的样式页面。
这边简单展示各层代码,主要难点在于jsp和action之间的参数传递,如何利用form表单提交,并在action中获取jsp提交的值。
六、结果展示
输入数据库相关账号密码就可以获取成功或者404页面。