Day 23 Sample

package week4training;
import java.sql.*;
//bago paganahin:
// -- may connector jar na ba?
// -- naka add na sa library ng project sa netbeans
// -- may ganyan ka ba na katulad na table sa database mo
// -- tama na ba yung address string?

// uses RunQuery01 Class for sql connection
public class Day23B {
    public static void main(String[] args) {
        Day23B callRunQuery = new Day23B();

        callRunQuery.viewProdList();
    }

    public void viewProdList() {
        String address = "jdbc:mysql://localhost:3306/db_mng_b2";
        String userName = "root";
        String passWord = "";
        String sqlQuery = "SELECT fld_plist_id"
                + ", fld_prod_name"
                + ", fld_prod_price"
                + ", fld_category"
                + ", fld_quantity "
                + "FROM tbl_prod_list";

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

            ResultSet rs = stmt.executeQuery();
            while (rs.next()) {
                System.out.print(rs.getString("fld_plist_id")+ " | ");
                System.out.print(rs.getString("fld_prod_name")+ " | ");
                System.out.print(rs.getString(3)+ " | ");
                System.out.print(rs.getString(4)+ " | ");
                System.out.println(rs.getString(5)+ " | ");
            }
            // your additional code here
            conn.close();
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
    }

}

//----------------------------------

CREATE TABLE tbl_prod_list
(
  fld_plist_id INT NOT NULL AUTO_INCREMENT
  ,fld_prod_name VARCHAR(30)
  ,fld_prod_price DECIMAL(20,4)
  ,fld_category VARCHAR(30)
  ,fld_quantity INTEGER
  ,PRIMARY KEY (fld_plist_id)
);

INSERT INTO tbl_prod_list (
  fld_prod_name
  , fld_prod_price
  , fld_category
  , fld_quantity
)
VALUES
('Corned Beef' ,39 ,'Canned Goods' ,3)
,('Lucky Me Pancit Canton' ,14 ,'Noodles' ,4)
,('Apples' ,20 ,'Fruits' ,6)
,('Leche Plan' ,115 ,'Dessert' ,5)
,('Piattos' ,30 ,'Snacks' ,8)
,('Aficionado' ,100 ,'Perfume' ,8)
,('Zara' ,2500 ,'Clothing' ,57)
,('Orange' ,25 ,'Fruits' ,32)
,('Mario De Boro' ,1000 ,'Shoes' ,4)
,('Aqua Flask' ,800 ,'Tumbler' ,5)
,('Colgate 22g' ,8.25 ,'Toothpaste' ,6)
,('Magic Sarap' ,3.75 ,'Food Seasoning' ,3)
,('Creamsilk' ,6.50 ,'Personal Hygiene' ,11)
,('Sunsilk' ,5.75 ,'Personal Hygiene' ,12)
,('Maybeline' ,135.00 ,'Lipstick' ,2)
,('Dove Beauty Bar' ,59.95 ,'Personal Hygiene' ,3)
,('Pantene Conditioner' ,77.10 ,'Personal Hygiene' ,24)
,('Eden Cheese' ,49.20 ,'Dairy' ,5)
,('Alaska Condensed Milk' ,33 ,'Canned Goods' ,10)
,('Lemon Square Twin Cake' ,58.80 ,'Bread' ,5)
,('Woofy' ,1800 ,'Pet Supplies' ,5)
,('Surf 1.18' ,250 ,'Detergent' ,3)
,('Freska Tuna' ,190 ,'Canned Goods' ,10)
,('Happy Pants' ,300 ,'Baby Diaper' ,5)
,('Canin' ,1600 ,'Pet Supplies' ,2)
,('Great Taste 3 in 1 Choco' ,108 ,'Drinks', 7)
,('Xtra Big Original',15,'Noodles',20)
,('Xtra Big Calamansi',15,'Noodles',30)
,('Nissin Yakisoba Spicy Chicken',9,'Noodles',20)
,('Nissin Yakisoba Savory Beef',9,'Noodles',20)
,('Oreo 3x10',48.95,'Biscuits',12)
,('Grahan Cracker 250g',37,'Biscuits',12)
,('Tide 1kl',242,'Detergent',5)
,('Cream o Original 3x10',52.30,'Biscuits',11)
,('Indomie Original',13,'Noodles',25)
,('CenturyTuna Flk in Oil 155g 3s',106,'Canned Goods',12)
,('Argentina Meat Loaf 170g x 3',74.25,'Canned Goods',8)
,('UFC Mushrooms 198g Bndl of 12',339.36,'Canned Goods',7)
,('Oishi Cheese & Onion 42g x 6',73,'Biscuits',13)
,('Quaker Variety (Bundle of 2)',138.29,'Biscuits',14)
,('Julies PB Biscuits 135g x 2',126,'Biscuits',15)
,('Surf Powder Cherry Blsm 1.1kg',118,'Detergent',12)
,('Mighty Clean Floral Pink 1Klx6',237,'Detergent',14)
,('2 DOZEN REXONA DEODORANT SACHT',24.55,'Personal Hygiene',8)
,('NIVEA Deodorant Extra 50 ml',197,'Personal Hygiene',8)
,('CJ Foods Kalbi BBQ Sauce 840g',209,'Food Seasoning',7)
,('Mang Tomas Regular 1 kg',82,'Food Seasoning',15)
,('V-Cut Spicy bbq 60g 3 Pack',110.58,'Snacks',11)
,('Mister Potato Sour Cream 85g',70,'Snacks',13)
,('Panpan Dorayaki Flavr 12g*12pc',95.48,'Snacks',14);