SQL statement learning

SQL statement Query statement select SELECT column_name,column_name FROM table_name [WHERE Clause] [LIMIT N][ OFFSET M] select is a query statement, followed by commas to separate multiple columns, and * indicates all columns Which form is it from after from where add conditional restrictions Limit limit the number of displays Offset indic ...

Posted by Sgarissta on Mon, 16 May 2022 03:42:58 +0300

Redis implements the secondary cache of Mybatis

1, Mybatis cache Like most ORM tier frameworks, Mybatis naturally provides support for L1 and L2 caching. The following is the role and definition of L1 cache and L2 cache. 1. The first level cache is the sqlSession level cache. When operating the database, you need to construct sqlSession object, in which there is a (memory area) data st ...

Posted by ladokha on Sun, 15 May 2022 22:48:08 +0300

Redis learning notes

Redis is a NoSQL Not Only SQL (key value) NoSQL Used to solve 3v+3 high Massive Volume, real-time Velocity, diversity High concurrency, high scalability and high performance Redis Download Windows Download the zip package and unzip it to the environment folder Linux I use the automatic installation of pagoda panel Directory for aut ...

Posted by ChrisBoden on Sun, 15 May 2022 10:01:55 +0300

What exactly does Spring integrate with Mybatis? (II. Introduction of Spring integration)

@EnableDubbo @SpringBootApplication @MapperScan(basePackages = "com.xiaoze.consumer.dao") public class DubboConsumerApplication { public static void main(String[] args) { SpringApplication.run(DubboConsumerApplication.class, args); } } This is a very common way to scan the Dao layer path and register the interface class of ...

Posted by doberman on Sun, 15 May 2022 05:48:09 +0300

Mongo Shell update operation

Mongo Shell update operation Update document - mongodb CN manual (mongoing. Com) Exercise data: db.inventory.insertMany( [ { item: "canvas", qty: 100, size: { h: 28, w: 35.5, uom: "cm" }, status: "A" }, { item: "journal", qty: 25, size: { h: 14, w: 21, uom: "cm" }, status: "A" }, { item: "mat", qty: 85, size: { h: 27.9, w: 35.5, uom ...

Posted by PHP_apprentice on Fri, 13 May 2022 22:28:37 +0300

3-minute essay: Laravel model scope, for you to "save" more code

introduction In principle, the code is written once and referenced everywhere. There is no need for a large number of redundant code. This is a trend and the direction of efforts to improve the robustness of the code. laravel model provides us with a database operation layer, which separates the data interaction. But over time, with the increa ...

Posted by Graphi on Fri, 13 May 2022 08:52:39 +0300

Spring Boot uses mybatis with TK Mybatis for database operation

Use mybatis with TK Mybatis for database operation This is a spring cloud project. mybatis uses TK Myabtis general mapper summary blog Use TK Mybatis is very simple, but there are some pits. Now let's talk about introducing mybatis, which is also very simple 1. First, introduce the dependency of mybatis, jdbc and mysql connecteor into the Co ...

Posted by podja on Fri, 13 May 2022 06:30:58 +0300

Java full stack Development -- Java ERP system development: the establishment of commercial ERP database and the construction of the project

6, Database ORACLE (1) Table space creation 1. Using PLSQL --Tablespace-- CREATE TABLESPACE ERP_TS DATAFILE 'c:\ts\erp.dbf' SIZE 100M AUTOEXTEND ON NEXT 10M; Created successfully (2) Create user -- Create users and associate default tablespaces CREATE USER ERPUSER IDENTIFIED BY itzheng DEFAULT TABLESPACE ERP_TS; (3) Assign permiss ...

Posted by johnbrayn on Fri, 13 May 2022 05:39:24 +0300

Based on Spring+SpringMVC+Mybatis distributed agile development system architecture source code sharing

Based on Spring+SpringMVC+Mybatis distributed agile development system architecture, it provides a complete set of public microservice service modules: centralized authority management (single sign-on), content management, payment center, user management (support third-party login), WeChat platform, storage system , configuration center, log an ...

Posted by njm on Thu, 12 May 2022 14:30:35 +0300

Mysql backup and recovery and xtrabackup backup

[transfer] Mysql backup recovery and xtrabackup backup 🎉 New Year greetings 🎉 2017 is about to pass, and the bell of the new year is about to ring. At this beautiful moment of farewell to the old and ushering in the new year, I would like to extend new year's greetings to the people of all ethnic groups across the country, compatriots in th ...

Posted by titeroy on Thu, 12 May 2022 11:10:13 +0300