Day 16 read

package week3;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet; // pang select query

public class Day16E {
    private String address = "jdbc:mysql://localhost:3306/db_jtvi_b8_23";
    private String userName = "root";
    private String passWord = "";

    public static void main(String[] args) {
        Day16E callMe = new Day16E();
        callMe.getAllRows();
    }

    void getAllRows() {
        try {
            Connection conn = DriverManager.getConnection(address, userName, passWord);
            String sqlQuery = "SELECT fld_traineeid, fld_fname"
                    + " , fld_lname, fld_email, fld_phone "
                    + " FROM tbl_trainee_list;";

            PreparedStatement stmt = conn.prepareStatement(sqlQuery);

            ResultSet rs = stmt.executeQuery();

            while (rs.next()) {
                System.out.printf("%d | %s | %s | %s | %s%n"
                    , rs.getInt(1)
                    , rs.getString(2)
                    , rs.getString(3)
                    , rs.getString(4)
                    , rs.getString(5)
                );
            }

            System.out.println( rs );
        } catch (Exception e) {
            System.out.println(e.toString());
        }
    }
}