操作远程mysql数据库代码

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

public class RemoteMysqlExample {

    public static void main(String[] args) {
        // 连接数据库
        String url = "jdbc:mysql://远程服务器IP地址:3306/数据库名称";
        String username = "数据库用户名";
        String password = "数据库密码";
        
        try (Connection conn = DriverManager.getConnection(url, username, password)) {
            System.out.println("成功连接到远程MySQL数据库！");
            
            // 执行SQL查询
            String sql = "SELECT * FROM 表名";
            try (Statement stmt = conn.createStatement();
                 ResultSet rs = stmt.executeQuery(sql)) {
                // 处理查询结果
                while (rs.next()) {
                    // 获取每行数据的列值
                    String column1 = rs.getString("列名1");
                    int column2 = rs.getInt("列名2");
                    // TODO: 处理数据
                }
            }
            
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}