{"id":1958,"date":"2023-04-01T10:22:51","date_gmt":"2023-04-01T02:22:51","guid":{"rendered":"https:\/\/www.appblog.cn\/?p=1958"},"modified":"2023-04-22T08:38:18","modified_gmt":"2023-04-22T00:38:18","slug":"sharding-sphere-sharding-jdbc-read-write-separation-docker-builds-mysql-master-slave","status":"publish","type":"post","link":"https:\/\/www.appblog.cn\/index.php\/2023\/04\/01\/sharding-sphere-sharding-jdbc-read-write-separation-docker-builds-mysql-master-slave\/","title":{"rendered":"Sharding-Sphere\uff1aSharding-JDBC\u8bfb\u5199\u5206\u79bb\uff0cDocker\u642d\u5efaMySQL\u4e3b\u4ece"},"content":{"rendered":"

\u8bfb\u5199\u5206\u79bb\u53ef\u4ee5\u63d0\u9ad8\u7cfb\u7edf\u541e\u5410\u91cf\uff0c\u5728\u7f51\u4e0a\u770b\u4e86\u5f88\u591aSpringBoot\u5b9e\u73b0\u8bfb\u5199\u5206\u79bb\u7684\u6587\u7ae0\uff0c\u5927\u90e8\u5206\u662f\u57fa\u4e8eSpring AOP \u786c\u7f16\u7801Java\u4ee3\u7801\u53bb\u5b9e\u73b0\u7684\uff0c\u4ee3\u7801\u4fb5\u5165\u6027\u8f83\u5927\uff0c\u539f\u7406\u662f\uff1a\u5982\u679c\u8c03\u7528select\u3001get\u5f00\u5934\u7684\u65b9\u6cd5\uff0c\u5c31\u8c03\u7528\u4ece\u5e93\uff0c\u5426\u5219\u8c03\u7528\u4e3b\u5e93\uff0c\u672c\u7bc7\u5c06\u57fa\u4e8e\u5f53\u5f53\u5f00\u6e90\u7684sharding-jdbc<\/code>\u5b9e\u73b0\u8bfb\u5199\u5206\u79bb\uff0c\u770b\u540d\u5b57\u5c31\u77e5\u9053\u5b83\u662f\u5728jdbc\u4e0a\uff0c\u4ee3\u7801\u96f6\u5165\u4fb5\uff0c\u914d\u7f6e\u6587\u4ef6\u914d\u7f6e\u4e3b\u4ece\u5e93\u5730\u5740\u3002<\/p>\n

\u672c\u7bc7\u535a\u5ba2\u5c06\u5206\u6210\u4e24\u5927\u5757\uff1a1.Docker\u73af\u5883\u642d\u5efaMySQL\u8bfb\u5199\u5206\u79bb\uff0c2.SpringBoot\u57fa\u4e8eSharding-JDBC\u5e94\u7528\u8bfb\u5199\u5206\u79bb<\/p>\n

<\/p>\n

Docker\u73af\u5883\u642d\u5efaMysql\u8bfb\u5199\u5206\u79bb<\/h2>\n

\u642d\u5efaDocker\u73af\u5883\u4e0bMySQL\u7684\u8bfb\u5199\u5206\u79bb\u65f6\uff0c\u9047\u5230\u4e00\u4e2a\u5751\uff0c\u6700\u65b0\u7684MySQL\u955c\u50cf\u662f8.0\u7248\u672c\u7684\uff0c\u65e0\u6cd5\u6210\u529f\u642d\u5efa\uff0c\u540e\u9762\u7528\u76845.7.26\u5c31\u597d\u4e86<\/p>\n

\u955c\u50cf\u5730\u5740\uff1ahttps:\/\/hub.docker.com\/_\/mysql<\/a><\/p>\n

docker pull mysql:5.7.26<\/code><\/pre>\n
\u4e0b\u9762\u7b80\u8ff0Docker\u914d\u7f6eMySQL\u4e3b\u4ece\u8fc7\u7a0b<\/p>\n
\uff081\uff09\u5728\u672c\u673a\u4e0a\u521b\u5efa2\u4e2a.cnf<\/code>\u7684\u914d\u7f6e\u6587\u4ef6\uff0c2\u4e2a\u6570\u636e\u5b58\u653e\u76ee\u5f55\uff0c\u7528\u6765\u4fdd\u5b58MySQL\u6570\u636e<\/p>\n
master_data\/\nmaster.cnf\nslave_data\/\nslave.cnf<\/code><\/pre>\n
\uff082\uff09mysql.cnf<\/code>\u914d\u7f6e\u6587\u4ef6\u5185\u5bb9\u5982\u4e0b\uff0c\u53ea\u6709server-id<\/code>\u4e0d\u80fd\u4e00\u6837<\/p>\n
[mysqld]\npid-file   = \/var\/run\/mysqld\/mysqld.pid\nsocket     = \/var\/run\/mysqld\/mysqld.sock\ndatadir    = \/var\/lib\/mysql\nsymbolic-links=0\ncharacter-set-server = utf8   \n#skip-networking  \ninnodb_print_all_deadlocks = 1\nmax_connections = 2000  \nmax_connect_errors = 6000  \nopen_files_limit = 65535  \ntable_open_cache = 128    \nbinlog_cache_size = 1M  \nmax_heap_table_size = 8M  \nquery_cache_type = 1  \nquery_cache_size = 8M  \nquery_cache_limit = 2M  \nft_min_word_len = 4  \n\n#\u4ece\u5e93\u9700\u8981\u4fee\u6539\u7aef\u53e3\u540e\u518d\u7528docker\u542f\u52a8\nport=3306\n#\u4ece\u5e93\u7684server-id\u4e0d\u80fd\u548c\u4e3b\u5e93\u4e00\u81f4\nserver-id = 1\nlog-bin = master-bin.log\nsync_binlog=1\n#binlog_format = mixed  \nbinlog_format = row\n\nperformance_schema = 0  \nexplicit_defaults_for_timestamp  \n#lower_case_table_names = 1  \ninteractive_timeout = 2880000\nwait_timeout = 2880000 \n# Recommended in standard MySQL setup  \nsql_mode=NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER,STRICT_TRANS_TABLES   \n[mysqldump]  \nquick  \nmax_allowed_packet = 64M  \n[myisamchk]\ntmp_table_size = 16M  \njoin_buffer_size = 128M  \nkey_buffer_size = 8M\nsort_buffer_size = 8M\nread_buffer = 4M\nwrite_buffer = 4M\n#MySQL\u8bfb\u5165\u7f13\u51b2\u533a\u7684\u5927\u5c0f\nread_buffer_size = 16M\n#MySQL\u7684\u968f\u673a\u8bfb\u7f13\u51b2\u533a\u5927\u5c0f\nread_rnd_buffer_size = 8M\n\n#\u7ebf\u7a0b\u7f13\u5b58\u5927\u5c0f\nthread_cache_size=16\nthread_concurrency=32<\/code><\/pre>\n
\uff083\uff09Docker\u8fd0\u884c2\u4e2amysql\u955c\u50cf\uff0c\u4f7f\u7528\u4e0b\u9762\u7684\u547d\u4ee4\uff0c\u6539\u4e00\u4e0b\u4e3b\u4ece\u5e93\u7684\u914d\u7f6e\u6587\u4ef6\u5730\u5740\u4e0e\u6570\u636e\u5b58\u653e\u76ee\u5f55\uff0c\u5e76\u8bbe\u7f6eroot\u7684\u767b\u9646\u5bc6\u7801123456\uff0c\u4ece\u5e93\u4fee\u6539\u914d\u7f6e\u6587\u4ef6\u4e2d\u7684port=3307\uff0c\u5bf9\u5e94docker\u542f\u52a8\u547d\u4ee4-p 3307:3307<\/code><\/p>\n
docker run -itd --name mysql_master -v \/data\/www\/database\/mysql\/master.cnf:\/etc\/mysql\/mysql.conf.d\/mysqld.cnf -v \/data\/www\/database\/mysql\/master_data:\/var\/lib\/mysql -e MYSQL_ROOT_PASSWORD=123456 -p 3306:3306 mysql:5.7.26<\/code><\/pre>\n
\uff084\uff09\u627e\u5230\u4e3b\u5e93\u5bb9\u5668ID\uff0c\u8fdb\u5165\u4e3b\u5e93\u5bb9\u5668\u63a7\u5236\u53f0docker exec -it container id \/bin\/bash<\/code><\/p>\n
\uff085\uff09\u8fdb\u5165mysql\u547d\u4ee4\u884c\uff0cmysql -uroot -p123456<\/code>\uff0c\u8f93\u5165\u5982\u4e0b\u547d\u4ee4\uff1a<\/p>\n
\u521b\u5efa\u4e00\u4e2a\u7528\u6237\uff0c\u8ba9\u4ece\u5e93\u901a\u8fc7\u8be5\u7528\u6237\u8fdb\u884c\u590d\u5236\u65e5\u5fd7\n\u521b\u5efa\u4e00\u4e2a\u7528\u6237\uff1acreate user 'yezhou'@'%' identified by '123456';\n\u7528\u6237\u8d4b\u4e88\u6743\u9650\uff1agrant all privileges on *.* to 'yezhou'@'%' with grant option;\n\u8d4b\u4e88\u590d\u5236\u6743\u9650\uff1agrant replication slave on *.* to 'yezhou'@'%' with grant option;\n\u4f7f\u521a\u521a\u7684\u547d\u4ee4\u751f\u6548\uff1aflush privileges;\n\u67e5\u770b\u4e3b\u5e93\u65e5\u5fd7\u6587\u4ef6\uff1ashow master status;  \/\/\u8bb0\u4f4fFile\u4e0ePosition\u7684\u503c\uff0c\u4ece\u5e93\u8981\u7528<\/code><\/pre>\n
\uff086\uff09\u8fdb\u5165\u4ece\u5e93\u5bb9\u5668mysql\u547d\u4ee4\u884c\uff0c\u548c\u4e0a\u9762\u4e00\u6837\u7684\u547d\u4ee4\uff0c\u8fde\u63a5\u4e3b\u5e93<\/p>\n
\u8fde\u63a5\u4e3b\u5e93\uff1achange master to master_host='192.168.0.115',master_user='root',master_password='123456',master_port=3306,master_log_file='master-bin.000004',master_log_pos=1118;  \/\/\u4e3b\u5e93\u8bb0\u5f55\u7684Position\u503c\n\u5f00\u542f\u4ece\u5e93\uff1astart slave;\n\u67e5\u770b\u4ece\u5e93\u72b6\u6001\uff1ashow slave status\\G\n\u5982\u679c\u8fde\u63a5\u914d\u7f6e\u9519\u8bef\u8981\u91cd\u65b0\u66f4\u6539\uff0c\u53ef\u4ee5\u4f7f\u7528 stop slave; reset slave;<\/code><\/pre>\n
\u770b\u5230\u5982\u4e0b\u4e24\u4e2a Yes\uff0c\u5219\u8bf4\u660e\u4e3b\u4ece\u5e93\u642d\u5efa\u6210\u529f<\/p>\n
Slave_IO_Running: Yes\nSlave_SQL_Running: Yes<\/code><\/pre>\n
\uff087\uff09\u4f7f\u7528 mysql \u5ba2\u6237\u7aef\u8fde\u63a5\u4e3b\u5e93\uff0c\u521b\u5efa\u4e00\u4e2a\u6570\u636e\u5e93\u548c\u8868\uff0c\u518d\u8fde\u63a5\u4ece\u5e93\u67e5\u770b\u8be5\u6570\u636e\u5e93\u662f\u5426\u6210\u529f\u540c\u6b65\u8fc7\u6765<\/p>\n
SpringBoot\u57fa\u4e8eSharding-JDBC\u5e94\u7528\u8bfb\u5199\u5206\u79bb<\/h2>\n
Sharding-JDBC\u662f\u5f53\u5f53\u5f00\u6e90\u7684\u5206\u5e93\u5206\u8868\uff0c\u8bfb\u5199\u5206\u79bb\u7684\u5229\u5668\uff0c\u57fa\u4e8eJDBC\uff0c\u5df2\u7ecf\u8fdb\u5165apache\u5b75\u5316\u5668\u9879\u76ee
\nGitHub\u7684\u5730\u5740\uff1ahttps:\/\/github.com\/apache\/incubator-shardingsphere<\/a>
\nshardingsphere\uff1ahttps:\/\/github.com\/apache\/incubator-shardingsphere-example<\/a>
\n\u4e2d\u6587\u6587\u6863\u5730\u5740\uff1ahttps:\/\/shardingsphere.apache.org\/document\/current\/cn\/overview\/<\/a><\/p>\n
\u5148\u770b\u770bSharding-JDBC\u7684\u67b6\u6784\u56fe\uff0c\u53ef\u4ee5\u6709\u4e2a\u76f4\u89c2\u7684\u4e86\u89e3<\/p>\n
\"Sharding-JDBC\u67b6\u6784\u56fe\"<\/p>\n
\uff081\uff09\u4f7f\u7528HikariCP\u4e0emybatis\u8fdb\u884c\u8bfb\u5199\u5206\u79bb\u7684\u9a8c\u8bc1\uff0c\u521b\u5efa\u4e863\u4e2a\u8868<\/p>\n
-- ----------------------------\n-- Table structure for t_member\n-- ----------------------------\nDROP TABLE IF EXISTS `t_member`;\nCREATE TABLE `t_member` (\n  `member_id` bigint(20) NOT NULL,\n  `member_name` varchar(36) DEFAULT NULL,\n  `nick_name` varchar(36) DEFAULT NULL,\n  `account_no` varchar(20) DEFAULT NULL,\n  `password` varchar(20) DEFAULT NULL,\n  `age` int(11) DEFAULT NULL,\n  `birth_date` datetime DEFAULT NULL,\n  `ebl_flag` varchar(1) DEFAULT '1',\n  `del_flag` varchar(1) DEFAULT '0',\n  `description` varchar(255) DEFAULT NULL,\n  `create_time` datetime DEFAULT NULL,\n  `update_time` datetime DEFAULT NULL,\n  PRIMARY KEY (`member_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='\u4f1a\u5458\u8868';\n\n-- ----------------------------\n-- Table structure for t_order\n-- ----------------------------\nDROP TABLE IF EXISTS `t_order`;\nCREATE TABLE `t_order` (\n  `order_id` bigint(20) NOT NULL,\n  `member_id` varchar(36) DEFAULT NULL,\n  `order_code` varchar(36) DEFAULT NULL,\n  `order_amount` varchar(20) DEFAULT NULL,\n  `status` varchar(1) DEFAULT '1',\n  `create_time` datetime DEFAULT NULL,\n  PRIMARY KEY (`order_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='\u8ba2\u5355\u8868';\n\n-- ----------------------------\n-- Table structure for t_order_item\n-- ----------------------------\nDROP TABLE IF EXISTS `t_order_item`;\nCREATE TABLE `t_order_item` (\n  `item_id` bigint(20) NOT NULL,\n  `order_id` varchar(36) DEFAULT NULL,\n  `product_name` varchar(128) DEFAULT NULL,\n  `item_account` double DEFAULT NULL,\n  `create_time` datetime DEFAULT NULL,\n  PRIMARY KEY (`item_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='\u8ba2\u5355\u8be6\u60c5\u8868';<\/code><\/pre>\n
\uff082\uff09\u65b0\u5efaSpringBoot\u9879\u76ee\uff0c\u6dfb\u52a0\u5f15\u7528\uff1a<\/p>\n
<dependency>\n    <groupId>org.springframework.boot<\/groupId>\n    <artifactId>spring-boot-starter-web<\/artifactId>\n<\/dependency>\n<dependency>\n    <groupId>org.apache.shardingsphere<\/groupId>\n    <artifactId>sharding-jdbc-spring-boot-starter<\/artifactId>\n<\/dependency>\n<dependency>\n    <groupId>org.apache.shardingsphere<\/groupId>\n    <artifactId>sharding-jdbc-spring-namespace<\/artifactId>\n<\/dependency>\n<dependency>\n    <groupId>org.mybatis.spring.boot<\/groupId>\n    <artifactId>mybatis-spring-boot-starter<\/artifactId>\n<\/dependency>\n<dependency>\n    <groupId>mysql<\/groupId>\n    <artifactId>mysql-connector-java<\/artifactId>\n<\/dependency>\n<dependency>\n    <groupId>com.zaxxer<\/groupId>\n    <artifactId>HikariCP<\/artifactId>\n<\/dependency><\/code><\/pre>\n
\uff083\uff09\u914d\u7f6e\u6587\u4ef6\uff0c\u8bf7\u4e0d\u8981\u7528ds_master<\/code>\uff0cds_slave<\/code>\u7b49\uff0c\u6709\u4e0b\u5212\u7ebf\u4f1a\u62a5\u9519<\/p>\n
server.port=8070\n\n# jdbc_config   datasource\n#spring.datasource.driver-class-name=com.mysql.jdbc.Driver\n#spring.datasource.url=jdbc:mysql:\/\/192.168.0.115:3306\/appblog_business1?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false&maxReconnects=15000&allowMultiQueries=true&useSSL=false\n#spring.datasource.username=root\n#spring.datasource.password=123456\n\n# Hikari will use the above plus the following to setup connection pooling\n#spring.datasource.type=com.zaxxer.hikari.HikariDataSource\n#spring.datasource.hikari.minimum-idle=10\n#spring.datasource.hikari.maximum-pool-size=25\n#spring.datasource.hikari.auto-commit=true\n#spring.datasource.hikari.idle-timeout=30000\n#spring.datasource.hikari.pool-name=HikariCP\n#spring.datasource.hikari.max-lifetime=1800000\n#spring.datasource.hikari.connection-timeout=30000\n#spring.datasource.hikari.connection-test-query=SELECT 1\n\nspring.shardingsphere.datasource.names=master,slave0\n\n# \u4e3b\u5e93\nspring.shardingsphere.datasource.master.type=com.zaxxer.hikari.HikariDataSource\nspring.shardingsphere.datasource.master.driver-class-name=com.mysql.jdbc.Driver\nspring.shardingsphere.datasource.master.jdbc-url=jdbc:mysql:\/\/192.168.0.115:3306\/appblog_business1?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false&maxReconnects=15000&allowMultiQueries=true&useSSL=false\nspring.shardingsphere.datasource.master.username=root\nspring.shardingsphere.datasource.master.password=123456\n\n# \u4ece\u5e93\nspring.shardingsphere.datasource.slave0.type=com.zaxxer.hikari.HikariDataSource\nspring.shardingsphere.datasource.slave0.driver-class-name=com.mysql.jdbc.Driver\nspring.shardingsphere.datasource.slave0.jdbc-url=jdbc:mysql:\/\/192.168.0.115:3307\/appblog_business1?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false&maxReconnects=15000&allowMultiQueries=true&useSSL=false\nspring.shardingsphere.datasource.slave0.username=root\nspring.shardingsphere.datasource.slave0.password=123456\n\nspring.shardingsphere.masterslave.name=ms\nspring.shardingsphere.masterslave.master-data-source-name=master\nspring.shardingsphere.masterslave.slave-data-source-names=slave0\n\nspring.shardingsphere.props.sql.show=true\n\n# mybatis \u914d\u7f6e\nmybatis.mapper-locations=classpath:mapping\/*.xml\nmybatis.type-aliases-package=cn.appblog.sharding.business.entity<\/code><\/pre>\n
\uff084\uff09MyBatis\u914d\u7f6e\u6587\u4ef6<\/p>\n
<?xml version="1.0" encoding="UTF-8"?>\n<!DOCTYPE generatorConfiguration\n        PUBLIC "-\/\/mybatis.org\/\/DTD MyBatis Generator Configuration 1.0\/\/EN"\n        "http:\/\/mybatis.org\/dtd\/mybatis-generator-config_1_0.dtd">\n<generatorConfiguration>\n    <!-- \u6570\u636e\u5e93\u9a71\u52a8:\u9009\u62e9\u4f60\u7684\u672c\u5730\u786c\u76d8\u4e0a\u9762\u7684\u6570\u636e\u5e93\u9a71\u52a8\u5305-->\n    <classPathEntry  location="D:\\software\\database\\mybatis-generator-core-1.3.2\\lib\\mysql-connector-java-5.1.25-bin.jar"\/>\n    <context id="DB2Tables"  targetRuntime="MyBatis3" defaultModelType="flat">\n        <commentGenerator>\n            <property name="suppressDate" value="true"\/>\n            <!-- \u662f\u5426\u53bb\u9664\u81ea\u52a8\u751f\u6210\u7684\u6ce8\u91ca true\uff1a\u662f \uff1a false:\u5426 -->\n            <property name="suppressAllComments" value="true"\/>\n        <\/commentGenerator>\n        <!--\u6570\u636e\u5e93\u94fe\u63a5URL\uff0c\u7528\u6237\u540d\u3001\u5bc6\u7801 -->\n        <jdbcConnection driverClass="com.mysql.jdbc.Driver" userId="xnxx" password="Xnxx85781245!" connectionURL="jdbc:mysql:\/\/47.107.177.150:3306\/zy_sharding_business1?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8&maxReconnects=15000&allowMultiQueries=true">\n        <\/jdbcConnection>\n        <javaTypeResolver>\n            <property name="forceBigDecimals" value="false"\/>\n        <\/javaTypeResolver>\n        <!-- \u751f\u6210\u6a21\u578b\u7684\u5305\u540d\u548c\u4f4d\u7f6e-->\n        <javaModelGenerator targetPackage="com.zypcy.sharding.business.entity" targetProject="src\/main\/java">\n            <property name="enableSubPackages" value="true"\/>\n            <property name="trimStrings" value="true"\/>\n        <\/javaModelGenerator>\n        <!-- \u751f\u6210\u6620\u5c04\u6587\u4ef6\u7684\u5305\u540d\u548c\u4f4d\u7f6e-->\n        <sqlMapGenerator targetPackage="mapping" targetProject="src\/main\/resources">\n            <property name="enableSubPackages" value="true"\/>\n        <\/sqlMapGenerator>\n        <!-- \u751f\u6210DAO\u7684\u5305\u540d\u548c\u4f4d\u7f6e-->\n        <javaClientGenerator type="XMLMAPPER" targetPackage="com.zypcy.sharding.business.repository" targetProject="src\/main\/java">\n            <property name="enableSubPackages" value="true"\/>\n        <\/javaClientGenerator>\n        <!-- \u8981\u751f\u6210\u7684\u8868 tableName\u662f\u6570\u636e\u5e93\u4e2d\u7684\u8868\u540d\u6216\u89c6\u56fe\u540d domainObjectName\u662f\u5b9e\u4f53\u7c7b\u540d-->\n        <!-- \u6ce8\u610f\uff1a\u5df2\u751f\u6210\u7684\u4e0d\u8981\u518d\u751f\u6210\uff0c\u4e0d\u7136\u4f1a\u8986\u76d6\u5df2\u751f\u6210\u7684\u6587\u4ef6 -->\n        <!--\n        <table tableName="t_member" domainObjectName="Member" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"><\/table>\n        <table tableName="t_order" domainObjectName="Order" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"><\/table>\n        <table tableName="t_order_item" domainObjectName="OrderItem" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"><\/table>\n        -->\n\n    <\/context>\n<\/generatorConfiguration><\/code><\/pre>\n
\uff085\uff09\u6dfb\u52a0\u63a7\u5236\u5668\u3001\u670d\u52a1\u3001mapper\u63a5\u53e3\u7b49<\/p>\n
@Service\npublic class MemberServiceImpl implements IMemberService {\n\n    @Autowired private MemberMapper memberMapper;\n\n    @Override\n    public int insert(Member record) {\n        return memberMapper.insert(record);\n    }\n\n    @Override\n    public Member selectByPrimaryKey(String memberId) {\n        return memberMapper.selectByPrimaryKey(memberId);\n    }\n\n    @Override\n    public int deleteByPrimaryKey(String memberId) {\n        return memberMapper.deleteByPrimaryKey(memberId);\n    }\n}<\/code><\/pre>\n
@RequestMapping("\/member")\n@RestController\npublic class MemberController {\n\n    @Autowired private IMemberService memberService;\n\n    @RequestMapping("\/add")\n    public String add() {\n        addMember();\n        return "success";\n    }\n\n    @RequestMapping("\/getMemberById")\n    public Member getMemberById(String memberId) {\n        return memberService.selectByPrimaryKey(memberId);\n    }\n\n    @RequestMapping("\/delete")\n    public String delete(String memberId) {\n        memberService.deleteByPrimaryKey(memberId);\n        return "success";\n    }\n\n    private void addMember() {\n        Member member = new Member();\n        member.setMemberId("201904280001");\n        member.setMemberName("\u5f20\u4e09");\n        member.setNickName("\u95ea\u8000\u7684\u77ac\u95f4");\n        member.setAccountNo("zhangsan");\n        member.setPassword("123465");\n        member.setAge(27);\n        member.setBirthDate(new Date());\n        member.setEblFlag("1");\n        member.setDelFlag("0");\n        member.setDescription("\u5c4c\u4e1d\u4e00\u4e2a");\n        member.setCreateTime(new Date());\n        member.setUpdateTime(new Date());\n        memberService.insert(member);\n    }\n}<\/code><\/pre>\n
\uff086\uff09\u8fd0\u884c\u9879\u76ee\uff0c\u8bbf\u95eelocalhost:8070\/member\/add<\/code>\u63a5\u53e3\uff0c\u6dfb\u52a0\u4e00\u6761\u6570\u636e\uff0c\u67e5\u770b\u6570\u636e\u5e93\uff0c\u53ef\u4ee5\u770b\u5230\u4e3b\u4ece\u5e93\u90fd\u5df2\u7ecf\u6dfb\u52a0\u4e86\u6570\u636e<\/p>\n
\uff087\uff09\u4fee\u6539\u4ece\u5e93\u7684\u6570\u636e\uff0c\u628amember_name<\/code>\u5b57\u6bb5\u503c\u624b\u52a8\u6539\u4e3aJoe.Ye<\/code>\uff0c\u7136\u540e\u8bbf\u95eelocalhost:8070\/member\/getMemberById?memberId=201908270001<\/code>\uff0c\u53ef\u4ee5\u770b\u5230\u67e5\u8be2\u63a5\u53e3\u8fd4\u56de\u7684\u662f\u4ece\u5e93\u4fee\u6539\u540e\u7684\u503c<\/p>\n
\u5230\u6b64\uff0c\u8bfb\u5199\u5206\u79bb\u7684\u642d\u5efa\u4e0e\u5e94\u7528\u5df2\u7ecf\u5b8c\u6210<\/p>\n","protected":false},"excerpt":{"rendered":"
\u8bfb\u5199\u5206\u79bb\u53ef\u4ee5\u63d0\u9ad8\u7cfb\u7edf\u541e\u5410\u91cf\uff0c\u5728\u7f51\u4e0a\u770b\u4e86\u5f88\u591aSpringBoot\u5b9e\u73b0\u8bfb\u5199\u5206\u79bb\u7684\u6587\u7ae0\uff0c\u5927\u90e8\u5206\u662f\u57fa\u4e8eSpring A […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[491],"tags":[436,492],"class_list":["post-1958","post","type-post","status-publish","format-standard","hentry","category-sharding-sphere","tag-sharding-jdbc","tag-sharding-sphere"],"_links":{"self":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts\/1958","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/comments?post=1958"}],"version-history":[{"count":0,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts\/1958\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/media?parent=1958"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/categories?post=1958"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/tags?post=1958"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}