Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 2.1.4 Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 i 2.2 ShardingSphere‐Proxy Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 2.2.4 Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 3 Features 16 3 267 Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 268 Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 269 Sample . . .

Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 2.1.4 Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 2.2 ShardingSphere‐Proxy Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 2.2.4 Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 3 Features 15 3 282 Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 283 Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 284 Sample . . .

Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 i 7.1.4 Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 7.2 ShardingSphere‐Proxy Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 7.2.4 Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 8 Features 19 8 397 Background . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 397 Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 397 9.3 Common Configuration

Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 i 7.1.4 Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 7.2 ShardingSphere‐Proxy Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 7.2.4 Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 8 Features 19 8 414 Background . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 414 Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 415 vi 9.2.9 CDC

PROCEDURES MYBATIS - STORED PROCEDURES You can call a stored procedure using MyBatis. First of all, let us understand how to create a stored procedure in MySQL. We have the following EMPLOYEE table in MySQL (`ID`) ); Let us create the following stored procedure in MySQL database − DELIMITER // DROP PROCEDURE IF EXISTS details.read_recordById // CREATE PROCEDURE details.read_recordById (IN emp_id INT) ----------+----------------------+ 2 rows in set (0.00 sec) STUDENT POJO Class To use stored procedure, you do not need to modify the Student.java file. Let us keep it as it was in the last chapter.

资料下载，可访问尚硅谷（中国）官网 www.atguigu.com 下载区】 #创建存储过程(查询得到男性或女性的数量, 如果传入的是 0 就女性否则是男性) DELIMITER $ CREATE PROCEDURE mybatis.ges_user_count(IN sex_id INT, OUT user_count INT) BEGIN IF sex_id=0 THEN SELECT COUNT(*)

3 Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 2.1.4 Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 2.2 ShardingSphere‐Proxy supported. 2.1.3 Requirements The development environment requires Java JRE 8 or later. 2.1.4 Procedure 1. Rules configuration. Please refer to User Manual for more details. 2. Import Maven dependency Apache ShardingSphere document, v5.1.2 Connection Interface • Do not support operations of stored procedure, function and cursor • Do not support native SQL • Do not support savepoint related operations

support timeout related operations Connection Interface • Do not support operations of stored procedure, function and cursor • Do not support native SQL • Do not support savepoint related operations

support timeout related operations Connection Interface • Do not support operations of stored procedure, function and cursor • Do not support native SQL • Do not support savepoint related operations

Apache ShardingSphere document, v5.1.1 Connection Interface • Do not support operations of stored procedure, function and cursor • Do not support native SQL • Do not support savepoint related operations