How to connect MySQL database using JSP?

2 years ago
Ava Mitchell
4 minutes

To connect to a MySQL database, you can use the JDBC (Java Database Connectivity) driver. The following are the steps to connect to a MySQL database: 1. Download and install the MySQL Connector/J driver. You can download the latest driver from the MySQL official website. 2. Add the downloaded driver’s JAR file to your project. You can copy the JAR file to the project’s lib folder and add the JAR file to the project’s build path. 3. Import the necessary classes in your Java code.

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

Create a connection object in the code and establish a connection to the database.

Connection conn = null;
try {
    String url = "jdbc:mysql://localhost:3306/db_name"; // 这里的 db_name 是你要连接的数据库名
    String username = "your_username";
    String password = "your_password";
    
    conn = DriverManager.getConnection(url, username, password);
    
    // 连接成功后可以执行其他操作，如执行 SQL 查询等
} catch (SQLException e) {
    e.printStackTrace();
} finally {
    if (conn != null) {
        try {
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

The `url` in the above code is a connection string, where `localhost:3306` represents the address and port number of the database server, and `db_name` is the name of the database. `username` and `password` are the credentials used to connect to the database. After successfully connecting, you can perform other operations such as executing SQL queries, inserting, updating, etc. You can use the `conn.createStatement()` method to create a `Statement` object and use that object to execute SQL queries.

import java.sql.ResultSet;
import java.sql.Statement;
Statement stmt = null;
ResultSet rs = null;
try {
    stmt = conn.createStatement();
    String sql = "SELECT * FROM table_name"; // 这里的 table_name 是你要查询的表名
    rs = stmt.executeQuery(sql);
    
    // 处理查询结果
    while (rs.next()) {
        // 通过 rs 对象获取查询结果的字段值
        String field1 = rs.getString("field_name1"); // 这里的 field_name1 是查询结果的字段名
        int field2 = rs.getInt("field_name2");
        // ...
    }
} catch (SQLException e) {
    e.printStackTrace();
} finally {
    if (rs != null) {
        try {
            rs.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    if (stmt != null) {
        try {
            stmt.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

The ‘table_name’ in the above code is the name of the table you want to query, while ‘field_name1’, ‘field_name2’, and so on are the names of the fields in the query results. These are the basic steps to connect to a MySQL database and perform queries. Depending on your specific needs, you may also need to perform other operations such as inserting, updating, or deleting data.

bannerAds