JDBC ODBC bridge
Ini contoh program menggunakan database access.
(ini ga' pake driver, tapi sebenarnya ga disarankan. bisa mengganggu JVMnya. ga' disarankan juga pake access, mending pake MySQL ato Derby. lebih stabil pake java)
import java.sql.*;
public class JDBCTest01 {
public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // step1
} catch (ClassNotFoundException cnfe) {
System.err.println(cnfe);
} catch (Exception E) {
E.printStackTrace();
} // end catch
try {
conn = DriverManager.getConnection("jdbc:odbc:db1");
// step 2 and 3
stmt = conn.createStatement(); // step 4
rs = stmt.executeQuery("SELECT * FROM tabel02");
while (rs.next()) { // step 6
System.out.print(rs.getString("Nomer") + " ");
System.out.print(rs.getString("Judul") + " ");
System.out.print(rs.getString("Pengarang") + " ");
System.out.print(rs.getString("Penerbit") + " ");
System.out.print(rs.getString("harga") + " ");
System.out.println("Oke");
} // while
stmt.close();
conn.close();
} catch(SQLException sqle) {
System.err.println("SQLException : " + sqle.getMessage());
} // end cacth
}
}
Selamat mencoba dan selamat ngerjain tugasnya pak adi..
cheers.
07.21 | | 0 Comments