mybatis代码

Test

package com.neusoft.main;

import com.neusoft.domain.Dept;
import com.neusoft.domain.Emp;
import com.neusoft.mapper.DeptMapper;
import com.neusoft.mapper.EmpMapper;
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;

/**
 * Created by Administrator on 2018/11/21.
 */

public class Test {

    DeptMapper deptMapper = null;
    EmpMapper empMapper = null;
    SqlSession sqlSession = null;

    @org.junit.Before
    public void Create () throws IOException {

        String resource = "SqlMapConfig.xml";

        InputStream inputStream = Resources.getResourceAsStream(resource);

        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

        sqlSession = sqlSessionFactory.openSession();

        deptMapper = sqlSession.getMapper(DeptMapper.class);

        empMapper = sqlSession.getMapper(EmpMapper.class);

    }

    @org.junit.Test
    public void getDeptById() {

        Dept dept = deptMapper.getDeptById(10);

        System.out.println(dept);
    }
    @org.junit.Test
    public void getAllDepts() {

        List<Dept> deptList=deptMapper.getAllDepts();

        System.out.println(deptList);
    }
    @org.junit.Test
    public void deleteDeptById() {
        deptMapper.deletDept(40);

        sqlSession.commit();
    }
    @org.junit.Test
    public void getDeptCount() {
        int i =deptMapper.getDeptCount();

        System.out.println(i);
    }
    @org.junit.Test
    public void addDept() {
        Dept dept = new Dept();

        dept.setDname("销售");

        dept.setLoc("沈阳");

        deptMapper.addDept(dept);

        sqlSession.commit();

        System.out.println(dept.getDeptno());
    }
    @org.junit.Test
    public void selectlike() {
        Dept dept = new Dept();

        dept.setDname("销售");

//        dept.setLoc("沈阳");

        List<Dept> list = deptMapper.selectlike(dept);

        sqlSession.commit();

        System.out.println(list);
    }
    @org.junit.Test
    public void updateDept() {
        Dept dept = new Dept();

        dept.setDeptno(44);

        dept.setDname("55555555555");

//        dept.setLoc("8888888888888");

        deptMapper.updateDept(dept);

        sqlSession.commit();
    }
    @org.junit.Test
    public void getDeptListMap() {
        Map<String,Object> params = new HashMap();

        params.put("loc","沈阳");

        params.put("dname","销售");

        List<Dept> x = deptMapper.getDeptListMap(params);

        System.out.println(x);

    }
    @org.junit.Test
    public void getEmpDeptInfo() {
        List<Map<String, Object>> empDeptInfo = deptMapper.getEmpDeptInfo();

        for (Map<String, Object> maprow:empDeptInfo){

            for(Map.Entry<String, Object> entry:maprow.entrySet()){

                System.out.println(entry);
            }
        }
    }