Day 16 with scanner

package week3;

import java.util.Scanner;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class Day16C {
    private String address = "jdbc:mysql://localhost:3306/db_jtvi_b8_23";
    private String userName = "jtvi23b8"; //default "root"
    private String passWord = "demo";

    public static void main(String[] args) {
        Scanner sc = new Scanner(System.in);
        Day16C callMe = new Day16C();
        boolean isValid = true;
        String itemName;
        String itemDesc;
        double itemValue = 0;
        String userInput;
        int rowResult;

        System.out.print("Enter Item Name: ");
        itemName = sc.nextLine();
        if (itemName.trim().isEmpty()) {
            isValid = false;
        }

        System.out.print("\nEnter Item Description: ");
        itemDesc = sc.nextLine();
        if (itemDesc.trim().isEmpty()) {
            isValid = false;
        }

        System.out.print("\nEnter Item Price: ");
        userInput = sc.nextLine();
        if (isNumeric(userInput)) {
            itemValue = Double.parseDouble(userInput);
            userInput = "";
        } else {
            isValid = false;
        }

        if (isValid) {
            System.out.println("all input ok");
            rowResult = callMe.addNewRowB(itemName, itemDesc, itemValue);

            System.out.println(rowResult + " rows affected");

        } else {
            System.out.println("one or more user input have problem");
        }

    }

    static boolean isNumeric(String txtIn) {
        boolean isNumber = true;
        if (txtIn.trim().isEmpty()) {
            isNumber = false;
        }
        try {
            double d = Double.parseDouble(txtIn);
        } catch (Exception e) {
            isNumber = false;
        }
        return isNumber;
    }

    int addNewRowB (String itemName, String itemDesc, double itemValue) {
        int rowsAffected = 0;
        try {
            Connection conn = DriverManager.getConnection(address, userName, passWord);

            String sqlQuery = "INSERT INTO tbl_item_list"
                    + " ( fld_item_name , fld_item_desc , fld_item_value)"
                    + " VALUES (?, ?, ?);";

            PreparedStatement stmt = conn.prepareStatement(sqlQuery);
            stmt.setString(1, itemName); //use proper set, starts at 1
            stmt.setString(2, itemDesc);
            stmt.setDouble(3, itemValue);

            rowsAffected = stmt.executeUpdate();

            conn.close();
        } catch (Exception e) {
            rowsAffected = -1;
        }
        return rowsAffected;
    }
}