mybatis测试类

mybatis测试类

package com.ym.test;

import java.io.Reader;
import java.util.Date;
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.ym.dao.IGoodtable;
import com.ym.dao.IUserTable;
import com.ym.entity.Goodtable;
import com.ym.entity.Usertable;

public class MybatisTest {
	
	static SqlSessionFactory factory;   
	static{
		try {
			//加载环境 读取配置 调用方法
			Reader rd = Resources.getResourceAsReader("mybatis-config.xml");
			/*创建 工厂*/
			factory = new SqlSessionFactoryBuilder().build(rd);	
		} catch (Exception e) {
			e.printStackTrace();
		}
		
	}
	
	@Test
	public void testOne(){
		/*获取session接口*/
		SqlSession session = factory.openSession();
		//得到接口对象
		IUserTable userDao = session.getMapper(IUserTable.class);
		//调用方法
				List<Usertable> list = userDao.queryUserList();			
				for (Usertable uent : list) {
					System.out.println(uent.toString());
				}
		
	}
	
	@Test
	public void testTwo(){
		/*获取session接口*/
		SqlSession session = factory.openSession();
		//得到接口对象
		IGoodtable goodTable=session.getMapper(IGoodtable.class);
				
		Goodtable goodEnt=new Goodtable();
		//goodEnt.setGoodId(1);
		goodEnt.setGoodName("大%");
		//调用方法
		List<Goodtable> list2= goodTable.queryGoodList(goodEnt);
				for (Goodtable gt : list2) {
					System.out.println(gt.toString());
				}		
	}
	
	
	@Test
	public void testThree(){
		/*获取session接口*/
		SqlSession session = factory.openSession();
		//得到接口对象
		IGoodtable goodTable=session.getMapper(IGoodtable.class);
				//调用方法
		Goodtable goodEnt=new Goodtable("大白", 20.3, 2, "12312",new Date(), "123", 0);
		boolean bool= goodTable.addGoodtable(goodEnt);
		session.commit();
		if(bool){
			System.out.println("添加成功");
		}else{
			System.out.println("添加失败");
		}
						
	}
	
	
	@Test
	public void testFour(){
		/*获取session接口*/
		SqlSession session = factory.openSession();
		//得到接口对象
		IGoodtable goodTable=session.getMapper(IGoodtable.class);
		Goodtable goodEnt=new Goodtable("大大白", 100.3, 1, "12312",new Date(), "123", 0);
		goodEnt.setGoodId(1);
		boolean bool= goodTable.updateGoodtable(goodEnt);
		session.commit();
		if(bool){
			System.out.println("修改成功");
		}else{
			System.out.println("修改失败");
		}					
	}
	
	
	@Test
	public void testFive(){
		/*获取session接口*/
		SqlSession session = factory.openSession();
		//得到接口对象
		IGoodtable goodTable=session.getMapper(IGoodtable.class);
		boolean bool= goodTable.deleteGoodtable(7);
		session.commit();
		if(bool){
			System.out.println("删除成功");
		}else{
			System.out.println("删除失败");
		}					
	}
	

}