Mybatis学习笔记（五）——DAO开发

本博客源码下载：戳我一下

Mybatis学习笔记汇总：戳我一下

一、原始Dao开发方式

1、这里配置文件仍然使用在Mybatis学习笔记（三）——入门程序中的配置文件。

2、写一个Dao接口

package com.jiayifan.dao;

import com.jiayifan.po.User;

/**
 * dao接口，用户管理
 * @author 贾一帆
 *
 */
public interface UserDao {
   
    //根据ID查询用户信息
    public User findUserById(int id) throws Exception;
    //添加用户信息
    public void insertUser(User user) throws Exception;
    //删除用户信息
    public void deleteUser(int id) throws Exception;
}

3、写一个Dao接口的实现类

package com.jiayifan.dao;

import java.util.Date;

import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;

import com.jiayifan.po.User;

/**
 * dao接口实现类
 * @author 贾一帆
 *
 */
public class UserDaoImpl implements UserDao {
   
    //需要向dao实现类注入SQLSessionFactory
    //这里通过构造方法注入
    private SqlSessionFactory sqlSessionFactory = null;
    public UserDaoImpl(SqlSessionFactory sqlSessionFactory) {
        this.sqlSessionFactory = sqlSessionFactory;
    }
    @Override
    public User findUserById(int id) throws Exception {
        SqlSession sqlSession = sqlSessionFactory.openSession();
        User user = sqlSession.selectOne("test.findUserById",id);
        sqlSession.close();
        return user;
    }

    @Override
    public void insertUser(User user) throws Exception {
        // TODO Auto-generated method stub
        SqlSession sqlSession = sqlSessionFactory.openSession();
        //执行插入操作
        sqlSession.insert("test.insertUser",user);
        System.out.println(user.getId());
        //提交事务
        sqlSession.commit();
        //释放资源
        sqlSession.close();
    }

    @Override
    public void deleteUser(int id) throws Exception {
        // TODO Auto-generated method stub
        SqlSession sqlSession = sqlSessionFactory.openSession();
        sqlSession.delete("test.deleteUser",id);
        sqlSession.commit();
        sqlSession.close();
    }

}

4、测试代码和运行情况

package com.jiayifan.dao;

import static org.junit.jupiter.api.Assertions.*;

import java.io.InputStream;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.jupiter.api.BeforeEach;
import org.junit.jupiter.api.Test;