interlij idea创建给Web项目添加SS2M

爱被打了一巴掌 2022-06-13 00:22 166阅读 0赞

## **1、系统环境** ##

IDE：InterliJ IDEA 2017.1.4  
jdk版本：1.8  
Maven版本：3.5  
struts版本：2.x  
spring版本:4.2  
Mybatis版本:3.X  
数据库：MySQL 5.7 [包含user表的sql脚本][user_sql]

其他两个环境搭建请参考：  
[interlij idea创建给Web项目添加struts2][interlij idea_Web_struts2]，[interlij idea创建给Web项目添加Mybatis][interlij idea_Web_Mybatis]，熟悉熟悉

## **2、spring环境搭建** ##

添加如下依赖:

<dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>javax.servlet-api</artifactId>
                <version>4.0.0-b01</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.eclipse.jetty</groupId>
                <artifactId>apache-jstl</artifactId>
                <version>9.4.6.v20170531</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-core</artifactId>
                <version>4.2.4.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-beans</artifactId>
                <version>4.2.4.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>4.2.4.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-web</artifactId>
                <version>4.2.4.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-orm</artifactId>
                <version>4.2.4.RELEASE</version>
            </dependency>

在resources文件右键，新建xml的spring配置文件，名字是：spring-config (当然你喜欢其他名字也行)

![SouthEast][]  
![SouthEast 1][]  
![SouthEast 2][]  
在web.xml的web-app节点下添加如下:

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

![SouthEast 3][]

## **3、Spring整合Mybatis** ##

追加如下依赖：

<dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <version>5.1.38</version>
        </dependency>
          
          <dependency>
              <groupId>org.mybatis</groupId>
              <artifactId>mybatis</artifactId>
              <version>3.4.4</version>
          </dependency>
    
          
          <dependency>
              <groupId>org.mybatis</groupId>
              <artifactId>mybatis-spring</artifactId>
              <version>1.3.1</version>
          </dependency>
          
          <dependency>
              <groupId>com.alibaba</groupId>
              <artifactId>druid</artifactId>
              <version>1.0.31</version>
          </dependency>
          
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.12</version>
                <scope>test</scope>
            </dependency>

由于spring官方没有对mybatis的支持，所以mybatis在自己社区开发出一个让spring支持mybatis的插件。  
最好还是先去看看[interlij idea创建给Web项目添加Mybatis][interlij idea_Web_Mybatis]，不然你找不到新建的模板。  
新建Mybatis配置文件。

![这里写图片描述][SouthEast 4]  
![这里写图片描述][SouthEast 5]  
新建实体类：

package POJO;
    
    import java.util.Date;
    
    /** * Created by hui on 2017/6/21. */
    public class User { 
    
        private int id;
        private String name;
        private Date birth;
        private Integer sex;
        private Integer age;
        private String phone;
        private String email;
        private String pwd;
    
      // 各属性getter和setter方法省略，toString方法

![SouthEast 6][]  
![SouthEast 7][]  
关联一下mapper和config文件，在mybatis-config.xm添加如下：

在UserDAO.xml添加如下：

<select id="getUserById" resultType="POJO.User">
            SELECT * FROM USER WHERE id = #{id};
        </select>

在UserDAO.java添加如下：

//使用xml配置文件
        User getUserById(int id);
        //不使用配置文件使用注解
        @Select("Select * from user where id = #{id}")
        User getUserByIdForAnnotation(int id);

![SouthEast 8][]  
![SouthEast 9][]  
上面完成了一次配置文件的创建和关联。  
下面是与spring整合：  
添加jdbc.properties配置文件

jdbc.driver=com.mysql.cj.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/networkalbum?useSSL=false&serverTimezone=GMT%2B8
    jdbc.username=root
    jdbc.password=root

![这里写图片描述][SouthEast 10]  
spring配置文件spring-config.xml添加如下：

加载jdbc配置文件  
添加dataSource：

datasource采用具有连接池的druid，参考[spring配置数据库连接池druid][spring_druid]  
构建sqlSessionFactory：（这是重点，操作数据库都是靠这个类嘛）

构建一个实现UserDao接口的实体类：

编写一个单元测试类，看看是否整合：

package space.xxhui;
    
    import POJO.User;
    import POJO.UserDao;
    import org.springframework.beans.factory.BeanFactory;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    
    /** * Created by hui on 2017/6/21. */
    public class Test { 
    
        @org.junit.Test
        public void getMapper(){
            BeanFactory beanFactory = new ClassPathXmlApplicationContext("spring-config.xml");
            UserDao userDao = (UserDao)beanFactory.getBean("userMapper");
            User user = userDao.getUserById(1);
            System.out.println(user.toString());
            User user1 = userDao.getUserByIdForAnnotation(2);
            System.out.println(user1.toString());
    
        }
    }

![这里写图片描述][SouthEast 11]  
  
看到输出，说明成功从spring的ioc容器中获取了usermapper类。

## **3、Spring整合Struts2** ##

追加如下依赖：

<dependency>
                <groupId>org.apache.struts</groupId>
                <artifactId>struts2-spring-plugin</artifactId>
                <version>2.3.24.1</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.apache.struts</groupId>
                <artifactId>struts2-core</artifactId>
                <version>2.3.24.1</version>
            </dependency>
            <dependency>
                <groupId>org.apache.struts</groupId>
                <artifactId>struts2-convention-plugin</artifactId>
                <version>2.3.24.1</version>
            </dependency>

添加Struts2（请参考前面添加Struts2，记得去project structure添加，详情请去看系统环境处的文章），添加完成的效果如下：

![这里写图片描述][SouthEast 12]  
在web.xml的web-app节点下，添加如下：

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

package action;
    import POJO.UserDao;
    import com.opensymphony.xwork2.ActionSupport;
    /** * Created by hui on 2017/6/21. */
    public class LoginAction extends ActionSupport { 
        //两个属性名跟Login.jsp的form属性的name一样
        //这样struts2框架会自动复制，每个属性需要getter和setter
        private String username;
        private String pwd;
        private UserDao userDao;
    
        public UserDao getUserDao() {
            return userDao;
        }
        public void setUserDao(UserDao userDao) {
            this.userDao = userDao;
        }
        public String getUsername() {
            return username;
        }
        public void setUsername(String username) {
            this.username = username;
        }
        public String getPwd() {
            return pwd;
        }
        public void setPwd(String pwd) {
            this.pwd = pwd;
        }
        @Override
        public String execute() throws Exception {
            String forword = null;
            if (username.equals("Hitvz") && pwd.equals("123456")) {
                forword = ActionSupport.SUCCESS;
            } else {
                forword = ActionSupport.INPUT;
            }
            return forword;
        }
    }

添加完Struct2，接下来Spring整合Struts2.  
在Spring配置文件添加如下：

在strut.xml添加如下：

<constant name="struts.objectFactory" value="spring"/>
        
        <package name="SSHDemo" extends="struts-default" namespace="/">
            <action name="login" class="loginActionBySpring" >
                <result name="success">index.jsp</result>
                <result name="input">Login.jsp</result>
            </action>
        </package>

这里是**整合重点**：struct2可以管理对象，而spring也可以管理对象，那么问题来了，到底最后谁来管理生成的对象呢？这里选**用Spring来管理对象**，应该在spring配置文件配置bean标签，在struts配置文件里的class标签，引用一个spring的实例，如上所示。

## **4、Struts2与Mybatis整合** ##

spring整合Strut2的操作我并没有查询数据库验证用户  
在UserDao添加如下方法:

@Select("Select * from user where name = #{user.name} and pwd = #{user.pwd}") User checkUser(@Param("user") User user);

下面改一下LoginAction代码:

@Override
        public String execute() throws Exception {
            String forword = null;
            User userEntity =new User();
            userEntity.setName(username);
            userEntity.setPwd(pwd);
            //mybatis配置文件中设置了，如果没有查询到返回null
            User entity = userDao.checkUser(userEntity);
    
            if (entity!=null) {
                System.out.println(entity.toString());
                ActionContext.getContext().put("user",entity);
                forword = ActionSupport.SUCCESS;
            } else {
                System.out.println("no such user");
                forword = ActionSupport.INPUT;
            }
            return forword;
        }

将固定的验证，变为数据库操作，整合完成

## **5、SSH的一两个过滤器** ##

放在web.xml的web-app下：

<filter>
            <filter-name>encodingFilter</filter-name>
            <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
            <init-param>
                <param-name>encoding</param-name>
                <param-value>utf-8</param-value>
            </init-param>
        </filter>
        <filter-mapping>
            <filter-name>encodingFilter</filter-name>
            <url-pattern>/*</url-pattern>
        </filter-mapping>

[码云-SS2MDemo案例源码][-SS2MDemo]

[user_sql]: http://git.oschina.net/1099764422/SQLScript/blob/master/create_table.sql
[interlij idea_Web_struts2]: http://blog.csdn.net/qq_26819733/article/details/72967406
[interlij idea_Web_Mybatis]: http://blog.csdn.net/qq_26819733/article/details/73441374
[SouthEast]: /images/20220613/01506e2a6e7a4cbe95c4f5d38e63b323.png
[SouthEast 1]: /images/20220613/15e0218018d042a799f77f2aeb510628.png
[SouthEast 2]: /images/20220613/31d37bac0bab40f98a021d7a363227e8.png
[SouthEast 3]: /images/20220613/088e1fea1c3742919a747c0ffed1ab81.png
[SouthEast 4]: /images/20220613/0a44f018f42343399f7b2a992435ce1b.png
[SouthEast 5]: /images/20220613/5bb4815e40ac4020a80da96fc2a71a8e.png
[SouthEast 6]: /images/20220613/dc004a28d1c24052a68849b5f7e2f9be.png
[SouthEast 7]: /images/20220613/68e66fecba9d45e2b5684e2e6dc211b1.png
[SouthEast 8]: /images/20220613/d96928ac56584367be41090c7416826b.png
[SouthEast 9]: /images/20220613/e971325a7eef473ba71d0fa24ad3d275.png
[SouthEast 10]: /images/20220613/dd2f0cce7d2b4e56956650e9c4e1d233.png
[spring_druid]: http://www.cnblogs.com/Jason-Xiang/p/6586311.html
[SouthEast 11]: /images/20220613/ddd1e45ecd4048dba7261fc25a00e311.png
[SouthEast 12]: /images/20220613/7017126bb4b44354afcaa9480a1aaf86.png
[-SS2MDemo]: http://git.oschina.net/1099764422/SS2MDemo