ssm整合

 

一、基本环境的搭建

1、导入meven依赖

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.GLH</groupId>
    <artifactId>SSM_Demo02</artifactId>
    <version>1.0-SNAPSHOT</version>
<!--    配置打包方式-->
    <packaging>war</packaging>

    <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.0.2.RELEASE</spring.version>
        <slf4j.version>1.6.6</slf4j.version>
        <log4j.version>1.2.12</log4j.version>
        <mysql.version>8.0.12</mysql.version>
        <mybatis.version>3.5.2</mybatis.version>

        <junit.version>4.12</junit.version>
        <jsp-api.version>2.2</jsp-api.version>
        <jstl.version>1.2</jstl.version>
        <mybatis-spring.version>2.0.2</mybatis-spring.version>
        <spring-webmvc.version>5.1.9.RELEASE</spring-webmvc.version>
        <spring-jdbc.version>5.1.9.RELEASE</spring-jdbc.version>
        <lombok.version>1.18.10</lombok.version>
        <druid.version>1.1.12</druid.version>


    </properties>
    <dependencies>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>${lombok.version}</version>
        </dependency>

        <!--Junit-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>${junit.version}</version>
        </dependency>
        <!--mysql驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>${mysql.version}</version>
        </dependency>


<!--jsp和jstl标签库-->
        <dependency>
            <groupId>javax.servlet.jsp</groupId>
            <artifactId>jsp-api</artifactId>
            <version>${jsp-api.version}</version>
        </dependency>
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>jstl</artifactId>
            <version>${jstl.version}</version>
        </dependency>

        <!--Mybatis-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>${mybatis.version}</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>${mybatis-spring.version}</version>
        </dependency>

        <!--Spring-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>${spring-webmvc.version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>${spring-jdbc.version}</version>
        </dependency>

        <!--阿里巴巴连接池-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>${druid.version}</version>
        </dependency>
    </dependencies>



</project>

Maven资源过滤问题

<build>
   <resources>
       <resource>
           <directory>src/main/java</directory>
           <includes>
               <include>**/*.properties</include>
               <include>**/*.xml</include>
           </includes>
           <filtering>false</filtering>
       </resource>
       <resource>
           <directory>src/main/resources</directory>
           <includes>
               <include>**/*.properties</include>
               <include>**/*.xml</include>
           </includes>
           <filtering>false</filtering>
       </resource>
   </resources>
</build>

 

2、创建项目结构

建立基本结构和配置框架

  • com.inspur.pojo (实体类)
  • com.inspur.dao (Dao层)
  • com.inspur.service (业务处理层)
  • com.inspur.controller (业务控制层)
  • mybatis-config.xml mybatis全局配置文件 (可在IDEA中设置xml模版) --> File | Settings | 编辑器 | 文件和代码模板

 

 

3、编写实体类

编写和数据库中对应的实体类

注意字段名的统一

 

1、编写dao接口

1、编写dao接口

package com.GLH.dao;


import com.GLH.pojo.User;
import org.springframework.stereotype.Repository;


public interface UserDao {

    public User userById(int id);


    public User userByName(String username);

    public void addUser(User user);

    public void deleteUser(int id);

    public void updateUser(User user);
}

2、编写dao.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.GLH.dao.UserDao">
<!--            id属性为：接口中的方法，resultType为返回的类型-->
        <select id="userByName" resultType="user">
            select * from user where username = #{username}
        </select>

        <insert id="addUser" parameterType="user">
                insert into user(username,password) values(#{username},#{password})
        </insert>

        <select id="userById" resultType="user">
            select * from user where user_id = #{id}
        </select>

        <delete id="deleteUser" >
                delete from user where user_id =#{id}
        </delete>

        <update id="updateUser" parameterType="user">
                update user
                set username =#{username},password = #{password}
                where user_id = #{user_id};
        </update>
</mapper>

4、编写service接口和实现类

1、编写service接口

package com.GLH.service;

import com.GLH.pojo.User;



public interface UserService {

    public User userById(int id);


    public User userByName(String username);

    public void addUser(User user);

    public void deleteUser(int id);

    public void updateUser(User user);
}

2、编写service实现类

package com.GLH.service.serviceImpl;

import com.GLH.dao.UserDao;

import com.GLH.pojo.User;
import com.GLH.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service("userService")
public class UserServiceImpl implements UserService {


    @Autowired
    private UserDao userDao;

    @Override
    public User userById(int id) {
        System.out.println("根据id查询");
        return userDao.userById(id);
//        return null;
    }

    @Override
    public User userByName(String username) {
        System.out.println("根据用户名查询");
        return userDao.userByName(username);
    }

    @Override
    public void addUser(User user) {
        System.out.println("添加一个用户"+user);
        userDao.addUser(user);
    }

    @Override
    public void deleteUser(int id) {
        System.out.println("删除一个用户根据id"+id);
        userDao.deleteUser(id);
    }

    @Override
    public void updateUser(User user) {
        System.out.println("更改一个用户"+user);
        userDao.updateUser(user);
    }
}

 

二、整合配置文件的编写

1、编写applicationContext.xml

1、配置扫描包

<!--    开启注解扫描，处理service和dao，但不需要处理controller-->
    <context:component-scan base-package="com.GLH">
<!--        配置哪注解不扫描-->
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>

2、编写mybatis-config.xml

1、创建实体类的别名
2、配置mapper的映射

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<!--configuration核心配置文件-->
<configuration>


<!--    设置实体类的别名-->
    <typeAliases>
<!--        使用扫描包的方式,默认为类名首字母小写-->
        <package name="com.GLH.pojo"/>
    </typeAliases>

<!--    配置mapper映射-->
    <mappers>
        <package name="com.GLH.dao"/>
    </mappers>

</configuration>

3、编写spring-dao.xml

//mybatis和spring的整合

1、编写数据库属性配置文件

db.properties

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&useSSL=false
jdbc.username=root
jdbc.password=5408
1、配置数据库配置文件
2、声明数据源
3、 创建bean SqlSessionFactoryBean创建SqlSessionFactory
4、声明mybatis的扫描器,创建dao对象
<?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"
       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">
<!--1、关联数据库配置文件-->
    <context:property-placeholder location="classpath:db.properties"></context:property-placeholder>

    <!--声明数据源，连接数据库-->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
          init-method="init" destroy-method="close">
        <property name="url" value="${jdbc.url}"/>
        <property name="driverClassName" value="${jdbc.driver}"></property>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>
    <!--SqlSessionFactoryBean创建SqlSessionFactory-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!--        配置数据源-->
        <property name="dataSource" ref="dataSource"></property>
<!--        配置mybatis的全局配置文件的路径-->
        <property name="configLocation" value="classpath:mybatis-config.xml"></property>
    </bean>
    <!--声明mybatis的扫描器，创建dao对象-->
    <bean id="mapperScanner" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.GLH.dao"></property>
    </bean>

    <!--声明service的注解@Service所在的包名位置-->

    <!--声明service的注解@Service所在的包名位置-->
</beans>

4、编写web.xml配置文件

1、配置字符过滤器
2、配置请求处理过滤器
3、配置dispatchServlet
		初始化的配置文件为:applicationContext




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

<!--    配置字符编码过滤器-->
    <filter>
        <filter-name>CharacterEncodingFilter</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>
        <init-param>
            <param-name>forceResponseEncoding</param-name>
            <param-value>true</param-value>
        </init-param>
    </filter>

    <filter-mapping>
        <filter-name>CharacterEncodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
<!--    配置请求处理过滤器-->
    <filter>
        <filter-name>HiddenHttpMethodFilter</filter-name>
        <filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class>
    </filter>
    <filter-mapping>
        <filter-name>HiddenHttpMethodFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
<!--    配置dispatchServlet-->
    <servlet>
        <servlet-name>DispatcherServlet</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>-->
            <param-value>classpath:applicationContext.xml</param-value>

        </init-param>
<!--        提前服务器启动-->
        <load-on-startup>1</load-on-startup>
    </servlet>
    <servlet-mapping>
        <servlet-name>DispatcherServlet</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>

<!--    &lt;!&ndash;    配置spring的监听器&ndash;&gt;
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
&lt;!&ndash;设置配置文件路径&ndash;&gt;
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext.xml</param-value>
    </context-param>-->

</web-app>

5、编写springmvc.xml配置文件

1、配置扫描包
2、配置视图解析器
3、开启静态资源访问
4、开启mvc注解驱动
<?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 https://www.springframework.org/schema/context/spring-context.xsd
          http://www.springframework.org/schema/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd">

<!--    开启扫描包-->
    <context:component-scan base-package="com.GLH">
<!--        只扫描Controller-->
        <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>
<!--   配置视图解析器-->
    <bean id="org" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<!--        配置前置-->
        <property name="prefix" value="/WEB-INF/View/"></property>
<!--        配置后缀-->
        <property name="suffix" value=".jsp"></property>
    </bean>

<!--    开启静态资源访问-->
    <mvc:default-servlet-handler/>
    <mvc:resources mapping="/css/**" location="/css/"/>
    <mvc:resources mapping="/images/**" location="/images/"/>
    <mvc:resources mapping="/js/**" location="/js/"/>

    <!--    设置mvc注解驱动-->
    <mvc:annotation-driven/>

<!--   -->
    <mvc:view-controller path="/" view-name="index"></mvc:view-controller>



</beans>

 

6、整合配置文件

1、导入spring-dao、springmvc配置文件
2、配置扫描包

<?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"
       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">
<!--引入sprinmvc配置文件-->
    <import resource="springmvc.xml"></import>
    <import resource="spring-dao.xml"></import>

<!--    开启注解扫描，处理service和dao，但不需要处理controller-->
    <context:component-scan base-package="com.GLH">
<!--        配置哪注解不扫描-->
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>
</beans>

 

7、测试

1、测试视图是否能够正常响应
2、测试dao层的调用
3、测试service层的调用
4、测试controller层的调用

 

 

 

posted @ 2022-04-01 22:54  无忧  阅读(35)  评论(0)    收藏  举报