如何使用jdbc连接mysql数据库

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

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

Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("SELECT * FROM mytable");
while (resultSet.next()) {
    // 处理每一行数据
}

PreparedStatement statement = connection.prepareStatement("INSERT INTO mytable (column1, column2) VALUES (?, ?)");
statement.setString(1, "value1");
statement.setInt(2, 100);
statement.executeUpdate();

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