2021.9.9 didi Data Analysis Intern written test
1, Written examination form
It may be because of the recruitment of interns, so the written test is not very formal. An hr Intern directly sent me the questions in the form of PDF after adding me to wechat. He asked to write the answers in word and send them to her in 1 hour to 1.5 hours (without giving me any excel). The PDF did not explain ...
Added by rtconner on Sun, 12 Sep 2021 05:22:52 +0300
After using MybatisPlus, I haven't written sql for a long time
(1) Preface
When you first wrote JDBC, you needed to manually configure connection information by writing SQL statements one by one. Then Mybatis appeared, no more manual configuration of connection information was needed, and the SQL statements were isolated from the code, but Sql was unavoidable. Then Mybatis Plus appeared, which did not eve ...
Added by $kevan on Thu, 09 Sep 2021 00:57:02 +0300
Usage of MyBatis dynamic SQL tag
1.MyBatis dynamic SQL
One of the powerful features of MyBatis is its dynamic SQL, that is, splicing SQL strings. If you have experience using JDBC or other similar frameworks, you can realize how painful it is to splice SQL statements according to different conditions. When splicing, make sure you don't forget the necessary spaces, and pay att ...
Added by Koobi on Tue, 07 Sep 2021 04:40:29 +0300
[dry goods, what happened to the senior Java Engineer dismissed by Tencent
END;;
– generate 100w random data – it is expected to take half an hour or more. In fact, 1w messages can also be generated. The main reason is that more data can better reflect the importance of the index call create_test_data(100*10000);
# Explain
Explain Is to identify a SQL Whether to take the easiest way to index, we can ...
Added by sujithtomy on Tue, 07 Sep 2021 04:21:14 +0300
MySQL Database - Advanced [Advanced] SQL Statements - SQL Advanced Statements, Functions
1. SQL Advanced Statements
1, SELECT
Displays all data for one or more columns in a table
Syntax: SELECT "field" FROM "table name"; Example:
select * from infol;
select name from infol;
2,DISTINCT
Do not show duplicate content
Syntax: SELECT DISTINCT "field" FROM "table name"; Example:
s ...
Added by markster on Mon, 06 Sep 2021 19:23:45 +0300
SQL Execution of Mybatis Core Working Principles
SQL Execution of Mybatis Core Working Principles
Learn the structure, working principle and main modules of Mybatis from a macro perspective, and learn the working principle and design idea of Mybatis from a micro perspective.
1. SQL Execution
Let's look at the execution of Mybatis's SQL statement.
List<User> list = mapper.selectUserL ...
Added by feyd on Sun, 05 Sep 2021 23:40:38 +0300
Xiaodi penetration & WEB vulnerability (iii-i)
Video resources
SQL injection (11-18)
11. Vulnerability introduction
11.1 PHP method of traversing all files and subfolders under a folder
<?php
function my_dir($dir) {
$files = [];
if(@$handle = opendir($dir)) {
while(($file = readdir($handle)) !== false) {
if($file != ".." && $file != ".") {
if(is_dir($dir . " ...
Added by ciaran on Sat, 04 Sep 2021 05:29:15 +0300
MySQL - high-level statements (including permutation, median, accumulation, percentage, regularity, stored procedure, etc.)
4, Some data processing methods
create table Total_Sales (Name char(10),Sales int(5));
insert into Total_Sales values ('zhangsan',10);
insert into Total_Sales values ('lisi',15);
insert into Total_Sales values ('wangwu',20);
insert into Total_Sales values ('zhaoliu',40);
insert into Total_Sales values ('sunqi',50);
insert into Total_Sales ...
Added by php-pendejo on Fri, 03 Sep 2021 05:32:27 +0300
Summarize django knowledge points
1. View functions:
Request Object------------- request:
1,HttpRequest.body:) Request original data
2,HttpRequest.path:) A string representing the requested path component (without domain name)
3,HttpRequest.method
4,HttpRequest.GET
5,HttpRequest.POST
6,HttpRequest.FILES
7,HttpResquest.user:) An AUTH_U ...
Added by simon71 on Sun, 19 Jul 2020 17:54:28 +0300
Beego Learning Notes 6: Paging Implementation
Implement Paging
1> Business logic for paging implementation
1->N data are displayed on each page. For the total number of data records M, the number of pages M%N==0?M/N:M/N+1;
2->Page Rendering Paging html Part
3>Switch pages, input parameters, background processing, and retrieve new eligible data
4>Paging method, js paging, and ...
Added by whare on Sun, 19 Jul 2020 17:37:26 +0300