-1

Hello i'm getting a coding problem in my class for some reason. i'm trying to connect between the database and the netbeans but keep getting the error mentioned above in the title

mainly this is the class getting the error :

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBHandler extends Configs {

   Connection dbconnection;
   
   public Connection getConnection()
   {
       String connectionString = "jdbc:mysql://"+ Configs.dbhost + ":" + Configs.dbport + "/" + Configs.dbname;
       
       try {
           Class.forName("com.mysql.jdbc.Driver");
       } catch (ClassNotFoundException e) {
           e.printStackTrace();
       }
       
         try {
           dbconnection = DriverManager.getConnection(connectionString,Configs.dbuser,Configs.dbpass);
       } catch (SQLException e) {
           e.printStackTrace();
       }
        
       return dbconnection;
       
   }
   
   
}

this is the sub class of Configs ^ which is very simple so far here it is :

public class Configs {
    protected String dbhost  = "a host";
    protected String dbport = "a port";
    protected String dbuser = "a user";
    protected String dbpass = "a password";
    protected String dbname = "a name";
    
}

will add more to configs but after i figure out how to fix the error i'm getting (got the mysql library imported btw)

Fady Mohamed Elganzoury
  • 29
  • 7
  • 1
    `dbhost` etc are *instance* fields, which means you need to have an instance of `Configs` in order to get at the fields for that particular instance. You're referring to just `Configs.dbhost` which isn't a specific instance. – Jon Skeet May 18 '21 at 18:05

1 Answers1

0

Use 'this' instead of the 'Configs' in the getConnection method. e.g. 'this.dbhost', etc

The syntax you use for accessing static variables

Vitaliy Yakovchuk
  • 493
  • 2
  • 5