B8 Day 26 Get one row for update

package mattroseb8wk5;
import java.util.Scanner;
import java.sql.*;

public class Day26B {
    private final String address = "jdbc:mysql://localhost:3306/mr_batch8_db";
    private final String userName = "root";
    private final String passWord = "";

    public static void main(String[] args) {
        Scanner sc = new Scanner(System.in);
        Day26B callMe = new Day26B();

        int pid;
        String[] rowValues;
        System.out.print("Enter id to get row value >> ");
        pid = sc.nextInt();
        sc.nextLine();

        rowValues = callMe.getRows(pid);

        for (String str : rowValues) {
            System.out.println(str);
        }
    }

    // ang silbi neto, para may ipapalaman tayo na value
    // kung sakaling nag skip yung encoder
    public String[] getRows(int searchId) {
        String[] resultArr = {"1","name","0.0","cat","manufacturer"};

        String sqlQuery = "SELECT * FROM tbl_price_list WHERE fld_pid = ? LIMIT 1";

        try {
            Connection conn = DriverManager.getConnection(
                    address, userName, passWord);

            PreparedStatement stmt = conn.prepareStatement(sqlQuery);

            stmt.setInt(1, searchId);
            ResultSet rs = stmt.executeQuery();

            rs.next();
            resultArr[0] = rs.getString(1);
            resultArr[1] = rs.getString(2);
            resultArr[2] = rs.getString(3);
            resultArr[3] = rs.getString(4);
            resultArr[4] = rs.getString(5);


            conn.close();
        } catch (Exception e) {
            System.out.println(e);
        }

        return resultArr;
    }
}