AIzaSyCSBAtE3BpAxQTGlq481leTTYyd4sj4Om0
Navigate Advanced topic: ) |
Java uses JDBC, an API that defines how a client may access a database. Its drivers may be installed first. [1][2]
The following is used to open an ODBC connection to an Access database. Note that the username (and password, if applicable) are given in the DSN rather than the getConnection
call. This is a MS Windows-only example, due to the requirement for the Microsoft Access Driver.
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String path = "C:/example.mdb";
String dsn = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" + path + ";UID=admin";
accessConn = DriverManager.getConnection(dsn, "", "");
try {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/MySite?user=MyAccount&password=MyPassword");
conn.close;
} catch(SQLException e) { e.printStackTrace; }
This script returns the database size:
import java.sql.*;
import java.io.*;
import oracle.jdbc.*;
import oracle.sql.*;
public class OracleDatabase {
public static void main(String[] args) {
try {
DriverManager.registerDriver(new oracle.jdbc.OracleDriver);
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:MyDatabase", "MyAccount", "MyPassword");
conn.setAutoCommit(true);
String sql = "SELECT sum(bytes) from dba_segments;";
Statement stmt = conn.createStatement;
stmt.execute(sql);
stmt.close;
conn.close;
} catch(SQLException e) { e.printStackTrace; }
}
}
try {
Class.forName("org.postgresql.Driver");
Connection conn = DriverManager.getConnection("jdbc:postgresql:MyDatabase", "MyAccount", "MyPassword");
conn.close;
} catch(SQLException e) { e.printStackTrace; }
If you have Oracle Database on your PC, just add to the classpath its following files[3]:
Otherwise, ojdbc7.jar can be downloaded from http://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html, and add it to the compilation. Eg:
javac MyClass.java -classpath ojdbc7.jar
Just add " as sysdba" after your Oracle account name, eg:
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:MyDatabase", "MyAccount as sysdba",
Manage research, learning and skills at defaultLogic. Create an account using LinkedIn or facebook to manage and organize your Digital Marketing and Technology knowledge. defaultLogic works like a shopping cart for information -- helping you to save, discuss and share.
Visit defaultLogic's partner sites below: