使用注解方式来操作

package com.item.mybatis_plus.test.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.item.mybatis_plus.test.domain.Book;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;


@Mapper
public interface UserDao extends BaseMapper<Book> {
    @Select("select * from tbl_book where type=#{name}")
    public List<Book> selectByName(String name);
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

使用@Select注解来自定义方法

    @Select("select * from tbl_book where type=#{name}")
1

测试