[JUG-Indonesia] Koneksi Java dengan database secara dinamis

[satria ardi]

Saya punya source code untuk membuat koneksi java secara dinamis sbg berikut

File SelectResource.properties untuk mengatur koneksi

Driver=com.mysql.jdbc.Driver
URL=jdbc:msql://192.168.123.2/Alamat

Connect.java

import java.sql.*;
import java.util.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;


public class Connect {
    public static void main(String argv[]) {
        Connection con = null;
        ResourceBundle bundle = 
ResourceBundle.getBundle("SelectResource");//MEMANGGIL .PROPERTIES

        try {
          String url = bundle.getString("URL");//dari .properties
            Statement stmt;
            ResultSet rs;
            try {
                Class.forName("com.mysql.jdbc..Driver");
            } catch (ClassNotFoundException ex) {
                Logger.getLogger(Connect.class.getName()).log(Level.SEVERE, 
null, ex);
            }
            // here is where the connection is made
            con = DriverManager.getConnection(url, "kargo", "invoice");
        }
        catch( SQLException e ) {
            e.printStackTrace();
        }
        finally {
            if( con != null ) {
                try { con.close();
                System.out.println("dada");
                }
                catch( Exception e ) { }
            }
        }
    }
}

Ketika di compile muncul error sebagai berikut:

init:
deps-module-jar:
deps-ear-jar:
deps-jar:
compile-single:
run-main:
Exception in thread "main" java.util.MissingResourceException: Can't find 
bundle for base name SelectResource, locale en_US
        at 
java.util.ResourceBundle.throwMissingResourceException(ResourceBundle.java:1521)
        at java.util.ResourceBundle.getBundleImpl(ResourceBundle.java:1260)
        at java.util.ResourceBundle.getBundle(ResourceBundle.java:715)
        at Connect.main(Connect.java:21)
Java Result: 1
BUILD SUCCESSFUL (total time: 0 seconds)



Kira - kira kenapa ?






      Mulai chatting dengan teman di Yahoo! Pingbox baru sekarang!! Membuat 
tempat chat pribadi di blog Anda sekarang sangatlah mudah. 
http://id.messenger.yahoo.com/pingbox/