SSM整合（XML）--------- (2)spring整合MyBatis

xml版本模板链接：https://pan.baidu.com/s/1foZrxFjQwf8YBpqVriN2Pg
提取码：3ldi

注解版本模板链接：https://pan.baidu.com/s/1mxY9QMletUlzcsZ2VfqfQg
提取码：g5gh

下面的图片是按照操作步骤排序的，从前到后

• UserDao.xml，这个文件在resource里面的com.yy.dao里面

  
  
  
  
      
      
          insert into user(userName,password,realName,gender,birthday)values(#{userName},#{password},#{realName},#{gender},#{birthday})
      
  
      
      
          delete from user where uuid = #{uuid}
      
  
      
      
          update user set userName=#{userName},password=#{password},realName=#{realName},gender=#{gender},birthday=#{birthday} where uuid=#{uuid}
      
  
      
      
          select * from user where uuid = #{uuid}
      
  
      
      
          select * from user
      
  
      
      
          select * from user where userName=#{userName} and password=#{password}
      
  
  
  

• 组件扫描

    
    

    
    
        
        
    

    
    

    
    

    
    
        
        
        
        
    

    
    
        
        
        
        
            
                
                    
                        
                            mysql
                            true
                        
                    
                
            
        
    

    
    
        
    

    
    
        
    

• SqlSesionFactoryBean

  
      
      
      
      
          
              
                  
                      
                          mysql
                          true
                      
                  
              
          
      
  
  

• 数据源(druid+jdbc.properties)

  • 数据源

  • jdbc.properties

    jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/ssm_db
    jdbc.username=root
    jdbc.password=2184021338
    

• 映射扫描

• 注解事务

  在业务层开启事务管理器

  package com.yy.service;
  
  import com.github.pagehelper.PageInfo;
  import com.yy.domain.User;
  import org.springframework.transaction.annotation.Transactional;
  
  @Transactional(readonly = true)//在这里开启业务层的事务管理，应该将它开在业务层的接口上
  //在这里开启只读事务，因为业务层的方法还是查询多，增删改有限的
  //给增删改方法，修改为读写事务
  public interface UserService {
      
      @Transactional(readonly = false)
      public boolean save(User user);
  
      
      @Transactional(readonly = false)
      public boolean update(User user);
  
      
      @Transactional(readonly = false)
      public boolean delete(Integer uuid);
  
      
      public User get(Integer uuid);
  
      
      public PageInfo getAll(int page, int size);
  
      
      public User login(String userName,String password);
  }
  

• 分页插件

  
      
      
      
      
          
              
                  
                      
                          mysql
                          true
                      
                  
              
          
      
  
  

package com.yy.service;

import com.github.pagehelper.PageInfo;
import com.yy.domain.User;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import java.util.Date;


//Junit专用的类加载器
@RunWith(SpringJUnit4ClassRunner.class)
//指定它的配置文件
@ContextConfiguration(locations = "classpath:applicationContext.xml")
public class UserServiceTest {
    //注入要测的能个接口
    @Autowired
    private UserService userService;
    //写测试方法
    @Test
    public void testSave(){
        User user = new User();
        user.setUserName("Jock");
        user.setPassword("root");
        user.setRealName("Jockme");
        user.setGender(1);
        user.setBirthday(new Date(333333000000L));

        userService.save(user);
    }

    @Test
    public void testDelete(){
        User user = new User();
        userService.delete(3);
    }

    @Test
    public void testUpdate(){
        User user = new User();
        user.setUuid(1);
        user.setUserName("Jockme");
        user.setPassword("root");
        user.setRealName("JockIsMe");
        user.setGender(1);
        user.setBirthday(new Date(333333000000L));

        userService.update(user);
    }

    @Test
    public void testGet(){
        User user = userService.get(1);
        System.out.println(user);
    }

    @Test
    public void testGetAll(){
        PageInfo all = userService.getAll(2, 2);
        System.out.println(all);
        System.out.println(all.getList().get(0));
        System.out.println(all.getList().get(1));
    }

    @Test
    public void testLogin(){
        User user = userService.login("Jockme", "root");
        System.out.println(user);
    }
}