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); }

}