Explain in detail the simple addition, deletion and modification through JDBC (take MySQL as an example)
Foreword: what is JDBC
Java database connectivity (JDBC) is an application program interface used in the Java language to regulate how client programs access the database. It provides methods such as querying and updating data in the database. JDBC is also a trademark of Sun Microsystems. JDBC is oriented to relational database.
In short, it is a kind of Java API used to execute SQL statements. Through JDBC, we can directly use Java programming to operate relational databases. Through encapsulation, developers can use pure Java APIs to complete SQL execution.
1、 Preparatory work (I): MySQL installation configuration and basic learning
Before using JDBC to operate a database, first you need to have a database. Here are three links for readers to learn by themselves. If they have ever used SQL language (including classroom learning in school), the first two links are enough to get started.
MySQL download installation, deployment and graphical detailed operation tutorial: https://www.oudahe.com/p/23229/