SSM整合

目录

整合思路

项目创建

在pom.xml添加相关依赖

配置文件编写

jdbc.properties

applicationContext.xml (spring整合mybatis)

sqlMapConfig.xml（mybatis配置文件）

spring-mvc.xml

web.xml

类的编写

com.cjt.domain(实体类)

com.cjt.mapper(接口)

AccountMapper.xml （对应mapper映射sql编写）

com.cjt.service(业务层)

com.cjt.controller(web层)

前端测试页面

测试

整合思路

创建Spring框架

通过Spring整合springMvc

通过Spring整合MyBatis

项目创建

 

在pom.xml添加相关依赖

  
  
    org.springframework
    spring-context
    5.0.5.RELEASE
  
  
    org.aspectj
    aspectjweaver
    1.8.7
  
  
    org.springframework
    spring-jdbc
    5.0.5.RELEASE
  
  
    org.springframework
    spring-tx
    5.0.5.RELEASE
  
  
    org.springframework
    spring-test
    5.0.5.RELEASE
  
  
    org.springframework
    spring-webmvc
    5.0.5.RELEASE
  
​
  
  
    javax.servlet
    servlet-api
    2.5
  
  
    javax.servlet.jsp
    jsp-api
    2.0
  
​
  
  
    org.mybatis
    mybatis
    3.4.5
  
  
    org.mybatis
    mybatis-spring
    1.3.1
  
  
    mysql
    mysql-connector-java
    5.1.6
  
  
    c3p0
    c3p0
    0.9.1.2
  
​
  
    junit
    junit
    4.12
  
  
    jstl
    jstl
    1.2
  

此处使用c3po数据库连接池

配置文件编写

jdbc.properties

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

applicationContext.xml (spring整合mybatis)

​
    
    
    
    
    
    
        
        
        
        
    
    
    
        
        
        
    
    
    
        
    

省略了事务管理部分

resources下的mapper要和mapper接口的路径相对应 否者无法映射

解决：

com.cjt.mapper (接口类)

com/cjt/mapper (resources存放sql文件的目录)

不同命要在配置sqlSessionFactory中加载sql文件

sqlMapConfig.xml（mybatis配置文件）

​
    
        
    


spring-mvc.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
    /*
  

类的编写

com.cjt.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;
    }
}

com.cjt.mapper(接口)

public interface AccountMapper {

    public List findAll();

}

AccountMapper.xml （对应mapper映射sql编写）

    
    
        select * from account
    

com.cjt.service(业务层)

public interface AccountService {

    public List findAll();

}

实现

@Service
public class AccountServiceImpl implements AccountService {
    @Autowired
    private AccountMapper accountMapper;

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

com.cjt.controller(web层)

@Controller
@RequestMapping("/account")
public class AccountController {

    @Autowired
    private AccountService accountService;

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

前端测试页面

WEB-INF/pages/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}
            
        

    

测试

运行访问controller中的findAll

http://localhost:8080/account/findAll