wHuZZup gUys!!

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

 

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

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

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();
  }
}

duuuuuuuuuuuuuh uTS gue ancuur mudah2an UASnya bisa ngebantu amiin

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.

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!!!!.

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