package main_package;
          
import java.sql.Connection;
import java.sql.DriverManager;

public class DataBaseConnection
{  

	final static private String myurl="jdbc:mysql://localhost:3306/";
	final static private String mydrivar="com.mysql.jdbc.Driver";

//	final static private String mydb="rro";
//	final static private String password="123456";
//	final static private String username="root";
    
//	final static private String mydb="satveera_db"; 
//	final static private String password="IXA$1js~-zxy";
//	final static private String username="satveera_user";
    
//	final static private String mydb="vinayak_db"; 
//	final static private String password="n+BLdR,gt.Jq";
//	final static private String username="vinayak_user";  
    
//	final static private String mydb="dwarika_db"; 
//	final static private String password="XHcYc!KEvS?#";
//	final static private String username="dwarika_user";
    
//	final static private String mydb="kuber_db"; 
//	final static private String password="o3lB*a5ps5T{";
//	final static private String username="kuber_user";
    
//	final static private String mydb="kuber_db"; 
//	final static private String password="o3lB*a5ps5T{";
//	final static private String username="kuber_user";
    
//	final static private String mydb="hanumat_db"; 
//	final static private String password="tNta{x$g{-;Y";
//	final static private String username="hanumat_user";	
	
//	final static private String mydb="vinayak_db"; 
//	final static private String password="n+BLdR,gt.Jq";
//	final static private String username="vinayak_user";
    
//	final static private String mydb="ssmfi_db"; 
//	final static private String password="sA+t=IJ*,Lq&";
//	final static private String username="ssmfi_user";
  	
//	final static private String mydb="apaar_db"; 
//	final static private String password="1$9l,]=WK%ev";
//	final static private String username="apaar_user";
	
//	final static private String mydb="kuber_db"; 
//	final static private String password="o3lB*a5ps5T{";
//	final static private String username="kuber_user";
    
//	final static private String mydb="hanumat_db"; 
//	final static private String password="tNta{x$g{-;Y";
//	final static private String username="hanumat_user";
    
//	final static private String mydb="coinsoft_db"; 
//	final static private String password="MSfIaN2V42e(";
//	final static private String username="coinsoft_user";

//	final static private String mydb="nagana_db"; 
//	final static private String password="_sN)p.]P=4_8";
//	final static private String username="nagana_user";
    
//	final static private String mydb="finko_db"; 
//	final static private String password="S6-436e?-ZT9";
//	final static private String username="finko_user";
	
//	final static private String mydb="satveera_db"; 
//	final static private String password="IXA$1js~-zxy";
//	final static private String username="satveera_user";

//	final static private String mydb="satveera_db"; 
//	final static private String password="IXA$1js~-zxy";
//	final static private String username="satveera_user";
    
//	final static private String mydb="devkripa_db"; 
//	final static private String password="aL!IZrs5f";
//	final static private String username="devkripa_user";
    
//	final static private String mydb="sudershana_db"; 
//	final static private String password="*+E8;f,he.WG";
//	final static private String username="sudershana_user";
    
//	final static private String mydb="tamanna_db"; 
//	final static private String password="{4xK{gpV3^-^";
//	final static private String username="tamanna_user";
    
//	final static private String mydb="mkmicro_db"; 
//	final static private String password="tH2[ro%eOwwb";
//	final static private String username="mkmicro_user";
	 
//	final static private String mydb="umidsoft_db"; 
//	final static private String password="c%-O+lNz,x&*";
//	final static private String username="umidsoft_user";
		
//	final static private String mydb="finazone_db"; 
//	final static private String password=")f}yH5J_$F3U";
//	final static private String username="finazone_user";	 // 304.FINAZONE ONLINE MICRO, JAIPUR 19-JULY-2023
	
//	final static private String mydb="scaleup_db"; 
//	final static private String password="F4=e~Q8bt#]7";
//	final static private String username="scaleup_user";
	
//	final static private String mydb="vandana_db"; 
//	final static private String password="-}Xzh@UHL9ka"; 
	
//	final static private String username="vandana_user";	
    
//    final static private String mydb="delights_db";       
//	final static private String password="]yYLVEF4$H~e";
//	final static private String username="delights_user";     // DELIGHTS MICRO CREDIT SOFT 25/05/2025 
	
//	final static private String mydb="sunlog_db"; 
//	final static private String password="Pq!nu,hDtJ3D";
//	final static private String username="sunlog_user"; 
	
//	final static private String mydb="gwitapi_temp";  
//	final static private String password="HFJa$()lTWjI";
//	final static private String username="gwitapi_tuser";   // TEMP SHIFT ON GWIT API SERVER 09/05/2025
	
//	final static private String mydb="gwitapi_demo";   
//	final static private String password="-##BGi2ka^rc";
//	final static private String username="gwitapi_duser";   // GWIT DEMO SOFT 20/05/2025
    
//	final static private String mydb="royalmfi_db";   
//	final static private String password=".^M[jrp)keA3";
//	final static private String username="royalmfi_user";   // ROYAL MICRO FINANCE SOFT 28/05/2025
	
//	final static private String mydb="umidsoft_db"; 
//	final static private String password="c%-O+lNz,x&*";
//	final static private String username="umidsoft_user";	
	
	// 28 JAN 2026  KUCHAMAN CITY
//		final static private String mydb="dhakasof1_db"; 
//	final static private String password="#v*deOb^2JaovIwX";
//	final static private String username="dhakasof1_user";
	
//	final static private String mydb="surnathm1_db"; 
//	final static private String password="NRhYTU6c*+,_r/^C";
//	final static private String username="surnathm1_user";     // 30 JAN 2026 TELANGANA 
    
//	final static private String mydb="kuberversha_db"; 
//	final static private String password="wmpWQ]4FRjcc";
//	final static private String username="kuberversha_user"; //      10 FEB 2026 KUBERVERSHA OLD TO NEW 
	
//	final static private String mydb="radiance2_db"; 
//	final static private String password="Rquua,K0&f0&sr7u";
//	final static private String username="radiance2_user";      // 11 FEB 2026  RADIANCE 
	
//	final static private String mydb="ssmicros1_db"; 
//	final static private String password="CLXSsCrh9dRm^z'!";
//	final static private String username="ssmicros1_user";      // 11 FEB SS MICRO 
    
//	final static private String mydb="gainpaym1_db"; 
//	final static private String password="To,L:YJ3XhKrjcQ#";
//	final static private String username="gainpaym1_user";    // 17 FEB 2026
	
//	final static private String mydb="trpmicro_db"; 
//	final static private String password="[69p(JAJ o2h=Bf*j";
//	final static private String username="trpmicro_user";     // 30 MARCH 2026
    
//	final static private String mydb="skfsoft_db"; 
//	final static private String password=")Kz3W4WXrI%K";
//	final static private String username="skfsoft_user";    // 30 MARCH 2026
	
//	final static private String mydb="vasuprad1_db"; 
//	final static private String password="9k^0T#'@S8bcuRY2";
//	final static private String username="vasuprad1_user"; 
	
//	final static private String mydb="silverro1_db"; 
//	final static private String password="M-5PjqwG_J$CCvi2";
//	final static private String username="silverro1_user";     // 5 MARCH 2026 SILVER ROCK
	
//	final static private String mydb="divyagur1_db"; 
//	final static private String password="B.LINL8TldzYl&cU";
//	final static private String username="divyagur1_user"; 
	
//	final static private String mydb="divyamicro_db"; 
//	final static private String password="C5r,iV{[Em6keVYK";
//	final static private String username="divyamicro_user"; 
	
//	final static private String mydb="gkfcmicro_audit"; 
//	final static private String password="A6fZRas$l";
//	final static private String username="gkfcmicro_auser";
	 
//	final static private String mydb="suncity_db"; 
//	final static private String password="^.B{x#kasK{3#Z-T";
//	final static private String username="suncity_user";
	
//	final static private String mydb="vibhumf_db"; 
//	final static private String password="tP$%02nPN&^!"; 
//	final static private String username="vibhumf_user";  // 13-06-2026  vibhu micro finance
	
//	final static private String mydb="uvajagriti_db"; 
//	final static private String password=",wwU^DInMjYj_0.V"; 
//	final static private String username="uvajagriti_user";      // 
	
//	final static private String mydb="bgsfc_db"; 
//	final static private String password="rG,.V}-WPj,Q7?Fu"; 
//	final static private String username="bgsfc_user";       // 26 june 2026   bg small finance
	 
//	final static private String mydb="sooryavansh_db"; 
//	final static private String password="a)cp!zWeZ036!~Vp"; 
//	final static private String username="sooryavansh_user"; // 30-06-2026   sooryavansh finance
	
//	final static private String mydb="bhawanamicro_db"; 
//	final static private String password="VBSAF$M(.Kh={*)l"; 
//	final static private String username="bhawanamicro_user"; // // bhawana micro finance
	
//	final static private String mydb="sahyog_db"; 
//	final static private String password="nCvFJ-%k}}@u4U+?"; 
//	final static private String username="sahyog_user";
	
//	final static private String mydb="bhawanamicro_db"; 
//	final static private String password="VBSAF$M(.Kh={*)l"; 
//	final static private String username="bhawanamicro_user";
	
//	final static private String mydb="parmarmfi_db"; 
//	final static private String password="gbz0o2H*W97m+duI";
//	final static private String username="parmarmfi_user";      // parmar mfi 17-07-2026
	
//	final static private String mydb="srmfisoft_db"; 
//	final static private String password="zCmEvY7At.tt@Cf8";
//	final static private String username="srmfisoft_user";  // srmfi soft 18 july 2026
	
//	final static private String mydb="rilsoft_db"; 
//	final static private String password=",1W#wAl-LA{FCeR&";
//	final static private String username="rilsoft_user";
	
//	final static private String mydb="chakrapani_db"; 
//	final static private String password="9(zi_G%J%~0mPL?Q";
//	final static private String username="chakrapani_user";     // chakrapani 29-07-2026
	
//	final static private String mydb="deepak_branch"; 
//	final static private String password="&];YJKr8av(NDMo+";
//	final static private String username="deepak_user";
	
//	final static private String mydb="toppersmfi_db"; 
//	final static private String password="Xy~#o5.GGaopqdtZ";
//	final static private String username="toppersmfi_user";     // 07-09-2026
	
//	final static private String mydb="cashbull_db"; 
//	final static private String password="i;d{X4pEI4UsMyn[";
//	final static private String username="cashbull_user";     // 18-11-2026
	
	final static private String mydb="gtfmicro_db"; 
	final static private String password="mBFnvLNG-LhV;4Ra";
	final static private String username="gtfmicro_user";   
	
	private static DataBaseConnection instance = new DataBaseConnection();
	
	private DataBaseConnection()
	{	
		try{
			Class.forName(mydrivar);
		}
		catch(ClassNotFoundException e){
			e.printStackTrace();
		}
	}
	
	private Connection createConnection()
	{
		Connection conn=null;
		try
		{
			conn = DriverManager.getConnection(
				    myurl + mydb +
				    "?useSSL=false&characterEncoding=UTF-8&serverTimezone=UTC&allowPublicKeyRetrieval=true",				    
				    username,
				    password
				);
			}
		catch(Exception e) 
		{
			e.printStackTrace();
		}
		return conn;
	}
	
	public static Connection JAVAConnection() 
	{		
		return instance.createConnection();
	}
	
	public static String getDatabaseUrl() {
	    return myurl + mydb;
	}

	public static String getUsername() {
	    return username;
	}

	public static String getPassword() {
	    return password;
	}
}