MyBatis的参数传递

主要参考代码：

BookMapper:

package com.yzh7.mapper;

import com.yzh7.entity.Book;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;


public interface BookMapper {
    //mybatis传参问题
    //1.传入一个参数:在mapper中可以用任意名字引用这个参数
    Book getById(Integer bookId);
    //2.传入多个基本类型参数:在mapper中无法通过参数名引用参数
    // 解决方法:1) 通过arg0,arg1... param1,param2...
    //        2) 通过@Param注解为方法参数设置参数mybatis能够引用的参数名
    Book getByNameAndAuthor(@Param("bn") String bookName,
                            @Param("at") String author);

    //3.传入对象:可以在mapper中直接应用对象属性
    Book getByMap(Map map);

    //4.传入对象:可以在mapper中直接应用对象属性
    Book getByBook(Book book);

    //5.区别#{},${}: 模糊查询
    // #{}:用参数占位的方式设置数据。不会有注入问题，但是不能用拼接方式拼接sql
    // ${}:直接用拼接sql的方式，拼接数据。有sql注入问题。一般用${value}引用单个参数值
    List listByBookName(String bookName);

    //查询
    List
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42

BookMapper.xml:

    
    
        select * from tb_book
    
    
        select * from tb_book
    
    
        select * from tb_book
        where book_id = #{bookId}
    

    
        select * from tb_book
        where book_name=#{bn} and author=#{at}
    


    
        select * from tb_book
        where book_name=#{bookName} and author=#{author}
    

    
        select * from tb_book
        where book_name=#{bookName} and author=#{author}
    

    
        select * from tb_book
        where book_name like '%${value}%'
    



    
        insert into tb_book
        (book_name,author,price,publisher,pub_date)
        values
        (#{bookName},#{author},#{price},#{publisher},#{pubDate})
    

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47

demo2:

package com.yzh7.test;

import com.yzh7.entity.Book;
import com.yzh7.mapper.BookMapper;
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.After;
import org.junit.Before;
import org.junit.BeforeClass;
import org.junit.Test;

import java.io.IOException;
import java.io.InputStream;
import java.lang.reflect.Method;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * @author: hy
 * @create: 2022-08-15 10:33:45
 */
public class Demo2 {

    @Test
    public void test1() throws NoSuchMethodException {
        BookMapper bm = session.getMapper(BookMapper.class);
        //1.传入一个参数:在mybatis中可以用任意名字引用这个参数
        Book book = bm.getById(1);
        System.out.println(book);
    }

    @Test
    public void test2() throws NoSuchMethodException {
        BookMapper bm = session.getMapper(BookMapper.class);
        //2.传入多个基本类型参数:在mybatis中无法通过参数名引用参数
        //  正确引用方式： ary0,ary1....
        //              param1,param2
        Book book = bm.getByNameAndAuthor("图书1","作者1");
        System.out.println(book);
    }

    @Test
    public void test3() throws NoSuchMethodException {
        BookMapper bm = session.getMapper(BookMapper.class);
        //3.传入对象:可以在mapper中直接应用对象属性
        Map map = new HashMap();
        map.put("bookName","图书1");
        map.put("author","作者1");
        Book book =bm.getByMap(map);
        System.out.println(book);
    }

    @Test
    public void test4() throws NoSuchMethodException {
        BookMapper bm = session.getMapper(BookMapper.class);
        //4.传入对象:可以在mapper中直接应用对象属性
       Book b = new Book();
       b.setBookName("图书1");
       b.setAuthor("作者1");
        Book book =bm.getByBook(b);
        System.out.println(book);
    }

    @Test
    public void test5() throws NoSuchMethodException {
        BookMapper bm = session.getMapper(BookMapper.class);
        //5.区别#{},${}: 模糊查询
        // #{}:用参数占位的方式设置数据。不会有注入问题，但是不能用拼接方式拼接sql
        // ${}:直接用拼接sql的方式，拼接数据。有sql注入问题。一般用${value}引用单个参数值
        List bookList = bm.listByBookName("图");
        System.out.println(bookList);
    }

    //会话工厂
    private static SqlSessionFactory factory;
    //会话
    private SqlSession session;

    @BeforeClass
    public static void befCls() throws IOException {
        InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
        factory = new SqlSessionFactoryBuilder().build(is);
    }

    @Before
    public void bf(){
        session = factory.openSession();
    }

    @After
    public void af(){
        //提交事务
        session.commit();
        //关闭会话
        session.close();
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101

运行结果展示：

数据库/数据表：

Book getById(Integer bookId);

//1.传入一个参数:在mybatis中可以用任意名字引用这个参数

Book getByNameAndAuthor(@Param(“bn”) String bookName,@Param(“at”) String author);

//2.传入多个基本类型参数:在mybatis中无法通过参数名引用参数
// 正确引用方式： ary0,ary1…
// param1,param2

Book getByMap(Map map);

//3.传入对象:可以在mapper中直接应用对象属性

Book getByBook(Book book);

//4.传入对象:可以在mapper中直接应用对象属性

List listByBookName(String bookName);

//5.区别#{},${}: 模糊查询
// #{}:用参数占位的方式设置数据。不会有注入问题，但是不能用拼接方式拼接sql
// $:直接用拼接sql的方式，拼接数据。有sql注入问题。一般用${value}引用单个参数值

项目实现思路（参考）：

代码整体布局：

注意：

完整代码：

数据库/数据表：

create table tb_book
(
	book_id int primary key auto_increment,
	book_name varchar(20),
	author varchar(20),
	price decimal(5,1),
	publisher varchar(20),
	pub_date date
);

select * from tb_book;
1
2
3
4
5
6
7
8
9
10
11

pom.xml:

    4.0.0

    org.example
    mybatis_0815_KTLX
    1.0-SNAPSHOT

    
        8
        8
    

    
    
        
        
            org.mybatis
            mybatis
            3.4.6
        

        
        
            mysql
            mysql-connector-java
            8.0.11
        
        
        
            org.projectlombok
            lombok
            1.18.22
        
        
        
            junit
            junit
            4.13
            compile
        
    


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46

db.properties:

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/70813_db?useSSL=false&serverTimezone=Asia/Shanghai&characterEncoding=utf8&allowPublicKeyRetrieval=true
jdbc.username=root
jdbc.password=123456
1
2
3
4

mybatis_config.xml:

    
    
        
        
    
    
        
    

    
        
            
            
                
                
                
                
            
        
    
    
        
        
    

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

参考官网：mybatis映射器mappers
https://mybatis.org/mybatis-3/zh/configuration.html#mappers

Book:

package com.yzh7.entity;

import lombok.Data;

import java.util.Date;

@Data
public class Book {
//    book_id,book_name,author,price,publisher,pub_date

    private Integer bookId;
    private String bookName;
    private String author;
    private Double price;
    private String publisher;
    private Date pubDate;

}

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

BookMapper:

package com.yzh7.mapper;


import com.yzh7.entity.Book;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface BookMapper {
    List
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

BookMapper.xml:

    
        select * from tb_book
    
    
        select * from tb_book
    
    
        select * from tb_book
        where book_id=#{bookId}
    
    
        insert into tb_book
        (book_name,author,price,publisher,pub_date)
        values
        (#{bookName},#{author},#{price},#{publisher},#{pubDate})   
    
    
        update tb_book
        set book_name=#{bookName},author=#{author},price=#{price},publisher=#{publisher},pub_date=#{pubDate}
        where book_id=#{bookId}
    
    
        delete from tb_book
        where book_id=#{bookId}
    

    
        select * from tb_book
        where book_name=#{bn} and author=#{at}
    

    
        select * from tb_book
        where book_name=#{bookName} and author=#{author}
    

    
        select * from tb_book
        where book_name=#{bookName} and author=#{author}
    

    
        select * from tb_book
        where book_name like '%${value}%'
    


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56

demo2 :

package com.yzh7.test;

import com.yzh7.entity.Book;
import com.yzh7.mapper.BookMapper;
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.After;
import org.junit.Before;
import org.junit.BeforeClass;
import org.junit.Test;

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

public class demo2 {

    @Test
    public void TestGetById(){
        BookMapper bookMapper=session.getMapper(BookMapper.class);
        Book book=bookMapper.getById(2);
        System.out.println("book1:"+book);
    }
    @Test
    public void testGetByNameAndAuthor(){
        BookMapper bookMapper=session.getMapper(BookMapper.class);
        Book book=bookMapper.getByNameAndAuthor("图书2","作者2");
        System.out.println("book2:"+book);
    }

    @Test
    public void testGetByMap(){
        BookMapper bookMapper=session.getMapper(BookMapper.class);
        Map map=new HashMap();
        map.put("bookName","图书2");
        map.put("author","作者2");
        Book book=bookMapper.getByMap(map);
        System.out.println("book3:"+book);
    }

    @Test
    public void testGetByBook(){
        BookMapper bookMapper=session.getMapper(BookMapper.class);
        Book b=new Book();
        b.setBookName("图书2");
        b.setAuthor("作者2");
        Book book=bookMapper.getByBook(b);
        System.out.println("book4:"+book);
    }

    @Test
    public void testListByBookName(){
        BookMapper bookMapper=session.getMapper(BookMapper.class);
        List book=bookMapper.listByBookName("图");
        System.out.println("book5:"+book);
    }



    private static SqlSessionFactory factory;    //静态
    private SqlSession session;

    @BeforeClass
    public static void befCla() throws IOException {
        String resource = "mybatis_config.xml";   //mybatis_config.xml
        InputStream inputStream = Resources.getResourceAsStream(resource);
        factory = new SqlSessionFactoryBuilder().build(inputStream);
    }

    @Before
    public void bf(){
        session=factory.openSession();
    }

    @After
    public void af(){
        session.commit();
        session.close();
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85

// A code block
var foo = 'bar';
1
2