Spring boot + mybatis + Druid + log42 to print sql logs

My version of SpringBoot is: 2.1.10.RELEASE First, add jar package in pom file, and add jar package of log42, druid and mysql <!--log4j2--> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter- ...

Posted on Tue, 25 Feb 2020 03:45:02 -0500 by blesseld

MySQL must know and be able to read notes

Chapter 14 using subqueries Subquery For example: query all customer information of TNT2 //1: Retrieve the number of all orders containing item TNT2 SELECT order_num FROM orderitems WHERE prod_id = 'TNT2'; //2 retrieve the IDs of all customers with the order numbers listed in the previous step SELE ...

Posted on Mon, 24 Feb 2020 08:33:46 -0500 by sanfly

Spring cloud learning record 4. Fusing mechanism

Article directory 1. Preface 2.Hystrix integrates Ribbon 3.Hystrix integrates OpenFeign 1. Preface After learning from the Ribbon and OpenFeign of the previous blog, we officially started to learn the fusing mechanism. Currently, the commonly used inter service invocation component is Hystrix. H ...

Posted on Mon, 24 Feb 2020 06:25:51 -0500 by srsimmons

Implement a simple user rights management (RBAC) using Python+Flask+Bootstrap (Part3)

Code structure and description I listed all the files in the first chapter, and I'll cover them in this chapter. root directory db_design.txt This is the sql script that initializes the database. There is a user.sqlite under the tool_portal directory, and this file is generated by this initializati ...

Posted on Sun, 23 Feb 2020 21:49:31 -0500 by mynameisbob

Oracle complex query

Preparation: start two services of Oracle - database instance service and monitoring service     1, Basic table - department table and employee table 1. sector table drop table dep; create table dep( d_id varchar2(11) primary key not null, d_name varchar2(50) not null, d_remark varchar2(20 ...

Posted on Sun, 23 Feb 2020 03:34:58 -0500 by dennissanche

WHERE clause - filter data

Chapter 6 filtering data Article directory Chapter 6 filtering data 1. Use WHERE clause 2. WHERE clause operator 2.1 check single value 2.2. Mismatch check 2.3 range value inspection 2.4. Null value check 3, summary Simple record - MySQL must know must know - [English] Ben Forta Learn how to u ...

Posted on Sun, 23 Feb 2020 02:38:23 -0500 by fahhem

Getting started with Delta Lake with Jupiter Notebook

The example of this article comes from Delta Lake Official course . Because the official tutorial is based on the commercial software Databricks Community Edition. Although the software features used in the tutorial are all possessed by the open-source Delta Lake version, considering the domestic network environment, the threshold for register ...

Posted on Sun, 23 Feb 2020 00:35:26 -0500 by GroundZeroStudios

CTFHub Boolean blind note

CTFHub Boolean blind note The topic has been shown to be Boolean blind. It is found that it is not closed, but also filtered. It is also a basic problem, but it is found that the echo is not right: payload:?id=1 and 's'='p'Echo is query < success This problem is different from the common Boolean bl ...

Posted on Sat, 22 Feb 2020 22:57:42 -0500 by Toxinhead

MyBatis MyBatis Plug-in Principle

MyBatis Plugin Principle MyBatis is very developer-friendly and provides plug-in mechanisms that allow us to enhance MyBatis's functionality to suit our needs.At the bottom is the use of agent mode + responsibility chain mode MyBatis Official https://mybatis.org/mybatis-3/zh/configuration.html#plug ...

Posted on Sat, 22 Feb 2020 21:54:30 -0500 by bloo

14, Learning Scrapy of distributed Crawlers

Scrapy framework Learning objectives Understand the skeleton. Learn how to write spider crawlers. Learn how to write Crawlspider. Learn how to write middleware. Learn pipeline to save data. Learn to use Scrapy with selenium. Learn to use IP proxy in scratch.Introduction to the Scrapy frameworkInstall ...

Posted on Sat, 22 Feb 2020 11:06:49 -0500 by Ludichrist