{"id":1959,"date":"2023-04-01T10:24:27","date_gmt":"2023-04-01T02:24:27","guid":{"rendered":"https:\/\/www.appblog.cn\/?p=1959"},"modified":"2023-04-22T08:38:05","modified_gmt":"2023-04-22T00:38:05","slug":"sharding-sphere-sharding-jdbc-sub-database-and-sub-table-based-on-mybatis","status":"publish","type":"post","link":"https:\/\/www.appblog.cn\/index.php\/2023\/04\/01\/sharding-sphere-sharding-jdbc-sub-database-and-sub-table-based-on-mybatis\/","title":{"rendered":"Sharding-Sphere\uff1aSharding-JDBC\u5206\u5e93\u5206\u8868\uff08\u57fa\u4e8eMyBatis\uff09"},"content":{"rendered":"

\u5206\u4eab\u4e86 Sharding-JDBC \u642d\u5efa\u8bfb\u5199\u5206\u79bb\uff0c\u672c\u7ae0\u5c06\u7528 Sharding-JDBC \u5b9e\u73b0\u5206\u5e93\u5206\u8868\u529f\u80fd<\/p>\n

\u4e3a\u4ec0\u4e48\u8981\u5206\u5e93\u5206\u8868\uff1f<\/h2>\n

\u4e3e\u4e2a\u6817\u5b50\uff1a\u5f53\u5355\u8868\u6570\u636e\u91cf\u8d85\u8fc71000\u4e07\u540e\uff0c\u67e5\u8be2\u7684\u901f\u5ea6\u5c06\u4f1a\u6162\u4e0b\u6765\uff0c\u5229\u7528\u7d22\u5f15\uff0c\u8bfb\u5199\u5206\u79bb\u7b49\u4f18\u5316\uff0c\u5982\u679c\u5f53\u6570\u636e\u91cf\u8d85\u8fc75000\u4e07\u65f6\uff0c\u4e00\u4e9b\u5e38\u89c1\u7684\u4f18\u5316\u65b9\u6cd5\u5c06\u5931\u53bb\u4f5c\u7528\uff0c\u6b64\u65f6\u628a\u5355\u8868\u6c34\u5e73\u5212\u5206\u5230\u591a\u5e93\u591a\u8868\u4e2d\uff0c\u63d0\u5347\u67e5\u8be2\u901f\u5ea6\uff0c\u800csharding-jdbc\u53ef\u4ee5\u5e2e\u52a9\u5b8c\u6210\u6c34\u5e73\u62c6\u5206\uff0c\u800c\u6211\u4eec\u53ea\u9700\u6dfb\u52a0\u4e00\u4e9b\u914d\u7f6e\u5373\u53ef<\/p>\n

<\/p>\n

\u5b98\u65b9\u6587\u6863<\/h2>\n

GitHub\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

\u4ee3\u7801\u5b9e\u73b0\uff08MyBatis\uff09<\/h2>\n

\uff081\uff09\u67093\u5f20\u8868t_member<\/code>\u3001t_order<\/code>\u3001t_order_item<\/code>\uff0c\u62c6\u5206\u52302\u4e2a\u6570\u636e\u5e93\u4e2d\uff0c\u6bcf\u4e2a\u6570\u636e\u5e932\u4efd\uff0c\u76f8\u5f53\u4e8e\u6bcf\u5f20\u8868\u62c6\u6210\u4e864\u5f20\uff0c\u9700\u8981\u6ce8\u610f\u7684\u662f\u6bcf\u4e2a\u8868\u7684\u4e3b\u952eId\u5c3d\u91cf\u8bbe\u7f6e\u6210 bigint \uff08\u6211\u5f00\u59cb\u8bbe\u7f6e\u4e3avarchar\uff0c\u7ed3\u679c\u5206\u8868\u65f6\u62a5\u9519\uff09\uff0c\u7ed3\u6784\u5982\u4e0b\uff1a<\/p>\n

\"\u5206\u5e93\u5206\u8868\u8bbe\u8ba1\"<\/p>\n

-- ----------------------------\n-- Table structure for t_member0\n-- ----------------------------\nDROP TABLE IF EXISTS `t_member0`;\nCREATE TABLE `t_member0` (\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_member1\n-- ----------------------------\nDROP TABLE IF EXISTS `t_member1`;\nCREATE TABLE `t_member1` (\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_order0\n-- ----------------------------\nDROP TABLE IF EXISTS `t_order0`;\nCREATE TABLE `t_order0` (\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_order1\n-- ----------------------------\nDROP TABLE IF EXISTS `t_order1`;\nCREATE TABLE `t_order1` (\n  `order_id` bigint(20) NOT NULL,\n  `member_id` varchar(36) DEFAULT NULL,\n  `order_code` varchar(36) DEFAULT NULL,\n  `order_amount` double 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_item0\n-- ----------------------------\nDROP TABLE IF EXISTS `t_order_item0`;\nCREATE TABLE `t_order_item0` (\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';\n\n-- ----------------------------\n-- Table structure for t_order_item1\n-- ----------------------------\nDROP TABLE IF EXISTS `t_order_item1`;\nCREATE TABLE `t_order_item1` (\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\u5f15\u5165\u4f9d\u8d56\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    <version>4.0.0-RC1<\/version>\n<\/dependency>\n<dependency>\n    <groupId>org.mybatis.spring.boot<\/groupId>\n    <artifactId>mybatis-spring-boot-starter<\/artifactId>\n    <version>2.0.0<\/version>\n<\/dependency>\n<dependency>\n    <groupId>mysql<\/groupId>\n    <artifactId>mysql-connector-java<\/artifactId>\n    <version>5.1.47<\/version>\n<\/dependency>\n<!-- https:\/\/mvnrepository.com\/artifact\/com.alibaba\/druid -->\n<dependency>\n    <groupId>com.alibaba<\/groupId>\n    <artifactId>druid<\/artifactId>\n    <version>1.1.16<\/version>\n<\/dependency>\n<dependency>\n    <groupId>com.alibaba<\/groupId>\n    <artifactId>fastjson<\/artifactId>\n    <version>1.2.47<\/version>\n<\/dependency>\n<dependency>\n    <groupId>org.projectlombok<\/groupId>\n    <artifactId>lombok<\/artifactId>\n    <optional>true<\/optional>\n<\/dependency><\/code><\/pre>\n
\uff083\uff09\u5f15\u5165 mybatis generator \u81ea\u52a8\u751f\u6210\u4ee3\u7801\u63d2\u4ef6\uff0c\u751f\u6210\u5b9e\u4f53\u7c7b\u4e0emybatis xml\u6587\u4ef6<\/p>\n
<plugin>\n    <groupId>org.mybatis.generator<\/groupId>\n    <artifactId>mybatis-generator-maven-plugin<\/artifactId>\n    <version>1.3.6<\/version>\n    <configuration>\n        <configurationFile>${basedir}\/src\/main\/resources\/generatorConfig.xml<\/configurationFile>\n        <overwrite>true<\/overwrite>\n        <verbose>true<\/verbose>\n    <\/configuration>\n<\/plugin><\/code><\/pre>\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: \u662f, 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.sublibrarytable.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.sublibrarytable.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    <\/context>\n<\/generatorConfiguration><\/code><\/pre>\n
\uff084\uff09\u6dfb\u52a0\u914d\u7f6e\u6587\u4ef6\uff0c\u8fd9\u70b9\u5f88\u91cd\u8981\uff0c\u5426\u5219\u65e0\u6cd5\u5b9e\u73b0\u5206\u5e93\u5206\u8868\uff0cds$->{0..1}.t_member$->{0..1}<\/code>\uff0c\u8868\u8fbe\u5f0f\u76f8\u5f53\u4e8e\uff1ads0.t_member0<\/code>\u3001ds0.t_member1<\/code>\u3001ds1.t_member0<\/code>\u3001ds1.t_member1<\/code>\uff0c\u5728\u914d\u7f6e\u4e2d\u914d\u7f6e\u4e86key-generator.column<\/code>\uff0c\u6240\u4ee5\u65b0\u589e\u8be5\u8868\u6570\u636e\u65f6\uff0c\u4e0d\u9700\u8981\u7ed9\u4e3b\u952eid\u8d4b\u503c\uff0csharding-jdbc\u4f1a\u8c03\u7528\u5185\u7f6e\u7684SNOWFLAKE\u7b97\u6cd5\u751f\u6210\u5206\u5e03\u5f0fid\uff0c\u8bf7\u5f80\u4e0b\u770b<\/p>\n
server.port=8071\n\n# mybatis \u914d\u7f6e\nmybatis.mapper-locations=classpath:mapping\/*.xml\nmybatis.type-aliases-package=com.zypcy.sharding.sublibrarytable.entity\n\nspring.shardingsphere.datasource.names=ds0,ds1\n\nspring.shardingsphere.datasource.ds0.type=com.alibaba.druid.pool.DruidDataSource\nspring.shardingsphere.datasource.ds0.driver-class-name=com.mysql.jdbc.Driver\nspring.shardingsphere.datasource.ds0.url=jdbc:mysql:\/\/localhost:3306\/ds0?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false&maxReconnects=15000&allowMultiQueries=true&useSSL=false\nspring.shardingsphere.datasource.ds0.username=root\nspring.shardingsphere.datasource.ds0.password=123456\n\nspring.shardingsphere.datasource.ds1.type=com.alibaba.druid.pool.DruidDataSource\nspring.shardingsphere.datasource.ds1.driver-class-name=com.mysql.jdbc.Driver\nspring.shardingsphere.datasource.ds1.url=jdbc:mysql:\/\/localhost:3306\/ds1?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false&maxReconnects=15000&allowMultiQueries=true&useSSL=false\nspring.shardingsphere.datasource.ds1.username=root\nspring.shardingsphere.datasource.ds1.password=123456\n\n# \u5206\u5e93\u914d\u7f6e\uff0c\u6839\u636emember_id\u5206\u5e93\nspring.shardingsphere.sharding.default-database-strategy.inline.sharding-column=member_id\nspring.shardingsphere.sharding.default-database-strategy.inline.algorithm-expression=ds$->{member_id % 2}\n\n# \u5206\u8868\u914d\u7f6e\uff0c\u6839\u636emember_id\u5206\u8868\nspring.shardingsphere.sharding.tables.t_member.actual-data-nodes=ds$->{0..1}.t_member$->{0..1}\nspring.shardingsphere.sharding.tables.t_member.table-strategy.inline.sharding-column=member_id\nspring.shardingsphere.sharding.tables.t_member.table-strategy.inline.algorithm-expression=t_member$->{member_id % 2}\nspring.shardingsphere.sharding.tables.t_member.key-generator.column=member_id\nspring.shardingsphere.sharding.tables.t_member.key-generator.type=SNOWFLAKE\n\n# \u5206\u8868\u914d\u7f6e\uff0c\u6839\u636eorder_id\u5206\u8868\nspring.shardingsphere.sharding.tables.t_order.actual-data-nodes=ds$->{0..1}.t_order$->{0..1}\nspring.shardingsphere.sharding.tables.t_order.table-strategy.inline.sharding-column=order_id\nspring.shardingsphere.sharding.tables.t_order.table-strategy.inline.algorithm-expression=t_order$->{order_id % 2}\nspring.shardingsphere.sharding.tables.t_order.key-generator.column=order_id\nspring.shardingsphere.sharding.tables.t_order.key-generator.type=SNOWFLAKE\n\n# \u5206\u8868\u914d\u7f6e\uff0c\u6839\u636eorder_id\u5206\u8868\nspring.shardingsphere.sharding.tables.t_order_item.actual-data-nodes=ds$->{0..1}.t_order_item$->{0..1}\nspring.shardingsphere.sharding.tables.t_order_item.table-strategy.inline.sharding-column=order_id\nspring.shardingsphere.sharding.tables.t_order_item.table-strategy.inline.algorithm-expression=t_order_item$->{order_id % 2}\nspring.shardingsphere.sharding.tables.t_order_item.key-generator.column=order_item_id\nspring.shardingsphere.sharding.tables.t_order_item.key-generator.type=SNOWFLAKE\n\n#spring.shardingsphere.sharding.binding-tables=t_member,t_order,t_order_item\n#spring.shardingsphere.sharding.broadcast-tables=t_config\n\nspring.shardingsphere.props.sql.show=true<\/code><\/pre>\n
\uff085\uff09Durid\u914d\u7f6e<\/p>\n
@Configuration\npublic class DuridConfig {\n\n    @Bean\n    public Filter statFilter() {\n        StatFilter filter = new StatFilter();\n        filter.setSlowSqlMillis(5000);\n        filter.setLogSlowSql(true);\n        filter.setMergeSql(true);\n        return filter;\n    }\n\n    @Bean\n    public ServletRegistrationBean statViewServlet() {\n        \/\/\u521b\u5efaservlet\u6ce8\u518c\u5b9e\u4f53\n        ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(), "\/druid\/*");\n        \/\/\u8bbe\u7f6eip\u767d\u540d\u5355\n        servletRegistrationBean.addInitParameter("allow", "127.0.0.1");\n        \/\/\u8bbe\u7f6eip\u9ed1\u540d\u5355\uff0c\u5982\u679callow\u4e0edeny\u5171\u540c\u5b58\u5728\u65f6,deny\u4f18\u5148\u4e8eallow\n        \/\/servletRegistrationBean.addInitParameter("deny","192.168.0.19");\n        \/\/\u8bbe\u7f6e\u63a7\u5236\u53f0\u7ba1\u7406\u7528\u6237\n        servletRegistrationBean.addInitParameter("loginUsername", "admin");\n        servletRegistrationBean.addInitParameter("loginPassword", "123456");\n        \/\/\u662f\u5426\u53ef\u4ee5\u91cd\u7f6e\u6570\u636e\n        servletRegistrationBean.addInitParameter("resetEnable", "false");\n        return servletRegistrationBean;\n    }\n}<\/code><\/pre>\n
\uff086\uff09\u6dfb\u52a0MemberService\u670d\u52a1\u63a5\u53e3\u4e0e\u5b9e\u73b0<\/p>\n
public interface IMemberService {\n\n    int insert(Member record);\n\n    Member selectByPrimaryKey(Long memberId);\n\n    int deleteByPrimaryKey(Long memberId);\n}\n\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.insertSelective(record);\n    }\n\n    @Override\n    public Member selectByPrimaryKey(Long memberId) {\n        return memberMapper.selectByPrimaryKey(memberId);\n    }\n\n    @Override\n    public int deleteByPrimaryKey(Long memberId) {\n        return memberMapper.deleteByPrimaryKey(memberId);\n    }\n}\n\n@Mapper\npublic interface MemberMapper {\n    int deleteByPrimaryKey(Long memberId);\n\n    int insert(Member record);\n\n    int insertSelective(Member record);\n\n    Member selectByPrimaryKey(Long memberId);\n\n    int updateByPrimaryKeySelective(Member record);\n\n    int updateByPrimaryKey(Member record);\n}<\/code><\/pre>\n
\uff087\uff09\u6dfb\u52a0MemberController<\/p>\n
@RequestMapping("\/member")\n@RestController\npublic class MemberController {\n\n    @Autowired\n    private IMemberService memberService;\n\n    @RequestMapping("\/add")\n    public Member add(){\n        Member member = new Member();\n        \/\/member.setMemberId(IdWorker.getLongId()); \u4e0d\u7528\u624b\u52a8\u8bbe\u7f6e\u4e3b\u952eid\uff0c\u65b0\u589e\u65f6\uff0csharding-jdbc\u4f1a\u81ea\u52a8\u8d4b\u503c\uff0c\u56e0\u4e3a\u5728\u914d\u7f6e\u6587\u4ef6\u4e2d\u914d\u7f6e\u4e86\u8be5\u5217\u4f7f\u7528SNOWFLAKE\u7b97\u6cd5\u751f\u6210\u503c\n        member.setMemberName("\u5f20\u4e09");\n        member.setNickName("\u95ea\u8000\u7684\u77ac\u95f4");\n        member.setAccountNo(member.getMemberId()+"");\n        member.setPassword("123465");\n        member.setAge(27);\n        member.setBirthDate(new Date());\n        member.setEblFlag("1");\n        member.setDelFlag("0");\n        member.setDescription("xxx");\n        member.setCreateTime(new Date());\n        member.setUpdateTime(new Date());\n        memberService.insert(member);\n        return member;\n    }\n\n    @RequestMapping("\/findById")\n    public Member findById(Long memberId){\n        return memberService.selectByPrimaryKey(memberId);\n    }\n\n    @RequestMapping("\/delete")\n    public String delete(Long memberId){\n        memberService.deleteByPrimaryKey(memberId);\n        return "success";\n    }\n}<\/code><\/pre>\n
\uff088\uff09\u542f\u52a8\u9879\u76ee\uff0c\u8bbf\u95ee\u65b0\u589e\u63a5\u53e3 http:\/\/localhost:8071\/member\/add<\/a> \uff0c\u53ef\u4ee5\u770b\u5230\u9875\u9762\u8fd4\u56de\u4e86\u65b0\u589e\u540e\u7684\u6570\u636e<\/p>\n
\u540c\u65f6\u67e5\u770bIntellij IDEA\u63a7\u5236\u53f0\uff0c\u53ef\u4ee5\u770b\u5230\u6570\u636e\u63d2\u5165\u5230ds1<\/code>\u5e93\u7684t_member1<\/code>\u8868\u4e86<\/p>\n
\u518d\u67e5\u770bds1<\/code>\u6570\u636e\u5e93\u7684t_member1<\/code>\u8868\uff0c\u6709\u521a\u521a\u65b0\u589e\u7684\u8bb0\u5f55<\/p>\n
\uff089\uff09\u8bbf\u95ee\u67e5\u8be2\u63a5\u53e3 http:\/\/localhost:8071\/member\/findById?memberId=xxxxxx<\/a><\/p>\n
\u540c\u65f6\u67e5\u770b\u63a7\u5236\u53f0\uff0csql\u4f1a\u81ea\u52a8\u8def\u7531\u5230ds1<\/code>\u5e93\u53bb\u67e5\u8be2\u6570\u636e<\/p>\n
\u53c2\u8003\uff1ahttps:\/\/gitee.com\/zhuyu1991\/spring-cloud\/tree\/master\/sharding-business\/sub-library-table<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
\u5206\u4eab\u4e86 Sharding-JDBC \u642d\u5efa\u8bfb\u5199\u5206\u79bb\uff0c\u672c\u7ae0\u5c06\u7528 Sharding-JDBC \u5b9e\u73b0\u5206\u5e93\u5206\u8868\u529f\u80fd \u4e3a\u4ec0 […]<\/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":[111,436,492,299],"class_list":["post-1959","post","type-post","status-publish","format-standard","hentry","category-sharding-sphere","tag-mybatis","tag-sharding-jdbc","tag-sharding-sphere","tag-299"],"_links":{"self":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts\/1959","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=1959"}],"version-history":[{"count":0,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts\/1959\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/media?parent=1959"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/categories?post=1959"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/tags?post=1959"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}