Mybatis simple crud configuration based on XML files

All the ORM framework learning curves come with a crud, which is cool. Now let's get a Crud. All the configurations are based on the previous one. Let's talk about the code.

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"  "http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.bird.mybatis.bean.userMapper"><!--CRUD  --><insert id="insertUser" parameterType="com.bird.mybatis.bean.Users">insert into users(name, age) values(#{name}, #{age});</insert><delete id="deleteUser" parameterType="int">delete from users where id = #{id};</delete><update id="updateUser" parameterType="com.bird.mybatis.bean.Users">update users set name = #{name}, age = #{age} where id = #{id};</update><select id="getUser" parameterType="int" resultType="com.bird.mybatis.bean.Users">select * from users where id = #{id};</select><select id="getAllUser" resultType="com.bird.mybatis.bean.Users">select * from users;</select></mapper>

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;@Beforepublic void init() {String resource = "conf.xml";Reader reader = null;try {reader = Resources.getResourceAsReader(resource);} catch (IOException e) {e.printStackTrace();}factory = new SqlSessionFactoryBuilder().build(reader);}@Testpublic 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();}@Testpublic 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();}@Testpublic void testDelete() {SqlSession session = factory.openSession();String statement = "com.bird.mybatis.bean.userMapper.deleteUser";session.delete(statement, 1);session.commit();session.close();}@Testpublic void testGetAllUser() {SqlSession session = factory.openSession();String statement = "com.bird.mybatis.bean.userMapper.getAllUser";List<Users> list = session.selectList(statement);System.out.println(list.size());session.close();}}

OK, so easy, where is it?

Mybatis simple crud configuration based on XML files