JAVA learning notes (JDBC)

JDBC Today's goal Master the CRUD of JDBCUnderstand the role of various objects in JDBCMaster the use of Druid 1. JDBC overview In the development, we use java language, so it is necessary to operate the data in the database through Java language. This is the JDBC to learn next. 1.1 JDBC concept JDBC is a set of API s that use ...

Posted by herrin on Mon, 31 Jan 2022 23:07:44 +0100

Binary balanced tree (AVL) of data structure and algorithm

I'm a sophomore. The purpose of writing this article is to make a certain record of my knowledge and technology, and I'm willing to share it with you. Because I'm still young, there are inevitably some mistakes and omissions in the published article. Please forgive me and correct me if you read this article. If you have any questions during rea ...

Posted by Nymphetamine on Mon, 31 Jan 2022 20:09:58 +0100

SQL learning notes

Introductory Grammar Table for example: +----+--------------+---------------------------+-------+---------+ | id | name | url | alexa | country | +----+--------------+---------------------------+-------+---------+ | 1 | Google | https://www.google.cm/ | 1 | USA | | 2 | TaoBao | htt ...

Posted by timmerk on Mon, 31 Jan 2022 17:34:52 +0100

Lock waiting for processing

1, Find out the specific statements that cause lock waiting Simulate the row lock waiting that may occur in DML operation of Damon database: Session 1: update table test_ A row of data with id=2 (ID field is the primary key field) in lock was successfully updated and not submitted: SQL> update test_lock set name='Change_na' where id=2;aff ...

Posted by dcalladi on Mon, 31 Jan 2022 17:33:05 +0100

Introduction to Spring Boot JPA Basics

Spring Boot JPA preface The full name of JPA is Java Persistence API, that is, Java Persistence API. It is a set of ORM based specifications launched by SUN company. It is internally composed of a series of interfaces and abstract classes. JPA describes the mapping relationship between object and relational table through JDK 5.0 annotation, a ...

Posted by vijayanand on Mon, 31 Jan 2022 16:19:17 +0100

[how to become a master of SQL] level 4: integrity constraints

👨‍🎓 Blogger introduction: IT Bond, a Jianghu person jeames007,10 year DBA hands-on background China DBA union(ACDU)Member, currently engaged in DBA And program programming SQL is almost a necessary skill for the production and research position of Internet companies, but if you only know SQL, you can't do anything. 1. If you are a da ...

Posted by raffielim on Mon, 31 Jan 2022 16:04:42 +0100

Experiment 5 java gui

Experiment 5 graphical application development <center> <strong>full name:</strong> <u>XXX</u> &emsp;&emsp; <strong>Class:</strong> <u>XXXXX</u> &emsp;&emsp; <strong>Student number:</strong> <u>XXXXXXXXXXXX</u></center> 1, Experime ...

Posted by paggard on Mon, 31 Jan 2022 14:07:48 +0100

Message communication - MQTT security authentication and testing

EMQX security certification The connection authentication and access control of EMQ X message server are provided by a series of authentication plugins, and their names comply with emqx_auth_ In EMQ X, these two functions refer to: Connection authentication: EMQ X checks whether the client on each connection has the permission to access t ...

Posted by mfouts on Mon, 31 Jan 2022 10:15:52 +0100

CentOS7 installs MySQL database and sets firewall

Steps for installing MySQL database in CentOS7 MySQL database installation Download wget command Delete the installed MySQL service Install MySQL installation package Possible problems Question one Question two MySQL database configuration Get temporary password ·Log in to MySQL Change Password Modify MySQL default code Simp ...

Posted by easyedy on Mon, 31 Jan 2022 05:25:02 +0100

MySQL master-slave replication has the most comprehensive understanding of notes (reason principle step synchronization mode GTID)

brief introduction Many articles on MySQL master-slave replication on the network explain how to implement and some implementation principles, and lack a comprehensive introduction to MySQL master-slave replication. For example, the mode of master-slave replication (semi synchronous mode and asynchronous synchronous mode), the principle of sy ...

Posted by always_confused on Mon, 31 Jan 2022 03:48:06 +0100