import java.sql.*;

public class MysqlTest {

    public static void main(String[] args) {
        String dbName = "customer";
        String dbUser = "root";
        String dbPasswd = "cccc!";
        String dbRow = "customer";

        getRows(dbName, dbRow, dbUser, dbPasswd);

    }



    public static void getRows(String dbName, String dbRow, String dbUser, String dbPasswd) {
        Connection conn = null;

        try {
            //Class.forName("com.mysql.jdbc.Driver");
            Class.forName("com.mysql.cj.jdbc.Driver");


            conn = DriverManager.getConnection("jdbc:mysql://localhost/"+ dbName + "?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC\n" ,dbUser, dbPasswd);
            Statement sqlState = conn.createStatement();

            String selectStuff = "SELECT first_name FROM " + "customers";

            ResultSet rows = sqlState.executeQuery(selectStuff);

            while (rows.next()) {
                System.out.println(rows.getString(dbRow));
            }

        } catch (SQLException ex) {
            System.out.println("SQLException: " + ex.getMessage());
            System.out.println("VendorError: " + ex.getErrorCode());

        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }

    }
}