欢迎访问 如意编程网!

如意编程网

当前位置: 首页 > 编程资源 > 编程问答 >内容正文

编程问答

Mybatis学习笔记13 - 动态sql之set标签

发布时间:2024/7/5 编程问答 4 豆豆
如意编程网 收集整理的这篇文章主要介绍了 Mybatis学习笔记13 - 动态sql之set标签 小编觉得挺不错的,现在分享给大家,帮大家做个参考.

示例代码:

接口定义: package com.mybatis.dao;import com.mybatis.bean.Employee;public interface EmployeeMapper {public void updateEmp(Employee employee);public void updateEmployee(Employee employee); }mapper定义: <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.mybatis.dao.EmployeeMapper"><update id="updateEmp">update tbl_employee<set><if test="lastName!=null">last_name=#{lastName},</if><if test="email!=null">email=#{email},</if><if test="gender!=null">gender=#{gender}</if></set>where id=#{id}</update><update id="updateEmployee">update tbl_employee<trim prefix="set" suffixOverrides=","><if test="lastName!=null">last_name=#{lastName},</if><if test="email!=null">email=#{email},</if><if test="gender!=null">gender=#{gender}</if></trim>where id=#{id}</update> </mapper>测试代码: package com.mybatis.demo;import com.mybatis.bean.Employee; import com.mybatis.dao.EmployeeMapper; 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 java.io.IOException; import java.io.InputStream; import java.util.List;public class MyTest {public SqlSessionFactory getSqlSessionFactory() throws IOException {String resource = "mybatis-config.xml";InputStream inputStream = Resources.getResourceAsStream(resource);return new SqlSessionFactoryBuilder().build(inputStream);}@Testpublic void test() throws IOException {SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();SqlSession openSession = sqlSessionFactory.openSession(true);try {EmployeeMapper mapper = openSession.getMapper(EmployeeMapper.class);mapper.updateEmp(new Employee(1, "good", null, null));mapper.updateEmployee(new Employee(5, "test", null, null));} finally {openSession.close();}} }

 

转载于:https://www.cnblogs.com/xidian2014/p/10351644.html

总结

以上是如意编程网为你收集整理的Mybatis学习笔记13 - 动态sql之set标签的全部内容,希望文章能够帮你解决所遇到的问题。

如果觉得如意编程网网站内容还不错,欢迎将如意编程网推荐给好友。