Mybatis的案例

创建数据库

导入jar包

创建对应的实体类

创建接口类

对应的mapper映射配置文件

创建核心配置文件

最后在测试类里实现增删改查

package com.Test;

import com.bean.User;
import com.dao.UserDao;
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.Before;
import org.junit.Test;

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

public class UserTest {

    InputStream stream = null;
    SqlSessionFactoryBuilder builder = null;
    SqlSessionFactory factory = null;
    SqlSession sqlSession = null;
    UserDao userDao = null;

    @Before
    public void  init() throws IOException {
        stream = Resources.getResourceAsStream("SqlMapConfig.xml");
        builder = new SqlSessionFactoryBuilder();
        factory = builder.build(stream);
        sqlSession = factory.openSession();
        userDao = sqlSession.getMapper(UserDao.class);
    }

    @Test
    public void testSelectAll() throws IOException {
        List<User> userList = userDao.selectAll();
        for (User user : userList) {
            System.out.println(user);
        }
    }
    @Test
    public void testAdd(){
        User user = new User();
        user.setEname("111");
        user.setDept("111");
        user.setJob("111");
        user.setSal(11);
        user.setPhone("111");
        user.setAddress("111");
        int n = userDao.add(user);
        if (n > 0){
            System.out.println("add success");
        }
    }

    @Test
    public void del(){
        int del = userDao.del(9);
        if (del > 0){
            System.out.println("del success");
        }
    }

    @Test
    public void update(){
        User oldUser = userDao.selectByUid(16);
        System.out.println("修改前："+oldUser);
        oldUser.setEname("111");
        oldUser.setDept("111");
        oldUser.setJob("111");
        oldUser.setSal(11);
        oldUser.setPhone("111");
        oldUser.setAddress("111");
        User newUser = userDao.selectByUid(16);
        System.out.println("修改后："+newUser);
    }

    @Test
    public void testSelectByeid(){
        User user = userDao.selectByUid(1);
        System.out.println(user);
    }

    public void distroy() throws IOException{
        sqlSession.commit();
        sqlSession.close();
        stream.close();
    }

}