[FIXED] How can I get the values from the main method to be accessed by the getConnection method?

Issue

I am trying to get the values that the main method would have produced and use them in the getConnection method. However when I try to access the getConnection method, null values are being returned.

I want to use the ConnectionManager class to connect to the database.

Code below.

public class ConnectionManager {

    public static String database;    
    public static String dbuser;
    public static String dbpassword;

    public static void main(String args[])  {

        Properties prop = new Properties();
        InputStream input = null;

        try {
            input = new FileInputStream("config.properties");

            // load a properties file
            prop.load(input);

            database = prop.getProperty("database");
            dbuser = prop.getProperty("dbuser");
            dbpassword = prop.getProperty("dbpassword");

            System.out.println(database);
        } catch (IOException ex) {
            ex.printStackTrace();
        } finally {
            if (input != null) {
                try {
                    input.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }
    }


    public static String url = "jdbc:mysql://localhost:3306/" + database;    
    private static String driverName = "com.mysql.jdbc.Driver";   
    private static String username = dbuser;   
    private static String password = dbpassword;
    private static Connection con;

    public static Connection getConnection() {

        try {
            Class.forName(driverName);
            try {
                con = DriverManager.getConnection(url, username, password);
            } catch (SQLException ex) {
                // log an exception. For example:
                System.out.println("Failed to create the database connection."); 
                System.out.println(url + " " + username + " " + password);
            }
        } catch (ClassNotFoundException ex) {
            System.out.println("Your driver has not been found."); 
        }
        return con;
    }
}

Solution

You just have to call the getConnection() method with parameters.

public static Connection getConnection(String url, String username, String password) {
    /* Your code here */
}

And then, call this method.

Connection connection = getConnection(url, username, password);

Answered By - 0ddlyoko