@Options

package com.flying.entity;

public class Student {
    private Integer id;
    private String name;
    private Integer age;
    private String major;
    private Double score;

    public Integer getId() { return id; }
    public void setId(Integer id) { this.id = id; }
    public String getName() { return name; }
    public void setName(String name) { this.name = name; }
    public Integer getAge() { return age; }
    public void setAge(Integer age) { this.age = age; }
    public String getMajor() { return major; }
    public void setMajor(String major) { this.major = major; }
    public Double getScore() { return score; }
    public void setScore(Double score) { this.score = score; }
}

package com.flying.mapper;

import com.flying.entity.Student;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Select;
import java.util.List;

public interface StudentMapper {

    /**
     * 插入学生，获取自增主键回填到 id 属性
     */
    @Insert("INSERT INTO student(name, age, major, score) VALUES(#{name}, #{age}, #{major}, #{score})")
    @Options(useGeneratedKeys = true, keyProperty = "id")
    int insertStudent(Student student);

    /**
     * 插入学生，同时设置超时时间为 3 秒
     */
    @Insert("INSERT INTO student(name, age, major, score) VALUES(#{name}, #{age}, #{major}, #{score})")
    @Options(useGeneratedKeys = true, keyProperty = "id", timeout = 3)
    int insertWithTimeout(Student student);

    /**
     * 查询所有学生，执行后刷新二级缓存
     */
    @Select("SELECT id, name, age, major, score FROM student")
    @Options(flushCache = Options.FlushCachePolicy.TRUE)
    List<Student> selectAllFlushCache();
}

package com.flying.test;

import com.flying.entity.Student;
import com.flying.mapper.StudentMapper;
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 java.io.InputStream;

public class OptionsTest {
    public static void main(String[] args) throws Exception {
        InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);
        SqlSession session = factory.openSession();

        StudentMapper mapper = session.getMapper(StudentMapper.class);

        // 1. 插入并获取自增主键
        System.out.println("=== 插入并获取自增主键 ===");
        Student newStu = new Student();
        newStu.setName("赵新");
        newStu.setAge(23);
        newStu.setMajor("人工智能");
        newStu.setScore(91.0);

        int rows = mapper.insertStudent(newStu);
        System.out.println("影响行数: " + rows);
        System.out.println("回填主键 id: " + newStu.getId());

        // 2. 带超时的插入
        System.out.println("\n=== 带超时的插入 ===");
        Student newStu2 = new Student();
        newStu2.setName("钱多多");
        newStu2.setAge(20);
        newStu2.setMajor("网络工程");
        newStu2.setScore(85.0);

        int rows2 = mapper.insertWithTimeout(newStu2);
        System.out.println("影响行数: " + rows2);
        System.out.println("回填主键 id: " + newStu2.getId());

        session.commit();
        session.close();
    }
}