鸣 BY Blog

Thinking will not overcome fear but action will.

git指令

git常用指令

将项目发布至git命令 git init git add . git commit -m 'first' git remote add origin https://github.com/fikyair/SSM.git (ps:新建的仓库地址) 拉取代码 git pull --rebase origin master git push origin master 4、等待上传就好了。 5、...

Posted by dm on August 14, 2020

MySQL问题

设置值自动递增排序

update equipment_market_goods_profile SET sort_no = NULL; # 设置值自动递增排序 set @num=0; update equipment_market_goods_catagory SET sort_no = (@num := @num + 1) ;

Posted by dm on March 25, 2020

UML6种关系

UML6种关系

泛化:(Generalization): 表示继承关系, 表示类/接口对父类/接口的功能扩展. java语法中的extends, 用来扩展父类或父接口的功能. 图形表示: 带三角箭头的实线, 箭头指向父类或父接口 ...

Posted by dm on March 19, 2020

springboot数据源配置

单数据源、多数据源区别

1.单数据源配置 配置信息datasource:url:XXX server: port: 8808 servlet: context-path: / spring: application: name: xcbdepot datasource: url: jdbc:mysql://xx.xxx.xxx:3306/xxx?a...

Posted by dm on March 19, 2020

MySQL问题

update 字段自动累加

修改时字段自动累加 set @num=0; update equipment_market_goods_catagory SET sort_no = (@num := @num + 1);

Posted by dm on March 11, 2020

MySQL问题

统计相同ID数据

统计相同ID数据 select id, user_id from user_profile group by user_id having count(user_id) >1;

Posted by dm on February 20, 2020

MySQL问题

根据拼音首字母排序

SQL语句根据拼音首字母排序 SELECT ship_num FROM xcb_ship_ll_newest ORDER BY CONVERT( ship_num USING gbk ) COLLATE gbk_chinese_ci ASC;

Posted by dm on February 20, 2020

MySQL问题

锁表解决方法

MySql事务- Lock wait timeout exceeded; try restarting transaction问题解决 1.查看数据库当前的进程 show processlist; 2.查看当前的事务 #当前运行的所有事务 SELECT * FROM information_schema.INNODB_TRX; #当前出现的锁 SELECT * FROM inform...

Posted by dm on January 3, 2020

MySQL问题

AB表数据转移

将A表信息同步至B表中，字段对应，B表为空，插入操作 insert into xcb_ship_info(id,user_id,ship_num,cargo_capacity,ais_number,mmsi_number,contact_person,contact_phone,shipsur_pic,ship_license_pic,port_license_pic,coas_licens...

Posted by dm on December 30, 2019

List操作

将List中的实体类按照某个字段进行分组并存放至Map中

/** * @author dongm * @Description： 将List中的实体类按照某个字段进行分组并存放至Map中 * @date：2019/12/24 * @param: [goodsTransitList] */ public Map<String, List<BackGoodsTransitDto>> getCatagory(List&l...

Posted by dm on December 24, 2019

FEATURED TAGS
MySQL JAVA git Jenkins Docker Elasticsearch SpringData Nexus Linux VMware
ABOUT ME

Goals determine what you going to be!

✉️ dongming0103@gmail.com

FRIENDS