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