B8 Day 24 INSERT INTO DEMO

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

// using tbl_price_list table for this sample
public class Day24InsertInto {
    public static void main(String[] args) {
        //set up phase
        Scanner sc = new Scanner(System.in);
        // para sa connection string
        String address = "jdbc:mysql://localhost:3306/mr_batch8_db";
        String userName = "root";
        String passWord = "";
        // para sa variable ng mga items
        String pName = "";
        double pPrice = 0.0;
        String pCat = "";
        String pManufacturer = "";
        // eto yung gagamiting SQL Query
        String sqlQuery = "INSERT INTO tbl_price_list "
                + "(fld_pname,fld_price,fld_pcategory,fld_manufacturer) "
                + "VALUES (?,?,?,?)";

        //hihingi ng value para sa variable
        System.out.print("Enter Product Name: ");
        pName = sc.nextLine();
        System.out.print("Enter Price: ");
        pPrice = sc.nextDouble();
        sc.nextLine();
        System.out.print("Enter Category: ");
        pCat = sc.nextLine();
        System.out.print("Enter Manufacturer: ");
        pManufacturer = sc.nextLine();



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

            // ibabala na yung ginawang SQL query
            PreparedStatement stmt = conn.prepareStatement(sqlQuery);
            // set_ para nga mga ?
            // yung mga set na start sa 1 hindi 0
            stmt.setString(1, pName);
            stmt.setDouble(2, pPrice);
            stmt.setString(3, pCat);
            stmt.setString(4, pManufacturer);
            // pagaganahin na yung SQL query
            int rowsAffected = stmt.executeUpdate();

            System.out.println(rowsAffected + " Row(s) Affected");

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


//NASA Day21A na file yan
CREATE TABLE tbl_price_list (
    fld_pid INT NOT NULL AUTO_INCREMENT
    ,fld_pname VARCHAR(35) NOT NULL
    ,fld_price DECIMAL(20,4) NOT NULL
    ,fld_pcategory VARCHAR(20) NOT NULL
    ,fld_manufacturer VARCHAR(35) NOT NULL
    ,PRIMARY KEY (fld_pid)
);