mybatis---Dao开发模式

最新推荐文章于 2023-12-19 18:00:58 发布

原创最新推荐文章于 2023-12-19 18:00:58 发布 · 165 阅读

0 ·

CC 4.0 BY-SA版权

mybatis 专栏收录该内容

5 篇文章

订阅专栏

本文介绍了一个基于MyBatis的用户DAO接口及其实现类UserDaoImpl,展示了如何使用SqlSessionFactory进行数据库操作，以及一个JUnit测试用例，用于验证UserDaoImpl中selectUser方法的正确性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

UserDao接口：

package com.it.mybaties.dao;

import com.it.mybaties.pojo.User;

public interface UserDao {
	public User selectUser(Integer id);
}

UserDaoImpl（UserDao的实现类）：

package com.it.mybaties.dao;

import java.io.IOException;
import java.io.InputStream;

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 com.it.mybaties.pojo.User;

public class UserDaoImpl implements UserDao {
	
	private SqlSessionFactory sqlSessionFactory;
	
	public UserDaoImpl(SqlSessionFactory sqlSessionFactory) {
		this.sqlSessionFactory = sqlSessionFactory;
	}

	public User selectUser(Integer id){
		SqlSession openSession = sqlSessionFactory.openSession();
		User user = openSession.selectOne("test.getUserById", id);
		
		return user;
		
	}
	
}

Test(junit测试)：

package com.it.mybaties.junit;

import java.io.IOException;
import java.io.InputStream;

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.Test;

import com.it.mybaties.dao.UserDao;
import com.it.mybaties.dao.UserDaoImpl;
import com.it.mybaties.pojo.User;

public class TestMybatisDao {
	
	@Test
	public void fun2() throws Exception{
		String resource = "sqlMapperConfig.xml";
		InputStream in = Resources.getResourceAsStream(resource);
		SqlSessionFactory sqlSessionFactory =
                     new SqlSessionFactoryBuilder().build(in);
		
		UserDao userdao = new UserDaoImpl(sqlSessionFactory);
		User user = userdao.selectUser(37);
		System.out.println(user);
		
	}
}