Java – Connection String Oracle / MS-SQL / MY-SQL

Oracle

 
String databaseName = “jdbc:oracle:thin:@10.178.18.26:1521:ORCL”;
String userName = “lims”;
String password = “Admin123″;
Connection jdbcConnection = null;
jdbcConnection = DriverManager.getConnection(databaseName,userName,password);

mySQL

String databaseName = “jdbc:mysql://10.178.18.26:3306/lims”;
String userName = “root”;
String password = “Admin123″;
Connection jdbcConnection = null;
jdbcConnection = DriverManager.getConnection(databaseName,userName,password);

ms-SQL
String databaseName = “jdbc:sqlserver://10.178.18.26;Database=limstest;user=lims;Password=Admin123″;
String userName = “lims”;
String password = “Admin123″;
Connection jdbcConnection = null;
jdbcConnection = DriverManager.getConnection(databaseName,userName,password);

Advertisement