本博客源码下载:戳我一下
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;