快捷導(dǎo)航

mybatis if標(biāo)簽使用總結(jié)

更新時(shí)間：2019年12月25日 11:26:52 作者：悟世君子

這篇文章主要介紹了mybatis if標(biāo)簽使用總結(jié)，文中通過示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，需要的朋友們下面隨著小編來一起學(xué)習(xí)學(xué)習(xí)吧

在項(xiàng)目開發(fā)中，mybatis <if> 標(biāo)簽使用廣泛，本文講解if標(biāo)簽的兩種使用方式

其一、使用 <if> 標(biāo)簽判斷某一字段是否為空

其二、使用 <if> 標(biāo)簽判斷傳入?yún)?shù)是否相等

具體代碼如下

數(shù)據(jù)庫表結(jié)構(gòu)和數(shù)據(jù)

實(shí)體類

package com.demo.bean;
 
public class Commodity {
	
	private String name;
	
	private String date;
 
	public String getName() {
		return name;
	}
 
	public void setName(String name) {
		this.name = name;
	}
 
	public String getDate() {
		return date;
	}
 
	public void setDate(String date) {
		this.date = date;
	}
 
	@Override
	public String toString() {
		return "Com [name=" + name + ", date=" + date + "]";
	}
	
}

mapper層

package com.demo.mapper;
 
import java.util.List;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import com.demo.bean.Commodity;
@Mapper
public interface CommodityMapper {
 
	List<Commodity> getListByDate(Commodity commodity);
	
	List<Commodity> getListByStartDateAndEndDate(@Param("startDate")String startDate, @Param("endDate")String endDate);
}

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="com.demo.mapper.CommodityMapper">
	
	<resultMap id="BaseResultMap" type="com.demo.bean.Commodity">
		<id column="name" property="name" jdbcType="VARCHAR" />
		<result column="date" property="date" jdbcType="VARCHAR" />
	</resultMap>
	
	<select id="getListByDate" resultMap="BaseResultMap">
	 select * from commodity where 1 = 1
	 <if test="date != null and date != ''">
	 and date = #{date}
	 </if> 
	</select>
	
	<select id="getListByStartDateAndEndDate" resultMap="BaseResultMap">
	 select * from commodity where 1 = 1
	 <if test="#{startDate}.toString() != #{endDate}.toString()">
	 and date between #{startDate} and #{endDate}
	 </if>
	</select>
	
</mapper>

注意:mybatis 等值判斷的 tostring()方法 (上邊代碼中第二個(gè)select中的toString()方法)

controller層

package com.demo.controller;
 
import java.util.HashMap;
import java.util.Map;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;
import com.demo.bean.Commodity;
import com.demo.mapper.CommodityMapper;
 
@RestController
public class DemoController {
 
	@Autowired
	private CommodityMapper comMapper;
	
	@RequestMapping(value = "/commodity")
	public Object commodity() {
		Map<String, Object> map = new HashMap<String, Object>();
		Commodity com =new Commodity();
		com.setDate("2018-10-12");
		map.put("res", comMapper.getListByDate(com));
		return map;
	}
	
	@RequestMapping(value = "/between")
	public Object commodityBetween() {
		Map<String, Object> map = new HashMap<String, Object>();
		map.put("res", comMapper.getListByStartDateAndEndDate("2018-10-09", "2018-10-13"));
		return map;
	}
}

測試

1、訪問 http://localhost:9000/commodity