Day 28 methods

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

// using tbl_mini_price_list_m from Day21A
// fields: fld_item_id, fld_item_name, fld_item_cat, fld_item_price, fld_item_qty
public class Day28Methods {
    private String connString = "jdbc:mysql://localhost:3306/db_nrg_b4_24";
    private String userName = "root";
    private String passWord = "";

    public String addNewRow(String name, String category, double price, int qty) {
        String resultMsg = "";
        // connection string, username and password are set outside of method
        // with private access modifier
        String sqlQuery = "INSERT INTO tbl_mini_price_list_m"
                + " (fld_item_name, fld_item_cat, fld_item_price, fld_item_qty)"
                + " VALUES (?, ?, ?, ?)";

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

            PreparedStatement stmt = conn.prepareStatement(sqlQuery);
            stmt.setString(1, name);
            stmt.setString(2, category);
            stmt.setDouble(3, price);
            stmt.setInt(4, qty);

            int rowsAffected = stmt.executeUpdate();
            if (rowsAffected == 1) {
                resultMsg = "New Row Added";
            } else {
                resultMsg = "Row Insert Failed";
            }
        } catch (Exception e) {
            resultMsg = "error: " + e.toString();
        }

        return resultMsg;
    }

    public void getAllRows() {
        String sqlQuery = "SELECT * FROM tbl_mini_price_list_m";

        try {
            Connection conn = DriverManager.getConnection(connString, userName, passWord);
            PreparedStatement stmt = conn.prepareStatement(sqlQuery);

            ResultSet rs = stmt.executeQuery();

            while (rs.next()) {
                String rowPrint = String.format("| %3d | %-25s | %-15s | %.1f | %3d |"
                                    , rs.getInt(1)
                                    , rs.getString(2)
                                    , rs.getString(3)
                                    , rs.getDouble(4)
                                    , rs.getInt(5)
                );
                System.out.println(rowPrint);
            }
        } catch (Exception e) {
            System.out.println("error: " + e.toString());
        }
    }
}

/*
CREATE TABLE tbl_mini_price_list_m (
    fld_item_id INT NOT NULL AUTO_INCREMENT
    , fld_item_name VARCHAR(30) NOT NULL
    , fld_item_cat VARCHAR(20) NOT NULL
    , fld_item_price DECIMAL(20, 4) NOT NULL
    , fld_item_qty INT NOT NULL
    , PRIMARY KEY (fld_item_id)
);
*/