java控制台程序连接mysql数据库

import java.sql.*;

Class.forName("com.mysql.jdbc.Driver");

String url = "jdbc:mysql://localhost:3306/mydatabase";
String user = "root";
String password = "password";
Connection connection = DriverManager.getConnection(url, user, password);

Statement statement = connection.createStatement();

String sql = "SELECT * FROM table_name";
ResultSet resultSet = statement.executeQuery(sql);

String sql = "INSERT INTO table_name (column1, column2) VALUES (value1, value2)";
int rowsAffected = statement.executeUpdate(sql);

while (resultSet.next()) {
    String column1Value = resultSet.getString("column1");
    int column2Value = resultSet.getInt("column2");
    // 其他操作...
}

resultSet.close();
statement.close();
connection.close();