import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
 
class MySQLCustomerViewer {
    public static void main(String[] args) {
        String url = "jdbc:mysql://db4free.net:3306/customer_db";
        String user = "yourusername";
        String password = "yourpassword";
 
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            Connection conn = DriverManager.getConnection(url, user, password);
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT * FROM customer");
 
            while (rs.next()) {
                int id = rs.getInt("id");
                String name = rs.getString("name");
                String email = rs.getString("email");
                System.out.println("ID: " + id + ", Name: " + name + ", Email: " + email);
            }
 
            rs.close();
            stmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}
 

aW1wb3J0IGphdmEuc3FsLkNvbm5lY3Rpb247CmltcG9ydCBqYXZhLnNxbC5Ecml2ZXJNYW5hZ2VyOwppbXBvcnQgamF2YS5zcWwuUmVzdWx0U2V0OwppbXBvcnQgamF2YS5zcWwuU3RhdGVtZW50OwoKY2xhc3MgTXlTUUxDdXN0b21lclZpZXdlciB7CiAgICBwdWJsaWMgc3RhdGljIHZvaWQgbWFpbihTdHJpbmdbXSBhcmdzKSB7CiAgICAgICAgU3RyaW5nIHVybCA9ICJqZGJjOm15c3FsOi8vZGI0ZnJlZS5uZXQ6MzMwNi9jdXN0b21lcl9kYiI7CiAgICAgICAgU3RyaW5nIHVzZXIgPSAieW91cnVzZXJuYW1lIjsKICAgICAgICBTdHJpbmcgcGFzc3dvcmQgPSAieW91cnBhc3N3b3JkIjsKCiAgICAgICAgdHJ5IHsKICAgICAgICAgICAgQ2xhc3MuZm9yTmFtZSgiY29tLm15c3FsLmNqLmpkYmMuRHJpdmVyIik7CiAgICAgICAgICAgIENvbm5lY3Rpb24gY29ubiA9IERyaXZlck1hbmFnZXIuZ2V0Q29ubmVjdGlvbih1cmwsIHVzZXIsIHBhc3N3b3JkKTsKICAgICAgICAgICAgU3RhdGVtZW50IHN0bXQgPSBjb25uLmNyZWF0ZVN0YXRlbWVudCgpOwogICAgICAgICAgICBSZXN1bHRTZXQgcnMgPSBzdG10LmV4ZWN1dGVRdWVyeSgiU0VMRUNUICogRlJPTSBjdXN0b21lciIpOwoKICAgICAgICAgICAgd2hpbGUgKHJzLm5leHQoKSkgewogICAgICAgICAgICAgICAgaW50IGlkID0gcnMuZ2V0SW50KCJpZCIpOwogICAgICAgICAgICAgICAgU3RyaW5nIG5hbWUgPSBycy5nZXRTdHJpbmcoIm5hbWUiKTsKICAgICAgICAgICAgICAgIFN0cmluZyBlbWFpbCA9IHJzLmdldFN0cmluZygiZW1haWwiKTsKICAgICAgICAgICAgICAgIFN5c3RlbS5vdXQucHJpbnRsbigiSUQ6ICIgKyBpZCArICIsIE5hbWU6ICIgKyBuYW1lICsgIiwgRW1haWw6ICIgKyBlbWFpbCk7CiAgICAgICAgICAgIH0KCiAgICAgICAgICAgIHJzLmNsb3NlKCk7CiAgICAgICAgICAgIHN0bXQuY2xvc2UoKTsKICAgICAgICAgICAgY29ubi5jbG9zZSgpOwogICAgICAgIH0gY2F0Y2ggKEV4Y2VwdGlvbiBlKSB7CiAgICAgICAgICAgIGUucHJpbnRTdGFja1RyYWNlKCk7CiAgICAgICAgfQogICAgfQp9Cg==