Mybatis实现users表的增删改查（CRUD）

1.XML的实现

1). 定义sql映射xml文件：

sql语句

2）实体类中必须提供无参构造函数

2. 在conf.xml中注册这个映射文件

<mapper resource="com/sxau/rjxy/mybatis/test1/userMapper.xml"/>

3.测试

3.1常用语句封装为工具方法

package com.rjxy.util;

import java.io.IOException;
import java.io.Reader;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

public class MybatisUtils {
public static SqlSession getSqlSession() throws IOException{
String resource=“conf.xml”;
Reader reader=Resources.getResourceAsReader(resource);
SqlSessionFactory sessionFactory=new SqlSessionFactoryBuilder().build(reader);
SqlSession sqlSession=sessionFactory.openSession(true);
return sqlSession;
}

}

3.2测试语句

package com.sxau.rjxy.mybatis.test1;

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

import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import com.rjxy.util.MybatisUtils;

public class UserTest {

@Test
public void insertUser() throws IOException {
		SqlSession session = MybatisUtils.getSqlSession();
	String s = "com.sxau.rjxy.mybatis.test1.userMapper.insertUser";
	//insertUser为insert语句中的id
	User user = new User(6, "mnmn", 71);
	int u = session.insert(s, user);
	session.commit();
	System.out.println(u);
}

@Test
public void updateUser() throws IOException {
	SqlSession session = MybatisUtils.getSqlSession();
	String s = "com.sxau.rjxy.mybatis.test1.userMapper.updateUser";
	int u = session.update(s, new User(2, "a123", 1));
	System.out.println(u);
}

@Test
public void deleteUser() throws IOException {
	SqlSession session = MybatisUtils.getSqlSession();
	String s = "com.sxau.rjxy.mybatis.test1.userMapper.deleteUser";
	int u = session.delete(s, 0);
	System.out.println(u);
}

@Test
public void selectUser() throws IOException {
	SqlSession session = MybatisUtils.getSqlSession();
	String s = "com.sxau.rjxy.mybatis.test1.userMapper.selectUser";
	User u = session.selectOne(s, 2);
	session.close();
	System.out.println(u);
}

@Test
public void selectAllUsers() throws IOException {
	SqlSession session = MybatisUtils.getSqlSession();
	String s = "com.sxau.rjxy.mybatis.test1.userMapper.selectAllUsers";
	List<User> list = session.selectList(s);
	session.close();
	System.out.println(list);
}

}