原始整合

目标

简单的添加账户和查看账户的功能

技术

框架：ssm

数据库：mysql

前端：jsp

构建：maven

步骤

1.创建数据库和表

create database ssm;
CREATE table account(
  id int primary key auto_increment,
  name VARCHAR(100),
  money double(7,2));

2.创建Maven工程，导入依赖

  <dependencies>
<!--        spring相关-->
        <!--上下文-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>${spring-version}</version>
        </dependency>
        <!--AOP用-->
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.9.8.M1</version>
        </dependency>
        <!--jdbc模板-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>${spring-version}</version>
        </dependency>
        <!--事务控制-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-tx</artifactId>
            <version>${spring-version}</version>
        </dependency>
        <!--测试相关-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>${spring-version}</version>
        </dependency>
        <!--springmvc-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>${spring-version}</version>
        </dependency>
<!--        servlet+jsp相关-->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>servlet-api</artifactId>
            <version>2.5</version>
        </dependency>
        <dependency>
            <groupId>javax.servlet.jsp</groupId>
            <artifactId>jsp-api</artifactId>
            <version>2.2</version>
        </dependency>
<!--        mybatis相关-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.5</version>
        </dependency>
        <!--正式整合的时候用，目前为原始整合，暂时不用-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.3.0</version>
        </dependency>
        <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <version>8.0.25</version>
      </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.13.2</version>
            <scope>test</scope>
        </dependency>
        <!--jsp标准库-->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>
    </dependencies>

3创建数据库Bean

在com.ssmfuse.domain包下创建Bean

package com.ssmfuse.domain;
/**
 * Account表的Bean
 * @author hfc
 */
public class Account {
    private Integer id;
    private String name;
    private Double money;
    public Integer getId() {
        return id;
    }
    public void setId(Integer id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public Double getMoney() {
        return money;
    }
    public void setMoney(Double money) {
        this.money = money;
    }
}

4.创建持久层和业务层，Controller层接口及实现类

4.1：持久层接口

package com.ssmfuse.mapper;
import com.ssmfuse.domain.Account;
import java.util.List;
/**
 * 持久层Mapper
 * @author hfc
 */
public interface IAccountMapper {
    /**
     * 保存账户
     * @param account
     */
    public void save(Account account);
    /**
     * 查询账户
     * @return
     */
    public List<Account> findAll();
}

4.2：业务层接口

package com.ssmfuse.service;
import com.ssmfuse.domain.Account;
import java.util.List;
/**
 * 业务层 service
 * @author hfc
 */
public interface AccountService {
    /**
     * 保存账户
     * @param account
     */
    public void save(Account account);
    /**
     * 查询账户
     * @return
     */
    public List<Account> findAll();
}

4.3：Controller层

package com.ssmfuse.controller;
import com.ssmfuse.domain.Account;
import org.springframework.web.servlet.ModelAndView;
/**
 * Controller层
 * @author 化粪池堵塞的凶手
 */
public class AccountController {
    /**
     * 保存
     */
    public String save(Account account){
        return null;
    }
    /**
     * 查询
     */
    public ModelAndView findAll(){
        return null;
    }
}

5 创建前端界面

在跟目录创建save.jsp

<%--
  Created by IntelliJ IDEA.
  User: 28985
  Date: 2021/11/7
  Time: 11:36
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
    <h1>添加账户信息</h1>
    <form name="accountFrom" action="${pageContext.request.contextPath}/account/save/" method="post">
        name<input type="text" name="name"/><br>
        money<input type="text" name="money"><br>
        <input type="submit" value="保存">
    </form>
</body>
</html>

在WEB-INF里创建文件pages，在pages目录下创建AccountList.jsp

<%--
  Created by IntelliJ IDEA.
  User: 28985
  Date: 2021/11/7
  Time: 11:42
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
    <h1>账户列表</h1>
    <table>
        <tr> <th> id</th> <th>名称</th> <th>金额</th></tr>
    </table>
</body>
</html>

配置文件

jdbc.properties

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssm
jdbc.password=adminadmin
jdbc.username=root

log4j.properties

#将等级为DEBUG的日志信息输出到console和file这两个目的地，console和file的定义在下面的代码
log4j.rootLogger=DEBUG,console,file
#控制台输出的相关设置
log4j.appender.console = org.apache.log4j.ConsoleAppender
log4j.appender.console.Target = System.out
log4j.appender.console.Threshold=DEBUG
log4j.appender.console.layout = org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern=[%c]-%m%n
#文件输出的相关设置
log4j.appender.file = org.apache.log4j.RollingFileAppender
log4j.appender.file.File=./log/logFile.log
log4j.appender.file.MaxFileSize=10mb
log4j.appender.file.Threshold=DEBUG
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=[%p][%d{yy-MM-dd}][%c]%m%n
#日志输出级别
log4j.logger.org.mybatis=DEBUG
log4j.logger.java.sql=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.ResultSet=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG

创建spring主配置文件appliccaltionContext.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"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:comtext="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/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
       http://www.springframework.org/schema/context
       http://www.springframework.org/schema/context/spring-context.xsd">
    <!--组件扫描-->
    <comtext:component-scan base-package="com.ssmfuse">
        <!--排除controller层，controller层是由springmvc进行管理的-->
        <context:exclude-filter type="annotation"  expression="org.springframework.stereotype.Controller"/>
    </comtext:component-scan>
</beans>

创建springMVC主配置文件

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:context="http://www.springframework.org/schema/context"
       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/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">
    <!--组件扫描-->
    <context:component-scan base-package="com.ssmfuse.controller"></context:component-scan>
    <!--配置mvc注解驱动-->
    <mvc:annotation-driven></mvc:annotation-driven>
    <!--内部资源视图解析器-->
    <bean id="resourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/pages"></property>
        <property name="suffix" value=".jsp"/>
    </bean>
    <!--开放静态资源访问权限-->
    <mvc:default-servlet-handler></mvc:default-servlet-handler>
</beans>

创建mybatis主配置文件sqlMapConfig.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>
    <!--加载properties文件-->
    <properties resource="jdbc.properties"></properties>
    <!--定义别名-->
    <typeAliases>
        <!--<typeAlias type="com.ssmfuse.domain.Account" alias="account"></typeAlias>-->
        <package name="com.ssmfuse.domain"/>
    </typeAliases>
    <!--环境-->
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>
    <!--加载映射-->
    <mappers>
        <mapper resource="com/ssmfuse/mapper/AccountMapper.xml"></mapper>
        <!--包加载方式接口名需要和配置文件名称一致-->
        <!--<package name="com.ssmfuse.mapper"/>-->
    </mappers>
</configuration>

在com/ssmfuse/mapper文件夹下创建mybatis映射文件AccountMapper.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.ssmfuse.mapper.IAccountMapper">
    <insert id="save" parameterType="account">
        insert into account values (#{id},#{name},#{money}) 
    </insert>
    <select id="findAll" resultType="account">
        select * from account
    </select>
</mapper>

修改web.xml文件

<web-app xmlns="http://java.sun.com/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
    http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
         version="2.5">
  <!--spring监听器-->
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:appliccaltionContext.xml</param-value>
  </context-param>
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
  <!--springmvc前端控制器-->
  <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:spring-mvc.xml</param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
  </servlet>
  <servlet-mapping>
    <servlet-name>DispatcherServlet</servlet-name>
    <!--任何访问资源都经过springmvc-->
    <url-pattern>/</url-pattern>
  </servlet-mapping>
  <!--乱码过滤器-->
  <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>
</web-app>

注解配置

根据index.html里的

内容给Controller层添加注解

package com.ssmfuse.controller;
import com.ssmfuse.domain.Account;
import com.ssmfuse.service.IAccountService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.servlet.ModelAndView;
import java.util.List;
/**
 * Controller层
 * @author 化粪池堵塞的凶手
 */
@Controller
@RequestMapping("/account")
public class AccountController {
    @Autowired
    private IAccountService accountService;
    /**
     * 保存
     */
    @RequestMapping(value="/save",produces = "text/html;charset=UTF-8")//解决乱码
    @ResponseBody//将java对象转为json格式的数据
    public String save(Account account){
        try {
            accountService.save(account);
            System.out.println("保存成功");
            return "保存成功";
        }catch (Exception e){
            System.out.println("保存失败");
            return "保存失败";
        }
    }
    /**
     * 查询
     */
    @RequestMapping(value = "/findAll")
    public ModelAndView findAll(){
        List<Account> accountList = accountService.findAll();
        ModelAndView modelAndView = new ModelAndView();
        modelAndView.addObject("accountList",accountList);
        modelAndView.setViewName("AccountList");
        return modelAndView;
    }
}

这时我们又可以发现

会报错因为此时spring容器中没有可以符合要求的bean

所以我们要到service层实现类中添加注解并增加方法实现

package com.ssmfuse.service.impl;
import com.ssmfuse.domain.Account;
import com.ssmfuse.mapper.IAccountMapper;
import com.ssmfuse.service.IAccountService;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.springframework.stereotype.Service;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
/**
 * @author 化粪池堵塞的凶手
 */
@Service("accountService")
public class AccountServiceImpl implements IAccountService {
    @Override
    public void save(Account account) {
        try {
            InputStream inputStream = Resources.getResourceAsStream("sqlMapConfig.xml");
            SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);
            SqlSession session =factory.openSession();//自动commit
            IAccountMapper accountMapper = session.getMapper(IAccountMapper.class);
            accountMapper.save(account);
            session.commit();
            inputStream.close();
            session.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    @Override
    public List<Account> findAll() {
        try {
            InputStream inputStream = Resources.getResourceAsStream("sqlMapConfig.xml");
            SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);
            SqlSession session =factory.openSession(true);//自动commit
            IAccountMapper accountMapper = session.getMapper(IAccountMapper.class);
            List<Account> all = accountMapper.findAll();
//            session.commit(); 已经设置自动commit了就不需要了
            inputStream.close();
            session.close();
            return all;
        } catch (IOException e) {
            e.printStackTrace();
        }
        return null;
    }
}

之后修改AccountList.jsp 加入jstl表达式便可以输出了

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<html>
<head>
    <title>Title</title>
</head>
<body>
    <h1>账户列表</h1>
    <table>
        <tr> <th> id</th> <th>名称</th> <th>金额</th></tr>
        <c:forEach items="${accountList}" var="account">
            <tr>
                <td>${account.id} </td>
                <td>${account.name} </td>
                <td>${account.money} </td>
            </tr>
        </c:forEach>
    </table>
</body>
</html>

我在运行时发现一个问题，在tomcat7时 controller层会无响应浏览器一直转圈切换为tomcat8问题就解决了

spring 整合

原始整合的一些问题：

我们可以发现在原始整合时，每调用一次业务层就读取一次配置文件，并且每个对数据库的操作都需要写一遍事务代码，整合就是要解决这些问题。

解决读取配置文件的问题

修改原来的mybatis配置文件将加载properties，mysql环境，以及映射交给spring管理

<?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>
        <!--<typeAlias type="com.ssmfuse.domain.Account" alias="account"></typeAlias>-->
        <package name="com.ssmfuse.domain"/>
    </typeAliases>
</configuration>

在appliccaltioncontext.xml中补充这些操作

<context:property-placeholder location="classpath:jdbc.properties"/>
    <!--创建数据源-->
    <bean id="dataSources" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${jdbc.driver}"/>
        <property name="jdbcUrl" value="${jdbc.url}"/>
        <property name="user" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>
    <!--创建工厂-->
    <bean id="mybatisFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSources"/>
        <property name="configLocation" value="classpath:sqlMapConfig_spring.xml"/>
    </bean>
    <!--扫描并创建所有mapper-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.ssmfuse.mapper"/>
    </bean>

在使用MapperScannerConfigurer时spring会扫描我们指定的包来将其存入IOC容器中供我们调用。

此时我们的业务层接口便可以更改为

/**
 * 业务层
 * @author 化粪池堵塞的凶手
 */
@Service("accountService")
public class AccountServiceImpl implements IAccountService {
    @Autowired
    IAccountMapper accountMapper;
    @Override
    public void save(Account account) {
        accountMapper.save(account);
    }
    @Override
    public List<Account> findAll() {
        return accountMapper.findAll();
    }
}

遇到的问题：

起初我创建的项目结构是这样的

映射文件名与被映射的类名不一致导致报错

Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid b

文件名更改后正常运行

SSM框架的整合

原始整合

目标

技术

步骤

1.创建数据库和表

2.创建Maven工程，导入依赖

3创建数据库Bean

4.创建持久层和业务层，Controller层接口及实现类

5 创建前端界面

配置文件

注解配置

spring 整合

原始整合的一些问题：

解决读取配置文件的问题

遇到的问题：

事务控制

热门文章

最新文章

相关课程

相关电子书

热门

活动广场

任务中心

开发者评测

高校计划

乘风者计划

训练营

阿里云MVP

话题

直播

下载

镜像站

技术资料

插件

SSM框架的整合

原始整合

目标

技术

步骤

1.创建数据库和表

2.创建Maven工程，导入依赖

3创建数据库Bean

4.创建持久层和业务层，Controller层接口及实现类

5 创建前端界面

配置文件

注解配置

spring 整合

原始整合的一些问题：

解决读取配置文件的问题

遇到的问题：

事务控制

热门文章

最新文章

相关课程

相关电子书