How MySQL implements JDBC
JDBC Basics Introduction
Concept
JDBC (Java DataBase Connectivity, java database connection) is a Java API used to execute SQL statements, which can provide unification for a variety of relational databases Access, which consists of a set of classes and interfaces written in Java language.
The JDBC specification defines the interface, and the specific implementation is implemented by major database vendors.
A specific database driver implementation is required to operate the database in Java, because JDBC is only the standard specification for Java to access the database. Each database vendor writes its own database driver based on the communication format of its database. Therefore, you only need to master the invocation of JDBC interface methods, and the database manufacturer will provide a database driver.
Essence
is actually a set of specifications (interfaces) officially provided by java. Used to help developers quickly connect different relational databases!
7 steps of JDBC
(1) Import jar package
(2) Register driver
Class.forName("com.mysql.cj.jdbc.Driver");
Note: If you use a higher version of MySQL, you must use the com.mysql.cj.jdbc.Driver method, otherwise an error will be reported!
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
If it is a lower version, you can use com.mysql.jdbc.Driver
If you still get an error, You can add the time zone to the url!
url=jdbc:mysql://localhost:3306/Database name?serverTimezone=UTC
(3) Get the connection
String url = "jdbc:mysql://localhost:3306/db1"; Connection con = DriverManager.getConnection(url,"root","888888");
(4) Get the executor object
Statement stat = con.createStatement();
(5) Execute the sql statement and receive the return result
String sql = "SELECT * FROM user"; ResultSet rs = stat.executeQuery(sql);
(6) Processing results
while(rs.next()) { System.out.println( rs.getInt("id") + "\t" + rs.getString("name")); }
(7) Release resources
con.close(); stat.close(); rs.close();
JDBC entry sample code
Change the user name, database name, and password in the Connection object to your own!
public class jdbc_demo01 { public static void main(String[] args) throws ClassNotFoundException, SQLException { // 1.导入jar包 // 2.注册驱动 Class.forName("com.mysql.cj.jdbc.Driver"); // 3.获取连接 String url = "jdbc:mysql://localhost:3306/db1"; Connection con = DriverManager.getConnection(url,"root","888888"); // 4.获取执行者对象 Statement stat = con.createStatement(); // 5.执行sql语句,并且接收结果 String sql = "SELECT * FROM product"; ResultSet rs = stat.executeQuery(sql); // 6.处理结果 while(rs.next()) { System.out.println( rs.getInt("id") + "\t" + rs.getString("name") + "\t" + rs.getInt("price") + "\t" + rs.getString("brand") + "\t" + rs.getInt("stock") ); } // 7。释放资源 con.close(); stat.close(); rs.close(); } }
The results are as follows:
The above is the detailed content of How MySQL implements JDBC. For more information, please follow other related articles on the PHP Chinese website!

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics











The main role of MySQL in web applications is to store and manage data. 1.MySQL efficiently processes user information, product catalogs, transaction records and other data. 2. Through SQL query, developers can extract information from the database to generate dynamic content. 3.MySQL works based on the client-server model to ensure acceptable query speed.

The process of starting MySQL in Docker consists of the following steps: Pull the MySQL image to create and start the container, set the root user password, and map the port verification connection Create the database and the user grants all permissions to the database

Laravel is a PHP framework for easy building of web applications. It provides a range of powerful features including: Installation: Install the Laravel CLI globally with Composer and create applications in the project directory. Routing: Define the relationship between the URL and the handler in routes/web.php. View: Create a view in resources/views to render the application's interface. Database Integration: Provides out-of-the-box integration with databases such as MySQL and uses migration to create and modify tables. Model and Controller: The model represents the database entity and the controller processes HTTP requests.

I encountered a tricky problem when developing a small application: the need to quickly integrate a lightweight database operation library. After trying multiple libraries, I found that they either have too much functionality or are not very compatible. Eventually, I found minii/db, a simplified version based on Yii2 that solved my problem perfectly.

Article summary: This article provides detailed step-by-step instructions to guide readers on how to easily install the Laravel framework. Laravel is a powerful PHP framework that speeds up the development process of web applications. This tutorial covers the installation process from system requirements to configuring databases and setting up routing. By following these steps, readers can quickly and efficiently lay a solid foundation for their Laravel project.

The key to installing MySQL elegantly is to add the official MySQL repository. The specific steps are as follows: Download the MySQL official GPG key to prevent phishing attacks. Add MySQL repository file: rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm Update yum repository cache: yum update installation MySQL: yum install mysql-server startup MySQL service: systemctl start mysqld set up booting

MySQL and phpMyAdmin are powerful database management tools. 1) MySQL is used to create databases and tables, and to execute DML and SQL queries. 2) phpMyAdmin provides an intuitive interface for database management, table structure management, data operations and user permission management.

MySQL is suitable for web applications and content management systems and is popular for its open source, high performance and ease of use. 1) Compared with PostgreSQL, MySQL performs better in simple queries and high concurrent read operations. 2) Compared with Oracle, MySQL is more popular among small and medium-sized enterprises because of its open source and low cost. 3) Compared with Microsoft SQL Server, MySQL is more suitable for cross-platform applications. 4) Unlike MongoDB, MySQL is more suitable for structured data and transaction processing.
