Logistics system - company information management based on Spring MVC + Spring + MyBatis

Resource download: https://download.csdn.net/download/weixin_44893902/45601768 Exercise point design: fuzzy query, delete, add 1, Language and environment Implementation language: JAVA language.Environment requirements: MyEclipse/Eclipse + Tomcat + MySql.Use technology: Jsp+Servlet+JavaBean or spring MVC + Spring + mybatis. 2, Realiz ...

Posted by Aybabtu on Wed, 24 Nov 2021 18:52:51 -0800

Nested dolls, MySQL subqueries, single line and multi line subqueries, related and unrelated (related) subqueries, complete and detailed, collectable

Subquery refers to a query in which one query statement is nested inside another query statement. This feature has been introduced since MySQL 4.1. The use of SQL sub query greatly enhances the ability of SELECT query, because many times the query needs to obtain data from the result set, or calculate a data result from the same table, an ...

Posted by johnnyboy16 on Wed, 24 Nov 2021 14:23:36 -0800

SQL training camp -- Task03: complex query methods - views, subqueries, functions, etc

This note is the learning content of Alibaba cloud Tianchi Longzhu plan SQL training camp. The link is: https://tianchi.aliyun.com/specials/promotion/aicampsql preface This note is the learning content of Alibaba cloud Tianchi Longzhu plan SQL training camp. The link is: https://tianchi.aliyun.com/specials/promotion/aicampsql 1. Part ...

Posted by jayd1985 on Wed, 24 Nov 2021 13:50:40 -0800

Da baa Da baa - related concepts of affairs. You can't beat me

catalogue 1, Concept of transaction 2, Operating transaction commands in MySQL database   2.1. Write the test SQL script as follows: 2.1. Start transaction 2.2. Commit 2.3. Rollback 3, Using transactions in JDBC 3.1. JDBC transaction example   3.2. Set transaction rollback point 4, Four characteristics of transaction (ACID) ...

Posted by sirkodo on Wed, 24 Nov 2021 05:25:11 -0800

CockroachDB integrates a simple application of Springboot

preface The company recently switched from Mysql to CockroachDB, so some problems encountered during this period are recorded here 1 development environment CockroachDB version V20.2.3 maven needs to introduce dependencies <dependency> <groupId>org.postgresql</groupId> <artifactId>postgresql</artifact ...

Posted by m@ndio on Tue, 23 Nov 2021 07:41:11 -0800

Mysql review notes - Fundamentals 7 [overview of database character set]

Character set, basic concepts of character order and their relations MySQL provides different character sets for data storage. In the data comparison operation, different character order support is provided. MySQL provides different levels of settings, including server level, database level, table level and column level, which can provide ver ...

Posted by lotrfan on Tue, 23 Nov 2021 01:48:27 -0800

Understand the modularity of NgModule~Angular

  catalogue @Class of NgModule() decorator Common system modules of Angular 1. Example - create and import feature modules order.module.ts list.component.ts app.module.ts app.component.html 2. Example - inert loading module order.module order-routing.module Configure in the top-level routing AppRoutingModule app.component.html im ...

Posted by optimiss on Tue, 23 Nov 2021 01:33:30 -0800

Create a short video and audio with Python j

Welcome to pay attention Python wechat ordering applet course video https://edu.csdn.net/course/detail/36074 Python practical quantitative transaction financial management system https://edu.csdn.net/course/detail/35475 pydub is a simple, convenient and powerful Python audio processing library Project address: https://github.com/jiaaro/p ...

Posted by Frame on Mon, 22 Nov 2021 21:31:41 -0800

Online shopping system based on Spring MVC + Spring + MyBatis

Resource download: https://download.csdn.net/download/weixin_44893902/45601185 Exercise point design: modify, delete 1, Language and environment Implementation language: JAVA language.Environment requirements: MyEclipse/Eclipse + Tomcat + MySql.Use technology: Jsp+Servlet+JavaBean or spring MVC + Spring + mybatis. 2, Realize function ...

Posted by Zpixel on Mon, 22 Nov 2021 20:33:00 -0800

MySQL master-slave replication - based on binlog

1, Overview MySQL performs real-time data synchronization and does not play back the executed import database script. Therefore, before synchronization, the data at both ends should be consistent. Data synchronization: Master slave replication (if the master database hangs up, the slave database will not automatically become the maste ...

Posted by n5tkn on Mon, 22 Nov 2021 12:16:53 -0800