Use of PostgreSQL_upsert function (insert_on_conflict_do)

Label PostgreSQL , upsert , insert on conflict do background PostgreSQL 9.5 introduces a new feature, UPSERT(insert on conflict do), which returns directly when an insert encounters a constraint error, or performs UPDATE instead. The syntax is as follows Command: INSERT Description: create new rows in a table Syntax: [ WITH [ RE ...

Posted by tym on Sat, 22 Dec 2018 08:51:06 -0800

Still and Video Media Capture

Still and Video Media Capture Most of the content comes from AV Foundation Development Secret Book. AVFoundation capture class Capture session AVCaptureSession captures sessions that are equivalent to a virtual "plugboard" for connecting input and output resources. Capture session management data streams from physical devices ...

Posted by jwalsh on Fri, 21 Dec 2018 15:18:05 -0800

Spring Security Builds Rest Service - 0900-rememberMe Remember Me

Spring security remembers my basic principles: When logged in, the request is sent to the filter Username Password Authentication Filter. When the filter is authenticated successfully, the RememberMeService is called and a token is generated, which is written to the browser cookie. At the same time, there is a TokenRepository inside the Rememb ...

Posted by mcdsoftware on Fri, 21 Dec 2018 12:15:06 -0800

MyBatis Initial 3_mapper.xml Optimization (parameterType Abbreviation_NameSpace Abbreviation_sql Fragment_Special Character Processing)_Dynamic SQL

This article is a hard summary for bloggers. I hope I can understand more deeply when I come back later. I also hope it can help beginners. Reproduced from: luogg's Blog Garden Thank you for your cooperation. optimization 1. Aliases (generally not used, easy to write to see the origin of the class) Previous wording: <insert id="insert"pa ...

Posted by TanyaTR on Fri, 21 Dec 2018 00:30:05 -0800

Day20-jsp & el & jstl

EL expression ${EL expression} EL (Express Lanuage) expressions can be embedded in jsp pages to reduce the writing of jsp scripts. The purpose of EL is to replace the writing of scripts in jsp pages. Expression language Expressions Language, borrowing js, jquery grammar Effect: 1) Simplify the code in jsp, mainly to replace the JSP s ...

Posted by swasheck on Thu, 20 Dec 2018 18:12:05 -0800

Keepalived+Nginx+Redis+Tomcat for High Availability web Load Balancing

I. System Environment Operating System: CentOS 7 tomcat 8.0.47 Nginx 1.12.2 Redis 4.0.2 192.168.124.128 tomcat1+Nginx+Redis 192.168.124.130 tomcat2 Specific how to install these software, here is no longer introduced, please go online to find information. After installation, modify the port number of tomcat 2. If th ...

Posted by roice on Thu, 20 Dec 2018 17:48:05 -0800

JavaScript/jQuery, HTML and CSS to Build Web IM Remote and Timely Chat Communication Program

The original address is: JavaScript/jQuery, HTML and CSS to Build Web IM Remote and Timely Chat Communication Program This article is mainly for introduction. JavaScript and jQuery,HTML,CSS And using the third-party chat JavaScript (jsjac) framework to build a BS Web chat application. This program can communicate and send mes ...

Posted by Patioman on Thu, 20 Dec 2018 08:33:08 -0800

Use and configuration of HTTPS on SL/TLS (IIS8 and iOS client)

Use and configuration of HTTPS on SL/TLS (IIS8 and iOS client) CA certificate 1. Domain Name Type SSL Certificate (DV SSL): The trust level is ordinary, only need to verify the authenticity of the website can issue certificates to protect the website; generally free. 2. Enterprise-type SSL Certificate (OV SSL): Strong trust level, ...

Posted by _theworks on Thu, 20 Dec 2018 05:48:05 -0800

iOS uses NSURLProtocol to Hook to intercept WK Webview requests and play back a pose (ti) potential (wei)

Sometimes we have to interact with WK WebView. Although WK WebView has high performance, there are still many pits. For example, we can get the js context in UIWebview in the following way, but WKWebView is error-prone let context = webView.valueForKeyPath("documentView.webView.mainFrame.javaScriptContext") as! JSContext context.evaluateScrip ...

Posted by poleposters on Wed, 19 Dec 2018 20:39:05 -0800

J2EE hibernate 4 Learning Notes (XVIII) -- hibernate Advanced Configuration (log4j Configuration Log Framework)

hibernate comes with a simple logging framework. Here we introduce a powerful logging framework log4j. Baidu Encyclopedia's introduction to log4j is very good. Most of the content below is copied from Baidu Encyclopedia. Introduction to log4j (Baidu Encyclopedia) Log4j is Apache An open source project, using Log4j, we can control the destinat ...

Posted by xt3mp0r~ on Wed, 19 Dec 2018 17:30:04 -0800