JDBC Connection Database

It is sometimes necessary to test the connectivity of the database with JDBC, but it is always not remembered how to write. Here is a summary, for later use.

Mysql

String Driver = "Com.mysql.jdbc.Driver"; // driver name String dbname = "MyDB"= "192.168.56.50"= "3306"= "root"= "root"= "JDBC: mysql://"+ IP +": "+ Port +":/"+ dbname; // Load Driver Class.forName (driver); // connecting to a database Connection conn = drivermanager.getconnection (URL, username, password);

Oracle

String Driver = "Oracle.jdbc.driver.OracleDriver";    // driver name String dbname = "MyDB"; String IP = "192.168.56.50"; String port = "1521"; String user = "root"; String password = "root"; String url = "jdbc:oracle:thin:@" + IP + ":" + Port + ":" +dbname; // Load Database driver Class.forName (driver); // connecting to a database Connection conn  = drivermanager.getconnection (url, user, password);

JDBC Connection Database