create table table_baru as select * from table_lama;
Selamat mencoba 😀
@bahrie_bhe
11 Sep 2013 Tinggalkan komentar
in Database
create table table_baru as select * from table_lama;
Selamat mencoba 😀
@bahrie_bhe
11 Sep 2013 Tinggalkan komentar
Store Procedure Update
create or replace PROCEDURE SP_BHE_MHS_U ( nim_in IN bhe_mhs.nim%type, name_in IN bhe_mhs.name%type, address_in IN bhe_mhs.address%type, result_cursor OUT SYS_REFCURSOR ) AS BEGIN update bhe_mhs set name =name_in, address =address_in where nim=nim_in; OPEN result_cursor FOR select 'success' as status from dual; END;
Store Procedure untuk Delete
create or replace PROCEDURE SP_BHE_MHS_D ( nim_in IN bhe_mhs.nim%type, result_cursor OUT SYS_REFCURSOR ) AS BEGIN delete from bhe_mhs where nim=nim_in; END;
Code java yang memanggilnya :
code Update
public void update(Mahasiswa o) throws SQLException { String updateMahasiswa = "{call bahrie_bhe.sp_bhe_mhs_u(?,?,?,?)}"; CallableStatement callableStatement = DatabaseUtilities.getConnection().prepareCall(updateMahasiswa); callableStatement.setString(1, o.getNim()); callableStatement.setString(2, o.getNama()); callableStatement.setString(3, o.getAlamat()); callableStatement.registerOutParameter(4, OracleTypes.CURSOR); callableStatement.executeUpdate(); }
Code java untuk delete
public void delete(String nim) throws SQLException { String deleteMahasiswa = "{call bahrie_bhe.sp_bhe_mhs_d(?,?)}"; CallableStatement callableStatement = DatabaseUtilities.getConnection().prepareCall(deleteMahasiswa); callableStatement.setString(1, nim); callableStatement.registerOutParameter(2, OracleTypes.CURSOR); callableStatement.executeUpdate(); }
insert select update delete sudah saya kasih contoh, silahkan teman2 kembangkan sendiri dalam belajar.
Selamat mencoba 😀
@bahrie_bhe
11 Sep 2013 Tinggalkan komentar
Store Procedure Select
create or replace PROCEDURE SP_BHE_MHS_S ( result_cursor OUT SYS_REFCURSOR ) AS BEGIN open result_cursor for SELECT nim nim, name nama, address alamat from bhe_mhs; END;
code java seperti dibawah ini :
public List<Mahasiswa> getAll() throws SQLException { String getMahasiswa = "{call bahrie_bhe.sp_bhe_mhs_s(?)}"; CallableStatement callableStatement = DatabaseUtilities.getConnection().prepareCall(getMahasiswa); callableStatement.registerOutParameter(1, OracleTypes.CURSOR); callableStatement.executeUpdate(); ResultSet rs = (ResultSet) callableStatement.getObject(1); List<Mahasiswa> list = new ArrayList<Mahasiswa>(); while (rs.next()) { Mahasiswa mhs = new Mahasiswa(); mhs.setNim(rs.getString("nim")); mhs.setNama(rs.getString("nama")); mhs.setAlamat(rs.getString("alamat")); list.add(mhs); } return list; }
Selamat mencoba 😀
@bahrie_bhe
10 Sep 2013 Tinggalkan komentar
table BHE_MHS didalam schema BAHRIE_BHE :
CREATE TABLE "BAHRIE_BHE"."BHE_MHS" ( "NIM" VARCHAR2(20 BYTE) NOT NULL ENABLE, "NAME" VARCHAR2(50 BYTE), "ADDRESS" VARCHAR2(100 BYTE), CONSTRAINT "BHE_MHS_PK" PRIMARY KEY ("NIM") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "BAHRI_TUTORIAL" ENABLE ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "BAHRI_TUTORIAL" ;
setelah itu bikin Store Procedure insert nya :
create or replace PROCEDURE SP_BHE_MHS_I ( nim_in IN bhe_mhs.nim%type, name_in IN bhe_mhs.name%type, address_in IN bhe_mhs.address%type, result_cursor OUT SYS_REFCURSOR ) AS BEGIN INSERT INTO bhe_mhs ( nim, name, address ) VALUES ( nim_in, name_in, address_in ); OPEN result_cursor FOR select 'success' as status from dual; EXCEPTION WHEN DUP_VAL_ON_INDEX THEN OPEN result_cursor FOR select 'error' as status from dual; END;
cara java memanggil sp tersebut dengan cara seperti dibawah ini :
public Mahasiswa insert(Mahasiswa o) throws SQLException { //use store procedure oracle String insertMahasiswa = "{call bahrie_bhe.sp_bhe_mhs_i(?,?,?,?)}"; CallableStatement callableStatement = DatabaseUtilities.getConnection().prepareCall(insertMahasiswa); callableStatement.setString(1, o.getNim()); callableStatement.setString(2, o.getNama()); callableStatement.setString(3, o.getAlamat()); callableStatement.registerOutParameter(4, OracleTypes.CURSOR); callableStatement.executeUpdate(); ResultSet rs = (ResultSet) callableStatement.getObject(4); if(rs.next()){ o.setStatus(rs.getString("status")); System.out.println(rs.getString("status")); } return o; }
Sekian tutorialnya. bila belumm paham bisa tinggalkan pesan dibawah atau mention aja di @bahrie_bhe 😀
Selamat Belajar.
06 Sep 2013 Tinggalkan komentar
Bentuk code java untuk pengecekan menggunakan algoritma Luhn dapat dilihat dibawah, code ini saya dapat dari googlecode 😀 jadi free untuk digunakan :
public class Luhn { public static boolean Check(String ccNumber) { int sum = 0; boolean alternate = false; for (int i = ccNumber.length() - 1; i >= 0; i--) { int n = Integer.parseInt(ccNumber.substring(i, i + 1)); if (alternate) { n *= 2; if (n > 9) { n = (n % 10) + 1; } } sum += n; alternate = !alternate; } return (sum % 10 == 0); } }
Selamat mencoba untuk belajar, siapa tahu bermanfaat dalam dunia kerja nantinya 😀
Untuk contoh programnya menyusul. hehe
Sumber : Google Code Luhn.java
02 Sep 2013 Tinggalkan komentar
dibawah ini adalah script yang saya bikin untuk latihan mengonekkan aplikasi java dengan store procedure yang ada di oracle. jadi setelah oracle di install, coba masuk pakai aplikasi seperti TOAD ataupun SQLDeveloper. setelah itu jalankan di editornya :
CREATE TABLESPACE "BAHRI_TUTORIAL" LOGGING DATAFILE 'D:\tutorial\oracle\BAHRI_TUTORIAL_01.DBF' SIZE 100M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE 32767M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; create user BAHRIE_BHE profile default identified by "bahrie_bhe" default tablespace BAHRI_TUTORIAL temporary tablespace TEMP account unlock; grant connect, resource to BAHRIE_BHE; GRANT UNLIMITED TABLESPACE TO BAHRIE_BHE; SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE='BAHRIE_BHE'; SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTEE='BAHRIE_BHE';
Selamat Mencoba 😀