MyBatis Data Source Setup Guide

1 year ago
Jackson Davis
2 minutes

Configuring a data source in MyBatis primarily involves setting up the data source information in the configuration file. Below are the steps for configuring a data source:

1. Configure data source information: Add relevant data source configuration information, such as database connection URL, username, and password, to the MyBatis configuration file (usually mybatis-config.xml).

<configuration>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mydatabase"/>
                <property name="username" value="root"/>
                <property name="password" value="password"/>
            </dataSource>
        </environment>
    </environments>
</configuration>

2. Configure Mapper files: Include the path to the Mapper file in the configuration file, so that MyBatis knows where to find the mapping file for the Mapper interface.

<mappers>
    <mapper resource="com/example/mapper/ExampleMapper.xml"/>
</mappers>

Create a data source: create a data source in your Java code, and then build a SqlSessionFactory object using SqlSessionFactoryBuilder.

String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

4. Obtain SqlSession: Get a SqlSession object through the SqlSessionFactory object, and then perform database operations.

try (SqlSession session = sqlSessionFactory.openSession()) {
    // do something
}

By following the above steps, you can configure a data source in MyBatis and perform database operations. It is important to modify the data source information in the configuration file according to the actual database configuration.

bannerAds