MyBatis的注解开发

除了XML映射方式，MyBatis还支持注解方式实现POJO对象和数据表之间的关联映射，使用注解的方式一般将SQL语句直接写到接口上。与XML的映射方式相比，基于注解的映射方式相对简单。Mybatis提供的注解有：

一、前期准备工作

1. 数据库准备

USE mybatis;
# 创建一个名称为tb_book的表
CREATE TABLE  tb_book( 
     id INT PRIMARY KEY AUTO_INCREMENT,
     name VARCHAR(255),
     price double,
     author VARCHAR(40)   
);
# 插入3条数据
INSERT INTO tb_book(name,price,author) VALUES('Java基础入门',45.0,'Liy');
INSERT INTO tb_book(name,price,author) VALUES('Java基础案例教程',48.0,'Tom');
INSERT INTO tb_book(name,price,author) VALUES('JavaWeb程序设计任务教程',50.0,'Jack');

2.搭建mybatis环境（不需要在resources创建映射文件了）

3. com.biem.pojo.Book.java实体类

package com.biem.pojo;

import lombok.*;

import java.io.Serializable;

@Getter
@Setter
@ToString
@NoArgsConstructor
@AllArgsConstructor
public class Book {
    private Integer id;
    private String name;
    private Integer price;
    private String author;
}

4.com.biem.mapper.BookMapper.java 接口类

package com.biem.mapper;

import com.biem.pojo.Book;
import org.apache.ibatis.annotations.*;

public interface BookMapper {

}

5.测试方法 com.biem.test.BookTest.java

package com.biem.test;

public class BookTest {

}

二、@select 注解

 1. com.biem.mapper.BookMapper.java下添加

@Select("select * from tb_book where id=#{id}")
    public Book findBookById(Integer id);

2.com.biem.test.BookTest.java 下添加测试方法

public void findBookById() {
        SqlSession session = MybatisUtil.openSession();
        BookMapper mapper = session.getMapper(BookMapper.class);
        System.out.println("mapper.findBookById(1) = " + mapper.findBookById(1));
        session.close();
    }

3.运行结果

三、@instert 注解

1. com.biem.mapper.BookMapper.java下添加

@Insert("insert into tb_book(name,price,author) values(#{name},#{price},#{author})")
    public int insertBook(Book book);

2.com.biem.test.BookTest.java 下添加测试方法

@Test
    public void insertBook(){
        SqlSession session =MybatisUtil.openSession(true);
        BookMapper mapper = session.getMapper(BookMapper.class);
        Book book =new Book();
        book.setName("大数据技术");
        book.setAuthor("王龙");
        book.setPrice(55);
        int result = mapper.insertBook(book);
        session.commit();
        session.close();
    }

3.运行结果

四、@ update注解

1. com.biem.mapper.BookMapper.java下添加

@Update("update tb_book set name=#{name},price=#{price},author=#{author} where id = #{id}")
    public int updateBook(Book book);

2.com.biem.test.BookTest.java 下添加测试方法

@Test
    public void updateBook(){
        SqlSession session = MybatisUtil.openSession();
        BookMapper mapper = session.getMapper(BookMapper.class);
        Book book =new Book();
        book.setId(4);
        book.setName("大数据技术");
        book.setAuthor("王冰");
        book.setPrice(36);
        int result = mapper.insertBook(book);
        if(result>0){
            System.out.println("更新了"+result+"条数据");
        } else {
            System.out.println("更新失败");
        }
        session.commit();
        session.close();
    }

3.运行结果

五、@ delete注解

1. com.biem.mapper.BookMapper.java下添加

@Delete("delete from tb_book where id=#{id}")
    public int deleteBook(Integer id);

2.com.biem.test.BookTest.java 下添加测试方法

@Test
    public void deleteBook(){
        SqlSession session = MybatisUtil.openSession();
        BookMapper mapper = session.getMapper(BookMapper.class);
        int result = mapper.deleteBook(4);
        if(result>0){
            System.out.println("删除了"+result+"条数据");
        } else {
            System.out.println("删除失败");
        }
        session.close();
    }

3.运行结果