史上最全SSM整合

最新推荐文章于 2024-10-01 13:49:09 发布

杨忠荣

最新推荐文章于 2024-10-01 13:49:09 发布

阅读量194

点赞数

分类专栏：史上最全ssm 文章标签： spring maven

本文链接：https://blog.csdn.net/yang_zhong_rong/article/details/119037633

版权

史上最全ssm 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

SSM

1.导入相应的依赖

<!--  mysql的依赖-->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.47</version>
    </dependency>
<!--    druid连接池的依赖-->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId>
      <version>1.0.31</version>
    </dependency>
<!--    mybatis依赖-->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.4.5</version>
    </dependency>

<!--    spring融合mybatis-->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>1.3.1</version>
    </dependency>
<!--    导入springjdbc依赖-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>5.0.2.RELEASE</version>
    </dependency>

<!--    springmvc依赖，包括了springaop springcore springasp springmvc springcotext springbean-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>5.0.2.RELEASE</version>
    </dependency>
<!--    导入asp切面依赖-->
    <dependency>
      <groupId>org.aspectj</groupId>
      <artifactId>aspectjweaver</artifactId>
      <version>1.8.4</version>
    </dependency>
<!--    导入springweb依赖-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-web</artifactId>
      <version>5.0.2.RELEASE</version>
    </dependency>
<!--    导入事务管理依赖-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-tx</artifactId>
      <version>5.0.2.RELEASE</version>
    </dependency>
<!--    导入lombok依赖-->
    <dependency>
      <groupId>org.projectlombok</groupId>
      <artifactId>lombok</artifactId>
      <version>1.18.4</version>
    </dependency>
<!--    导入web层依赖-->
<!--      1.访问jsp必须配置的依赖-->
    <dependency>
      <groupId>org.apache.tomcat.embed</groupId>
      <artifactId>tomcat-embed-jasper</artifactId>
      <version>8.5.23</version>
    </dependency>
<!--    2.导入Tomcat对servlet的支持-->
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>javax.servlet-api</artifactId>
      <version>4.0.1</version>
    </dependency>
<!--    3.导入解析jsp页面，跳转所需配置-->
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>jstl</artifactId>
      <version>1.2</version>
    </dependency>
<!--    4.导入文件上传的依赖-->
    <dependency>
      <groupId>commons-fileupload</groupId>
      <artifactId>commons-fileupload</artifactId>
      <version>1.3.3</version>
    </dependency>
<!--    5.将后台数据解析或封装为json格式    1.jackson-core    2.jackson-databind  3.jackson-annotations-->
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-core</artifactId>
      <version>2.10.0</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-databind</artifactId>
      <version>2.10.0</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-annotations</artifactId>
      <version>2.10.0</version>
    </dependency>
    <dependency>
      <groupId>redis.clients</groupId>
      <artifactId>jedis</artifactId>
      <version>2.7.0</version>
    </dependency>

合计：17个依赖 3m-7s-7s

1.mybatis的依赖有 ：（3）
    1.mysql依赖 2.连接池依赖  3.mybatis依赖   
   
2.spring的依赖有：（7）
    1.springMVC依赖 2.spring-tx事务的依赖 3.mybatis-spring spring融合mybatis  4.spring-jdbc的依赖
    5.spring-web的依赖 6.aspectjweaver asp的依赖  7.lombok的依赖
3.web层的依赖有：（7）
    1.tomcat-embed-jasper 导入对web层支持的依赖  2.javax.servlet-api 导入Tomcat对servlet的支持
    3.jstl 3.导入解析jsp页面，跳转所需配置 4.commons-fileupload 导入文件上传的依赖
    5.jackson-core 6.jackson-databind 7.jackson-annotations 将后台数据解析或封装为json格式

实现类:mapperxml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.qs.lianxi0720.mapper.UserMapper">
    <insert id="save" parameterType="users">
        insert into tb_users
            <trim prefix="(" suffix=")" suffixOverrides=",">
                <if test="userid !=null">
                    userid,
                </if>
                <if test="userid !=null">
                    username,
                </if>
                <if test="userid !=null">
                    pwd,
                </if>
                <if test="userid !=null">
                    status,
                </if>
            </trim>
        values
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="userid !=null">
                #{userid}
            </if>
            <if test="userid !=null">
                #{username},
            </if>
            <if test="userid !=null">
                #{pwd},
            </if>
            <if test="userid !=null">
                #{status},
            </if>
        </trim>
    </insert>
</mapper>

spring的配置文件（6步走）

本人记忆法：1开著，2数配, 3s接m ,4.思m口 5.思事务 6.开事注

<?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"
       xsi:schemaLocation="
		http://www.springframework.org/schema/beans
		http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context
		http://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/tx
		http://www.springframework.org/schema/tx/spring-tx.xsd">
     
<!--   1.   开启注解扫描-->
    <context:component-scan base-package="com.qs.lianxi0720">
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>
	<!--2.数据源的配置-->
    <bean name="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="username" value="root"/>
        <property name="password" value="root"/>
        <property name="url" value="jdbc:mysql://localhost:3306/company?characterEncoding=utf-8"/>
     </bean>
    <!--  3.  spring接管mybatis-->
    <bean class="org.mybatis.spring.SqlSessionFactoryBean" name="sqlSessionFactory">
   		<property name="dataSource" ref="dataSource"/> <!-- 引入数据源-->
        <property name="typeAliasesPackage" value="com.qs.lianxi0720.pojo"/><!-- 取别名-->
        <property name="mapperLocations" value="classpath*:*Mapper.xml"/><!-- 引入mapper实现类文件-->
    </bean>
<!--  4.  实例化mapper接口-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer" name="scannerConfigurer">
        <property name="basePackage" value="com.qs.lianxi0720.mapper"/>
    </bean>
<!--  5.  开启事务-->
    <bean class="org.springframework.jdbc.datasource.DataSourceTransactionManager" name="transactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>
<!--  6.  配置注解驱动-->
    <tx:annotation-driven transaction-manager="transactionManager"></tx:annotation-driven>
</beans>

业务层实现类及事务开启

@Service("userService")
public class UserServiceImpl implements UserService {
    @Autowired
    private UserMapper userMapper;
    @Override
    @Transactional(readOnly = false,propagation = Propagation.SUPPORTS )
    public boolean save(Users users) {
        return userMapper.save(users)>0;
    }
}

测试类

public class Test01 {
    @Test
    public void test01(){
        ApplicationContext context =new ClassPathXmlApplicationContext("applicationContext.xml");
        UserService userService =(UserService) context.getBean("userService");
        Users users =(Users) context.getBean("users");
        users.setUserid("663");
        users.setUsername("shu6");
        users.setPwd("444");
        users.setStatus("vip656");
        userService.save(users);
    }
}

springmvc的配置

<?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:mvc="http://www.springframework.org/schema/mvc"
       xsi:schemaLocation="
		http://www.springframework.org/schema/beans
		http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context
		http://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/mvc
		http://www.springframework.org/schema/mvc/spring-mvc.xsd">
<!--    开启controller注解扫描-->
    <context:component-scan base-package="com.qs.lianxi0720">
        <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>
<!--    开启MVC注解扫描-->
    <mvc:annotation-driven/>
<!--    过滤静态文件-->
    <mvc:default-servlet-handler/>
<!--    定义服务器转发的前缀和后缀-->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/"/><!-- 控制中心UserController最后要转发的页面在哪个文件夹里面,此处配置为根目录，也就是webapp目录 -->
        <property name="suffix" value=".jsp"/><!-- 此服务器页面的后缀 -->
     </bean>
<!--    文件上传配置-->
    <bean class="org.springframework.web.multipart.commons.CommonsMultipartResolver" id="commonsFileUploadSupport">
        <property name="defaultEncoding" value="UTF-8"/>
        <property name="maxInMemorySize" value="1048576"/>
     </bean>

</beans>

web.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">
<!--  解决post请求乱码-->
  <filter>
    <filter-name>encoding</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>encoding</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>
  
  <!--  载入appilcationContext.xml-->
  <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>
<!--  初始化载入springmvc.xml-->
    <servlet>
      <servlet-name>springmvc</servlet-name>
      <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
      <init-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:springmvc.xml</param-value>
      </init-param>
    </servlet>
    <servlet-mapping>
      <servlet-name>springmvc</servlet-name>
      <url-pattern>/</url-pattern>
    </servlet-mapping>
</web-app>

bookInFoMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.qs.lianxi0717.Mapper.BookMapper">
        <select id="findNewBook" resultType="bookinfo">
            select * from bookinfo order by sendBookTime desc limit 0,5
        </select>
        <select id="findHotBook" resultType="bookinfo">
            select * from bookinfo order by bookprice desc limit 0,7
        </select>
        <select id="findDisCount" resultType="bookinfo">
            select * from bookinfo where discount &lt; 1 limit 0,4
        </select>

<!--        <select id="findById" parameterType="String" resultType="bookinfo">-->
<!--            select * from bookinfo where bookid=#{bookid}-->
<!--        </select>-->
    <resultMap id="users" type="Users">
        <id property="userid" column="userid"/>
        <result property="username" column="username"/>
        <result property="pwd" column="pwd"/>
        <result property="status" column="status"/>
    </resultMap>
    <resultMap id="repliesuser" type="Reply">
        <id property="rid" column="RID"/>
        <result property="rcontent" column="RCONTENT"/>
        <result property="rtime" column="RTIME"/>
        <result property="buytime" column="BUYTIIME"/>
        <association property="users" javaType="Users" resultMap="users"/>
    </resultMap>
        <resultMap id="bookMap" type="BookInFo">
            <id property="bookid" column="BOOKID"/>
            <result property="bookname" column="BOOKNAME"/>
            <result property="bookprice" column="BOOKPRICE"/>
            <result property="discountprice" column="DISCOUNTPRICE"/>
            <result property="bookimg" column="BOOKIMG"/>
            <result property="bookdetails" column="BOOKDETAILS" />
            <result property="discount" column="discount"/>
            <result property="state" column="STATE"/>
            <result property="btype" column="BTYPE"/>
            <result property="arname" column="ARNAME"/>
            <result property="sendBookTime" column="SENDBOOKTIME"/>
            <collection property="replies" ofType="Reply" resultMap="repliesuser"/>
        </resultMap>
        <select id="findById" parameterType="String" resultMap="bookMap">
            SELECT B.*,T.*,R.* FROM BOOKINFO B,TB_USERS T,REPLY R
            WHERE  B.BOOKID = R.BOOKID AND T.USERID = R.USERID
              AND B.BOOKID = #{bookid}
        </select>
</mapper>