×

Welcome to TagMyCode

Please login or create account to add a snippet.
 

DBConnector.java

0
0
 
0
Language: Java
Posted by: Pascal Surget
Added: Sep 17, 2018 10:39 PM
Views: 3379
Tags: dbmanager jdbc method mssql mysql
  1. public String DBConn(String servType, String servAddr, String DBname, int CustPort, Boolean ssl) {
  2.                 switch (servType) {
  3.                 case "mysql":
  4.                         UrlSch = "jdbc:mysql://";
  5.                         servAddr = ((servAddr == null) ? "localhost" : servAddr);
  6.                         port = ((CustPort == 0) ? 3306 : CustPort);
  7.                         break;
  8.  
  9.                 case "mssql":
  10.                         UrlSch = "jdbc:mssql://";
  11.                         servAddr = ((servAddr == null) ? "localhost" : servAddr);
  12.                         port = ((CustPort == 0) ? 1433 : CustPort);
  13.                         break;
  14.                 }
  15.  
  16.                 return UrlSch + servAddr + ":" + port + "/" + DBname + "?useSSL=" + ssl + "&serverTimezone=UTC";
  17.  
  18.         }

Write a comment

To post comments, please log in or register.