有時(shí)候?yàn)榱撕?jiǎn)化我們的代碼。

1 舉個(gè)例子

Student類：

@Datapublic class Student { private Integer id; private Integer age; private Integer sno;}

有時(shí)候我們想通過(guò)age這個(gè)屬性獲取Student對(duì)象

有時(shí)候我們也想通過(guò)sno這個(gè)屬性獲取Student對(duì)象

難道我們?cè)贒AO層寫(xiě)兩個(gè)接口？

比如這樣子？

Student getStudentByAge(Int age);

Student getStudentBySno(Int sno);

那么在mapper文件中要這樣寫(xiě)？

<select parameterType='int' resultMap='studentMap'> select * from student where age=#{age} </select> <select parameterType='int' resultMap='studentMap'> select * from student where sno=#{sno} </select>

顯然，這樣子是不高效的

2 上手測(cè)試 實(shí)驗(yàn)

實(shí)體類 Student：

@Datapublic class Student { @ApiModelProperty(name = 'id',example = '1',position = 1) private Integer id; @ApiModelProperty(name = 'age',value = '年齡',example = '18',position = 2) private Integer age; @ApiModelProperty(name = 'sno',value = '學(xué)號(hào)',example = '334',position = 3) private Integer sno;}

數(shù)據(jù)庫(kù)：

CREATE TABLE `student` ( `id` int(11) NOT NULL AUTO_INCREMENT, `age` int(11) DEFAULT NULL COMMENT ’年齡’, `sno` int(11) NOT NULL COMMENT ’學(xué)號(hào)’, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

手動(dòng)添加一些數(shù)據(jù)

Dao層：

@Mapperpublic interface StudentDao { /** * @description: 通過(guò)student中的屬性 查詢到student * @param: student * @author: Yuz * @creat_time: 2019/8/20 * @return: student **/ Student getStudent(Student student); /** * @description: 通過(guò)age sno 屬性來(lái)刪除 * @param: student * @author: Yuz * @creat_time: 2019/8/20 * @return: void **/ void deleteStudent(Student student);}

Mapper

<?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.dao.StudentDao'> <resultMap type='com.entity.Student'> <id property='id' column='id'/> <result property='age' column='age'/> <result property='sno' column='sno'/> </resultMap> <select parameterType='com.entity.Student' resultMap='studentMap'> select * from student where <if test='age != null'>age=#{age}</if> <if test='sno !=null'>sno=#{sno}</if> </select> <delete parameterType='Student'> delete from student <where> <if test='age != null'> age =#{age} </if> <if test='sno != sno'> sno=#{sno} </if> </where> </delete></mapper>

Service層：

@Servicepublic class StudentService { @Autowired StudentDao studentDao; /** * @description: 通過(guò)student中的屬性 查詢到student * @param: student * @author: Yuz * @creat_time: 2019/8/20 * @return: student **/ public Student getStudent(Student student){ return studentDao.getStudent(student); } /** * @description: 通過(guò)age sno 屬性來(lái)刪除 * @param: student * @author: Yuz * @creat_time: 2019/8/20 * @return: void **/ public void deleteStudent(Student student){ studentDao.deleteStudent(student); }}

Controller:

@RestController@Api('學(xué)生接口')@RequestMapping('/student')public class StudentController { @Autowired StudentService studentService; /** * @description: 通過(guò)student中的屬性 查詢到student * @param: student * @author: Yuz * @creat_time: 2019/8/20 * @return: student **/ @ApiOperation('通過(guò)屬性查詢student') @PostMapping('/getStudent') Student getStudent(@RequestBody Student student){ return studentService.getStudent(student); } /** * @description: 通過(guò)age sno 屬性來(lái)刪除 * @param: student * @author: Yuz * @creat_time: 2019/8/20 * @return: void **/ @ApiOperation('通過(guò)屬性刪除student') @PostMapping('/delete') public void deleteStudent(@RequestBody Student student){ studentService.deleteStudent(student); }}

3 直接測(cè)試

通過(guò)age屬性查詢student：成功

通過(guò)sno屬性查詢:

通過(guò)屬性age刪除Student:

通過(guò)sno屬性刪除Student

補(bǔ)充知識(shí)：mybatis使用if條件判斷，數(shù)字類型不能寫(xiě) 0 ！=‘’，否則會(huì)進(jìn)不到條件拼接里面

1.對(duì)于 if條件判斷：數(shù)字類型屬性判斷的時(shí)候

注意不可以是這種情況

<if test='delFlag!= null and delFlag!= ’’'> and del_flag = #{delFlag}</if>

參數(shù)一個(gè)是0，一個(gè)是''，最終debug會(huì)走進(jìn)case 8 里面，0和“”都會(huì)被轉(zhuǎn)成double進(jìn)行比較，都會(huì)變成0.0，這就是mybati中if test 0!=''判定為false的原因

以上這篇mybatis通過(guò)if語(yǔ)句實(shí)現(xiàn)增刪改查操作就是小編分享給大家的全部?jī)?nèi)容了，希望能給大家一個(gè)參考，也希望大家多多支持好吧啦網(wǎng)。