• 猿创征文|Spring、SpringMVC、Mybatis整合测试

    目录

    SSM整合测试

    ①创建数据库

    ②创建maven工程

     ③pom.xml中导入对应的坐标

    ④编写实体类

    ⑤编写Mapper接口（dao接口）

     ⑥编写service接口

     ⑦编写Service接口实现

     ⑧编写Controller

     ⑨编写jsp添加页面

     ⑩编写列表jsp展示页面

    ①①编写响应的配置文件

    applicationContext.xml

    jdbc.properties

    spring-mvc.xml

    sqlMapConfig.xml

    sqlMapConfig-spring.xml

    ①②测试添加账户和账户列表

    ①③数据库中测试

    SSM整合测试

    ①创建数据库

    ②创建maven工程

     ③pom.xml中导入对应的坐标

    1.   <dependencies>
    2.     
    3.     <dependency>
    4.       <groupId>org.springframeworkgroupId>
    5.       <artifactId>spring-contextartifactId>
    6.       <version>5.0.5.RELEASEversion>
    7.     dependency>
    8.     <dependency>
    9.       <groupId>org.aspectjgroupId>
    10.       <artifactId>aspectjweaverartifactId>
    11.       <version>1.8.7version>
    12.     dependency>
    13.     <dependency>
    14.       <groupId>org.springframeworkgroupId>
    15.       <artifactId>spring-jdbcartifactId>
    16.       <version>5.0.5.RELEASEversion>
    17.     dependency>
    18.     <dependency>
    19.       <groupId>org.springframeworkgroupId>
    20.       <artifactId>spring-txartifactId>
    21.       <version>5.0.5.RELEASEversion>
    22.     dependency>
    23.     <dependency>
    24.       <groupId>org.springframeworkgroupId>
    25.       <artifactId>spring-testartifactId>
    26.       <version>5.0.5.RELEASEversion>
    27.     dependency>
    28.     <dependency>
    29.       <groupId>org.springframeworkgroupId>
    30.       <artifactId>spring-webmvcartifactId>
    31.       <version>5.0.5.RELEASEversion>
    32.     dependency>
    33.  
    34.     
    35.     <dependency>
    36.       <groupId>javax.servletgroupId>
    37.       <artifactId>servlet-apiartifactId>
    38.       <version>2.5version>
    39.     dependency>
    40.     <dependency>
    41.       <groupId>javax.servlet.jspgroupId>
    42.       <artifactId>jsp-apiartifactId>
    43.       <version>2.0version>
    44.     dependency>
    45.  
    46.     
    47.     <dependency>
    48.       <groupId>org.mybatisgroupId>
    49.       <artifactId>mybatisartifactId>
    50.       <version>3.4.5version>
    51.     dependency>
    52.     <dependency>
    53.       <groupId>org.mybatisgroupId>
    54.       <artifactId>mybatis-springartifactId>
    55.       <version>1.3.1version>
    56.     dependency>
    57.     <dependency>
    58.       <groupId>mysqlgroupId>
    59.       <artifactId>mysql-connector-javaartifactId>
    60.       <version>5.1.6version>
    61.     dependency>
    62.     <dependency>
    63.       <groupId>c3p0groupId>
    64.       <artifactId>c3p0artifactId>
    65.       <version>0.9.1.2version>
    66.     dependency>
    67.  
    68.     <dependency>
    69.       <groupId>junitgroupId>
    70.       <artifactId>junitartifactId>
    71.       <version>4.12version>
    72.     dependency>
    73.     <dependency>
    74.       <groupId>jstlgroupId>
    75.       <artifactId>jstlartifactId>
    76.       <version>1.2version>
    77.     dependency>
    78.  
    79.   dependencies>

    ④编写实体类

    1. public class Account {
    2.  
    3.     private Integer id;
    4.     private String name;
    5.     private Double money;
    6.  
    7. //get set方法
    8. }

    ⑤编写Mapper接口（dao接口）

    1.  
    2. public interface AccountMapper {
    3.    @Insert(" insert into account values(#{id},#{name},#{money})")
    4.     public void save(Account account);
    5.  
    6. @Select(" select * from account")
    7.     public List findAll();
    8.  
    9. }

     ⑥编写service接口

    1.  
    2.  
    3. public interface AccountService {
    4.  
    5.     public void save(Account account);
    6.  
    7.     public List findAll();
    8.  
    9. }

     ⑦编写Service接口实现

    1.  
    2.  
    3. @Service("accountService")
    4. public class AccountServiceImpl implements AccountService {
    5.  
    6.     @Autowired
    7.     private AccountMapper accountMapper;
    8.  
    9.     @Override
    10.     public void save(Account account) {
    11.         accountMapper.save(account);
    12.     }
    13.  
    14.     @Override
    15.     public List findAll() {
    16.         return accountMapper.findAll();
    17.     }
    18. }

     ⑧编写Controller

    1.  
    2.  
    3. @Controller
    4. @RequestMapping("/account")
    5. public class AccountController {
    6.  
    7.     @Autowired
    8.     private AccountService accountService;
    9.  
    10.     //保存
    11.     @RequestMapping(value = "/save",produces = "text/html;charset=UTF-8")
    12. @ResponseBody
    13.     public String save(Account account){
    14.         accountService.save(account);
    15.         return  "提交成功";
    16.     }
    17.  
    18.     //查询
    19.     @RequestMapping("/findAll")
    20.     public ModelAndView findAll(){
    21.         List accountList =  accountService.findAll();
    22.         ModelAndView modelAndView = new ModelAndView();
    23.         modelAndView.addObject("accountList",accountList);
    24.         modelAndView.setViewName("accountList");
    25.         return modelAndView;
    26.     }
    27.  
    28. }

     ⑨编写jsp添加页面

    1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    2. <html>
    3. <head>
    4.     <title>Titletitle>
    5. head>
    6. <body>
    7.     <h1>添加账户信息表单h1>
    8.     <form name="accountForm" action="${pageContext.request.contextPath}/account/save" method="post">
    9.         账户名称:<input type="text" name="name"><br>
    10.         账户金额:<input type="text" name="money"><br>
    11.         <input type="submit" value="保存"><br>
    12.     form>
    13. body>
    14. html>

     ⑩编写列表jsp展示页面

    1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    2. <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
    3. <html>
    4. <head>
    5.     <title>Titletitle>
    6. head>
    7. <body>
    8.     <h1>展示账户数据列表h1>
    9.     <table border="1">
    10.         <tr>
    11.             <th>账户idth>
    12.             <th>账户名称th>
    13.             <th>账户金额th>
    14.         tr>
    15.  
    16.         <c:forEach items="${accountList}" var="account">
    17.             <tr>
    18.                 <td>${account.id}td>
    19.                 <td>${account.name}td>
    20.                 <td>${account.money}td>
    21.             tr>
    22.         c:forEach>
    23.  
    24.     table>
    25.  
    26. body>
    27. html>

    ①①编写响应的配置文件

    applicationContext.xml

    1. "1.0" encoding="UTF-8" ?>
    2. <beans xmlns="http://www.springframework.org/schema/beans"
    3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.        xmlns:aop="http://www.springframework.org/schema/aop"
    5.        xmlns:tx="http://www.springframework.org/schema/tx"
    6.        xmlns:context="http://www.springframework.org/schema/context"
    7.        xsi:schemaLocation="http://www.springframework.org/schema/beans
    8. http://www.springframework.org/schema/beans/spring-beans.xsd
    9. http://www.springframework.org/schema/tx
    10. http://www.springframework.org/schema/tx/spring-tx.xsd
    11. http://www.springframework.org/schema/aop
    12. http://www.springframework.org/schema/aop/spring-aop.xsd
    13. http://www.springframework.org/schema/context
    14. http://www.springframework.org/schema/context/spring-context.xsd">
    15.  
    16.     
    17.     <context:component-scan base-package="com">
    18.         
    19.         <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller">context:exclude-filter>
    20.     context:component-scan>
    21.  
    22.     
    23.     <context:property-placeholder location="classpath:jdbc.properties"/>
    24.  
    25.     
    26.     <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    27.         <property name="driverClass" value="${jdbc.driver}">property>
    28.         <property name="jdbcUrl" value="${jdbc.url}">property>
    29.         <property name="user" value="${jdbc.username}">property>
    30.         <property name="password" value="${jdbc.password}">property>
    31.     bean>
    32.  
    33.     
    34.     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    35.         <property name="dataSource" ref="dataSource">property>
    36.         
    37.         <property name="configLocation" value="classpath:sqlMapConfig-spring.xml">property>
    38.     bean>
    39.  
    40.     
    41.     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    42.         <property name="basePackage" value="com.mapper">property>
    43.     bean>
    44.  
    45.  
    46.     
    47.     
    48.     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    49.         <property name="dataSource" ref="dataSource">property>
    50.     bean>
    51.  
    52.     
    53.     <tx:advice id="txAdvice">
    54.         <tx:attributes>
    55.             <tx:method name="*"/>
    56.         tx:attributes>
    57.     tx:advice>
    58.  
    59.     
    60.     <aop:config>
    61.         <aop:advisor advice-ref="txAdvice" pointcut="execution(* com.service.impl.*.*(..))">aop:advisor>
    62.     aop:config>
    63.  
    64. beans>

    jdbc.properties

    1. jdbc.driver=com.mysql.jdbc.Driver
    2. jdbc.url=jdbc:mysql://localhost:3306/ssm
    3. jdbc.username=root
    4. jdbc.password=123456


    spring-mvc.xml

    1. "1.0" encoding="UTF-8" ?>
    2. <beans xmlns="http://www.springframework.org/schema/beans"
    3.        xmlns:mvc="http://www.springframework.org/schema/mvc"
    4.        xmlns:context="http://www.springframework.org/schema/context"
    5.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    6.        xsi:schemaLocation="http://www.springframework.org/schema/beans
    7. http://www.springframework.org/schema/beans/spring-beans.xsd
    8. http://www.springframework.org/schema/mvc
    9. http://www.springframework.org/schema/mvc/spring-mvc.xsd
    10. http://www.springframework.org/schema/context
    11. http://www.springframework.org/schema/context/spring-context.xsd">
    12.  
    13.     
    14.     <context:component-scan base-package="com.controller"/>
    15.     
    16.     <mvc:annotation-driven/>
    18.     <bean id="resourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    19.         <property name="prefix" value="/WEB-INF/pages/"/>
    20.         <property name="suffix" value=".jsp"/>
    21.     bean>
    22.     
    23.     <mvc:default-servlet-handler/>
    24.  
    25.  
    26. beans>


    sqlMapConfig.xml

    1. "1.0" encoding="UTF-8" ?>
    2. configuration
    3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
    5. <configuration>
    6.  
    7.     
    8.     <properties resource="jdbc.properties">properties>
    9.  
    10.  
    11.  
    12.     
    13.     <environments default="development">
    14.         <environment id="development">
    15.             <transactionManager type="JDBC">transactionManager>
    16.             <dataSource type="POOLED">
    17.                 <property name="driver" value="${jdbc.driver}">property>
    18.                 <property name="url" value="${jdbc.url}">property>
    19.                 <property name="username" value="${jdbc.username}">property>
    20.                 <property name="password" value="${jdbc.password}">property>
    21.             dataSource>
    22.         environment>
    23.     environments>
    24.  
    25.     
    26.     <mappers>
    27.  
    28.         <package name="com.mapper">package>
    29.     mappers>
    30.  
    31.  
    32. configuration>


    sqlMapConfig-spring.xml

    1. "1.0" encoding="UTF-8" ?>
    2. configuration
    3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
    5. <configuration>
    6.  
    7.     
    8.     <typeAliases>
    9.         
    10.         <package name="com.domain">package>
    11.     typeAliases>
    12.  
    13. configuration>

    ①②测试添加账户和账户列表

    ①③数据库中测试

  • 相关阅读:
    国家互联网信息办公室修订《互联网跟帖评论服务管理规定》发布施行
    前端架构师之09_JavaScript_BOM
    计算机Android毕业设计论文基于Uniapp+SSM实现的Android安全网购平台
    自动化运维机器人（RPA）在银行IT运维领域应用场景分析
    Visual Studio 中的键盘快捷方式大全
    Vue详解及综合案例
    分布式事务Seata
    springboot毕设项目个人博客的设计与实现i03nz（java+VUE+Mybatis+Maven+Mysql）
    权限管理系统-0.4.0
    解析90后创客教育的主观积极性
  • 原文地址：https://blog.csdn.net/weixin_60719453/article/details/126636749