How to create MyBatis mapping files?

2 years ago
Olivia Parker
2 minutes

The main steps in creating a MyBatis mapping file include the following:

  1. The file named xxxMapper.xml
  2. xxx
  3. Add namespace and DTD declaration to the root node of the XML file as shown below:
<!DOCTYPE mapper
    PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.example.mapper.XxxMapper">
    <!-- 映射语句 -->
</mapper>
  1. choose
  2. put in
  3. – I only need one option: update.
  4. Remove
  5. Choose
<select id="selectById" parameterType="int" resultType="com.example.model.Xxx">
    SELECT * FROM xxx WHERE id = #{id}
</select>

The id attribute serves as the unique identifier for the mapping statement, the parameterType attribute indicates the parameter type, and the resultType attribute specifies the return result type.
Dynamic SQL statements in MyBatis mapping statements can be used, such as using the if tag for conditional statements or the foreach tag for looping operations.
The location of the mapping files can be configured in the MyBatis configuration file (usually mybatis-config.xml), for example:

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

The resource attribute corresponds to the path of the mapping file.

The above are the basic steps for creating MyBatis mapping files. Depending on specific needs, more mapping statements and dynamic SQL can be added to meet business requirements.

bannerAds