prepareStatement(sql)) { hintManager.setDatabaseShardingValue(3); try (ResultSet rs = pstmt.executeQuery()) { while (rs.next()) { //... } 3.1. Sharding 29 Apache ShardingSphere document, v5.0.0-beta conn.prepareStatement(sql)) { ps.setInt(1, 10); ps.setInt(2, 1000); try (ResultSet rs = ps.executeQuery()) { while(rs.next()) { // ... } } } 4.1. ShardingSphere-JDBC 151 Apache ShardingSphere document prepareStatement(sql)) { ps.setInt(1, 10); ps.setInt(2, 1000); try (ResultSet rs = preparedStatement.executeQuery()) { while(rs.next()) { // ... } } } 4.1. ShardingSphere-JDBC 153 Apache ShardingSphere

conn.prepareStatement(sql)) { ps.setInt(1, 10); ps.setInt(2, 1000); try (ResultSet rs = ps.executeQuery()) { while(rs.next()) { // ... } } } Use YAML Import Maven Dependency org prepareStatement(sql)) { ps.setInt(1, 10); ps.setInt(2, 1000); try (ResultSet rs = preparedStatement.executeQuery()) { while(rs.next()) { // ... } } } Use Spring Boot Starter Import Maven Dependency r", 1); hintManager.addTableShardingValue("t_order", 2); try (ResultSet rs = preparedStatement.executeQuery()) { while (rs.next()) { // ... } } } // Sharding database and one database route with

prepareStatement(sql)) { hintManager.setDatabaseShardingValue(3); try (ResultSet rs = pstmt.executeQuery()) { while (rs.next()) { //... } } } 3.1. 数据分片 27 Apache ShardingSphere document, v5.0.0-beta conn.prepareStatement(sql)) { ps.setInt(1, 10); ps.setInt(2, 1000); try (ResultSet rs = ps.executeQuery()) { while(rs.next()) { // ... } } } 使用 YAML 配置 引入 Maven 依赖 org.apache prepareStatement(sql)) { ps.setInt(1, 10); ps.setInt(2, 1000); try (ResultSet rs = preparedStatement.executeQuery()) { while(rs.next()) { // ... } } } 使用 Spring Boot Starter 引入 Maven 依赖

conn.prepareStatement(sql)) { ps.setInt(1, 10); ps.setInt(2, 1000); try (ResultSet rs = ps.executeQuery()) { while(rs.next()) { // ... } } } 使用 YAML 配置 引入 Maven 依赖 org.apache prepareStatement(sql)) { ps.setInt(1, 10); ps.setInt(2, 1000); try (ResultSet rs = preparedStatement.executeQuery()) { while(rs.next()) { // ... } } } 使用 Spring Boot Starter 引入 Maven 依赖 r", 1); hintManager.addTableShardingValue("t_order", 2); try (ResultSet rs = preparedStatement.executeQuery()) { while (rs.next()) { // ... } } } // Sharding database without sharding table and

prepareStatement(sql)) { ps.setInt(1, 10); ps.setInt(2, 1000); try (ResultSet rs = preparedStatement.executeQuery()) { while(rs.next()) { // ... } } } Mode Configuration Root Configuration Class name: prepareStatement(sql)) { ps.setInt(1, 10); ps.setInt(2, 1000); try (ResultSet rs = preparedStatement.executeQuery()) { while(rs.next()) { // ... } } } Database Connection Pool Usage String driverClassName prepareStatement(sql)) { ps.setInt(1, 10); ps.setInt(2, 1000); try (ResultSet rs = preparedStatement.executeQuery()) { while(rs.next()) { // ... } } } 5.1. ShardingSphere-JDBC 99 Apache ShardingSphere

prepareStatement(sql)) { ps.setInt(1, 10); ps.setInt(2, 1000); try (ResultSet rs = preparedStatement.executeQuery()) { while(rs.next()) { // ... } } } • Use database connection pool: String driverClassName prepareStatement(sql)) { ps.setInt(1, 10); ps.setInt(2, 1000); try (ResultSet rs = preparedStatement.executeQuery()) { while(rs.next()) { 9.1. ShardingSphere-JDBC 86 Apache ShardingSphere document // prepareStatement(sql)) { ps.setInt(1, 10); ps.setInt(2, 1000); try (ResultSet rs = preparedStatement.executeQuery()) { while(rs.next()) { // ... } } } Mode Background Build the running mode through

1001); try (ResultSet rs = preparedStatement.executeQuery()) { 2.2使用Spring 引入Maven依赖 基于Spring boot的规则配置 while(rs.next()) { System.out.println(rs.getInt(1)); System.out.println(rs.getInt(2)); } } } io.shardingsphere sharding-jdbc-spring-boot-starter

prepareStatement(sql)) { ps.setInt(1, 10); ps.setInt(2, 1000); try (ResultSet rs = preparedStatement.executeQuery()) { while(rs.next()) { // ... } } } • Use database connection pool: 4.1. ShardingSphere-JDBC prepareStatement(sql)) { ps.setInt(1, 10); ps.setInt(2, 1000); try (ResultSet rs = preparedStatement.executeQuery()) { while(rs.next()) { // ... } } } Sample Load JDBC URL of config.yaml profile in prepareStatement(sql)) { ps.setInt(1, 10); ps.setInt(2, 1000); try (ResultSet rs = preparedStatement.executeQuery()) { while(rs.next()) { // ... } } } Mode Background Build the running mode through

prepareStatement(sql)) { ps.setInt(1, 10); ps.setInt(2, 1000); try (ResultSet rs = preparedStatement.executeQuery()) { while(rs.next()) { // ... } } } • 使用数据库连接池 9.1. ShardingSphere-JDBC 78 Apache prepareStatement(sql)) { ps.setInt(1, 10); ps.setInt(2, 1000); try (ResultSet rs = preparedStatement.executeQuery()) { while(rs.next()) { // ... } } } 配置示例 加载 classpath 中 config.yaml 配置文件的 JDBC URL： prepareStatement(sql)) { ps.setInt(1, 10); ps.setInt(2, 1000); try (ResultSet rs = preparedStatement.executeQuery()) { while(rs.next()) { // ... } } } 模式配置 背景信息 通过 Java API 方式构建运行模式。 参数解释 类名称：org

ShardingSphere document ps.setInt(1, 10); ps.setInt(2, 1000); try (ResultSet rs = preparedStatement.executeQuery()) { while(rs.next()) { // ... } } } • 使用数据库连接池 String driverClassName = "org.apache prepareStatement(sql)) { ps.setInt(1, 10); ps.setInt(2, 1000); try (ResultSet rs = preparedStatement.executeQuery()) { while(rs.next()) { // ... } } } 配置示例 加载 classpath 中 config.yaml 配置文件的 JDBC URL： prepareStatement(sql)) { ps.setInt(1, 10); ps.setInt(2, 1000); try (ResultSet rs = preparedStatement.executeQuery()) { while(rs.next()) { // ... } } } 模式配置 背景信息 通过 Java API 方式构建运行模式。 参数解释 类名称：org