Java springboot based online ordering and takeout platform website (java+springboot+vue+mysql)
Operating environment:
Development tools: IDEA /Eclipse Database: mysql5 seven Application service: Tomcat7/Tomcat8 Using the framework springboot+vue
Project introduction
For the design of the ordering platform website, the system development mainly adopts java language technology and applies MySQL database to complete data storage in the d ...
Posted by drums on Sat, 14 May 2022 22:16:22 +0300
3-minute essay: I've never met before. Introduction to Laravel database model
introduction
The framework without model is not flexible! Each framework will carry out in-depth design for the database,
In order to quickly add, delete, modify and check SQL, abstract the repeated work and improve the efficiency of application development.
In this issue, we will talk about the initial use of laravel's model.
Code time
The mo ...
Posted by verano on Sat, 14 May 2022 06:02:55 +0300
JDBC (connection, basic addition, deletion, modification and query, PrepareStatement and Statement)
Interface oriented programming
Programming steps
Get connection
Before that, to obtain the mysql driver, you need to put the corresponding jar package under the project:
Mode 1
import org.junit.Test;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.SQLException;
import java.util.Properties;
public class Connectio ...
Posted by toysrfive on Fri, 13 May 2022 08:40:54 +0300
Analysis of MySQL lock in MySQL database
preface
In his work, the author encountered inserting a piece of data into the MySQL table, but he couldn't insert it. And the same operation can be inserted in Oracle, so I specially studied MySQL 5 7 lock logic.
Introduction of lock
Before introducing locks, you need to understand the transaction isolation level: https://www.cnblogs.com/jssj/ ...
Posted by ephmynus on Fri, 13 May 2022 07:43:21 +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
Create a mybaits from scratch
catalogue
1: Create project maven
2: Import mybaits dependent package
3: Configure
4: Write mybaits tool class
mybaits tool class
5: Interface between code entity class and mapper/dao layer
6: Test
7: Attention items
SqlsessionFactoryBuilder class
SqlSessionFactory interface
SqlSession interface
1: Create maven project ...
Posted by 2705ap on Thu, 12 May 2022 21:06:11 +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
MySQL backup and recovery
preface
In enterprises, the value of data is very important, and data ensures the normal operation of enterprise business. Therefore, data security and data Reliability is the top priority of operation and maintenance. Any loss of data may have serious consequences for the enterprise.
1: Classification of database backup
1.1: what are t ...
Posted by corsc on Thu, 12 May 2022 07:41:45 +0300
Master slave replication of a database that has been running for a period of time
Master slave replication of a database that has been running for a period of time
Preface: a few days ago, the master-slave replication of MySQL database that has been running for a period of time and has not opened bin log was made. Hereby, the detailed operation steps and instructions are recorded. Note that this synchronization does not use ...
Posted by virtuexru on Wed, 11 May 2022 23:14:11 +0300