Kamis, 25 November 2010

contoh koneksi ke oracle dgn java via odbc


import java.sql.*;

class ConODBCOracle{
public static void main(String[] args){
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:OdbcOracle","SYSMAN","admin");
con.close();
System.out.println("Koneksi ke Database Oracle via ODBC berhasil..!!!");
System.exit(0);
}
catch(ClassNotFoundException eclass){
System.out.println("Driver tidak ada");
}
catch(SQLException esql){
System.out.println(esql.getMessage());
}
}
}

Selengkapnya...

contoh koneksi ke my. sql dgn java via odbc


import java.sql.*;

class ConOdbcMySQL {
public static void main(String[] args) {
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:ConnectMySQL","root","");
con.close();
System.out.println("Koneksi ke Server MySQL via ODBC berhasil....!!!");
System.exit(0);
}
catch(ClassNotFoundException eclass) {
System.out.println("Driver tidak ada");
}
catch(SQLException esql){
System.out.println(esql.getMessage());
}
}
}

Selengkapnya...