weixin_37460672的博客

1.项目中接收客户时间入库varchar类型当时只发现 excel格式 2022/5/20 13:30:24 只简单将‘/’替换为‘-’，入库后造成数据格式不正确查询不到数据 按yyyy-MM-dd HH:mm:ss条件筛选2.入库时时间格式判断并补‘0’ if (bjsj.length() < 19) { String[] timeArray = bjsj.split(" "); String[] localDate = ti

1创建表时先分好区，否则数据量大分区卡SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for mon_dev_real-- ----------------------------DROP TABLE IF EXISTS `mon_dev_real`;CREATE TABLE `mon_dev_real` ( `data_id` bigint(20) NOT NULL AUTO_INCRE

1.数据源#其它配置spring: #MySQL数据库 datasource: main: jdbc-url: jdbc:mysql:///zcfx_main?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&serverTimezone=GMT%2B8 username: root password: trkj.2020 slave1: