Java优学网MyBatis插入入门解析：从基础语法到批量操作，轻松掌握数据库插入技巧

Java 框架原理百科来源：网络作者：编辑：facai888 2025-10-21 22:25:52 浏览：3 评论：0

INSERT INTO users(name, email) VALUES(#{name}, #{email}) INSERT INTO employee (emp_name, department, salary, hire_date) VALUES (#{name}, #{department}, #{salary}, #{hireDate})

// Mapper接口方法 int insertDepartment(String departmentName);

Java优学网MyBatis插入入门解析：从基础语法到批量操作，轻松掌握数据库插入技巧

// XML配置 INSERT INTO department(dept_name) VALUES(#{departmentName})

INSERT INTO user(name, email) VALUES(#{name}, #{email})

@Transactional public void batchInsertUsers(List users) {

SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH);
try {
    UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    for (int i = 0; i < users.size(); i++) {
        mapper.insertUser(users.get(i));
        if (i % 1000 == 0) {
            sqlSession.flushStatements();
        }
    }
    sqlSession.commit();
} finally {
    sqlSession.close();
}

}

Java优学网MyBatis插入入门解析：从基础语法到批量操作，轻松掌握数据库插入技巧