MyBatis插入，修改，删除

编写接口：

    int add(User user);

编写衍射sql文件：

   <insert id="add">
        insert into user(id, name, age, gender, email)
        values (#{id}, #{name}, #{age}, #{gender}, #{email});
    </insert>

运行代码，获取结果：

package Test;

import com.quxiao.mybatis.mapper.userMapper;
import com.quxiao.mybatis.pojo.Text;
import com.quxiao.mybatis.pojo.User;
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.BeforeClass;
import org.junit.Test;

import java.io.IOException;
import java.io.Reader;
import java.util.HashMap;
import java.util.List;
import java.util.Map;


public class MybatisTest {
    private static SqlSessionFactory sqlSessionFactory;

    @BeforeClass
    public static void init() {
        try {
            Reader reader = Resources.getResourceAsReader("mybatis-config.xml");
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
            reader.close();
        } catch (IOException e) {
            throw new RuntimeException(e);
        }
    }

    @Test
    public void testSelectAll() {
        SqlSession session = sqlSessionFactory.openSession();
        try {
            User user = new User();
            user.setName("测试测试");
            user.setAge(20);
            user.setGender("男");
            user.setEmail("1546546546@qq.com");
            int add = userMapper.add(user);
            System.out.println("插入了:" + add);
            session.commit();
        } finally {
            session.close();
        }
    }
}

 修改、删除：

    int update(User user);

    int delete(int age);

 <update id="update">
        update user
        set name=#{name}
        where id = #{id};
    </update>
    <delete id="delete">
        delete
        from user
        where age > #{age};
    </delete>

运行结果：

数据无价啊！！！！！！！！！！谨慎操作！！！！！

 一个没注意，给删完了、、、、、、、、