APIJSON code analysis
2021SC@SDUSC
#SQLConfig interface – configure SQL
The first is to divide all different databases to facilitate the matching of different databases
String DATABASE_MYSQL = "MYSQL";
String DATABASE_POSTGRESQL = "POSTGRESQL";
String DATABASE_SQLSERVER = "SQLSERVER";
String DATABASE_ORACLE = "ORACLE";
String DATABASE_DB2 = "DB2";
Stri ...
Posted by rimedey on Sun, 07 Nov 2021 06:47:50 +0100
json function of mysql
MySQL 5.7 provides a new field format json, which is probably because MySQL wants to eat all non relational and relational databases, so it has introduced this very easy-to-use format. In this way, many of our businesses based on mongoDb or clickHouse can be implemented with MySQL. Of course, version 5.7 is only the most basic version, and the ...
Posted by ofi on Wed, 03 Nov 2021 23:39:12 +0100
Figure query analysis and tuning tool Optimizer Trace
Query analysis and tuning backgroundIn the process of using the database, we often encounter the sudden slow down of SQL due to the following problems:Select wrong indexSelect the wrong connection orderRange queries use different quick optimization strategiesExecution method change of sub query selectionChange of policy mode of semi connection ...
Posted by TheMayhem on Thu, 28 Oct 2021 20:31:26 +0200
SpringBoot: how to gracefully pass parameters, encapsulate response data, and handle exceptions?
In project development, JSON format is used for data transmission between interfaces and between front and back ends.
1 fastjson usage
Alibaba's fastjson is currently the most widely used JSON parsing framework. This article will also use fastjson.
1.1 introducing dependencies
<dependency>
<groupId>com.alibaba</groupId> ...
Posted by Deadman2 on Mon, 25 Oct 2021 15:00:37 +0200
day2021-10-13(mvc multi file upload, json file)
2. File upload
2.1 multi file upload
form <form action="${pageContext.request.contextPath}/file/upload2.action" method="post" enctype="multipart/form-data">
Select file: <input type="file" name="images" /> <br/>
Select file: <input type="file" name="images" /> <br/>
Select file: <input ...
Posted by lobster on Thu, 14 Oct 2021 01:44:22 +0200
REST Assured 34 - serialize Java objects into JSON objects using the Gson API
REST Assured series summary REST Assured 34 - serialize Java objects into JSON objects using the Gson API
We have learned about POJOs before. When you see this article, I suggest you read the following related articles first.
What is Plain Old Java Object (POJO)? Create a POJO as a JSON Object Payload Create a POJO as a JSON Array Payload Cre ...
Posted by perrio on Sun, 12 Sep 2021 07:41:15 +0200
Life is short. I learn python day15 time, hash and json
1, Time module
There are two time related modules in python; time,datetime
1. Time stamp
It refers to the time difference (in seconds) between the current time and 0:00 on January 1, 1970 (Greenwich mean time)Saving time with timestamp takes much less content than saving time with string;It is simpler to encrypt time through time stamp, and ...
Posted by walshd on Wed, 08 Sep 2021 23:55:12 +0200
vue property binding and interaction
vue directive binding properties
vue binds attributes by directive v-bind, src/width/height/title, such as v-bind:src='''can be abbreviated as: src=''', the same v-Bind:widthWait a moment, abbreviated as width,:height
<script src="https://unpkg.com/vue/dist/vue.js"></script>
<body>
<div id="box">
<img v-bind:sr ...
Posted by ariliquin on Mon, 20 Jul 2020 18:09:56 +0200
Crawl app photos with python
Download a fighting fish first (you can do it without downloading, the URLs are all here, right)
Grab a json package by grabbing it and get the address below
Observed tests show that modifying offset values is equivalent to paging an app
Accessing this url returns a large dictionary with two indexes, one error and one data.Data is another 20 ...
Posted by djcubez on Mon, 20 Jul 2020 16:59:48 +0200
Angular template reference variable (#var)
1. Template Reference Variables
Template reference variables use the pound sign (#) to declare reference variables.
Template reference variables are often used to reference a DOM element in a template, which can reference Angular components or directives or Web Component s.
We can use a template to reference variables anywhere in the current ...
Posted by q1234ask on Mon, 13 Jul 2020 16:35:15 +0200