http://www.tutorialspoint.com/mybatis/mybatis_dynamic_sql.htm Copyright © tutorialspoint.com MYBATIS - DYNAMIC SQL MYBATIS - DYNAMIC SQL Dynamic SQL is a very powerful feature of MyBatis. It enables programmers search the Student data base, based on the name of the student in MyBatis, you have to write the query using the dynamic SQL. MyBatis uses a powerful Dynamic SQL language that can be used within any mapped mapped SQL statement. Following are the OGNL based Dynamic SQL expressions provided by MyBatis. if choose when, otherwise trim where, set foreach The if Statement The most common thing to do in dynamic

http://www.tutorialspoint.com/mybatis/mybatis_quick_guide.htm Copyright © tutorialspoint.com MYBATIS - QUICK GUIDE MYBATIS - QUICK GUIDE MYBATIS - OVERVIEW MYBATIS - OVERVIEW MyBatis is an open source, lightweight Clinton Begin in 2002. MyBatis 3 is the latest version. It is a total makeover of IBATIS. A significant difference between MyBatis and other persistence frameworks is that MyBatis emphasizes the use of HQL or Enterprise JavaBeans Query Language EJBQL. MYBATIS Design Features MyBatis comes with the following design philosophies − Simplicity − MyBatis is widely regarded as one of the simplest persistence

document, v5.0.0-beta • Applicable in any ORM framework based on JDBC, such as JPA, Hibernate, Mybatis, Spring JDBC Template or direct use of JDBC. • Support any third‐party database connection pool DataSource, which implements DataSource interface of JDBC. It can be used for native JDBC or JPA, MyBatis and other ORM frameworks. DataSource dataSource = ShardingSphereDataSourceFactory. createDataSource(dataSourceMap kinds of ORM frameworks. • Applicable in any ORM framework based on JDBC, such as JPA, Hibernate, Mybatis, Spring JDBC Template or direct use of JDBC. • Support any third‐party database connection pool

kinds of ORM frameworks. • Applicable in any ORM framework based on JDBC, such as JPA, Hibernate, Mybatis, Spring JDBC Template or direct use of JDBC. • Supports any third‐party database connection pool DataSource, which implements DataSource interface of JDBC. It can be used for native JDBC or JPA, MyBatis and other ORM frameworks. DataSource dataSource = ShardingSphereDataSourceFactory. createDataSource(dataSourceMap kinds of ORM frameworks. • Applicable in any ORM framework based on JDBC, such as JPA, Hibernate, Mybatis, Spring JDBC Template or direct use of JDBC. • Support any third‐party database connection pool

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

kinds of ORM frameworks. • Applicable in any ORM framework based on JDBC, such as JPA, Hibernate, Mybatis, Spring JDBC Template, or direct use of JDBC; • Support any third‐party database connection pool Data Source Developer can choose to use native JDBC or ORM frameworks such as JPA, Hibernate or MyBatis through the DataSource. Take native JDBC usage as an example: // Create ShardingSphereDataSource Data Source Developer can inject to use native JDBC or ORM frameworks such as JPA, Hibernate or MyBatis through the DataSource. Take native JDBC usage as an example: @Resource private DataSource dataSource;

kinds of ORM frameworks. • Applicable in any ORM framework based on JDBC, such as JPA, Hibernate, Mybatis, Spring JDBC Template, or direct use of JDBC; • Support any third‐party database connection pool Data Source Developer can choose to use native JDBC or ORM frameworks such as JPA, Hibernate or MyBatis through the DataSource. Take native JDBC usage as an example: // Create ShardingSphereDataSource Data Source Developer can inject to use native JDBC or ORM frameworks such as JPA, Hibernate or MyBatis through the DataSource. Take native JDBC usage as an example: @Resource private DataSource dataSource;

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: