package com.fgkj;

import com.fgkj.mapper.UserMapper;
import com.fgkj.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 java.io.IOException;
import java.io.InputStream;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class MyBatisDemo {


    public static void main(String[] args) throws IOException {
        //1.加载mybatis 的核心配置文件，获取SqlSessionFactory
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

        //2.获取 SqlSession 对象，用它执行sql
        SqlSession sqlSession = sqlSessionFactory.openSession();

        System.out.println(sqlSession);
        //3.执行sql
//        List<User> users = sqlSession.selectList("test.selectAll");
//
        //3.1 获取UserMapper 对象
        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
        List<User> users = userMapper.selectAll();
        System.out.println(users);

        System.out.println("---------------------------------------------------------------------------------");

        User user = userMapper.selectById(2);
        System.out.println(user);

        System.out.println("---------------------------------------------------------------------------------");

        String uName = "admin";
        String uDepartment = "省";
        String uJobGroup = "管理员";

        uName = "%" + uName + "%";
        uDepartment = "%" + uDepartment + "%";
        uJobGroup = "%" + uJobGroup + "%";

        User u = new User();
        u.setuName(uName);
        u.setuDepartment(uDepartment);
        u.setuJobGroup(uJobGroup);

        Map map = new HashMap();
//        map.put("uName",uName);
//        map.put("uDepartment",uDepartment);
//        map.put("uJobGroup",uJobGroup);

//        List<User> users1 = userMapper.selectCondition(uName, uDepartment, uJobGroup);
//        List<User> users1 = userMapper.selectCondition(u);
        //List<User> users1 = userMapper.selectCondition(map);
        List<User> users1 = userMapper.selectConditionSigle(map);


        System.out.println(users1);

        //4.释放资源
        sqlSession.close();
    }
}