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>
  
<strong>Class:</strong>
<u>XXXXX</u>
  
<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