SSM项目整合复习记录 来自黑马程序员的视频：连接ssm整合b站视频 1、创建Maven 2、导入Maven坐标

    
      junit
      junit
      4.11
      test
    
    
      javax.servlet
      jsp-api
      2.0
      provided
    
    
    
      javax.servlet
      servlet-api
      3.0-alpha-1
      provided
    

    
    
    
      org.springframework
      spring-web
      5.0.3.RELEASE
    


    
    
    
      org.springframework
      spring-webmvc
      5.0.3.RELEASE
    

    
    
    
      org.springframework
      spring-jdbc
      5.0.3.RELEASE
    

    
    
    
      org.springframework
      spring-aspects
      5.0.3.RELEASE
    

    
    
    
      org.mybatis
      mybatis
      3.4.5
    

    
    
    
      org.mybatis
      mybatis-spring
      1.3.1
    

    
    
    
      c3p0
      c3p0
      0.9.1.2
    

    
    
    
      mysql
      mysql-connector-java
      5.1.45
    

    
    
    
      jstl
      jstl
      1.2
    

    
    
      com.googlecode.json-simple
      json-simple
      1.1
    

    
    
      commons-fileupload
      commons-fileupload
      1.3.3
    

    
    
      com.google.code.gson
      gson
      2.8.2
    

    
    
      org.apache.commons
      commons-lang3
      3.7
    
  

3、开始，创建实体类

在java下创建放实体类的包，添加实体

package com.lyd.domain;

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、创建Accountmapper接口

package com.lyd.mapper;

import com.lyd.domain.Account;

import java.util.List;

public interface AccountMapper {
    public void save(Account account);
    public List findAll();
}

5、服务层Servic—AccountService接口以及实现AccountServiceImpl的实现

public interface AccountService {
    public void save();
    public List findAll();
}
//impl
@Service("accountService")
public class AccountServiceImpl implements AccountService {

    @Autowired
    private AccountMapper accountMapper;//已经放入spring容器，可以直接注入
    @Override
    public void save(Account account) {
        accountMapper.save(account);
    }

    @Override
    public List findAll() {
        return accountMapper.findAll();
    }
}

6、编写web层 AcountController

@Controller
@RequestMapping("/account")
public class AccountController {
    @Autowired
    private AccountService accountService;
    @RequestMapping(value = "/save",produces = "text/html;charset=UTF-8")
    @ResponseBody
    public String save(Account account){
        accountService.save(account);
        return "保存成功";
    }

    @RequestMapping(value = "/findAll")
    public ModelAndView findAll(){
        List accountList = accountService.findAll();
        ModelAndView modelAndView = new ModelAndView();
        modelAndView.addObject("accountList",accountList);
        modelAndView.setViewName("accountList");
        return modelAndView;
    }
}

7、编写页面 添加页面和显示页面

save.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    


    
添加账户金额
    

        账户名称：

        账户金额：

        

    

accountList.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>


    
展示用户数据
    
            

        

            
账户id
            
账户名称
            
账户密码
        
        

                
${account.id}
                
${account.name}
                
${account.money}
            
        

    

8、编写配置文件

Spring配置文件：applicationContext.xmlSpringMVC配置文件：spring-mvc.xmlMybatis映射文件：AccountMapper.xmlMybatis核心文件：sqlMapConfig.xml数据库连接信息文件：jdbc.propertiesWeb.xml文件：web.xml日志文件：log4j.xml ①jdbc.properties

jdbc.jdbcUrl = jdbc:mysql://localhost:3306/news
jdbc.driverClass = com.mysql.jdbc.Driver
jdbc.user = root
jdbc.password = root

②log4j.xml

# Global logging configuration
log4j.rootLogger=ERROR, stdout
# MyBatis logging configuration...
log4j.logger.com.ssm=DEBUG
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

③spring配置：applicationContext.xml

④配置spring-mvc.xml

⑤配置AccountMapper.xml

可以用mapper的方式，也可以用注解的方式，@Select…

    
        insert into account value (#{id},#{name},#{money})
    
    
        select * from account
    

结构图：

主意此处的创建要对应，而且新建需要用com/lyd/mapper,而非com.lyd.mapper 详情看解决org.apache.ibatis.binding.BindingException: Invalid bound statement (not found)问题

⑥sqlMapConfig.xml（mybatis未整合到spring）

整合到spring 的 sqlMapConfig-spring.xml

⑦web.xml

    
        contextConfigLocation
        classpath:applicationContext.xml
    
    
        org.springframework.web.context.ContextLoaderListener
    

    
        DispatcherServlet
        org.springframework.web.servlet.DispatcherServlet
        
            contextConfigLocation
            classpath:spring-mvc.xml
        
        1
    
    
        DispatcherServlet
        /
    

    
        CharacterEncodingFilter
        org.springframework.web.filter.CharacterEncodingFilter
        
            encoding
            UTF-8
        
    
    
        CharacterEncodingFilter
        /*
    

※将Spring整合到Mybatis的配置

在spring中配置 将sqlMapConfig配置转移到applicationContext.xml配置里面，将SQLSessionFactory配置到Spring容器中

在applicationContext.xml配置声明式事务控制实现

结束！！！