jsp + servlet campus forum campus bbs (administrator, user) based on javaweb + mysql (java + jsp + servlet + mysql) Private message Source code acquisition and debugging communication Operating environment Java≥8, MySQL≥5.7, Tomcat≥8 development tools eclipse/idea/myeclipse/sts, etc. can be configured to run Be applicable Course design, major assignments, graduation projects, project exercises, learning demonstrations, […]
Tag: mysql
jsp+servlet online ordering system (front desk, backend) based on javaweb+mysql (java+jsp+servlet+mysql+dbutil+tomcat)
jsp + servlet online ordering system (front desk, backend) based on javaweb + mysql (java + jsp + servlet + mysql + dbutil + tomcat) Private message Source code acquisition and debugging communication Operating environment Java≥8, MySQL≥5.7, Tomcat≥8 development tools eclipse/idea/myeclipse/sts, etc. can be configured to run Be applicable Course design, major assignments, graduation projects, […]
“Network Security” How to build a MySQL malicious server to read files?
Foreword Note: This article does not involve research on MySQL protocol messages. It only explains the principles and does some demonstrations. Although the threshold for direct use of building a MySQL malicious server to read files is relatively high, I personally feel that it is relatively new because I saw a relatively new way of […]
Thoughts on MySQL optimization two [Performance analysis tools, optimization principles]
In actual work, we inevitably need to analyze and optimize SQL predictions. Today we will take a look at the relevant content: SQL performance analysis SQL optimization principles 1 SQL performance analysis Performance analysis of SQL mainly includes: View slow SQL View through profile details explain execution plan 1.1 View slow SQL SQL execution frequency […]
MySQL face vector, Euclidean distance similarity query
Foreword For example, the title uses the extracted face feature vector to write a Euclidean SQL statement to query the top_K data records with the highest similarity in the database. Although the approach is alternative, there is a ready-made facial retrieval API on the market at the business layer, and there is now a vector […]
[MySQL Advanced] SQL Optimization
5. SQL optimization 5.1 Insert data in bulk Environment preparation: CREATE TABLE `tb_user_2` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(45) NOT NULL, `password` varchar(96) NOT NULL, `name` varchar(45) NOT NULL, `birthday` datetime DEFAULT NULL, `sex` char(1) DEFAULT NULL, `email` varchar(45) DEFAULT NULL, `phone` varchar(45) DEFAULT NULL, `qq` varchar(32) DEFAULT NULL, `status` varchar(32) NOT NULL […]
Docker installation of mysql, redis, rabbitmq, es, nacos under Liunx
1. Environment preparation Note: Ignore if related tools have already been installed. 1Install JAVA operating environment Step 1: Upload or download the installation package cd /usr/local jdk-8u152-linux-x64.tar.gz Step 2: Unzip the installation package tar -zxvf jdk-8u152-linux-x64.tar.gz Step 3: Establish a soft connection ln -s /usr/local/jdk1.8.0_152/ /usr/local/jdk Step 4: Modify environment variables vim /etc/profile export JAVA_HOME=/usr/local/jdk […]
MySQL Backup and Recovery Best Practices: The Ultimate Guide
As businesses and applications increasingly rely on MySQL databases to manage their critical data, ensuring data reliability and availability becomes critical. In this digital information age, a strong backup and recovery strategy is the backbone of application stability. In this article, we will review all the commonly used MySQL backup and recovery strategies, which are […]
Monitoring tool: Prometheus monitoring middleware (Nginx, Redis, MySql, etc.)
Our products currently use middleware such as Nginx, Redis, RabbitMQ, MySql, etc. This article introduces how to use Promtheus to monitor these middleware. There is a picture in “Monitoring Tool: Introduction and Installation of Prometheus” that shows the data trend of Prometheus, as follows: As can be seen from the figure, the first step in […]
The use of foreign keys and foreign key constraint strategies in MySQL
1. The concept of foreign key constraints Foreign key constraint (FOREIGN KEY, abbreviated as FK is a concept of database design, it ensures that the relationship between two tables maintains data consistency and integrity. Foreign key means that a field in the table depends on the value of a field in another table, and the […]