数据库操作：Java JDBC连接MySQL并执行SQL语句实例？

原创淡淡的烟草味﹌ 2024-09-16 06:04 97阅读 0赞

以下是一个使用Java JDBC连接MySQL并执行SQL语句的简单例子：

```java
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class MySQLExample {

private static final String DB_URL = "jdbc:mysql://localhost:3306/mydatabase"; // Replace with your database URL
    private static final String USER = "username"; // Replace with your username
    private static final String PASS = "password"; // Replace with your password

public static void main(String[] args) {

// 1. Establish a connection to the MySQL server
        Connection conn = DriverManager.getConnection(DB_URL, USER, PASS));

if (conn != null) {
            try {
                // 2. Create a PreparedStatement for an SQL query
                String sql = "SELECT column_name(s) FROM table_name"; // Replace with your desired query
                PreparedStatement pstmt = conn.prepareStatement(sql);

// 3. Execute the prepared statement and handle the results
                ResultSet rs = pstmt.executeQuery();
                while (rs.next()) {
                    String columnValue = rs.getString("column_name(s)"));
                    System.out.println(columnValue);
                }

} catch (Exception e) {
                e.printStackTrace();
                conn.close(); // Close the connection if an error occurs
            }
        }

// 4. Close the JDBC resources when done
        conn.close();

}
}
```

这个例子中，我们连接到一个名为`mydatabase`的MySQL数据库，执行一个查询获取特定列的数据，并将结果打印出来。最后确保所有资源都被正确关闭。