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