原始dao开发（与mapper代理开发对比）

最新推荐文章于 2023-12-17 23:30:09 发布

Kiko_Fan

最新推荐文章于 2023-12-17 23:30:09 发布

阅读量277

点赞数

本文链接：https://blog.csdn.net/Kiko_Fan/article/details/103738528

版权

有实现类
在这里插入图片描述

package com.dao;

import java.util.List;

import com.model.User;

public interface IuserDao {
List<User> selectAll();

}

package com.dao.impl;

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

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.dao.IuserDao;
import com.model.User;

public class DaoImpl implements IuserDao {
	//1.加载全局配置文件得到stream
	//2.sessionfactory
	//3.session	
	private SqlSessionFactory sf;//全局变量，依赖注入
	public SqlSessionFactory getSf() {
		InputStream stream = null;
		try {
			 stream = Resources.getResourceAsStream("SqlMapper.xml");
		} catch (IOException e) {
			// TODO 自动生成的 catch 块
			e.printStackTrace();
		}	
		return new SqlSessionFactoryBuilder().build(stream);
	}
	@Override
	public List<User> selectAll() {
		//调用方法
		SqlSessionFactory sf = new DaoImpl().getSf();
		SqlSession session = sf.openSession();
		return session.selectList("userMapper.selectAll");
	}

}

package com.mb.test;

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

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.dao.IuserDao;
import com.dao.impl.DaoImpl;
import com.model.User;

public class TestFirst {
	@Test
public void test() {
	//原始
	IuserDao dao = new DaoImpl();
	List<User> selectAll = dao.selectAll();
	for(User user : selectAll)
		System.out.println(user);
}

	
	
}

package com.model;

public class User {
	public  int sId;
	public String sName;
	public String sSex;
	public int sAge;
	public int getsId() {
		return sId;
	}
	public void setsID(int sID) {
		this.sId = sID;
	}
	public String getsName() {
		return sName;
	}
	public void setsName(String sName) {
		this.sName = sName;
	}
	public String getSsex() {
		return sSex;
	}
	public void setSsex(String ssex) {
		this.sSex = ssex;
	}
	public int getSage() {
		return sAge;
	}
	public void setSage(int sage) {
		this.sAge = sage;
	}
	@Override
	public String toString() {
		return "User [sID=" + sId + ", sName=" + sName + ", ssex=" + sSex + ", sage=" + sAge + "]";
	}
}