1. Implement an operation of adding, modifying, deleting and querying data tables in the database by integrating SpringBoot, SpringMVC and MyBatis.
First of all, you're using the Springboot version 2.2.6.RELEASE, and since Springboot iterates quickly, you need to be aware of the version issues.
Add a new dependency package to the pom file as ...
Posted on Mon, 11 May 2020 18:54:35 -0700 by spyke01
Mybatis generator can help us automatically generate a lot of structured code, such as Entity, Mapper interface and Xml file corresponding to each table, which can save a lot of tedious work.
1. Add plug-in dependency in pom file:
<!-- mybatis generator Auto generate code plug-in -->
Posted on Mon, 11 May 2020 09:40:55 -0700 by robinjohn
This blog is no longer so verbose. Please visit the previous blog about Zabbix's working principle and overview:Centos 7 builds Zabbix 4.0 monitoring system
1, Installing Zabbix3.4
2, Visit the Web interface of zabbix
3, zabbix monitoring Linux client
4, Custom monitor
5, Custom monitoring graphics
6, Create template
7, ZABBIX agent passing p ...
Posted on Mon, 11 May 2020 00:12:14 -0700 by The.Pr0fess0r
The third comprehensive system practice
1, Installation of docker compose
Download docker composesudo curl -L "https://github.com/docker/compose/releases/download/1.25.5/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose
Apply executable permissions to binariessudo chmod +x /usr/local/bin/docker-compose
Create s ...
Posted on Fri, 08 May 2020 19:31:51 -0700 by v4g
sudo apt-get install mysql-server
sudo apt-get install mysql-client
sudo apt-get install libmysqlclient-dev
During the installation process, you will be prompted to set a password, so that you can complete the mysql installation. You can log in through the following command:
mysql -u root -p where - u represents the user n ...
Posted on Tue, 05 May 2020 10:27:51 -0700 by mrneilrobinson
Workflow is very common in projects, so here are two diagrams:
First:Second:Explain the above two pictures:
Assume these two diagrams are flowcharts of Chinese brothers'vacations
Components of the graph:
Characters: Fan Bingbing, Feng Xiaogang, Wang Zhongjun
Events (Actions): Leave, Approve, Disapprove
Workflow: is the "automation of pa ...
Posted on Tue, 05 May 2020 01:39:58 -0700 by CiPH
Execute integration test mysql deploy with docker
The integration test needs to use flywayDB to manage the script information of the database according to the test case. Each time before the production goes online, it must pass the integration test to verify the accuracy of the data. Therefore, each integration test is the database instanc ...
Posted on Mon, 04 May 2020 17:40:07 -0700 by Entanio
Please indicate the source of Reprint: http://blog.csdn.net/l1028386804/article/details/79042734
Before we go online, we need to deploy the corresponding environment, often a business involves multiple environments, such as Web, DB, Proxy, Cache, etc. in this example, we define different roles through env.roledefs, and then use the @ roles(&qu ...
Posted on Mon, 04 May 2020 08:48:51 -0700 by shibobo12
When writing mysql statement with mybatis, we encountered the problem of 1-to-many relationship
First look at the relationship:
Based on table A, A record in table A corresponds to A record in table B, while A record in table A corresponds to n records in table C. then table B and table C are 1-to-1. The query statement at this time is:
Posted on Mon, 04 May 2020 08:17:15 -0700 by kneifelspy
To create a table:
create database Database name;
CREATE DATABASE mybase;
use Database name
Create data table format
create table Table name(
Column name 1 data type constraint,
Column name 2 data type constraint,
Column name 3 ...
Posted on Sun, 03 May 2020 12:56:35 -0700 by drums