Step 2. Get the code git clone https://github.com/pingcap-inc/tidb-example-java.git Compared with Mybatis, the JDBC implementation might be not a best practice, be- cause you need to write error handling code easily, which makes your code slightly redundant. Mybatis is a popular open-source Java class persistence framework. The following uses MyBatis Generator as a Maven plugin to generate the persistence persistence layer code. Change to the plain-java-mybatis directory: cd plain-java-mybatis The structure of this directory is as follows: . ￿── Makefile ￿── pom.xml ￿── src ￿── main ￿── java ￿ ￿── com

com/pingcap-inc/tidb-example-java.git Mybatis 是当前比较流行的开源 Java 应用持久层框架，本文将以 Maven 插件的方式使用 MyBatis Generator 生成部 分持久层代码。 进入目录 plain-java-mybatis： cd plain-java-mybatis 目录结构如下所示： . ├ ─ ─ Makefile ├ ─ ─ ├ ─ ─ mapper │ ├ ─ ─ PlayerMapper.xml │ └ ─ ─ PlayerMapperEx.xml 150 ├ ─ ─ mybatis-config.xml └ ─ ─ mybatis-generator.xml 其中，自动生成的文件有： • src/main/java/com/pingcap/model/Player.java：Player 实体类文件 XML 映射，它是 Mybatis 用于生成 Player Mapper 接口的实现类的配置 这些文件的生成策略被写在了 mybatis-generator.xml 配置文件内，它是 Mybatis Generator 的配置文件，下面 配置文件中添加了使用方法的说明： mybatis.org//DTD MyBatis

complex SQL statements, it is recommended to use ORM framework for development, such as Hibernate, MyBatis, or Spring Data JPA. It can help you: • Reduce boilerplate code for managing connections and transactions 2 Connect to TiDB with MyBatis TiDB is a MySQL-compatible database, and MyBatis is a popular open-source Java ORM. In this tutorial, you can learn how to use TiDB and MyBatis to accomplish the following following tasks: 144 • Set up your environment. • Connect to your TiDB cluster using MyBatis. • Build and run your application. Optionally, you can find sample code snippets for basic CRUD operations. Note:

complex SQL statements, it is recommended to use ORM framework for development, such as Hibernate, MyBatis, or Spring Data JPA. It can help you: • Reduce boilerplate code for managing connections and transactions 2 Connect to TiDB with MyBatis TiDB is a MySQL-compatible database, and MyBatis is a popular open-source Java ORM. In this tutorial, you can learn how to use TiDB and MyBatis to accomplish the following following tasks: • Set up your environment. • Connect to your TiDB cluster using MyBatis. • Build and run your application. Optionally, you can find sample code snippets for basic CRUD operations. Note:

complex SQL statements, it is recommended to use ORM framework for development, such as Hibernate, MyBatis, or Spring Data JPA. It can help you: • Reduce boilerplate code for managing connections and transactions 2 Connect to TiDB with MyBatis TiDB is a MySQL-compatible database, and MyBatis is a popular open-source Java ORM. In this tutorial, you can learn how to use TiDB and MyBatis to accomplish the following following tasks: • Set up your environment. • Connect to your TiDB cluster using MyBatis. • Build and run your application. Optionally, you can find sample code snippets for basic CRUD operations. Note:

complex SQL statements, it is recommended to use ORM framework for development, such as Hibernate, MyBatis, or Spring Data JPA. It can help you: • Reduce boilerplate code for managing connections and transactions 2 Connect to TiDB with MyBatis TiDB is a MySQL-compatible database, and MyBatis is a popular open-source Java ORM. In this tutorial, you can learn how to use TiDB and MyBatis to accomplish the following following tasks: • Set up your environment. • Connect to your TiDB cluster using MyBatis. • Build and run your application. Optionally, you can find sample code snippets for basic CRUD operations. Note:

complex SQL statements, it is recommended to use ORM framework for development, such as Hibernate, MyBatis, or Spring Data JPA. It can help you: • Reduce boilerplate code for managing connections and transactions 2 Connect to TiDB with MyBatis TiDB is a MySQL-compatible database, and MyBatis is a popular open-source Java ORM. In this tutorial, you can learn how to use TiDB and MyBatis to accomplish the following following tasks: • Set up your environment. • Connect to your TiDB cluster using MyBatis. • Build and run your application. Optionally, you can find sample code snippets for basic CRUD operations. Note:

complex SQL statements, it is recommended to use ORM framework for development, such as Hibernate, MyBatis, or Spring Data JPA. It can help you: • Reduce boilerplate code for managing connections and transactions 2 Connect to TiDB with MyBatis TiDB is a MySQL-compatible database, and MyBatis is a popular open-source Java ORM. In this tutorial, you can learn how to use TiDB and MyBatis to accomplish the following following tasks: • Set up your environment. • Connect to your TiDB cluster using MyBatis. • Build and run your application. Optionally, you can find sample code snippets for basic CRUD operations. Note:

complex SQL statements, it is recommended to use ORM framework for development, such as Hibernate, MyBatis, or Spring Data JPA. It can help you: • Reduce boilerplate code for managing connections and transactions 2 Connect to TiDB with MyBatis TiDB is a MySQL-compatible database, and MyBatis is a popular open-source Java ORM. In this tutorial, you can learn how to use TiDB and MyBatis to accomplish the following following tasks: • Set up your environment. • Connect to your TiDB cluster using MyBatis. • Build and run your application. Optionally, you can find sample code snippets for basic CRUD operations. Note:

complex SQL statements, it is recommended to use ORM framework for development, such as Hibernate, MyBatis, or Spring Data JPA. It can help you: • Reduce boilerplate code for managing connections and transactions 2 Connect to TiDB with MyBatis TiDB is a MySQL-compatible database, and MyBatis is a popular open-source Java ORM. In this tutorial, you can learn how to use TiDB and MyBatis to accomplish the following following tasks: • Set up your environment. • Connect to your TiDB cluster using MyBatis. • Build and run your application. Optionally, you can find sample code snippets for basic CRUD operations. Note: