Mybatis简单的CRUD基于XML文件配置

	
	
	insert into users(name, age) values(#{name}, #{age});
	
	
	
	delete from users where id = #{id};
	
	
	
	update users set name = #{name}, age = #{age} where id = #{id};
	
	
	
	select * from users where id = #{id};
	
	
	
	select * from users;
	
 

package com.bird.mybatis.bean;

import java.io.IOException;
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 org.junit.Before;
import org.junit.Test;

public class MyTest {
	
	private SqlSessionFactory factory;
	
	@Before
	public void init() {
	String resource = "conf.xml";
	Reader reader = null;
	try {
	reader = Resources.getResourceAsReader(resource);
	} catch (IOException e) {
	e.printStackTrace();
	}
	factory = new SqlSessionFactoryBuilder().build(reader);
	}
	
	@Test
	public void testAdd() {
	//默认是手动的 
	SqlSession session = factory.openSession();
	String statement = "com.bird.mybatis.bean.userMapper.insertUser";
	int rows = session.insert(statement, new Users(-1, "哈哈", 29));
	//提交
	session.commit();
	System.out.println(rows);
	session.close();
	}
	
	@Test
	public void testUpdate() {
	SqlSession session = factory.openSession();
	String statement = "com.bird.mybatis.bean.userMapper.updateUser";
	session.update(statement, new Users(4, "呵呵", 29));
	session.commit();
	session.close();
	}
	
	@Test
	public void testDelete() {
	SqlSession session = factory.openSession();
	String statement = "com.bird.mybatis.bean.userMapper.deleteUser";
	session.delete(statement, 1);
	session.commit();
	session.close();
	}
	
	@Test
	public void testGetAllUser() {
	SqlSession session = factory.openSession();
	String statement = "com.bird.mybatis.bean.userMapper.getAllUser";
	List list = session.selectList(statement);
	System.out.println(list.size());
	session.close();
	}
}