add sharding-jdbc test case of nacos (#186)
* add nacos-jdbc test case
* add nacos springboot test case and modified properties
* Update master-slave.yaml
* add sharding-jdbc test case of nacos
* Update encrypt.yaml
* Update encrypt.yaml
* Update application-cloud-nacos-encrypt.properties
* Update application-cloud-nacos-master-slave.properties
* update indent
* Update application-sharding-databases-tables.xml
* Update application-sharding-databases-tables.xml
* Update application-sharding-databases-tables.xml
* Update encrypt.yaml
* Update encrypt.yaml
* Update master-slave.yaml
* Update encrypt.yaml
* Update application-encrypt.xml
* Update application-sharding-databases-tables.xml
* Update application-encrypt.xml
* Update application-encrypt.xml
* Update application-encrypt.xml
* Update application-encrypt.xml
* Update application-encrypt.xml
* Update application-encrypt.xml
* Update application-master-slave.xml
* Update application-encrypt.xml
* Update application-encrypt.xml
* Update application-encrypt.xml
* Update application-encrypt.xml
* Update application-encrypt.xml
* Update application-encrypt.xml
* Update application-encrypt.xml
* Update application-encrypt.xml
* Update application-encrypt.xml
* update indent
* update indent
* update indent
* update indent
* Update application-encrypt.xml
* Update application-encrypt.xml
* Update application-encrypt.xml
* Update application-master-slave.xml
* update indent
diff --git a/sharding-jdbc-example/orchestration-example/orchestration-raw-jdbc-example/src/main/resources/META-INF/nacos/cloud/encrypt.yaml b/sharding-jdbc-example/orchestration-example/orchestration-raw-jdbc-example/src/main/resources/META-INF/nacos/cloud/encrypt.yaml
new file mode 100644
index 0000000..d9173c8
--- /dev/null
+++ b/sharding-jdbc-example/orchestration-example/orchestration-raw-jdbc-example/src/main/resources/META-INF/nacos/cloud/encrypt.yaml
@@ -0,0 +1,10 @@
+orchestration:
+ name: demo_yaml_ds_encrypt
+ overwrite: false
+ registry:
+ type: nacos
+ serverLists: localhost:8848
+ namespace:
+ props:
+ group: SHARDING_SPHERE_DEFAULT_GROUP
+ timeout: 3000
diff --git a/sharding-jdbc-example/orchestration-example/orchestration-raw-jdbc-example/src/main/resources/META-INF/nacos/cloud/master-slave.yaml b/sharding-jdbc-example/orchestration-example/orchestration-raw-jdbc-example/src/main/resources/META-INF/nacos/cloud/master-slave.yaml
new file mode 100644
index 0000000..7c0b1b8
--- /dev/null
+++ b/sharding-jdbc-example/orchestration-example/orchestration-raw-jdbc-example/src/main/resources/META-INF/nacos/cloud/master-slave.yaml
@@ -0,0 +1,10 @@
+orchestration:
+ name: demo_yaml_ds_ms
+ overwrite: false
+ registry:
+ type: nacos
+ serverLists: localhost:8848
+ namespace:
+ props:
+ group: SHARDING_SPHERE_DEFAULT_GROUP
+ timeout: 3000
diff --git a/sharding-jdbc-example/orchestration-example/orchestration-raw-jdbc-example/src/main/resources/META-INF/nacos/local/encrypt.yaml b/sharding-jdbc-example/orchestration-example/orchestration-raw-jdbc-example/src/main/resources/META-INF/nacos/local/encrypt.yaml
new file mode 100644
index 0000000..77ca956
--- /dev/null
+++ b/sharding-jdbc-example/orchestration-example/orchestration-raw-jdbc-example/src/main/resources/META-INF/nacos/local/encrypt.yaml
@@ -0,0 +1,33 @@
+orchestration:
+ name: demo_yaml_ds_encrypt
+ overwrite: true
+ registry:
+ type: nacos
+ serverLists: localhost:8848
+ namespace:
+ props:
+ group: SHARDING_SPHERE_DEFAULT_GROUP
+ timeout: 3000
+
+dataSource: !!com.zaxxer.hikari.HikariDataSource
+ driverClassName: com.mysql.jdbc.Driver
+ jdbcUrl: jdbc:mysql://localhost:3306/demo_ds
+ username: root
+ password:
+
+encryptRule:
+ encryptors:
+ status_encryptor:
+ type: aes
+ props:
+ aes.key.value: 123456
+ tables:
+ t_order:
+ columns:
+ status:
+ cipherColumn: status
+ encryptor: status_encryptor
+
+props:
+ query.with.cipher.column: true
+ sql.show: false
diff --git a/sharding-jdbc-example/orchestration-example/orchestration-raw-jdbc-example/src/main/resources/META-INF/nacos/local/master-slave.yaml b/sharding-jdbc-example/orchestration-example/orchestration-raw-jdbc-example/src/main/resources/META-INF/nacos/local/master-slave.yaml
new file mode 100644
index 0000000..7c8ca89
--- /dev/null
+++ b/sharding-jdbc-example/orchestration-example/orchestration-raw-jdbc-example/src/main/resources/META-INF/nacos/local/master-slave.yaml
@@ -0,0 +1,35 @@
+dataSources:
+ ds_master: !!com.zaxxer.hikari.HikariDataSource
+ driverClassName: com.mysql.jdbc.Driver
+ jdbcUrl: jdbc:mysql://localhost:3306/demo_ds_master
+ username: root
+ password:
+ ds_slave_0: !!com.zaxxer.hikari.HikariDataSource
+ driverClassName: com.mysql.jdbc.Driver
+ jdbcUrl: jdbc:mysql://localhost:3306/demo_ds_slave_0
+ username: root
+ password:
+ ds_slave_1: !!com.zaxxer.hikari.HikariDataSource
+ driverClassName: com.mysql.jdbc.Driver
+ jdbcUrl: jdbc:mysql://localhost:3306/demo_ds_slave_1
+ username: root
+ password:
+
+masterSlaveRule:
+ name: ds_ms
+ masterDataSourceName: ds_master
+ slaveDataSourceNames: [ds_slave_0, ds_slave_1]
+
+props:
+ sql.show: true
+
+orchestration:
+ name: demo_yaml_ds_ms
+ overwrite: true
+ registry:
+ type: nacos
+ serverLists: localhost:8848
+ namespace:
+ props:
+ group: SHARDING_SPHERE_DEFAULT_GROUP
+ timeout: 3000
diff --git a/sharding-jdbc-example/orchestration-example/orchestration-spring-boot-example/src/main/resources/application-cloud-nacos-encrypt.properties b/sharding-jdbc-example/orchestration-example/orchestration-spring-boot-example/src/main/resources/application-cloud-nacos-encrypt.properties
new file mode 100644
index 0000000..4de4076
--- /dev/null
+++ b/sharding-jdbc-example/orchestration-example/orchestration-spring-boot-example/src/main/resources/application-cloud-nacos-encrypt.properties
@@ -0,0 +1,24 @@
+#
+# Copyright 2016-2018 shardingsphere.io.
+# <p>
+# Licensed under the Apache License, Version 2.0 (the "License");
+# you may not use this file except in compliance with the License.
+# You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+# </p>
+#
+
+spring.shardingsphere.orchestration.name=demo_spring_boot_ds_encrypt
+spring.shardingsphere.orchestration.overwrite=false
+spring.shardingsphere.orchestration.registry.type=nacos
+spring.shardingsphere.orchestration.registry.server-lists=localhost:8848
+spring.shardingsphere.orchestration.registry.namespace=
+spring.shardingsphere.orchestration.registry.props.group=SHARDING_SPHERE_DEFAULT_GROUP
+spring.shardingsphere.orchestration.registry.props.timeout=3000
diff --git a/sharding-jdbc-example/orchestration-example/orchestration-spring-boot-example/src/main/resources/application-cloud-nacos-master-slave.properties b/sharding-jdbc-example/orchestration-example/orchestration-spring-boot-example/src/main/resources/application-cloud-nacos-master-slave.properties
new file mode 100644
index 0000000..ce9b2fc
--- /dev/null
+++ b/sharding-jdbc-example/orchestration-example/orchestration-spring-boot-example/src/main/resources/application-cloud-nacos-master-slave.properties
@@ -0,0 +1,7 @@
+spring.shardingsphere.orchestration.name=demo_spring_boot_ds_ms
+spring.shardingsphere.orchestration.overwrite=false
+spring.shardingsphere.orchestration.registry.type=nacos
+spring.shardingsphere.orchestration.registry.server-lists=localhost:8848
+spring.shardingsphere.orchestration.registry.namespace=
+spring.shardingsphere.orchestration.registry.props.group=SHARDING_SPHERE_DEFAULT_GROUP
+spring.shardingsphere.orchestration.registry.props.timeout=3000
diff --git a/sharding-jdbc-example/orchestration-example/orchestration-spring-boot-example/src/main/resources/application-local-nacos-encrypt.properties b/sharding-jdbc-example/orchestration-example/orchestration-spring-boot-example/src/main/resources/application-local-nacos-encrypt.properties
new file mode 100644
index 0000000..11c1502
--- /dev/null
+++ b/sharding-jdbc-example/orchestration-example/orchestration-spring-boot-example/src/main/resources/application-local-nacos-encrypt.properties
@@ -0,0 +1,38 @@
+#
+# Copyright 2016-2018 shardingsphere.io.
+# <p>
+# Licensed under the Apache License, Version 2.0 (the "License");
+# you may not use this file except in compliance with the License.
+# You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+# </p>
+#
+
+spring.shardingsphere.datasource.name=ds_encrypt
+
+spring.shardingsphere.datasource.ds_encrypt.type=com.zaxxer.hikari.HikariDataSource
+spring.shardingsphere.datasource.ds_encrypt.driver-class-name=com.mysql.jdbc.Driver
+spring.shardingsphere.datasource.ds_encrypt.jdbc-url=jdbc:mysql://localhost:3306/demo_ds
+spring.shardingsphere.datasource.ds_encrypt.username=root
+spring.shardingsphere.datasource.ds_encrypt.password=
+
+spring.shardingsphere.encrypt.encryptors.status_encryptor.type=aes
+spring.shardingsphere.encrypt.encryptors.status_encryptor.props.aes.key.value=123456
+spring.shardingsphere.encrypt.tables.t_order.columns.status.cipherColumn=status
+spring.shardingsphere.encrypt.tables.t_order.columns.status.encryptor=status_encryptor
+
+spring.shardingsphere.props.query.with.cipher.comlum=true
+spring.shardingsphere.props.sql.show=true
+
+spring.shardingsphere.orchestration.name=demo_spring_boot_ds_encrypt
+spring.shardingsphere.orchestration.overwrite=true
+spring.shardingsphere.orchestration.registry.type=nacos
+spring.shardingsphere.orchestration.registry.server-lists=localhost:8848
+spring.shardingsphere.orchestration.registry.namespace=
diff --git a/sharding-jdbc-example/orchestration-example/orchestration-spring-boot-example/src/main/resources/application-local-nacos-master-slave.properties b/sharding-jdbc-example/orchestration-example/orchestration-spring-boot-example/src/main/resources/application-local-nacos-master-slave.properties
new file mode 100644
index 0000000..7667e7d
--- /dev/null
+++ b/sharding-jdbc-example/orchestration-example/orchestration-spring-boot-example/src/main/resources/application-local-nacos-master-slave.properties
@@ -0,0 +1,30 @@
+spring.shardingsphere.datasource.names=ds_master,ds_slave_0,ds_slave_1
+
+spring.shardingsphere.datasource.ds_master.type=com.zaxxer.hikari.HikariDataSource
+spring.shardingsphere.datasource.ds_master.driver-class-name=com.mysql.jdbc.Driver
+spring.shardingsphere.datasource.ds_master.jdbc-url=jdbc:mysql://localhost:3306/demo_ds_master
+spring.shardingsphere.datasource.ds_master.username=root
+spring.shardingsphere.datasource.ds_master.password=
+
+spring.shardingsphere.datasource.ds_slave_0.type=com.zaxxer.hikari.HikariDataSource
+spring.shardingsphere.datasource.ds_slave_0.driver-class-name=com.mysql.jdbc.Driver
+spring.shardingsphere.datasource.ds_slave_0.jdbc-url=jdbc:mysql://localhost:3306/demo_ds_slave_0
+spring.shardingsphere.datasource.ds_slave_0.username=root
+spring.shardingsphere.datasource.ds_slave_0.password=
+
+spring.shardingsphere.datasource.ds_slave_1.type=com.zaxxer.hikari.HikariDataSource
+spring.shardingsphere.datasource.ds_slave_1.driver-class-name=com.mysql.jdbc.Driver
+spring.shardingsphere.datasource.ds_slave_1.jdbc-url=jdbc:mysql://localhost:3306/demo_ds_slave_1
+spring.shardingsphere.datasource.ds_slave_1.username=root
+spring.shardingsphere.datasource.ds_slave_1.password=
+
+spring.shardingsphere.masterslave.load-balance-algorithm-type=round_robin
+spring.shardingsphere.masterslave.name=ds_ms
+spring.shardingsphere.masterslave.master-data-source-name=ds_master
+spring.shardingsphere.masterslave.slave-data-source-names=ds_slave_0,ds_slave_1
+
+spring.shardingsphere.orchestration.name=demo_spring_boot_ds_ms
+spring.shardingsphere.orchestration.overwrite=true
+spring.shardingsphere.orchestration.registry.type=nacos
+spring.shardingsphere.orchestration.registry.server-lists=localhost:8848
+spring.shardingsphere.orchestration.registry.namespace=
diff --git a/sharding-jdbc-example/orchestration-example/orchestration-spring-boot-example/src/main/resources/application.properties b/sharding-jdbc-example/orchestration-example/orchestration-spring-boot-example/src/main/resources/application.properties
index 3cc2dd6..8a58078 100755
--- a/sharding-jdbc-example/orchestration-example/orchestration-spring-boot-example/src/main/resources/application.properties
+++ b/sharding-jdbc-example/orchestration-example/orchestration-spring-boot-example/src/main/resources/application.properties
@@ -12,4 +12,10 @@
#spring.profiles.active=cloud-zookeeper-encrypt
#spring.profiles.active=local-nacos-sharding-databases-tables
-#spring.profiles.active=cloud-nacos-sharding-databases-tables
\ No newline at end of file
+#spring.profiles.active=local-nacos-master-slave
+
+#spring.profiles.active=cloud-nacos-sharding-databases-tables
+#spring.profiles.active=cloud-nacos-master-slave
+
+#spring.profiles.active=local-nacos-encrypt
+#spring.profiles.active=cloud-nacos-encrypt
diff --git a/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/nacos/cloud/application-encrypt.xml b/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/nacos/cloud/application-encrypt.xml
new file mode 100644
index 0000000..c17bfbe
--- /dev/null
+++ b/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/nacos/cloud/application-encrypt.xml
@@ -0,0 +1,51 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ ~ Copyright 2016-2018 shardingsphere.io.
+ ~ <p>
+ ~ Licensed under the Apache License, Version 2.0 (the "License");
+ ~ you may not use this file except in compliance with the License.
+ ~ You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ ~ </p>
+ -->
+
+<beans xmlns="http://www.springframework.org/schema/beans"
+ xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xmlns:context="http://www.springframework.org/schema/context"
+ xmlns:tx="http://www.springframework.org/schema/tx"
+ xmlns:orchestraion="http://shardingsphere.apache.org/schema/shardingsphere/orchestration"
+ xsi:schemaLocation="http://www.springframework.org/schema/beans
+ http://www.springframework.org/schema/beans/spring-beans.xsd
+ http://www.springframework.org/schema/context
+ http://www.springframework.org/schema/context/spring-context.xsd
+ http://www.springframework.org/schema/tx
+ http://www.springframework.org/schema/tx/spring-tx.xsd
+ http://shardingsphere.apache.org/schema/shardingsphere/orchestration
+ http://shardingsphere.apache.org/schema/shardingsphere/orchestration/orchestration.xsd">
+ <import resource="classpath*:META-INF/nacos/registry-center.xml" />
+ <context:component-scan base-package="org.apache.shardingsphere.example.core.mybatis" />
+
+ <orchestraion:encrypt-data-source id="encryptDataSource" registry-center-ref="regCenter" />
+
+ <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
+ <property name="dataSource" ref="encryptDataSource" />
+ </bean>
+ <tx:annotation-driven />
+
+ <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
+ <property name="dataSource" ref="encryptDataSource"/>
+ <property name="mapperLocations" value="classpath*:META-INF/mappers/*.xml"/>
+ </bean>
+
+ <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
+ <property name="basePackage" value="org.apache.shardingsphere.example.core.mybatis.repository"/>
+ <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
+ </bean>
+</beans>
diff --git a/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/nacos/cloud/application-master-slave.xml b/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/nacos/cloud/application-master-slave.xml
new file mode 100644
index 0000000..7b3f5a7
--- /dev/null
+++ b/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/nacos/cloud/application-master-slave.xml
@@ -0,0 +1,34 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<beans xmlns="http://www.springframework.org/schema/beans"
+ xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xmlns:context="http://www.springframework.org/schema/context"
+ xmlns:tx="http://www.springframework.org/schema/tx"
+ xmlns:orchestration="http://shardingsphere.apache.org/schema/shardingsphere/orchestration"
+ xsi:schemaLocation="http://www.springframework.org/schema/beans
+ http://www.springframework.org/schema/beans/spring-beans.xsd
+ http://www.springframework.org/schema/context
+ http://www.springframework.org/schema/context/spring-context.xsd
+ http://www.springframework.org/schema/tx
+ http://www.springframework.org/schema/tx/spring-tx.xsd
+ http://shardingsphere.apache.org/schema/shardingsphere/orchestration
+ http://shardingsphere.apache.org/schema/shardingsphere/orchestration/orchestration.xsd">
+ <import resource="classpath*:META-INF/nacos/registry-center.xml" />
+ <context:component-scan base-package="org.apache.shardingsphere.example.core.mybatis" />
+
+ <orchestration:master-slave-data-source id="masterSlaveDataSource" registry-center-ref="regCenter" />
+
+ <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
+ <property name="dataSource" ref="masterSlaveDataSource" />
+ </bean>
+ <tx:annotation-driven />
+
+ <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
+ <property name="dataSource" ref="masterSlaveDataSource"/>
+ <property name="mapperLocations" value="classpath*:META-INF/mappers/*.xml"/>
+ </bean>
+
+ <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
+ <property name="basePackage" value="org.apache.shardingsphere.example.core.mybatis.repository"/>
+ <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
+ </bean>
+</beans>
diff --git a/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/nacos/local/application-encrypt.xml b/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/nacos/local/application-encrypt.xml
new file mode 100644
index 0000000..af69777
--- /dev/null
+++ b/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/nacos/local/application-encrypt.xml
@@ -0,0 +1,86 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ ~ Copyright 2016-2018 shardingsphere.io.
+ ~ <p>
+ ~ Licensed under the Apache License, Version 2.0 (the "License");
+ ~ you may not use this file except in compliance with the License.
+ ~ You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ ~ </p>
+ -->
+
+<beans xmlns="http://www.springframework.org/schema/beans"
+ xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xmlns:context="http://www.springframework.org/schema/context"
+ xmlns:tx="http://www.springframework.org/schema/tx"
+ xmlns:bean="http://www.springframework.org/schema/util"
+ xmlns:encrypt="http://shardingsphere.apache.org/schema/shardingsphere/encrypt"
+ xmlns:orchestraion="http://shardingsphere.apache.org/schema/shardingsphere/orchestration"
+ xsi:schemaLocation="http://www.springframework.org/schema/beans
+ http://www.springframework.org/schema/beans/spring-beans.xsd
+ http://www.springframework.org/schema/context
+ http://www.springframework.org/schema/context/spring-context.xsd
+ http://www.springframework.org/schema/tx
+ http://www.springframework.org/schema/tx/spring-tx.xsd
+ http://www.springframework.org/schema/util
+ http://www.springframework.org/schema/util/spring-util.xsd
+ http://shardingsphere.apache.org/schema/shardingsphere/encrypt
+ http://shardingsphere.apache.org/schema/shardingsphere/encrypt/encrypt.xsd
+ http://shardingsphere.apache.org/schema/shardingsphere/orchestration
+ http://shardingsphere.apache.org/schema/shardingsphere/orchestration/orchestration.xsd">
+ <import resource="classpath*:META-INF/nacos/registry-center.xml" />
+ <context:component-scan base-package="org.apache.shardingsphere.example.core.mybatis" />
+
+ <bean id="demo_ds_encrypt" class="com.zaxxer.hikari.HikariDataSource" destroy-method="close">
+ <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
+ <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/demo_ds"/>
+ <property name="username" value="root"/>
+ <property name="password" value=""/>
+ </bean>
+
+ <bean:properties id="props">
+ <prop key="aes.key.value">123456</prop>
+ </bean:properties>
+
+ <encrypt:data-source id="realEncryptDataSource" data-source-name="demo_ds_encrypt" >
+ <encrypt:encrypt-rule>
+ <encrypt:tables>
+ <encrypt:table name="t_user">
+ <encrypt:column logic-column="user_name" cipher-column="user_name" encryptor-ref="name_encryptor" />
+ <encrypt:column logic-column="pwd" cipher-column="pwd" assisted-query-column="assisted_query_pwd" encryptor-ref="pwd_encryptor"/>
+ </encrypt:table>
+ </encrypt:tables>
+ <encrypt:encryptors>
+ <encrypt:encryptor id="name_encryptor" type="AES" props-ref="props"/>
+ <encrypt:encryptor id="pwd_encryptor" type="assistedTest" />
+ </encrypt:encryptors>
+ </encrypt:encrypt-rule>
+ <encrypt:props>
+ <prop key="query.with.cipher.column">true</prop>
+ </encrypt:props>
+ </encrypt:data-source>
+
+ <orchestraion:encrypt-data-source id="encryptDataSource" data-source-ref="realEncryptDataSource" registry-center-ref="regCenter" overwrite="true" />
+
+ <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
+ <property name="dataSource" ref="encryptDataSource" />
+ </bean>
+ <tx:annotation-driven />
+
+ <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
+ <property name="dataSource" ref="encryptDataSource"/>
+ <property name="mapperLocations" value="classpath*:META-INF/mappers/*.xml"/>
+ </bean>
+
+ <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
+ <property name="basePackage" value="org.apache.shardingsphere.example.core.mybatis.repository"/>
+ <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
+ </bean>
+</beans>
diff --git a/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/nacos/local/application-master-slave.xml b/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/nacos/local/application-master-slave.xml
new file mode 100644
index 0000000..b4f327d
--- /dev/null
+++ b/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/nacos/local/application-master-slave.xml
@@ -0,0 +1,60 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<beans xmlns="http://www.springframework.org/schema/beans"
+ xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xmlns:context="http://www.springframework.org/schema/context"
+ xmlns:tx="http://www.springframework.org/schema/tx"
+ xmlns:master-slave="http://shardingsphere.apache.org/schema/shardingsphere/masterslave"
+ xmlns:orchestraion="http://shardingsphere.apache.org/schema/shardingsphere/orchestration"
+ xsi:schemaLocation="http://www.springframework.org/schema/beans
+ http://www.springframework.org/schema/beans/spring-beans.xsd
+ http://www.springframework.org/schema/context
+ http://www.springframework.org/schema/context/spring-context.xsd
+ http://www.springframework.org/schema/tx
+ http://www.springframework.org/schema/tx/spring-tx.xsd
+ http://shardingsphere.apache.org/schema/shardingsphere/masterslave
+ http://shardingsphere.apache.org/schema/shardingsphere/masterslave/master-slave.xsd
+ http://shardingsphere.apache.org/schema/shardingsphere/orchestration
+ http://shardingsphere.apache.org/schema/shardingsphere/orchestration/orchestration.xsd">
+ <import resource="classpath*:META-INF/nacos/registry-center.xml" />
+ <context:component-scan base-package="org.apache.shardingsphere.example.core.mybatis" />
+
+ <bean id="demo_ds_master" class="com.zaxxer.hikari.HikariDataSource" destroy-method="close">
+ <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
+ <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/demo_ds_master"/>
+ <property name="username" value="root"/>
+ <property name="password" value=""/>
+ </bean>
+
+ <bean id="demo_ds_slave_0" class="com.zaxxer.hikari.HikariDataSource" destroy-method="close">
+ <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
+ <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/demo_ds_slave_0"/>
+ <property name="username" value="root"/>
+ <property name="password" value=""/>
+ </bean>
+
+ <bean id="demo_ds_slave_1" class="com.zaxxer.hikari.HikariDataSource" destroy-method="close">
+ <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
+ <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/demo_ds_slave_1"/>
+ <property name="username" value="root"/>
+ <property name="password" value=""/>
+ </bean>
+
+ <master-slave:load-balance-algorithm id="randomStrategy" type="RANDOM" />
+ <master-slave:data-source id="realMasterSlaveDataSource" master-data-source-name="demo_ds_master" slave-data-source-names="demo_ds_slave_0, demo_ds_slave_1" strategy-ref="randomStrategy" />
+ <orchestraion:master-slave-data-source id="masterSlaveDataSource" data-source-ref="realMasterSlaveDataSource" registry-center-ref="regCenter" overwrite="true" />
+
+ <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
+ <property name="dataSource" ref="masterSlaveDataSource" />
+ </bean>
+ <tx:annotation-driven />
+
+ <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
+ <property name="dataSource" ref="masterSlaveDataSource"/>
+ <property name="mapperLocations" value="classpath*:META-INF/mappers/*.xml"/>
+ </bean>
+
+ <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
+ <property name="basePackage" value="org.apache.shardingsphere.example.core.mybatis.repository"/>
+ <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
+ </bean>
+</beans>
diff --git a/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/nacos/local/application-sharding-databases-tables.xml b/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/nacos/local/application-sharding-databases-tables.xml
index 81d679a..a607a2e 100644
--- a/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/nacos/local/application-sharding-databases-tables.xml
+++ b/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/nacos/local/application-sharding-databases-tables.xml
@@ -22,14 +22,14 @@
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="jdbcUrl" value="jdbc:mysql://localhost:3306/demo_ds_0?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=UTC"/>
<property name="username" value="root"/>
- <property name="password" value="123456"/>
+ <property name="password" value=""/>
</bean>
<bean id="demo_ds_1" class="com.zaxxer.hikari.HikariDataSource" destroy-method="close">
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="jdbcUrl" value="jdbc:mysql://localhost:3306/demo_ds_1?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=UTC"/>
<property name="username" value="root"/>
- <property name="password" value="123456"/>
+ <property name="password" value=""/>
</bean>
<sharding:inline-strategy id="databaseStrategy" sharding-column="user_id" algorithm-expression="demo_ds_${user_id % 2}" />
diff --git a/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/zookeeper/cloud/application-encrypt.xml b/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/zookeeper/cloud/application-encrypt.xml
index 97de002..7f34c67 100755
--- a/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/zookeeper/cloud/application-encrypt.xml
+++ b/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/zookeeper/cloud/application-encrypt.xml
@@ -48,5 +48,4 @@
<property name="basePackage" value="org.apache.shardingsphere.example.core.mybatis.repository"/>
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
</bean>
-
</beans>
diff --git a/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/zookeeper/local/application-encrypt.xml b/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/zookeeper/local/application-encrypt.xml
index 6fd3d29..bd53cca 100755
--- a/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/zookeeper/local/application-encrypt.xml
+++ b/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/zookeeper/local/application-encrypt.xml
@@ -83,5 +83,4 @@
<property name="basePackage" value="org.apache.shardingsphere.example.core.mybatis.repository"/>
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
</bean>
-
</beans>
diff --git a/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/zookeeper/local/application-master-slave.xml b/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/zookeeper/local/application-master-slave.xml
index d42564f..e12d40a 100755
--- a/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/zookeeper/local/application-master-slave.xml
+++ b/sharding-jdbc-example/orchestration-example/orchestration-spring-namespace-example/src/main/resources/META-INF/zookeeper/local/application-master-slave.xml
@@ -57,5 +57,4 @@
<property name="basePackage" value="org.apache.shardingsphere.example.core.mybatis.repository"/>
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
</bean>
-
</beans>
