Day 16 statements

package week3;

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

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

    public static void main(String[] args) {
        Day16A callMe = new Day16A();

        String itemName = textPicker(); // "Janny";
        String itemDesc = "statement test";
        double itemValue = Math.random() * 4000; // random para di na ako type ng type

//        callMe.addNewRowA(itemName, itemDesc, itemValue);

        System.out.println("-----------------------");
        itemName = textPicker(); // "Janny";
        itemDesc = "prep statement' test";
        itemValue = Math.random() * 4000;

        int result = callMe.addNewRowB(itemName, itemDesc, itemValue);
        System.out.println(result + " row(s) affected");

    }

    void addNewRowA(String itemName, String itemDesc, double itemValue) {
        try {
            Connection conn = DriverManager.getConnection(address, userName, passWord);
            int rowsAffected = 0;
            //PREPARE INFO

            String sqlQuery = "INSERT INTO tbl_item_list"
                    + " ( fld_item_name , fld_item_desc , fld_item_value)"
                    + " VALUES ('%s', '%s', %.4f);";

            sqlQuery = String.format(sqlQuery, itemName, itemDesc, itemValue);
            System.out.println(sqlQuery);

            Statement stmt = conn.createStatement();
            rowsAffected = stmt.executeUpdate(sqlQuery);

            if (rowsAffected == 1) {
                System.out.println("new row added");
            } else {
                System.out.println("no row added");
            }

            conn.close();
        } catch (Exception e) {
            System.out.println("connection error");
            System.out.println(e.toString());
        }

    }

    static String textPicker() {
        String[] txtList = {"book", "magazine", "novel", "e book", "hardbound"};
        int index = (int) (Math.random() * txtList.length);
        return txtList[index];
    }

    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;
    }
}