Mybatis和Spring相整合的详细步骤

pom.xml dependencies标签下所需导入的18个依赖：

      junit
      junit
      4.12
    
    
      commons-logging
      commons-logging
      1.2
    
    
      log4j
      log4j
      1.2.17
    
    
      org.mybatis
      mybatis
      3.2.2
    

    
      org.springframework
      spring-beans
      4.3.14.RELEASE
    
    
      org.springframework
      spring-context
      4.3.14.RELEASE
    
    
      org.springframework
      spring-core
      4.3.14.RELEASE
    
    
      org.springframework
      spring-expression
      4.3.14.RELEASE
    

    
      org.springframework
      spring-aop
      4.3.14.RELEASE
    
    
      org.springframework
      spring-aspects
      4.3.14.RELEASE
    
    
      org.aspectj
      aspectjweaver
      1.6.9
    
    
      aopalliance
      aopalliance
      1.0
    

    
      org.mybatis
      mybatis-spring
      1.2.2
    
    
      org.springframework
      spring-jdbc
      4.3.14.RELEASE
    
    
      org.springframework
      spring-tx
      4.3.14.RELEASE
    
    
      commons-dbcp
      commons-dbcp
      1.4
    
    
      commons-pool
      commons-pool
      1.6
    
    
      mysql
      mysql-connector-java
      5.1.45
    

build标签中注入resources标签：

    
      
        ${basedir}/src/main/java
        
          **/*.xml
        
      
    

注：此案例我以smbms为数据库，使用此库中的smbms_role和smbms_user两个表

pojo包，Smbms_Role

import java.util.Date;

private Integer id;
private String roleCode;
private String roleName;
private Integer createBy;
private Date creationDate;
private Integer modifyBy;
private Date modifyDate;

get，set和toString方法省略......（Alt＋Insert快捷键）

pojo包，Smbms_User

import java.util.Date;

private Integer id;
private String userCode;
private String userName;
private String userPassWord;
private String gender;
private Date birthday;
private String phone;
private String address;
private Integer userRole;
private Integer createBy;
private Date creationDate;
private Integer modifyBy;
private Date modifyDate;
private String idPicPath;
private String workPicPath;

get，set和toString方法省略......

UserMapper包，UserMapper

import org.apache.ibatis.annotations.Param;
import pojo.Smbms_User;
import java.util.List;

public interface UserMapper {
    //根据用户名和角色id查询信息
    List selectBy(@Param("userName") String userName, @Param("roleId")  Integer roleId);
}

UserMapper包，UserMapperImpl

import org.mybatis.spring.SqlSessionTemplate;
import pojo.Smbms_User;
import java.util.List;

public class UserMapperImpl implements UserMapper{
    private SqlSessionTemplate sqlSessionTemplate;

    public SqlSessionTemplate getSqlSessionTemplate() {
        return sqlSessionTemplate;
    }

    public void setSqlSessionTemplate(SqlSessionTemplate sqlSessionTemplate) {
        this.sqlSessionTemplate = sqlSessionTemplate;
    }

    @Override
    public List selectBy(String userName, Integer roleId) {
        //两种方式都可以
    //return sqlSessionTemplate.selectList("UserMapper.UserMapper.selectBy");
       return sqlSessionTemplate.getMapper(UserMapper.class).selectBy(userName,roleId);
    }
}

UserMapper包，Smbms_UserMapper.xml

    
        SELECT * FROM smbms_user WHERe username LIKE CONCAt('%',#{userName},'%') AND userrole = #{roleId}
    

service包，UserService

import pojo.Smbms_User;
import java.util.List;

public interface UserService {
    //根据用户名和角色id查询信息
    List selectBy(String userName,Integer roleId);
}

serviceImpl包，UserServiceImpl

import UserMapper.UserMapper;
import pojo.Smbms_User;
import service.UserService;
import java.util.List;

public class UserServiceImpl implements UserService {
    private UserMapper userMapper;

    public UserMapper getUserMapper() {
        return userMapper;
    }

    public void setUserMapper(UserMapper userMapper) {
        this.userMapper = userMapper;
    }

    @Override
    public List selectBy(String userName, Integer roleId) {
        return userMapper.selectBy(userName,roleId);
    }
}

resources文件夹，database (1).properties

driver=com.mysql.jdbc.Driver

#在和mysql传递数据的过程中，使用unicode编码格式，并且字符集设置为utf-8
url=jdbc:mysql://127.0.0.1:3306/smbms?useUnicode=true&characterEncoding=utf-8

username=root

password=ok

resources文件夹，log4j.properties

自己可以去百度下载，如果没有，正常的System.out.println()输出也行

resources文件夹，mybaties-config.xml

mybaties-config.xml整合之后就不需要了，以下代码只供参考

resources文件夹，ApplicationContext.xml

    
        
    


    
        
        
        
        
    


    


        


        
            
                UserMapper/Smbms_UserMapper.xml
            
        


        
            
                pojo.Smbms_User
            
        



    


    
        
    


    
        
    


    
        
    

AppTest测试类

import org.apache.log4j.Logger;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import pojo.Smbms_User;
import service.UserService;
import java.util.List;

public class AppTest {
    //采用日志打印
    private Logger logger = Logger.getLogger(AppTest.class);
    
    @Test
    public void test2(){
        ApplicationContext atx = new
                ClassPathXmlApplicationContext("ApplicationContext.xml");
        UserService service = (UserService) atx.getBean("userService");
        List users = service.selectBy("孙",3);
        for (Smbms_User user : users) {
            logger.debug(user.toString());
        }
    }
}

以上就是Mybatis和Spring相整合的全部步骤，测试结果过多，这里不便截图