MyBatis CRUD Tutorial: Data Manipulation Guide

MyBatis is a persistence framework that offers a way to map SQL queries to Java objects using XML files or annotations. Here is an example of using MyBatis for CRUD operations.

1. Increase data.

// 使用 SQLSessionFactoryBuilder 创建 SQLSessionFactory
SQLSessionFactory factory = new SQLSessionFactoryBuilder().build(inputStream);

// 获取 SQLSession
SQLSession session = factory.openSession();

// 创建一个实体对象
User user = new User();
user.setId(1);
user.setName("Alice");
user.setAge(20);

// 调用 SQLSession 的 insert 方法插入数据
session.insert("insertUser", user);

// 提交事务
session.commit();

// 关闭 SQLSession
session.close();

1. Delete data.

// 获取 SQLSession
SQLSession session = factory.openSession();

// 调用 SQLSession 的 delete 方法删除数据
session.delete("deleteUser", 1);

// 提交事务
session.commit();

// 关闭 SQLSession
session.close();

1. Update data.

// 获取 SQLSession
SQLSession session = factory.openSession();

// 创建一个实体对象
User user = new User();
user.setId(1);
user.setName("Bob");
user.setAge(25);

// 调用 SQLSession 的 update 方法更新数据
session.update("updateUser", user);

// 提交事务
session.commit();

// 关闭 SQLSession
session.close();

1. Data retrieval:

// 获取 SQLSession
SQLSession session = factory.openSession();

// 调用 SQLSession 的 selectOne 方法查询单条数据
User user = session.selectOne("getUserById", 1);
System.out.println(user);

// 调用 SQLSession 的 selectList 方法查询多条数据
List<User> userList = session.selectList("getAllUsers");
for (User u : userList) {
    System.out.println(u);
}

// 关闭 SQLSession
session.close();

The code example above demonstrates how to perform CRUD operations using MyBatis. You need to configure corresponding SQL statements in the XML file, instantiate the SQLSessionFactory, and then use the SQLSession to execute the operations.