5.Mybatis更新与删除

更新记录

• 添加一条 Mapper项    
• session.update( )      session.commit()

1.修改mybatis-mapper.xml

<?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="af.test">

  <update id="updateStudent" parameterType="hashmap">
    update student set cellphone=#{cellphone} where id=#{id}
  </update>
  
</mapper>

2.测试

package my;

import java.io.InputStream;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

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 Test
{
	public static void main(String[] args) throws Exception
	{
		// 创建 SqlSessionFactory
		String resource = "mybatis-config.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

		// 使用简化的try-with-resources语法，等效于try..finally语句
		try (SqlSession session = sqlSessionFactory.openSession())
		{
			HashMap<String,Object> map = new HashMap<>();
			map.put("id", 20190001);
			map.put("cellphone", "13810012388");
			
			int affectedRows = session.update("af.test.updateStudent", map);
			System.out.println("受影响的行数: " + affectedRows);
			
			session.commit(); // 因为默认开启了事务，所以要commit()一下
		}
		System.out.println("Exit");
	}

}

3.结果

删除记录

• 添加一条 Mapper项    
• session.delete( )      session.commit()

1.修改mybatis-mapper.xml

<?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="af.test">

  <delete id="deleteStudent" parameterType="hashmap">
    delete from student where sex=#{sex}    
  </delete>
  
</mapper>

2.测试

package my;

import java.io.InputStream;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

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 Test
{
	public static void main(String[] args) throws Exception
	{
		// 创建 SqlSessionFactory
		String resource = "mybatis-config.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

		// 使用简化的try-with-resources语法，等效于try..finally语句
		try (SqlSession session = sqlSessionFactory.openSession())
		{
			HashMap<String,Object> map = new HashMap<>();
			map.put("sex", 1);
			
			int affectedRows = session.delete("af.test.deleteStudent", map);
			System.out.println("受影响的行数: " + affectedRows);
			
			session.commit(); // 因为默认开启了事务，所以要commit()一下
		}
		System.out.println("Exit");
	}

}

3.结果