JDBC Ada 7 lanhkah untuk mengakses database 1
JDBC • Ada 7 lanhkah untuk mengakses database: 1. Load the JDBC Driver 2. Define the connection URL 3. Establish the connection 4. Create a statement object 5. Execute a query or update 6. Process the result 7. Close the connection
JDBC try { // Class. for. Name("org. gjt. mm. mysql. Driver"); // Step 1 Class. for. Name("sun. jdbc. odbc. Jdbc. Odbc. Dri ver"); // step 1 } catch (Exception E) { E. print. Stack. Trace(); } // end catch
JDBC try { con = Driver. Manager. get. Connection("jdbc: odb c: Database 1"); //, "root", ""); // step 2 and 3
JDBC stmt = con. create. Statement(); // step 4 rs = stmt. execute. Query("SQL Query'"); // step 5 while (rs. next()) { // step 6 : : } // while
JDBC stmt. close(); // step 7 con. close();
Access Database • Microsoft Acess Database : db 1
Setting Access Database • Menset Database yang dipakai sebagai acuan dalam Program • Start -> Control Panel -> ODBC Data Source
Setting Access Database • Tampil jendela ODBC Data Source Administrator • Click System DSN-> Add-> pilih Driver (Microsoft Access Driver) -> Finish. Dalam hal ini kita memakai Access Database. • Tentukan Letak File Database yang digunakan
Setting Access Database • Click OK • Data base db 1 siap diakses oleh Program
JDBC Program package jdbc 01; import java. sql. *; public class JDBCTest 01 { public static void main(String[] args) { Connection conn = null; Statement stmt = null; Result. Set rs = null; try { Class. for. Name("sun. jdbc. odbc. Jdbc. Od bc. Driver"); // step 1 } catch (Class. Not. Found. Exception cnfe) { System. err. println(cnfe); } catch (Exception E) { E. print. Stack. Trace(); } // end catch try { conn = Driver. Manager. get. Connection("jdbc: odbc: db 1"); // step 2 and 3 stmt = conn. create. Statement(); // step 4 rs = stmt. execute. Query("SELECT * FROM tabel 02"); while (rs. next()) { // step 6 System. out. print(rs. get. String("Nomer") + " "); System. out. print(rs. get. String("Judul") + " "); System. out. print(rs. get. String("Pengarang") + " "); System. out. print(rs. get. String("Penerbit") + " "); System. out. print(rs. get. String("harga") + " "); System. out. println("Oke"); } // while stmt. close(); conn. close(); } catch(SQLException sqle) { System. err. println("SQLException : " + sqle. get. Message()); } // end cacth } }
JDBC Program • Hasil Program 1 Java 2 Complete Reference Patrick Naughton Mc. Graw Hill 600000 Oke 2 Distributed Systems Tanenbaum Prentice Hall 500000 Oke 3 Home Networking Bible Plumley IDG Books 375000 Oke • Bandingkan
JDBC Program dengan Access • Setting perlu dilakukan pada Control Panel, untuk menset Database yang dipakai • Pada Java Program tidak diperlukan setting apapun • Sun telah menyediakan driver secara otomatis untuk Access • Hal ini tidak berlaku untuk Sistem Database yang lain, misal: mysql, oracle, dll.
Mysql Database • Mysql dapat didownload di : www. mysql. com/downloads • Extract and Just install it: Setup. exe • Mysql terletak di C: mysql • Aktifkan mysql admin dengan double click di : C: mysqlbinwinmysqladmin
Mysql Database • Inilah tampilannya • Atau tampak di pojok kanan bawah
Mysql Database • Mysql database : test 002 • Tabel : tabel 02
Java to mysql • JDBC Driver for My. SQL dapat di-download di : www. mysql. com/downloads dengan nama : My. SQL Connector/J 2. 0. 14 • Extract ke C: • JDBC Driver akan terletak di subdirectory C: mysql-connector-java-2. 0. 14
Java to mysql • Dengan JBUILDER, buat program (class) Java misalnya : JDBCTest 01. java • Project -> Project Properties -> Path -> Required Libraries -> Add. . . -> New, tuliskan nama library-nya, misal mysql-connectorjava, click Add. . .
Java to mysql • Pilih subdirectory C: mysql-connector-java-. . . , di mana JDBC driver untuk mysql diletakkan, click OK
Java to mysql • Library yang baru akan tampak seperti pada gambar, click OK
JDBC Program package jdbc 01; import java. sql. *; public class JDBCTest 01 { public static void main(String[] args) { Connection conn = null; Statement stmt = null; Result. Set rs = null; try { Class. for. Name("org. gjt. mm. mysql. Driver"); // Step 1 } catch (Class. Not. Found. Exception cnfe) { System. err. println(cnfe); } catch (Exception E) { E. print. Stack. Trace(); } // end catch try { conn = Driver. Manager. get. Connection("jdbc: mysql: //localhost: 3306/test 002", "rsn", "risanuri"); stmt = conn. create. Statement(); // step 4 rs = stmt. execute. Query("SELECT * FROM tabel 02"); while (rs. next()) { // step 6 System. out. print(rs. get. String("Nomer") + " "); System. out. print(rs. get. String("Judul") + " "); System. out. print(rs. get. String("Pengarang") + " "); System. out. print(rs. get. String("Penerbit") + " "); System. out. print(rs. get. String("harga") + " "); System. out. println("Oke"); } // while stmt. close(); conn. close(); } catch(SQLException sqle) { System. err. println("SQLException : " + sqle. get. Message()); } // end cacth } }
Hasil JDBC mysql 1 Core Servlets and JSP Marty Hall Prentice Hall 350000 Oke 2 Java 2 Complete Reference Patrick Naughton Mc. Graw Hill 600000 Oke 3 J 2 EE Unleashed Bambara Allen Sams 600000 Oke • Bandingkan
JDBC Program dengan mysql • Setting tidak perlu dilakukan pada Control Panel • Perlu dilakukan setting pada Java Program • Driver JDBC disediakan oleh mysql dan harus di-download secara terpisah • Mysql memungkinkan memanggil Database lewat jaringan
Tambahan con = Driver. Manager. get. Connection("jdbc: mysql: //localhost: 3306/pasiendreritta", "r oot", ""); stmt = con. create. Statement(); stmt. execute. Update("INSERT INTO catatanpasien VALUES('"+ navn[0] +"', '"+ navn[1] +"', '"+ navn[2] +"', '"+ navn[3] +"', '"+ navn[4] +"', '"+ navn[5] +"'); ");
Mysql tools • Dbtools • Mysql-front
Java to mysql • Setting Classpath, prosesnya sama dengan setting classpath yang lain – Pada Win 98, Start ->Run (sysedit), kemudian pada autoexec. bat tambahkan C: mysqlconnector-java-2. 0. 14, yang merupakan letak subdir JDBC Driver
Java to mysql
Java to mysql • Compile – myjava>javac JDBCTest 01. java • Buat subdir jdbc 01 di dalam : myjava • Letakkan JDBCTest 01. class pada subdir : myjavajdbc 01 • Eksekusi – myjava>java jdbc 01. JDBCTest 01 1 Routing TCP/IP Jeff Doyle null 900000 Oke 2 Top Down Network Design Oppenheimer 0 600000 Oke 3 Java Security Jess Gams 0 500000 Oke
- Slides: 27