September 22, 2008

Netbeans + mysql dengan ‘klak-klik’

Filed under: Uncategorized

Jika dalam keseharian anda sering mengalami kesulitan dalam mengcoding bahasa pemrograman seperti java, kali ini saya akan menunjukan betapa mengasyikanya mengcoding dengan java kali ini saya akan menggunakan editor Netbeans 6.1


Lalu next dan akan keluar tampilan seperti ini pilih lah java desktop application Disini anda bebas dalam memilih nama lalu pilihlah database application


 

April 23, 2008

the power of oracle

Filed under: Uncategorized

Hmm newBie nih di Oracle…disini kita saling sharing ilmu aja yaaaa
hmm berikut adalah sintak klo mo bikin user di oracle dan bagaimana user tersebut bisa dilihat oleh orang lain dengan membukanya dari user milik pribadi.

sql>create user ditta identified by permen;
sql>grant connect, resource to ditta;
grant connect

lalu misal kita ingin meilhat isi tabel dari user ditta

sql>grant connect penjualan to ditta;
grant connected
sql>connect system/ditta;
connected
sql>select * from ditta.penjualan;

nah selamat mencoba

January 29, 2008

triger on oracle

Filed under: Uncategorized

kadang dalam suatu DBMS untuk memainipulasi data tuh complecated banget nahh disini deh peran triger untuk membackup data2 yang kita buat..nah mariii kita belajar triger

CREATE [OR REPLACE] TRIGGER <trigger_name>
	
    {BEFORE|AFTER} {INSERT|DELETE|UPDATE} ON <table_name>
	
    [REFERENCING [NEW AS <new_row_name>] [OLD AS <old_row_name>]]
	
    [FOR EACH ROW [WHEN (<trigger_condition>)]] 

 nah data diatas adalah contoh simple klo kita mau bikin triger..selamat mencoba

January 26, 2008

Koneksi Oracle JDBC

Filed under: Uncategorized

Berhubung karena pernah hampir lupa gimana caranya konekin oracle di java jadinya tulis aja deh daripada lupa

import java.sql.*;
class dbAccess {
  public static void main (String args []) throws SQLException
  {
        DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());

        Connection conn = DriverManager.getConnection
             ("jdbc:oracle:thin:@hostname:1526:orcl", "scott", "tiger");
                             // @machineName:port:SID,   userid,  password

        Statement stmt = conn.createStatement();
        ResultSet rset = stmt.executeQuery("select BANNER from SYS.V_$VERSION");
        while (rset.next())
              System.out.println (rset.getString(1));   // Print col 1
        stmt.close();
  }
}

January 8, 2008

UJIAN

Filed under: Uncategorized

duuuuuuuuuuuuuh uTS gue ancuur mudah2an UASnya bisa ngebantu amiin

November 20, 2007

Vietnam I’m in Love

Filed under: Uncategorized

5 days in vietnam has given me a lot of memories, especially with the guys there they were so friendly to us well i think all of the vietnamese people were friendly to us.I become more realize that english is very necessery, you could be anything you want if you can speak english fluently.Vietnam was not as bad as i thought before especially with the traffic, its not traffic at all there and there wa no pollution.

November 12, 2007

what a bad day

Filed under: Uncategorized

on  tuesday i wrote an english test, i thought it’s not difficult at all then I gave it to my lecture BUT YOU KNOW WHAT!! I didnt realize that in paragraph that make the paragraph, i didnt make it into a correct sentences i thought i just had to make a paragraph,thats all, BUT actually i had to make it into a paragraph an make it into a correct sentences like which sentence that i have to use the 3. person or something like that, what a stupid!!!!.emoticon

and my lecture said that i had so many mistakes ooooh god, now I understand that somebody are not allow to be conceited, you just have to be humble so god will give you the best emoticon