Tutorial Lengkap Membuat Web E-Commerce dengan Ruby dan Oracle Database

gem install ruby-oci8

# Panggil jembatannya dulu
require 'oci8'

puts "Mencoba ngetok pintu Oracle..."

begin
  # Format: OCI8.new('username', 'password', 'alamat_server/Service_Name')
  koneksi = OCI8.new('sistem_toko', 'rahasia123', 'localhost:1521/XEPDB1')
  
  puts "Alhamdulillah, koneksi ke Oracle tembus, Cing!"
  
  # Coba nanya jam server ke Oracle buat bukti
  koneksi.exec('SELECT SYSDATE FROM DUAL') do |baris|
    puts "Waktu di server database sekarang: #{baris[0]}"
  end
  
  # Tutup pintu biar memori kagak bocor
  koneksi.logoff
  
rescue OCIError => e
  puts "Waduh, gagal nyambung nih. Cek lagi dah: #{e.message}"
end

ruby tes_koneksi.rb

require 'oci8'

begin
  koneksi = OCI8.new('sistem_toko', 'rahasia123', 'localhost:1521/XEPDB1')
  puts "Koneksi aman, Cing! Mulai ngaduk semen buat tabel..."

  # Blueprint rak etalasenya pake bahasa SQL Oracle.
  rancangan_sql = <<-SQL
    CREATE TABLE barang_dagangan (
      id NUMBER GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
      nama_barang VARCHAR2(100) NOT NULL,
      deskripsi VARCHAR2(500),
      harga NUMBER NOT NULL,
      stok NUMBER DEFAULT 0
    )
  SQL

  koneksi.exec(rancangan_sql)
  puts "Alhamdulillah, rak etalase (tabel) 'barang_dagangan' udah berdiri kokoh!"

rescue OCIError => e
  puts "Waduh, ada yang salah pas ngecor nih: #{e.message}"
ensure
  if koneksi
    koneksi.logoff
    puts "Pintu Oracle udah ditutup rapi."
  end
end

require 'oci8'

begin
  koneksi = OCI8.new('sistem_toko', 'rahasia123', 'localhost:1521/XEPDB1')
  puts "Koneksi tembus! Siap bongkar muatan barang..."

  # Bind Variables (:nama, :deskripsi) biar aman dari SQL Injection
  sql_tambah = <<-SQL
    INSERT INTO barang_dagangan (nama_barang, deskripsi, harga, stok)
    VALUES (:nama, :deskripsi, :harga, :stok)
  SQL

  kursor = koneksi.parse(sql_tambah)
  
  # Barang 1 & 2
  kursor.exec('Kaos Polos Mbois', 'Kaos bahan katun adem, cocok buat nongkrong', 55000, 24)
  kursor.exec('Kopi Bubuk Asli', 'Kopi item racikan warkop, bikin melek nulis kode', 25000, 50)
  
  # Wajib Commit di Oracle!
  koneksi.commit
  
  puts "Dua barang andalan udah sukses masuk etalase!"

rescue OCIError => e
  puts "Gagal bongkar muatan, Cing: #{e.message}"
ensure
  koneksi.logoff if koneksi
end

require 'oci8'

def format_rupiah(angka)
  angka.to_s.reverse.gsub(/(\d{3})(?=\d)/, '\\1.').reverse
end

begin
  koneksi = OCI8.new('sistem_toko', 'rahasia123', 'localhost:1521/XEPDB1')
  puts "\n============================================="
  puts "   SELAMAT DATANG DI TOKO RUBY SULTAN      "
  puts "=============================================\n\n"

  sql_tarik_data = "SELECT id, nama_barang, deskripsi, harga, stok FROM barang_dagangan ORDER BY id ASC"

  koneksi.exec(sql_tarik_data) do |baris|
    id_barang = baris[0]
    nama      = baris[1]
    deskripsi = baris[2]
    harga     = format_rupiah(baris[3])
    stok      = baris[4]

    puts "[#{id_barang}] #{nama.upcase}"
    puts "    Keterangan : #{deskripsi}"
    puts "    Harga      : Rp #{harga}"
    puts "    Sisa Stok  : #{stok} Pcs"
    puts "---------------------------------------------"
  end

rescue OCIError => e
  puts "Waduh, etalase macet nutup nih: #{e.message}"
ensure
  koneksi.logoff if koneksi
end

require 'oci8'

begin
  koneksi = OCI8.new('sistem_toko', 'rahasia123', 'localhost:1521/XEPDB1')
  
  # UPDATE wajib pake WHERE!
  sql_revisi = <<-SQL
    UPDATE barang_dagangan 
    SET harga = :harga_baru, stok = :stok_baru 
    WHERE id = :id_barang
  SQL

  koneksi.exec(sql_revisi, 60000, 20, 1) # Update ID 1
  koneksi.commit
  puts "Harga sama stok sukses di-update!"
ensure
  koneksi.logoff if koneksi
end

require 'oci8'

begin
  koneksi = OCI8.new('sistem_toko', 'rahasia123', 'localhost:1521/XEPDB1')
  
  # DELETE wajib pake WHERE juga!
  sql_hapus = "DELETE FROM barang_dagangan WHERE id = :id_barang"
  koneksi.exec(sql_hapus, 2) # Hapus ID 2 (Kopi)
  koneksi.commit
  puts "Beres, Cing! Barang udah musnah."
ensure
  koneksi.logoff if koneksi
end

gem install sinatra

<!DOCTYPE html>
<html lang="id">
<head>
    <meta charset="UTF-8">
    <title>Toko Sultan Oracle - Belanja Ngacir</title>
    <style>
        body { font-family: sans-serif; background-color: #f4f4f9; padding: 20px; }
        .grid-container { display: flex; gap: 20px; flex-wrap: wrap; justify-content: center; }
        .card { background: white; border-radius: 10px; padding: 20px; width: 280px; box-shadow: 0 4px 6px rgba(0,0,0,0.05); }
        .harga { color: #e74c3c; font-weight: bold; font-size: 1.2em; }
        .btn-beli { display: block; text-align: center; background-color: #27ae60; color: white; padding: 10px; text-decoration: none; border-radius: 5px; }
    </style>
</head>
<body>
    <h1 style="text-align: center;">Katalog Toko Sultan</h1>

    <div class="grid-container">
        <% @daftar_barang.each do |barang| %>
            <div class="card">
                <h3><%= barang[:nama] %></h3>
                <p><%= barang[:deskripsi] %></p>
                <p class="harga">Rp <%= barang[:harga] %></p>
                <p class="stok">Sisa Stok: <%= barang[:stok] %></p>
                <a href="#" class="btn-beli">🛒 Beli Sekarang</a>
            </div>
        <% end %>
    </div>
</body>
</html>

require 'sinatra'
require 'oci8'

get '/' do
  @daftar_barang = []
  begin
    koneksi = OCI8.new('sistem_toko', 'rahasia123', 'localhost:1521/XEPDB1')
    
    koneksi.exec("SELECT id, nama_barang, deskripsi, harga, stok FROM barang_dagangan ORDER BY id ASC") do |baris|
      harga_rupiah = baris[3].to_s.reverse.gsub(/(\d{3})(?=\d)/, '\\1.').reverse
      
      @daftar_barang << {
        id: baris[0], nama: baris[1], deskripsi: baris[2],
        harga: harga_rupiah, stok: baris[4]
      }
    end
  ensure
    koneksi.logoff if koneksi
  end

  erb :etalase
end

        <% 
          require 'uri'
          nomor_wa = "6281234567890" 
          teks_pesan = "Halo Admin, ane kepincut sama barang ini:\n" +
                       "📦 Nama Barang: #{barang[:nama]}\n" +
                       "💰 Harga: Rp #{barang[:harga]}\n"
          teks_aman = URI.encode_www_form_component(teks_pesan)
          link_checkout = "https://wa.me/#{nomor_wa}?text=#{teks_aman}"
        %>
        <a href="<%= link_checkout %>" target="_blank" class="btn-beli">🛒 Beli via WhatsApp</a>

get '/tambah' do
  erb :tambah_barang
end

post '/simpan' do
  nama      = params[:nama_barang]
  deskripsi = params[:deskripsi]
  harga     = params[:harga]
  stok      = params[:stok]

  begin
    koneksi = OCI8.new('sistem_toko', 'rahasia123', 'localhost:1521/XEPDB1')
    sql_simpan = "INSERT INTO barang_dagangan (nama_barang, deskripsi, harga, stok) VALUES (:1, :2, :3, :4)"
    koneksi.exec(sql_simpan, nama, deskripsi, harga, stok)
    koneksi.commit
  ensure
    koneksi.logoff if koneksi
  end
  redirect '/'
end

<form action="/simpan" method="POST">
    <label>Nama Barang:</label>
    <input type="text" name="nama_barang" required>
    
    <label>Harga:</label>
    <input type="number" name="harga" required>
    
    <button type="submit">💾 Simpan ke Database</button>
</form>

helpers do
  def satpam_jaga!
    return if authorized?
    headers['WWW-Authenticate'] = 'Basic realm="Gudang Rahasia"'
    halt 401, "Akses Ditolak, Cing!\n"
  end

  def authorized?
    @auth ||= Rack::Auth::Basic::Request.new(request.env)
    @auth.provided? && @auth.basic? && @auth.credentials && @auth.credentials == ['admin', 'rahasia123']
  end
end

get '/tambah' do
  satpam_jaga! # Panggil satpam di mari!
  erb :tambah_barang
end

get '/' do
  @daftar_barang = []
  kata_kunci = params[:cari]

  begin
    koneksi = OCI8.new('sistem_toko', 'rahasia123', 'localhost:1521/XEPDB1')
    
    if kata_kunci && !kata_kunci.strip.empty?
      sql_tarik = "SELECT id, nama_barang, deskripsi, harga, stok FROM barang_dagangan 
                   WHERE LOWER(nama_barang) LIKE :1 ORDER BY id ASC"
      pencarian_aman = "%#{kata_kunci.downcase}%"
      kursor = koneksi.exec(sql_tarik, pencarian_aman)
    else
      sql_tarik = "SELECT id, nama_barang, deskripsi, harga, stok FROM barang_dagangan ORDER BY id ASC"
      kursor = koneksi.exec(sql_tarik)
    end

    # Looping data kursor kayak biasa...
  end
end