今天自己整了一下springboot+druid+mybatisplus+sharding-jdbc读写分离,遇到的一些坑及解决办法
1、导入pom.xml依赖server: port: 6080spring: # environment: dev application: name: rw # 服务名称 shardingsphere: props: sql: show: true # 开启显示sql sharding: default-data-source-name: master masterslave: name: ms master-data-source-name: master slave-data-source-names: slave load-balance-algorithm-type: round_robin datasource: # 数据源名称,名称自定义,需要与后面配置的一一对应,可以多个,以英文逗号分割 names: master,slave master: # 采用 druid 数据库连接池 type: com.alibaba.druid.pool.DruidDataSource driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://192.168.1.1:3306/itcast?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowPublicKeyRetrieval=true username: root password: admin1234 initialSize: 5 # 初始化连接池数量 minIdle: 5 # 最小空闲连接池 minPoolSize: 5 # 最小连接数量 maxPoolSize: 20 # 最大连数量 maxWait: 60000 slave: type: com.alibaba.druid.pool.DruidDataSource driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://192.168.1.2:3306/itcast?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowPublicKeyRetrieval=true username: root password: admin1234 initialSize: 5 minIdle: 5 minPoolSize: 5 maxPoolSize: 20 maxWait: 60000 main: allow-bean-definition-overriding: truesharding: jdbc: config: masterslave: load-balance-algorithm-type: randommybatis-plus: datasource: dataSource type-aliases-package: com.itcast.entity configuration: #在映射实体或者属性时,将数据库中表名和字段名中的下划线去掉,按照驼峰命名法映射 实体类属性名:idNumber -> 数据库字段名:id_number map-underscore-to-camel-case: true log-impl: org.apache.ibatis.logging.stdout.StdOutImpl global-config: db-config: id-type: AUTO table-prefix: tb_
3、创建实体类、controller、mapper、service@Datapublic class User implements Serializable { private static final long serialVersionUID = 1L; private Long id; private String name; private Integer age; private String address;}#-------------@RestController@RequestMapping("/user")public class UserController { @Autowired private UserService userService; @PostMapping("/add") public String add(@RequestBody User user){ userService.save(user); return "0"; } @GetMapping("/list") public List
新增
参考文档:https://www.jianshu.com/p/ed7bc1e49b61
点击排行
- 2 0
- 3 0
- 4 0
-
5
Android中WebView使用LoadUrl不刷新网页的问题,网址带#只能通过reload刷新
0 - 6 0
-
7
Hive报错ERRORtool.ImportTool:Importfailed:java.io.IOException:HiveCliDriverexitedwithstatus=1
0 - 8 0
- 9 0
- 10 0
- 11 0