String url = "jdbc:mysql://localhost:3306/mydatabase";
String username = "username";
String password = "password";
import java.sql.*;
try {
Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection(url, username, password);
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("SELECT * FROM mytable");
while (resultSet.next()) {
String name = resultSet.getString("name");
int age = resultSet.getInt("age");
System.out.println("Name: " + name + ", Age: " + age);
}
PreparedStatement preparedStatement = connection.prepareStatement("UPDATE mytable SET age = ? WHERE name = ?");
preparedStatement.setInt(1, 30);
preparedStatement.setString(2, "John");
preparedStatement.executeUpdate();
resultSet.close();
statement.close();
preparedStatement.close();
connection.close();
e.printStackTrace();
}
