SSH2实现用户增删改查

落日映苍穹つ 2021-09-28 03:40 398阅读 0赞

### SSH2实现用户增删改查 ###

*   *   *  一、使用myeclipse搭建ssh2框架
         *  二、相关配置文件
         *  三、各个层级代码示例
         *   *   *  1、action层
                 *  2、service层
                 *  3、dao层
         *  四、jsp文件
         *   *   *  1、显示列表
                 *  2、获取查询到的信息
                 *  3、更新信息
                 *  4、添加信息
         *  五、运行

### 一、使用myeclipse搭建ssh2框架 ###

这边使用的是spring4.1+struts2.1+hibernate4.1进行框架搭建，详细查看（MyEclipse搭建ssh2项目）：[https://blog.csdn.net/lxw983520/article/details/85704506][https_blog.csdn.net_lxw983520_article_details_85704506]

### 二、相关配置文件 ###

参考：[https://blog.csdn.net/lxw983520/article/details/86631710][https_blog.csdn.net_lxw983520_article_details_86631710]  
这边需要指出的是struts.xml的不同：每个增删改查需要用不同的jsp页面去做视图跳转。

<?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="saveUser" class="userAction" method="saveUser">
    			<result name="saveSuccess" type="redirectAction">
    				<param name="actionName">userList</param>
    			</result>
    		</action>
    		
    		<action name="selectById" class="userAction" method="selectById">
    			<result name="getSuccess">/jsp/info.jsp</result>
    			<result name="404">/jsp/404.jsp</result>
    		</action>
    		
    		<action name="updateUser" class="userAction" method="updateUser">
    			<result name="updateSuccess" type="redirectAction">
    				<param name="actionName">userList</param>
    			</result>
    		</action>
    		
    		<action name="deleteUser" class="userAction" method="deleteUser">
    			<result name="updateSuccess" type="redirectAction">
    				<param name="actionName">userList</param>
    			</result>
    		</action>
    		
    		<action name="userList" class="userAction">
    			<result name="success" type="redirect">/jsp/list.jsp</result>
    		</action>
    	</package>
    </struts>

### 三、各个层级代码示例 ###

##### 1、action层 #####

调用service层，不同业务逻辑使用不同方法。

package ssh2.com.action;
    
    import java.util.List;
    
    
    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;
    	}
    	
    	//用户列表
    	@Override
    	public String execute() throws Exception {
    		System.out.println("用户列表Action");
    		List<SysUser> list = userService.userList();
    	    ActionContext.getContext().getSession().put("userList",list);
    	    return SUCCESS;		
    	}	
    	
    	//保存用户信息
    	public String saveUser(){
    		System.out.println("保存用户信息Action");
    		userService.save(sysUser);
    		return "saveSuccess";
    	}
    	
    	//更新用户信息
    	public String updateUser(){
    		System.out.println("更新用户信息Action");
    		userService.update(sysUser);
    		return "updateSuccess";
    	}		
    	
    	//删除用户信息
    	public String deleteUser(){
    		System.out.println("删除用户信息Action");
    		userService.delete(sysUser);
    		System.out.println(sysUser.getId());
    		return "updateSuccess";
    	}			
    	
    	//查询用户信息
    	public String selectById(){
    		System.out.println("查询用户信息Action");
    		//根据Id获取用户
    		sysUser = userService.selectById(sysUser.getId());
    		if(sysUser != null){
    			System.out.println(sysUser.getUserName());
    			return "getSuccess";
    		}
    		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;
    	}
    }

##### 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;
    	}
    	
    	public List<SysUser> userList(){
    		System.out.println("用户列表Service");
    		return userDao.getUserList();
    	}
    
    	public void save(SysUser sysUser) {
    		System.out.println("保存Service");
    		userDao.saveUser(sysUser);
    	}
    	
    	public void update(SysUser sysUser) {
    		System.out.println("更新用户Service");
    		userDao.updateUser(sysUser);
    	}
    	
    	public void delete(SysUser sysUser) {
    		System.out.println("更新用户Service");
    		userDao.deleteUser(sysUser);
    	}
    	
    	public SysUser selectById(Integer id) {
    		System.out.println("查询用户Service");
    		
    		return userDao.selectById(id);
    	}
    }

##### 3、dao层 #####

使用session中的自带增删改查操作。

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;
    	}
    
    	//用户列表
    	@SuppressWarnings("unchecked")
    	public List<SysUser> getUserList() {
    		System.out.println("用户列表Dao");
    		String sql = "select * from sys_user";
    		SQLQuery sqlQuery = this.sessionFactory.getCurrentSession().createSQLQuery(sql);
    		sqlQuery.addEntity(SysUser.class);
    		return sqlQuery.list();
    	}
    	
    	//保存用户
    	public void saveUser(SysUser sysUser) {
    		System.out.println("保存用户Dao");
    		
    		this.sessionFactory.getCurrentSession().save(sysUser);
    		System.out.println("保存成功");
    	}
    	
    	//更新用户
    	public void updateUser(SysUser sysUser) {
    		System.out.println("更新用户Dao");
    		
    		this.sessionFactory.getCurrentSession().update(sysUser);
    		System.out.println("更新用户成功");
    	}
    	
    	//根据用户Id获取用户信息
    	public SysUser selectById(Integer id) {
    		System.out.println("查询用户Dao");
    		
    		return (SysUser) this.sessionFactory.getCurrentSession().get(SysUser.class,id);
    	}
    	
    
    	//删除用户
    	public void deleteUser(SysUser sysUser) {
    		System.out.println("删除用户Dao");
    		
    		this.sessionFactory.getCurrentSession().delete(sysUser);
    		System.out.println("删除用户成功");
    	}
    }

### 四、jsp文件 ###

##### 1、显示列表 #####

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
    <%
    String path = request.getContextPath();
    String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
    %>
    
    <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
    
    <!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>
      <h2>查询用户</h2>
    	<form action="selectById" method="post">
    	  <input type="text" name="sysUser.id">
    	  <input type="submit" value="ID查询">
    	 </form>
        <h1>用户列表</h1>
         <table border="1">
    		<tr>
    	 		<td align="center">ID</td>
    	        <td align="center">姓名</td>
    	        <td align="center">密码</td>   
    	       	<td>修改用户</td>
    			<td>删除用户</td>              
    	    </tr>
    		
        	<c:forEach var="user" items="${userList}">
                <tr>
                   <td>${user.id}</td>
                   <td>${user.userName}</td>
                   <td>${user.password}</td>
                   <td><a href="${pageContext.request.contextPath}/jsp/update.jsp?id=${user.id}&userName=${user.userName}&password=${user.password}">修改</a></td>
    			   <td><a href="deleteUser?sysUser.id=${user.id}">删除</a></td>
                </tr>
             </c:forEach>
    	</table>
    	
      </body>
    </html>

##### 2、获取查询到的信息 #####

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
    <%
    String path = request.getContextPath();
    String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
    %>
    <%@ taglib uri="/struts-tags" prefix="s"%>
    
    <!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>
        <table border="1">
    	<tr>
    		<td>ID</td>
    		<td>姓名</td>
    		<td>密码</td>
    	</tr>
    
    	<tr>
    		<td>${sysUser.id}</td>
    		<td>${sysUser.userName}</td>
    		<td>${sysUser.password}</td>
    	</tr>
        </table>
        <a href="userList.action">用户列表</a> <br>
      </body>
    </html>

##### 3、更新信息 #####

<%@ 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>
        <form action="updateUser" method="post">
    	ID:<input type="text" name="sysUser.id" value="${param.id}" readonly="readonly">
    	姓名:<input type="text" name="sysUser.userName" value="${param.userName}">
    	年龄:<input type="text" name="sysUser.password" value="${param.password}">
    	<input type="submit" value="修改">
    	</form>
      </body>
    </html>

##### 4、添加信息 #####

<%@ page language="java" import="java.util.*" contentType="text/html;charset=UTF-8" 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>  
    	<form action="saveUser" method="post">  
              姓名：<input type="text" name="sysUser.userName">
              密码：<input type="text" name="sysUser.password">
        <input type="submit" value="保存">
        </form>
      </body>
    </html>

### 五、运行 ###

> 保存用户的时候遇到中文乱码存储问题：  
> 解决方案：jsp采用UTF-8格式，在applictionContext.xml文件中的数据库配置添加\*\*?characterEncoding=utf8\*\*

该框架使用的是tomcat9运行的，具体可以自行更改。  
示例代码：[https://github.com/HardProgrammer/ssh2.git][https_github.com_HardProgrammer_ssh2.git]

[https_blog.csdn.net_lxw983520_article_details_85704506]: https://blog.csdn.net/lxw983520/article/details/85704506
[https_blog.csdn.net_lxw983520_article_details_86631710]: https://blog.csdn.net/lxw983520/article/details/86631710
[https_github.com_HardProgrammer_ssh2.git]: https://github.com/HardProgrammer/ssh2.git