header ads

Praktikum 09 OODB

Lukman Rheza 08.24
 Langsung saja ke langkah kerjanya yah...
  • Siapkan project baru dengan 2 class. Main.java dan Barang.java
  • Pada library, silahkan load JAR Db4o.
  • Pastekan kode berikut di barang.java


/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package prak09rheza;

/**
 *
 * @author LukmanRheza
 */
public class Barang {
  
 String KodeBarang;
String NamaBarang;
String Jenis;
double HargaSatuan;
String Supplier;
public Barang(String kd,String nm, String jns,
double hrg, String sup){
this.KodeBarang = kd;
this.NamaBarang = nm;
this.Jenis =jns;
this.HargaSatuan =hrg;
this.Supplier = sup;
}
public String getKodeBarang(){
return KodeBarang;
}
public String getNamaBarang(){
return NamaBarang;
}
public String getJenis(){
return Jenis;
}
public double getHarga(){
return HargaSatuan;
}
public String getSupplier(){
return Supplier;
}
public String toString(){
return KodeBarang+"/"+NamaBarang+"/"+Jenis+"/"+ String.valueOf(HargaSatuan)+"/"+Supplier;
}
}

  • Kalau yang ini kode di Main.java


/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package prak09rheza;

import com.db4o.ObjectSet;
import com.db4o.query.Constraint;
import com.db4o.*;
import com.db4o.query.*;
import java.io.File;
/**
 *
 * @author LukmanRheza
 */
public class Main {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
      InsertData();
Query1();
Query2();
Query3();
Query4();
Query5();
Query6();
Query7();
}
public static void InsertData(){
new File("Barang.yap").delete();
ObjectContainer db = Db4o.openFile("Barang.yap");
Barang barang1 = new Barang("M33", "Mie Goreng Ayam","Mie",1200,"Fastfood");
Barang barang2 = new Barang("S03", "Sun Silk","Shampo",6500,"UniClean");
Barang barang3 = new Barang("M11", "Mie Goreng Ayam","Mie",1000,"FlyFood");
Barang barang4 = new Barang("K31", "Kopi cap API","Kopi",2700,"Obor");
Barang barang5 = new Barang("T01", "Teh Aroma Wangi","Teh",4500,"UniClean");
Barang barang6 = new Barang("M02", "Soto Mie","Mie",1100,"Fastfood");
Barang barang7 = new Barang("M51", "Mie Kari","Mie",1300,"FlyFood");
Barang barang8 = new Barang("K21", "Kopi cap Wangi","Kopi",7500,"Uniclean");
Barang barang9 = new Barang("T05", "Teh T-Melati","Teh",5500,"Obor");
Barang barang10 = new Barang("M82", "Mie Bakso","Mie",1200,"Fastfood");

db.store(barang1);db.store(barang2);
db.store(barang3);db.store(barang4);
db.store(barang5);db.store(barang6);
db.store(barang7);db.store(barang8);
db.store(barang9);db.store(barang10);
db.close();
System.out.println("Data Barang sudah tersimpan pada Object Database");
}

public static void Query1(){
ObjectContainer db = Db4o.openFile("Barang.yap");
Query Qry = db.query();
Qry.constrain(Barang.class);
ObjectSet Hasil = Qry.execute();
System.out.println("Query 1 : SELECT * FROM BARANG");
TampilSemua(Hasil);
db.close();
}

public static void Query2(){
ObjectContainer db =
Db4o.openFile("Barang.yap");
Query Qry = db.query();
Qry.constrain(Barang.class);
Qry.descend("Jenis").constrain("Mie");
ObjectSet Hasil = Qry.execute();
System.out.println("Query 2 : SELECT * FROM Barang WHERE Jenis = 'Mie'");
TampilSemua(Hasil);
db.close();
}

public static void Query3(){
ObjectContainer db =
Db4o.openFile("Barang.yap");
Query Qry = db.query();
Qry.constrain(Barang.class);
Qry.descend("Jenis").constrain("Mie").not();
ObjectSet Hasil = Qry.execute();
System.out.println("Query 3 : SELECT KodeBarang, NamaBarang FROM Barang WHERE NOT (Jenis = 'Mie')");
System.out.println("Hasil : "+ Hasil.size()+" record");
while (Hasil.hasNext())
{
Barang brg = (Barang)Hasil.next();
System.out.println(brg.getKodeBarang() +"/"+brg.getNamaBarang());
}
db.close();
}
public static void Query4(){
ObjectContainer db =
Db4o.openFile("Barang.yap");
Query Qry = db.query();
Qry.constrain(Barang.class);
Qry.descend("HargaSatuan").constrain(new
Double(5000)).greater();
ObjectSet Hasil = Qry.execute();
System.out.println("Query 4 : SELECT NamaBarang, HargaSatuan FROM Barang WHERE HargaSatuan > 5000");
System.out.println("Hasil : "+ Hasil.size()+" record");
while (Hasil.hasNext())
{
Barang brg = (Barang)Hasil.next();
System.out.println(brg.getNamaBarang()+"/"+String.valueOf(brg.getHarga()));
}
db.close();
}
public static void Query5(){
ObjectContainer db = Db4o.openFile("Barang.yap");
Query Qry = db.query();
Qry.constrain(Barang.class);
Constraint Qry1 = Qry.descend("Jenis").constrain("Kopi");
Qry.descend("Jenis").constrain("Teh").or(Qry1);
ObjectSet Hasil = Qry.execute();
System.out.println("Query 5 : SELECT NamaBarang, HargaSatuan FROM Barang WHERE Jenis = 'Kopi' OR Jenis = 'Teh'");
System.out.println("Hasil : "+ Hasil.size()+" record");
while (Hasil.hasNext())
{
Barang brg = (Barang)Hasil.next();
System.out.println(brg.getNamaBarang()+ "/"+String.valueOf(brg.getHarga()));
}
db.close();
}

public static void Query6(){
ObjectContainer db =
Db4o.openFile("Barang.yap");
Query Qry = db.query();
Qry.constrain(Barang.class);
Constraint Qry1 = Qry.descend("Jenis").constrain("Mie");
Qry.descend("Supplier").constrain("Fastfood").and(Qry1);

ObjectSet Hasil = Qry.execute();
System.out.println("Query 6 : SELECT NamaBarang, HargaSatuan FROM Barang WHERE Jenis = 'Mie' AND Supplier = 'Fastfood'");
System.out.println("Hasil : "+ Hasil.size()+" record");
while (Hasil.hasNext())
{
Barang brg = (Barang)Hasil.next();
System.out.println(brg.getNamaBarang()+"/"+String.valueOf(brg.getHarga()));
}
db.close();
}


public static void Query7(){
ObjectContainer db =
Db4o.openFile("Barang.yap");
Query Qry = db.query();
Qry.constrain(Barang.class);
Constraint Qry1 = Qry.descend("HargaSatuan").constrain( new Double(1000)).greater();
Constraint Qry2 = Qry.descend("HargaSatuan").constrain( new Double(5000)).smaller();
Qry.descend("Jenis").constrain( "Teh").and(Qry1).and(Qry2);
ObjectSet Hasil = Qry.execute();
System.out.println("Query 7 : SELECT KodeBarang, NamaBarang FROM Barang WHERE Jenis = 'Teh' AND HargaSatuan between 1000 AND 5000");
System.out.println("Hasil : "+ Hasil.size()+" record");
while (Hasil.hasNext())
{
Barang brg = (Barang)Hasil.next();
System.out.println(brg.getKodeBarang() +"/"+brg.getNamaBarang());
}
db.close();
}

public static void TampilSemua(ObjectSet Hasil){
System.out.println("Hasil : "+Hasil.size()+" record");
while (Hasil.hasNext())
{
System.out.println(Hasil.next());
}
}  // TODO code application logic here
    }
Selesai lagi satu pertemuan praktikum...
monggow di run programnya...
klw tidak ada halangan. hasil running nya akan seperti berikut:


Data Barang sudah tersimpan pada Object Database
Query 1 : SELECT * FROM BARANG
Hasil : 10 record
M33/Mie Goreng Ayam/Mie/1200.0/Fastfood
S03/Sun Silk/Shampo/6500.0/UniClean
M11/Mie Goreng Ayam/Mie/1000.0/FlyFood
K31/Kopi cap API/Kopi/2700.0/Obor
T01/Teh Aroma Wangi/Teh/4500.0/UniClean
M02/Soto Mie/Mie/1100.0/Fastfood
M51/Mie Kari/Mie/1300.0/FlyFood
K21/Kopi cap Wangi/Kopi/7500.0/Uniclean
T05/Teh T-Melati/Teh/5500.0/Obor
M82/Mie Bakso/Mie/1200.0/Fastfood
Query 2 : SELECT * FROM Barang WHERE Jenis = 'Mie'
Hasil : 5 record
M33/Mie Goreng Ayam/Mie/1200.0/Fastfood
M11/Mie Goreng Ayam/Mie/1000.0/FlyFood
M02/Soto Mie/Mie/1100.0/Fastfood
M51/Mie Kari/Mie/1300.0/FlyFood
M82/Mie Bakso/Mie/1200.0/Fastfood
Query 3 : SELECT KodeBarang, NamaBarang FROM Barang WHERE NOT (Jenis = 'Mie')
Hasil : 5 record
S03/Sun Silk
K31/Kopi cap API
T01/Teh Aroma Wangi
K21/Kopi cap Wangi
T05/Teh T-Melati
Query 4 : SELECT NamaBarang, HargaSatuan FROM Barang WHERE HargaSatuan > 5000
Hasil : 3 record
Sun Silk/6500.0
Kopi cap Wangi/7500.0
Teh T-Melati/5500.0
Query 5 : SELECT NamaBarang, HargaSatuan FROM Barang WHERE Jenis = 'Kopi' OR Jenis = 'Teh'
Hasil : 4 record
Kopi cap API/2700.0
Teh Aroma Wangi/4500.0
Kopi cap Wangi/7500.0
Teh T-Melati/5500.0
Query 6 : SELECT NamaBarang, HargaSatuan FROM Barang WHERE Jenis = 'Mie' AND Supplier = 'Fastfood'
Hasil : 3 record
Mie Goreng Ayam/1200.0
Soto Mie/1100.0
Mie Bakso/1200.0
Query 7 : SELECT KodeBarang, NamaBarang FROM Barang WHERE Jenis = 'Teh' AND HargaSatuan between 1000 AND 5000
Hasil : 1 record
T01/Teh Aroma Wangi


Berikut saya sertakan screen shoot hasil kerja eyke...


Tags
Reactions
Lukman Rheza

Diposting oleh Lukman Rheza

You can follow Me at https://www.facebook.com/rezaqyu.rezaqta http://twitter.com/lukmanrheza

Posting Komentar

0 Komentar