package com.ddb.mybatis.test;

import java.io.InputStream;
import java.io.Reader;
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.ddb.mybatis.domain.UserInfo;


public class Test {
	//配置mybatis配置文件
	//路径是从src目录下寻找的
private static final String resource="mybatis-config.xml";
//创建sqlsession对象
private SqlSession session=null;
//初始化配置文件，并创建sqlsession对象
//init()方法任选其一
//字符流
public void init() throws Exception {
	//读取mybatis配置文件
	Reader reader=Resources.getResourceAsReader(resource);
	//创建mybatis的session工厂对象
	SqlSessionFactory sessionFactory=new SqlSessionFactoryBuilder().build(reader);
	//返回session会话
	session=sessionFactory.openSession();	
}
//字节流
public void init2()throws Exception{
	InputStream inputStream=Resources.getResourceAsStream(resource);
	SqlSessionFactoryBuilder builder=new SqlSessionFactoryBuilder();
	SqlSessionFactory factory=builder.build(inputStream);
	session=factory.openSession();
}
////插入操作
public int insert(UserInfo uesInfo) {
	int id=session.insert("insertUserInfo",uesInfo);
	session.commit();
	return id;
}
//更新操作
public int update(UserInfo uesInfo) {
	int id=session.update("updateUserInfo",uesInfo);
	session.commit();
	return id;
}
////删除操作
public int delete(int id) {
	int idx=session.delete("deleteUserInfo",id);
	session.commit();
	return idx;
}
////获取单个对象
public UserInfo getone(int id) {
	UserInfo userInfo=session.selectOne("getUserInfoById",id);	
	return userInfo;	
}
////获取所有对象
public List<UserInfo> getList(UserInfo userInfo){
	List<UserInfo> userInfoList=session.selectList("getUserInfoList",userInfo);
	return userInfoList;
}


public static void main(String[] args)throws Exception {
	Test test=new Test();
	test.init();
	UserInfo userInfo=new UserInfo();
	
	
	//test.getone(6);
	//System.out.println(test.getone(6));
	//测试插入数据
	userInfo.setUsername("kk");
	userInfo.setPassword("123");   
	test.insert(userInfo);
	
	
	
	//测试更新数据
//	userInfo.setId(9);
//	userInfo.setUsername("luoxi");
//	userInfo.setPassword("luoxi123");
//	test.update(userInfo);
	
	
	
	//测试删除数据
//	test.delete(4);
//	System.out.println(test.getone(2));//根据id得到一条数据
	
	//test.init2();
	
	//打印表中所有数据
	List<UserInfo>userInfoList=test.getList(userInfo);
	for(UserInfo userInfoX:userInfoList) {
		System.out.println(userInfoX.tosString());
	}
	test.session.close();
}





}