leo leo493852107

人的生命只有一次

16 followers · 49 following

View GitHub Profile

Recently created

Least recently created

Recently updated

Least recently updated

leo493852107 / application.yml

Created March 10, 2025 07:12

seata配置参考

	server:
	port: 7099

	spring:
	application:
	name: seata-server

	logging:
	config: classpath:logback-spring.xml
	file:

leo493852107 / GlobalExceptionHandler.java

Created January 16, 2025 08:23

springboot全局异常处理

	package com.lgd985.tx.advice;

	import com.lgd985.tx.common.R;
	import com.lgd985.tx.exception.BizException;
	import org.springframework.validation.BindingResult;
	import org.springframework.validation.FieldError;
	import org.springframework.web.bind.MethodArgumentNotValidException;
	import org.springframework.web.bind.annotation.ExceptionHandler;
	import org.springframework.web.bind.annotation.RestControllerAdvice;

leo493852107 / BizException.java

Created January 16, 2025 05:49

springboot异常处理

	package com.lgd985.tx.exception;

	import lombok.Data;

	/**
	* @author 李建舜
	* @version 1.0
	* @date 2025/1/16 13:38
	* @description
	*/

leo493852107 / BizExceptionEnum.java

Created January 16, 2025 05:46

springboot异常处理枚举

	package com.lgd985.tx.exception;


	import lombok.Getter;

	/**
	* @author 李建舜
	* @version 1.0
	* @date 2025/1/16 13:39
	* @description

leo493852107 / R.java

Created January 16, 2025 05:45

Springboot统一返回R

	package com.lgd985.tx.common;

	import lombok.Data;

	/**
	* @author 李建舜
	* @version 1.0
	* @date 2025/1/16 13:24
	* @description
	*/

leo493852107 / ego.sql

Created March 19, 2023 08:58

Vue2-Vue后台管理系统项目实战 Ego.sql

	-- phpMyAdmin SQL Dump
	-- version 4.5.1
	-- http://www.phpmyadmin.net
	--
	-- Host: 127.0.0.1
	-- Generation Time: 2022-12-08 14:00:24
	-- 服务器版本： 10.1.19-MariaDB
	-- B站 https://www.bilibili.com/video/BV1j5411o7xH/
	-- PHP Version: 5.6.28

leo493852107 / user_role_menu.sql

Created October 29, 2022 00:21

用户，角色，菜单表 for java

	# Host: localhost (Version 5.7.19-log)
	# Date: 2022-06-13 10:04:40
	# Generator: MySQL-Front 6.1 (Build 1.26)

	CREATE DATABASE `guigu-auth` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
	use `guigu-auth`;

	#
	# Structure for table "sys_dept"
	#

leo493852107 / east_stock.py

Created March 11, 2021 00:59

east_stock 股票盈利计算，默认佣金按万2.5算

	#!/usr/bin/env python
	# -- coding: utf-8 --
	# 股票盈利计算，默认佣金按万2.5算

	print ('================== 默认佣金为万2.5 ==================')

	# 佣金比率万2.5
	commission = 0.00025

	buy_count = raw_input('请输入购买的数量:')

leo493852107 / mysql_export_select.sql

Last active January 13, 2020 08:48

mysql导出SQL导出客户的计划单item(planorder_item)

	mysql -h127.0.0.1 -uroot -p --default-character-set=utf8 -e "SELECT customer_customer.short_name, sale_planorderitem.* FROM sale_planorder INNER JOIN customer_customer ON sale_planorder.customer_id=customer_customer.id INNER JOIN sale_planorderitem ON sale_planorderitem.order_id=sale_planorder.id
	WHERE customer_customer.short_name='客户名称' AND sale_planorder.add_time>='2019-08-01 00:00:00' AND sale_planorder.add_time<='2019-10-01 00:00:00' ORDER BY sale_planorder.add_time;" hey_star_crm > /Users/leo/Downloads/test.xls

leo493852107 / update_planorder_item_total_price.sql

Created October 7, 2019 03:38

3表间查询后更新价格数据

	UPDATE sale_planorderitem a
	INNER JOIN
	(SELECT b.id FROM sale_planorder b, customer_customer c WHERE c.short_name='客户名称' AND b.customer_id=c.id AND b.add_time>='2019-08-01 00:00:00' AND b.add_time<='2019-10-01 00:00:00') as t
	ON a.order_id=t.id SET a.total_price=a.unit_price*a.quantity

NewerOlder