Spring整合Mybatis （一）

简单的实现查询

1.接口

package com.yyf.mapper;

import com.yyf.pojo.User;

import java.util.List;

public interface userMapper {
    public List selectUser();
}

2.接口配置文件

    
        select * from mybatis.user

3.接口实现类

package com.yyf.mapper;

import com.yyf.pojo.User;
import org.mybatis.spring.SqlSessionTemplate;

import java.util.List;


public class userMapperImpl implements userMapper{

//    原来所有的操作都是由sqSession执行，现在由sqsSessionTemplate
      private SqlSessionTemplate sqlSession;

    public void setSqlSession(SqlSessionTemplate sqlSession) {
        this.sqlSession = sqlSession;
    }

    @Override
    public List selectUser() {
        userMapper mapper = sqlSession.getMapper (userMapper.class);
        return mapper.selectUser ();
        }
    }

3。mybatis 配置文件  里面只实现了别名的配置

4.spring和mybatis整合配置文件

  第一步 ：datasource 数据源  连接数据库

  第二步： 创建sqlsessionFactory

  第三步：创建sqlsession

5.测试类

import com.yyf.mapper.userMapper;
import com.yyf.pojo.User;
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.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;

public class MyTest {
    @Test
    public void test() throws IOException {

        ApplicationContext context = new ClassPathXmlApplicationContext ("mybatis-spring.xml");

        userMapper usermapper = context.getBean ("usermapper2", com.yyf.mapper.userMapper.class);
        for (User user : usermapper.selectUser ()) {
            System.out.println (user);
        }
    }

    }