# ssh-admin-template

**Repository Path**: devape/ssh-admin-template

## Basic Information

- **Project Name**: ssh-admin-template
- **Description**: 整合 Spring+Struts+Hibernate
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2025-09-04
- **Last Updated**: 2025-10-14

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README




## 整合步骤

### 1.添加依赖
```xml
    <properties>
    <maven.compiler.source>8</maven.compiler.source>
    <maven.compiler.target>8</maven.compiler.target>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

    <spring.version>5.3.39</spring.version>
    <struts.version>2.5.33</struts.version>
    <hibernate.version>5.6.15.Final</hibernate.version>
    <mysql.version>8.0.33</mysql.version>
    <druid.version>1.2.23</druid.version>

</properties>
<dependencies>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-web</artifactId>
    <version>${spring.version}</version>
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-context</artifactId>
    <version>${spring.version}</version>
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-beans</artifactId>
    <version>${spring.version}</version>
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>${spring.version}</version>
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-aop</artifactId>
    <version>${spring.version}</version>
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-orm</artifactId>
    <version>${spring.version}</version>
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-tx</artifactId>
    <version>${spring.version}</version>
</dependency>
<dependency>
    <groupId>org.aspectj</groupId>
    <artifactId>aspectjweaver</artifactId>
    <version>1.9.6</version>
</dependency>
<dependency>
    <groupId>org.aspectj</groupId>
    <artifactId>aspectjrt</artifactId>
    <version>1.9.6</version>
</dependency>
<!-- servlet -->
<dependency>
    <groupId>javax.servlet</groupId>
    <artifactId>javax.servlet-api</artifactId>
    <version>4.0.0</version>
    <scope>provided</scope>
</dependency>


<dependency>
    <groupId>org.apache.struts</groupId>
    <artifactId>struts2-core</artifactId>
    <version>${struts.version}</version>
</dependency>
<dependency>
    <groupId>org.apache.struts</groupId>
    <artifactId>struts2-spring-plugin</artifactId>
    <version>${struts.version}</version>
</dependency>
<dependency>
    <groupId>org.hibernate</groupId>
    <artifactId>hibernate-core</artifactId>
    <version>${hibernate.version}</version>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>${mysql.version}</version>
</dependency>
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>${druid.version}</version>
</dependency>


<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
    <version>1.18.38</version>
</dependency>
<dependency>
    <groupId>junit</groupId>
    <artifactId>junit</artifactId>
    <version>4.13.2</version>
    <scope>test</scope>
</dependency>
</dependencies>
<build>
<resources>
    <resource>
        <directory>src/main/java</directory>
        <includes>
            <include>**/*.xml</include>
        </includes>
    </resource>
</resources>
</build>
```

### 2.配置web.xml
```xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
         version="4.0">

    <!--spring-->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext.xml</param-value>
    </context-param>
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>


    <!--struts-->
    <filter>
        <filter-name>struts2</filter-name>
        <filter-class>org.apache.struts2.dispatcher.filter.StrutsPrepareAndExecuteFilter</filter-class>
    </filter>
    <filter-mapping>
        <filter-name>struts2</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
</web-app>
```

### 3.配置applicationContext.xml
```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:context="http://www.springframework.org/schema/context"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd
        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">

    <!-- 组件扫描 -->
    <context:component-scan base-package="ssh">
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>

    <!--jdbc.properties-->
    <context:property-placeholder location="classpath:jdbc.properties"/>

    <!--数据源-->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="${jdbc.driver}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>

    <!--SessionFactory-->
    <bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
        <property name="configLocation" value="classpath:hibernate.cfg.xml"/>
        <property name="dataSource" ref="dataSource"/>
        <property name="mappingLocations" value="classpath:ssh/entity/*.xml"/>
    </bean>


    <!--事务管理器-->
    <bean id="transactionManager" class="org.springframework.orm.hibernate5.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory"/>
    </bean>
    <!-- 使用AOP配置事务 -->
    <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <tx:attributes>
            <tx:method name="get*" read-only="true"/>
            <tx:method name="list*" read-only="true"/>
            <tx:method name="*"/>
        </tx:attributes>
    </tx:advice>
    <!--事务切入点-->
    <aop:config>
        <aop:pointcut id="txPointcut" expression="execution(* ssh.service.*.*(..))"/>
        <aop:advisor advice-ref="txAdvice" pointcut-ref="txPointcut"/>
    </aop:config>

</beans>
```


### 4.配置hibernate.cfg.xml
```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.driver_class">com.mysql.cj.jdbc.Driver</property>
        <property name="connection.url">jdbc:mysql://localhost:3306/test</property>
        <property name="connection.username">root</property>
        <property name="connection.password">root</property>


        <property name="hibernate.dialect">org.hibernate.dialect.MySQL8Dialect</property>
        <property name="hibernate.dialect.storage_engine">innodb</property>
        <property name="hibernate.show_sql">true</property>
        <property name="hibernate.format_sql">true</property>

        <property name="hibernate.hbm2ddl.auto">update</property>

    </session-factory>

</hibernate-configuration>


```

### 5.配置struts.xml
```xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts PUBLIC
        "-//Apache Software Foundation//DTD Struts Configuration 2.5//EN"
        "http://struts.apache.org/dtds/struts-2.5.dtd">

<struts>

    <constant name="struts.enable.DynamicMethodInvocation" value="false"/>
    <constant name="struts.devMode" value="true"/>

    <package name="default" namespace="/" extends="struts-default">

    </package>

</struts>
```

### 6.创建数据库
```sql
CREATE TABLE IF NOT EXISTS role
(
    id          INT PRIMARY KEY AUTO_INCREMENT,
    name   VARCHAR(50) NOT NULL
);

CREATE TABLE IF NOT EXISTS user
(
    id         INT PRIMARY KEY AUTO_INCREMENT,
    username   VARCHAR(50)  NOT NULL UNIQUE,
    password   VARCHAR(100) NOT NULL,
    role_id    INT
);
```

### 7.实体类及其映射
```java
package ssh.entity;

import lombok.Data;


@Data
public class Role {
    private Integer id;
    private String name;
}

```

```xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="ssh.entity">

    <class name="Role" table="role">

        <id name="id" column="id" type="integer">
            <generator class="identity"/>
        </id>

        <property name="name" column="name" type="string"/>

    </class>

</hibernate-mapping>
```

```java
package ssh.entity;

import lombok.Data;

@Data
public class User {
    private Integer id;
    private String username;
    private String password;

    private Role role;

}

```

```xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="ssh.entity">

    <class name="User" table="user">

        <id name="id" column="id" type="integer">
            <generator class="identity"/>
        </id>

        <property name="username" column="username" type="string"/>
        <property name="password" column="password" type="string"/>

        <many-to-one name="role" column="role_id" class="ssh.entity.Role"/>

    </class>

</hibernate-mapping>
```

### 8.Dao
```java
package ssh.dao;

import lombok.Setter;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.query.Query;
import ssh.entity.User;

import java.util.List;

public class UserDao {
    @Setter
    private SessionFactory sessionFactory;


    public Session getSession() {
        return sessionFactory.getCurrentSession();
    }


    public void deleteById(Integer id) {
        String hql = "delete from User where id = :id";
        getSession().createQuery(hql).setParameter("id",id).executeUpdate();
    }

    public List<User> selectList() {
        String hql = "from User u left join fetch u.role";
        return getSession().createQuery(hql).list();
    }

    public void insert(User user) {
        if (user == null) {
            throw new IllegalArgumentException("User cannot be null");
        }
        getSession().save(user);
    }

    public User selectById(Integer id) {
        if (id == null || id <= 0) {
            return null;
        }
        String hql = "FROM User u LEFT JOIN FETCH u.role WHERE u.id = :id";
        Query<User> query = getSession().createQuery(hql, User.class);
        query.setParameter("id", id);
        return query.uniqueResult();
    }

    public void update(User user) {
        if (user == null) {
            throw new IllegalArgumentException("User cannot be null");
        }
        if (user.getId() == null) {
            throw new IllegalArgumentException("User ID cannot be null for update");
        }
        getSession().update(user);
    }
}

```
### 9.Service
```java
package ssh.service;

import lombok.Setter;
import ssh.dao.UserDao;
import ssh.entity.User;

import java.util.List;


public class UserService {
    @Setter
    private  UserDao userDao;


    public void  deleteById(Integer id){
        userDao.deleteById(id);
    }

    public List<User> list(){
        return userDao.selectList();
    }

    public void save(User user) {
        userDao.insert(user);
    }

    public User getById(Integer id) {
        return userDao.selectById(id);
    }

    public void update(User user) {
        userDao.update(user);
    }
}

```

### 10.Action
```java
package ssh.action;

import com.opensymphony.xwork2.ActionSupport;
import com.opensymphony.xwork2.ModelDriven;
import com.opensymphony.xwork2.Preparable;
import lombok.Getter;
import lombok.Setter;
import ssh.entity.User;
import ssh.service.UserService;

import java.util.List;

public class UserAction extends ActionSupport implements ModelDriven<User>, Preparable {


    @Setter
    private UserService userService;

    @Setter
    private Integer id;
    @Getter
    private User model;

    @Getter
    private List<User> userList;


    public String viewCreate() {
        return SUCCESS;
    }

    public String viewList() {
        userList = userService.list();
        return SUCCESS;
    }

    public String viewUpdate() {
        model = userService.getById(id);
        System.out.println(model);
        return SUCCESS;
    }

    public void prepareCreate() {
        model = new User();
    }

    public String create() {
        userService.save(model);
        return SUCCESS;
    }


    public String delete() {
        userService.deleteById(id);
        return SUCCESS;
    }

    public void prepareUpdate() {
        model = new User();
    }

    public String update() {
        userService.update(model);
        return SUCCESS;
    }


    @Override
    public void prepare() throws Exception {

    }
}

```

### 11.applicationContext.xml配置 spring bean
```xml
    <bean id="userDao" class="ssh.dao.UserDao">
        <property name="sessionFactory" ref="sessionFactory"/>
    </bean>
    <bean id="userService" class="ssh.service.UserService">
        <property name="userDao" ref="userDao"/>
    </bean>
    <bean id="userAction" class="ssh.action.UserAction" scope="prototype">
        <property name="userService" ref="userService"/>
    </bean>
```

### 12.struts.xml中配置action
```xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts PUBLIC
        "-//Apache Software Foundation//DTD Struts Configuration 2.5//EN"
        "http://struts.apache.org/dtds/struts-2.5.dtd">

<struts>

    <constant name="struts.enable.DynamicMethodInvocation" value="false"/>
    <constant name="struts.devMode" value="true"/>

    <package name="default" namespace="/user" extends="struts-default">


        <action name="viewCreate" class="userAction" method="viewCreate">
            <result name="success">/WEB-INF/views/user-create.jsp</result>
            <result name="error">/error.jsp</result>
        </action>

        <action name="viewList" class="userAction" method="viewList">
            <result name="success">/WEB-INF/views/user-list.jsp</result>
            <result name="error">/error.jsp</result>
        </action>

        <action name="viewUpdate" class="userAction" method="viewUpdate">
            <result name="success">/WEB-INF/views/user-update.jsp</result>
            <result name="error">/error.jsp</result>
        </action>

        <action name="create" class="userAction" method="create">
            <result name="success" type="redirect">/user/viewList</result>
            <result name="error">/error.jsp</result>
        </action>

        <action name="delete" class="userAction" method="delete">
            <result name="success" type="redirect">/user/viewList</result>
            <result name="error">/error.jsp</result>
        </action>

        <action name="update" class="userAction" method="update">
            <result name="success" type="redirect">/user/viewList</result>
            <result name="error">/error.jsp</result>
        </action>


    </package>

</struts>
```

### 13.创建jsp
```jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="s" uri="/struts-tags" %>
<html>
<head>
    <title>Title</title>
</head>
<body>

<a href="${pageContext.request.contextPath}/user/viewCreate">新增</a>

<s:if test="userList == null || userList.size() == 0">
    没有数据
</s:if>
<s:else>
    <table border="1" cellpadding="0" cellspacing="0">
        <tr>
            <td>ID</td>
            <td>用户名</td>
            <td>密码</td>
            <td>角色</td>
            <td>操作</td>
        </tr>
        <s:iterator value="userList">
            <tr>
                <td>${id}</td>
                <td>${username}</td>
                <td>${password}</td>
                <td>${role.name}</td>
                <td>
                    <a href="${pageContext.request.contextPath}/user/viewUpdate?id=${id}">编辑</a>
                    <a href="${pageContext.request.contextPath}/user/delete?id=${id}">删除</a>
                </td>
            </tr>

        </s:iterator>
    </table>
</s:else>
</body>
</html>

```

```jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="s" uri="/struts-tags" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<s:form action="/user/create" method="post">
    <s:textfield name="model.username" label="用户名" />
    <s:password name="model.password" label="密码" />
    <s:submit value="保存" />
</s:form>
</body>
</html>

```

```jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="s" uri="/struts-tags" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<s:form action="/user/update" method="post">
    <s:hidden name="model.id"/>
    <s:textfield name="model.username" label="用户名" />
    <s:password name="model.password" label="密码" />
    <s:submit value="保存" />
</s:form>
</body>
</html>

```
### 14.启动访问
http://localhost:8080/user/viewList
![](./project.png)