import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
String url = "jdbc:mysql://localhost:3306/database_name";
String username = "username";
String password = "password";
try {
Connection connection = DriverManager.getConnection(url, username, password);
} catch (SQLException e) {
e.printStackTrace();
}
String query = "SELECT * FROM table_name";
try {
PreparedStatement statement = connection.prepareStatement(query);
ResultSet resultSet = statement.executeQuery();
while (resultSet.next()) {
}
resultSet.close();
statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
String update = "UPDATE table_name SET column_name = value WHERE condition";
try {
PreparedStatement statement = connection.prepareStatement(update);
int rowsUpdated = statement.executeUpdate();
statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
