Mybatis-04-更新和删除

本文简单介绍一下MyBatis的更新和删除功能。直接上代码：

1、映射文件：

<?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="UserSpace">
	<!-- 更新用户 -->
	<update id="updateUser" parameterType="com.wp.model.User">
		update user set username=#{userName}, sex=#{sex}, age=#{age}, 
		birthday=#{birthDay}, address=#{address}
		where id=#{id}
	</update>
	
	<!-- 删除用户 -->
	<delete id="deleteById" parameterType="java.lang.Integer">
		delete from user where id=#{id}
	</delete>
	
</mapper>

    有了上两节的基础后，相信这里不做解释也能够看明白的。

 

2、测试代码：

package com.wp.test;

import java.io.IOException;
import java.io.InputStream;
import java.util.Date;
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.Test;

import com.wp.model.User;
import com.wp.util.DateUtil;


public class UserTest2 {
	@Test
	public void testUpdateUser() {
		String resource = "mybatis-config.xml";
		try {
			InputStream inputStream = Resources.getResourceAsStream(resource);
			SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
			SqlSession session = sessionFactory.openSession();
			
			Date birthDay = DateUtil.parseStrToFullDate("2003-10-04", "yyyy-MM-dd");
			User user = new User(11, "张无忌", 1, 780, birthDay, "九阳神功、乾坤大挪移");
			
			session.update("UserSpace.updateUser", user);
			session.commit();
			session.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
	
	@Test
	public void testDeleteById() {
		String resource = "mybatis-config.xml";
		try {
			InputStream inputStream = Resources.getResourceAsStream(resource);
			SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
			SqlSession session = sessionFactory.openSession();
			
			session.delete("UserSpace.deleteById", 10);
			session.commit();
			session.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
	
}

 

3、数据库结果：

未进行更新和删除操作之前：

 

更新后：

 

删除后：