@Insert

package com.flying.entity;

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

    // Getter 和 Setter
    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.Param;
import java.util.List;

public interface StudentMapper {

    /**
     * 插入单条记录，并获取自增主键回填到对象中
     */
    @Insert("INSERT INTO student(name, age, major, score) VALUES(#{name}, #{age}, #{major}, #{score})")
    @Options(useGeneratedKeys = true, keyProperty = "id")
    int insertStudent(Student student);

    /**
     * 批量插入学生
     * 使用 <script> 标签包裹 XML 动态 SQL 的 <foreach>
     */
    @Insert("<script>" +
            "INSERT INTO student(name, age, major, score) VALUES " +
            "<foreach collection='list' item='item' separator=','>" +
            "(#{item.name}, #{item.age}, #{item.major}, #{item.score})" +
            "</foreach>" +
            "</script>")
    int batchInsert(@Param("list") List<Student> students);
}

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;
import java.util.ArrayList;
import java.util.List;

public class InsertTest {
    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=== 批量插入 ===");
        List<Student> batch = new ArrayList<>();
        Student s1 = new Student(); s1.setName("钱多多"); s1.setAge(20); s1.setMajor("网络工程"); s1.setScore(85.0);
        Student s2 = new Student(); s2.setName("孙小空"); s2.setAge(21); s2.setMajor("网络工程"); s2.setScore(89.5);
        batch.add(s1);
        batch.add(s2);

        int batchRows = mapper.batchInsert(batch);
        System.out.println("影响行数: " + batchRows);

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