Mybatis uses Redis instead of secondary caching
1. Case introduction
The results of Mybatis query database are stored in Redis database as key-value pairs instead of secondary cache in Mybatis. When querying the same operation, we can read the results directly in Redis to improve efficiency.
2. Case Realization
2.1 Importing project dependencie ...
Posted by iamatube on Fri, 04 Oct 2019 12:18:16 -0700
MySQL Data Synchronizes Process to ES Search Engine in Full and Incremental Way
This article source code: GitHub. Click here || GitEE. Click here
I. Detailed Configuration
Scenario Description: MySQL tables synchronize with Elastic Search search engines in a full and incremental manner.
1. Download Content
Elastic search version 6.3.2
logstash Version 6.3.2
mysql-connector-java-5.1.13.jar
2. Core configuration
Path: / ...
Posted by beboo002 on Fri, 04 Oct 2019 11:12:52 -0700
ANTLR4 SQL parsing of sharding-jdbc
Public Number: Madad's Technical Wheel
Sharing mainly uses ANTLR4 to parse SQL. Take mysql as an example, before analyzing the source code, we can first understand the following three points:
antlr4, how to write.g4 grammar file
The mysql grammar can be referred to https://dev.mysql.com/doc/refman/8.0/en/sql-syntax-data-manipulation.html
...
Posted by trippyd on Thu, 03 Oct 2019 22:02:18 -0700
MyBatis-14 Interface Binding Scheme and Multi-parameter Transfer
Interface Binding Scheme
Effect
After creating an interface, the implementation class of the interface is generated by mybatis. By calling the interface object, the sql written in mapper.xml can be obtained.
Note: This solution is used in the later integration of mybatis and spring
Implementation ...
Posted by CoderGoblin on Thu, 03 Oct 2019 16:13:44 -0700
How to use Oauth2 to complete password policy authorization in SpringBook?
How does Oauth2 use password policy to complete authorization?
I. Importing Relevant Dependencies
POM file
<!-- oauth2 Dependent dependence -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-security</artifactId>
</dependency>
<dependency>
&l ...
Posted by volatileboy on Thu, 03 Oct 2019 14:46:39 -0700
News Management System Based on WEB
News Management System Based on WEB
WEB-based news management system mysql database creation statement
WEB-based news management system oracle database creation statement
WEB-based news management system sqlserver database creation statement
WEB-based news management system mysql database ...
Posted by mikster on Thu, 03 Oct 2019 10:45:09 -0700
Mysql database default encoding
View the encoding used
1. View with status
mysql> status
--------------
mysql Ver 14.14 Distrib 5.6.44, for Linux (x86_64) using EditLine wrapper
Connection id: 22
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server versi ...
Posted by Xproterg^vi on Thu, 03 Oct 2019 10:09:06 -0700
Installation and basic use of mysql backup tool innobackupex
Preface:
The encapsulation of xtrabackup by innobackupex is a reliable physical backup tool launched by percona. Official Link Address For mysql, logical backup can use mysqldump, mysqlpump, mysqldumper, and physical backup can use innobackupex directly.
Installation:
For convenience, I use centos ...
Posted by hossein2kk on Thu, 03 Oct 2019 08:28:11 -0700
Spring Boot Integrated druid Connection Pool
Step 1: Add Jar to the Pom.xml file
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.10</version>
</dependency>
<dependency>
<groupId& ...
Posted by Jem on Wed, 02 Oct 2019 11:51:35 -0700
Hibernate Framework of Java Framework
What is a framework?
Answer: Semi-finished projects that can complete some functions
JavaEE Three-tier Architecture
Web
Service
Dao
The 5 framework:
SSH: Spring + Struts2 + Hibernate
SSM: Spring + SpringMVC + MyBatis
hibernate is an orm framework
orm:object relation mapping. Object relation mapping
orm ...
Posted by pmt2k on Wed, 02 Oct 2019 04:12:34 -0700