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