Connection Error with the Database in ANDROID

1

I created a database on localhost, and wanted to pull this database to my Android, I created two classes, CONEXAODAO, and ConnectionMYSQL:

public class conexaoDAO {

    public String tabelaDepartamento () {
        String departamentoNome = "";

        conexaoMysqlActivity conexao = new conexaoMysqlActivity();
        conexaoActivity objConexao = new conexaoActivity();

        objConexao.db_connect_string = "localhost";
        objConexao.db_name = "souprogresso";
        objConexao.db_userid = "root";
        objConexao.db_password = "";
        Connection conn = conexao.dbConnect(objConexao);
        if (conn != null) {
            try {
                   Statement statement = conn.createStatement();
                   String queryString = "SELECT nomeDepartamento, idprefeituraDepartamento FROM departamento WHERE idprefeituraDepartamento = '1'";
                   ResultSet rs;
                   rs = statement.executeQuery(queryString);
                   if (rs.next()) {
                       departamentoNome = rs.getString("nomeDepartamento");
                       System.out.println(departamentoNome);
                   }
            } catch (SQLException e) {
                departamentoNome = e.getMessage();
            }
        }
        return departamentoNome;
    }

}


public class conexaoMysqlActivity {
     @SuppressLint("NewApi")
     public Connection dbConnect(conexaoActivity objConexao) {
          StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
          StrictMode.setThreadPolicy(policy);
          Connection conn = null;
          String connectionUrl = null;

          try {
              Class.forName("com.mysql.jdbc.Driver");
              connectionUrl = "jdbc:mysql://" + 
                      objConexao.db_connect_string + ";" +
                      "databaseName=" + objConexao.db_name + ";user=" 
                      +objConexao.db_userid + 
                      ";password=" +  objConexao.db_password + ";";
              conn = DriverManager.getConnection(connectionUrl);

          } catch (SQLException se) {
              se.printStackTrace();
              System.out.println("Não foi possível se conectar com a base de dados");
          } catch (ClassNotFoundException e) {
              e.printStackTrace();
              System.out.println("Erro de Classe SQL");
          } catch (Exception se) {
              se.printStackTrace();
              System.out.println("Erro de Expressão");
          }
          return conn;
     }
}

When I try to run the following error occurs:

08-14 17:48:30.149: E/AndroidRuntime(674): FATAL EXCEPTION: main
08-14 17:48:30.149: E/AndroidRuntime(674): java.lang.RuntimeException: Unable to instantiate activity ComponentInfo{br.com.example.secretario/br.com.example.secretario.conexaoMysqlActivity}: java.lang.ClassCastException: br.com.example.secretario.conexaoMysqlActivity cannot be cast to android.app.Activity
08-14 17:48:30.149: E/AndroidRuntime(674):  at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1880)
08-14 17:48:30.149: E/AndroidRuntime(674):  at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1981)
08-14 17:48:30.149: E/AndroidRuntime(674):  at android.app.ActivityThread.access$600(ActivityThread.java:123)
08-14 17:48:30.149: E/AndroidRuntime(674):  at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1147)
08-14 17:48:30.149: E/AndroidRuntime(674):  at android.os.Handler.dispatchMessage(Handler.java:99)
08-14 17:48:30.149: E/AndroidRuntime(674):  at android.os.Looper.loop(Looper.java:137)
08-14 17:48:30.149: E/AndroidRuntime(674):  at android.app.ActivityThread.main(ActivityThread.java:4424)
08-14 17:48:30.149: E/AndroidRuntime(674):  at java.lang.reflect.Method.invokeNative(Native Method)
08-14 17:48:30.149: E/AndroidRuntime(674):  at java.lang.reflect.Method.invoke(Method.java:511)
08-14 17:48:30.149: E/AndroidRuntime(674):  at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)
08-14 17:48:30.149: E/AndroidRuntime(674):  at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551)
08-14 17:48:30.149: E/AndroidRuntime(674):  at dalvik.system.NativeStart.main(Native Method)
08-14 17:48:30.149: E/AndroidRuntime(674): Caused by: java.lang.ClassCastException: br.com.example.secretario.conexaoMysqlActivity cannot be cast to android.app.Activity
08-14 17:48:30.149: E/AndroidRuntime(674):  at android.app.Instrumentation.newActivity(Instrumentation.java:1023)
08-14 17:48:30.149: E/AndroidRuntime(674):  at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1871)
    
asked by anonymous 14.08.2015 / 19:55

1 answer

-1

Failed to extend Activity :

public class conexaoMysqlActivity extends Activity {  
    
14.08.2015 / 21:12