SSM整合(xml配置文件形式)

2023-11-29 23:16:27 星期三

1.依赖引入

<dependencies>
        <!--servlet-api依赖-->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>4.0.1</version>
            <scope>provided</scope>
        </dependency>
        <!--spring基础依赖-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.3.20</version>
        </dependency>
        <!--spring连接jdbc-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.3.20</version>
        </dependency>
        <!--spring web依赖-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-web</artifactId>
            <version>5.3.20</version>
        </dependency>
        <!--spring webmvc依赖-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>5.3.20</version>
        </dependency>
        <!--aop面向切面编程框架-->
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.9.7</version>
        </dependency>
        <!--spring事务管理-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-tx</artifactId>
            <version>5.3.20</version>
        </dependency>
        <!--mybatis依赖-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.4</version>
        </dependency>
        <!--mybatis与spring整合-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.3.2</version>
        </dependency>
        <!--mysql数据库依赖-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.29</version>
        </dependency>
        <!--dbcp连接池-->
        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-dbcp2</artifactId>
            <version>2.11.0</version>
        </dependency>
        <!--lombok依赖-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.30</version>
        </dependency>
    </dependencies>

2.application.xml核心配置文件

<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.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">

    <!--配置数据源-->
    <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource">
        <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/qinmanage"/>
        <property name="username" value="root"/>
        <property name="password" value="127003"/>
    </bean>

    <!--sqlSessionFactory-->
    <bean  id="sqlSessionFactory"  class="org.mybatis.spring.SqlSessionFactoryBean">
        <!-- mybatis配置文件-->
        <property name="configLocation" value="classpath:mybatis-config.xml"/>
        <!--数据源的配置-->
        <property name="dataSource" ref="dataSource"/>
    </bean>

    <!--Mapper接口的代理-->
    <bean id="studentMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
        <!--指定需要代理的接口-->
        <property name="mapperInterface" value="com.bboy.mapper.StudentMapper"/>
        <!--sqlSession工厂-->
        <property name="sqlSessionFactory" ref="sqlSessionFactory"/>
    </bean>
    <!--Service注册-->
    <bean id="studentService" class="com.bboy.service.impl.StudentServiceImpl">
        <property name="studentMapper" ref="studentMapper"/>
    </bean>
    <!-- 事务管理数据源的配置-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>
    <!--配置事务-->
    <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <!--配置事务的属性
            1. name: 指定的哪些方式进行事务管理(这些方式指的事service中的方法)
                1.1 * 表示所有的方法都需要进行事务管理
                1.2 save* 表示save开头的方式需要进行事务管理
            2. propagation: 传播级别
                2.1 REQUIRED 如果当前没有事务，就新建一个事务，如果已经存在一个事务中，就加入到这个事务中。这是最常见的选择。
            3. isolation： 隔离级别
        -->
        <tx:attributes>
            <tx:method name="*" propagation="REQUIRED" isolation="DEFAULT"/>
           <!--
            <tx:method name="update*" propagation="REQUIRED" isolation="DEFAULT"/>
            <tx:method name="select*" propagation="REQUIRED" isolation="DEFAULT"/>
            -->
        </tx:attributes>
    </tx:advice>
    <!--使用AOP编程进行事务的配置-->
    <aop:config>
        <aop:advisor advice-ref="txAdvice" pointcut="execution(* com.bboy.service.impl.*.*(..))"/>
    </aop:config>
</beans>

3.spring-mvc.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"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">
    <!--
            处理映射器
            BeanNameUrlHandlerMapper
        -->
    <bean class="org.springframework.web.servlet.handler.BeanNameUrlHandlerMapping"/>
    <!--
        处理器适配器
        SimpleControllerHandlerAdapter
    -->
    <bean class="org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter"/>
    <!--
         处理器
         自定义实现Controller接口（对应：SimpleControllerHandlerAdapter）
    -->
    <bean name="/query" class="com.bboy.controller.StudentQueryController">
        <property name="studentService" ref="studentService"/>
    </bean>
    <!--
        视图解析器
    -->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <!--添加跳转目录的前缀-->
        <property name="prefix" value="/WEB-INF/"/>
        <!--添加跳转目录的后缀缀-->
        <property name="suffix" value=".jsp"/>
    </bean>
</beans>

4.mybatis-config.xml

<?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>
    <!--实体类别名的设置-->
    <typeAliases>
        <package name="com.bboy.pojo"/>
    </typeAliases>
    <mappers>
        <mapper resource="mapper/StudentMapper.xml"/>
    </mappers>
</configuration>

5.controller(StudentQueryController)

package com.bboy.controller;

import com.bboy.pojo.Student;
import com.bboy.service.StudentService;
import org.springframework.context.annotation.Configuration;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.Controller;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.List;

/**
 * @类描述：
 * @作者：秦帅
 * @时间：2023/11/29 0029 15:50:24
 */
public class StudentQueryController implements Controller {
    private StudentService studentService;

    public void setStudentService(StudentService studentService) {
        this.studentService = studentService;
    }

    @Override
    public ModelAndView handleRequest(HttpServletRequest request, HttpServletResponse response) throws Exception {
        ModelAndView mav = new ModelAndView();
        List<Student> students = studentService.listStudents();
        mav.addObject("students",students);
        mav.setViewName("show");
        return mav;
    }
}

6.pojo(Student)

package com.bboy.pojo;

import lombok.Data;

@Data
/**
 * @类描述：
 * @作者：秦帅
 * @时间：2023/11/29 0029 15:45:15
 */
public class Student {
    private int id ;
    private String name ;
    private  String birth ;
    private  String sex ;
    private  String password ;
}

7.service

service接口

package com.bboy.service;

import com.bboy.pojo.Student;

import java.util.List;

public interface StudentService {
    public List<Student> listStudents();
}

实现类(StudentServiceImpl)

package com.bboy.service.impl;

import com.bboy.mapper.StudentMapper;
import com.bboy.pojo.Student;
import com.bboy.service.StudentService;

import java.util.List;

/**
 * @类描述：
 * @作者：秦帅
 * @时间：2023/11/29 0029 15:47:48
 */
public class StudentServiceImpl implements StudentService {
    private StudentMapper studentMapper ;

    public void setStudentMapper(StudentMapper studentMapper) {
        this.studentMapper = studentMapper;
    }

    @Override
    public List<Student> listStudents() {
        return studentMapper.listStudents();
    }
}

8.mapper

package com.bboy.mapper;

import com.bboy.pojo.Student;

import java.util.List;

public interface StudentMapper {
    public List<Student> listStudents();
}

9.mapper.StudentMapper.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.bboy.mapper.StudentMapper">
    <select id="listStudents" resultType="Student">
        select * from t_student;
    </select>
</mapper>

10.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">
    <!--Spring监听器-->
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    <!--Spring配置文件的加载-->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext.xml</param-value>
    </context-param>
    <!--SpringMVC前端控制器-->
    <servlet>
        <servlet-name>springmvc</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <!--
        在前端控制器中加载springmvc的配置文件，例如：spring-mvc.xml   
        -->
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:spring-mvc.xml</param-value>
        </init-param>
    </servlet>
    <servlet-mapping>
        <servlet-name>springmvc</servlet-name>
        <!--
             配置哪些请求进入到：前端控制器
        -->
        <url-pattern>/</url-pattern>
    </servlet-mapping>
</web-app>

本栏目推荐文章
• C++实现文件内查找字符串
• 2023年度总结
• IDEA项目名称后面出现中括号，模块Modules的名子和文件夹名称不同，可以右键修改名称也可以在File->Project Structure 修改Modules的Name(快捷键ctrl+Shift+Alt+s)
• 和利时MACS6通过dat文件实现任意时间范围与测点的历史数据提取与科研分析
• CSP-J/S 2023 游记
• Libevent [补档-2023-08-29]
• 本地套接字 [补档-2023-07-24]
• UDP通信 [补档-2023-07-22]
• 多路io复用Select [补档-2023-07-16]
• 多路io复用pool [补档-2023-07-19]

SpringMVC 形式 文件 2023 SSMspringmvc形式 文件2023 springmvc-ssm springmvc案例2023 注解springmvc形式2023 springmvc注解 形式2023 springmvc-ssm ssm-springmvc springmvc ssm ssm-springmvc springmvc mybatis spring ssm springmvc-ssm springmvc ssm springmvc syntax ssm