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

Simple Use of Sharing-sphere 3.1.0

At the beginning, I spent half a day searching for sharding-sphere on the Internet and reading the source code for half a day (trying to use the @Configuration annotation instead of writing configuration files, I think there are too many configuration files, which are dazzling), and I didn't understand why. Later, I found a more complete answe ...

Posted by movieflick on Thu, 03 Oct 2019 21:47:23 -0700

Python automation: export zabbix data concurrent mail scripts

Zabbix has no report export function, so it exports ZABBIX data and sends mail concurrently by writing scripts. The results are as follows: [External Chain Picture Transfer.. (img-YujWHCbu-1565876650802)] Following is the script, which can be modified according to its own specific circumstances: `#!/usr ...

Posted by malbera on Thu, 03 Oct 2019 04:30:26 -0700

mybatis Details - Dynamic sql_Common Label Details

IF Tags Problems arising from the non-use of if tags Dynamic splicing sql is realized by various tag methods provided by mybatis. Demand: user enquiry based on gender and name Query sql: SELECT id, username, birthday, sex, address FROM user WHERE sex = 1 AND username LIKE'% Liu%' <!-- Query users b ...

Posted by RamboJustRambo on Thu, 03 Oct 2019 03:45:27 -0700

ExtJs 4.2 Application: Using ExtJs Extension Component searchfield to Realize Data Search Function

Links to the original text: https://my.oschina.net/qiuzhping/blog/611700 ExtJs 4.2 Application: Extending component search field with ExtJs Implementing Data Search Function 1. Int ...

Posted by jonathandg on Wed, 02 Oct 2019 12:37:45 -0700

Spring Data Jpa Learning-Dynamic Query

Specifications dynamic query Sometimes when we query an entity, the given condition is not fixed, so we need to dynamically construct the corresponding query statement. In Spring Data JPA, we can query through Jpa Specification Executor interface. Compared with JPQL, its advantage is type-safe and mor ...

Posted by discosuperfly on Wed, 02 Oct 2019 11:22:27 -0700

The use of Druid in Spring and Spring Book projects

What is it? One kind of database connection pool, manages and releases the connection of database, realizes the reuse of connection, and can compare thread pool. Parameter configuration What can we do? 1, Connection Pool 2, Monitoring 3, Encryption 4, Extending JDBC How do you use it? Adding ...

Posted by LightningSt on Wed, 02 Oct 2019 09:51:18 -0700

sharding-jdbc read-write separation

Read the official document before analyzing the source code Read / write separation Major Records Learn, Public Number: Madad's Technical Wheel Core concept Main library: add, update and delete data operations Slave library: The database used to query data operations, which can support multiple slave Libraries Multi-master and multi-slav ...

Posted by thedualmind on Wed, 02 Oct 2019 01:49:01 -0700

Database Connection Pool Druid Configuration

Druid is provided by the C3P0, and the specific operation steps are very similar to those of the C. We will copy the downloaded Druid directly into the IDEA tool Druid's configuration file is in the form of properties. Its configuration file can be called any name and can be placed in any directory. It ...

Posted by max101 on Wed, 02 Oct 2019 01:29:05 -0700

Photon Use Experience

The evaluation is not very pleasant, but it has to be used. Translated Documents: Although the version is very old, it is still valuable. https://vibrantlink.com/pun_multiplay_manual/?tdsourcetag=s_pcqq_aiomsg   Common api memo Custom classes inherit from Photon.PunBehaviour Join the room: Phot ...

Posted by raw100 on Tue, 01 Oct 2019 21:19:59 -0700