What is the method of connecting to the database in MyBatis?

MyBatis is a persistence framework that offers various methods for connecting to a database. Here are common ways to connect to a database using MyBatis:

XML configuration file: In MyBatis’s XML configuration file, you can set up data source and connection information. This includes the database URL, username, password, and more. By configuring this file, MyBatis will connect to the designated database based on your settings.

2. Annotation approach: In addition to XML configuration files, MyBatis also supports connecting to databases using annotations. By adding relevant annotations to Java objects or methods, you can specify database connection information.

// 使用注解方式配置数据库连接
@Mapper
public interface UserMapper {
  @Select("SELECT * FROM users WHERE id = #{id}")
  User getUserById(int id);
}

3. Programmatic API: MyBatis also offers a programmatic API, which allows you to directly create and configure database connections in your code. By utilizing the `SqlSessionFactoryBuilder` and `SqlSessionFactory` classes, you can manually establish database connections.

// 使用编程式 API 配置数据库连接
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

Here are three common methods for connecting to a database using MyBatis. You can choose one or more of these methods based on your own needs for connecting and manipulating the database.