在xml映射器配置中使用mybatis中的HikariConfig配置HikariCp dataSource

<configuration>
  <!-- 其他配置项 -->
  
  <!-- 配置数据源 -->
  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC" />
      <dataSource type="com.zaxxer.hikari.HikariDataSource">
        <!-- HikariCP的配置项 -->
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/mydatabase" />
        <property name="username" value="root" />
        <property name="password" value="password" />
        
        <!-- HikariCP特有的配置项 -->
        <property name="maximumPoolSize" value="10" />
        <property name="connectionTimeout" value="30000" />
        <property name="idleTimeout" value="600000" />
        <property name="dataSourceProperties">
          <props>
            <prop key="cachePrepStmts">true</prop>
            <prop key="prepStmtCacheSize">250</prop>
            <prop key="prepStmtCacheSqlLimit">2048</prop>
            <!-- 其他HikariCP配置项 -->
          </props>
        </property>
      </dataSource>
    </environment>
  </environments>
  
  <!-- 映射器配置 -->
  <mappers>
    <!-- 配置映射器 -->
  </mappers>
</configuration>

<mapper namespace="com.example.mapper.UserMapper">
  <select id="getUser" resultType="com.example.model.User">
    SELECT * FROM users WHERE id = #{id}
  </select>
</mapper>