How to use MySQL for database connection?

How to use MySQL for database connection?

MySQL is a widely used relational database management system that is open source and has high performance, reliability and scalability. During development, we often need to connect to the MySQL database to perform operations such as adding, deleting, modifying, and querying data. This article will introduce how to use MySQL for database connection and provide corresponding code examples.

First of all, we need to make sure that the MySQL database has been installed and know the host name, port number, database name, username and password of the database to be connected. Then, we can use the MySQL connection driver in the Java language to implement the database connection.

The following is a code example for MySQL database connection using Java language:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class MySQLConnection {

    public static void main(String[] args) {
        // 数据库连接相关信息
        String host = "localhost"; // 主机名
        int port = 3306; // 端口号
        String database = "mydatabase"; // 数据库名称
        String username = "root"; // 用户名
        String password = "password"; // 密码

        Connection connection = null;

        try {
            // 加载MySQL驱动程序
            Class.forName("com.mysql.jdbc.Driver");

            // 创建连接
            String url = "jdbc:mysql://" + host + ":" + port + "/" + database;
            connection = DriverManager.getConnection(url, username, password);

            // 连接成功
            System.out.println("成功连接到数据库！");

            // 执行操作...

        } catch (ClassNotFoundException e) {
            System.out.println("找不到MySQL驱动程序！");
            e.printStackTrace();
        } catch (SQLException e) {
            System.out.println("连接数据库失败！");
            e.printStackTrace();
        } finally {
            // 关闭连接
            if (connection != null) {
                try {
                    connection.close();
                } catch (SQLException e) {
                    System.out.println("关闭连接失败！");
                    e.printStackTrace();
                }
            }
        }
    }
}

In the above code, we first load the MySQL driver, and then based on the provided host name, port number, database name , username and password to create a connection string. Next, we establish a connection with the database through the DriverManager.getConnection() method. If the connection is successful, corresponding database operations can be performed. Finally, we close the connection in the finally block to release the resources.

It should be noted that this is just a basic database connection example. In actual use, more operations may be required, such as executing SQL statements, processing query results, etc. In addition, connection pooling can be used to improve the efficiency and performance of connections.

The above is an introduction and sample code on how to use MySQL for database connection. Through these codes, we can easily connect to the MySQL database and perform corresponding database operations. I hope this article can be helpful to everyone!

The above is the detailed content of How to use MySQL for database connection?. For more information, please follow other related articles on the PHP Chinese website!