You need to connect to MySQL in Android Studio and create a table like this: I'm trying to do this:

try{ String url = "jdbc:mysql://localhost/qrdb"; String username = "root"; String password = "****"; Class.forName("com.mysql.cj.jdbc.Driver").getDeclaredConstructor().newInstance(); String sqlCommand = "CREATE TABLE items (Id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(20), price INT)"; try (Connection conn = DriverManager.getConnection(url, username, password)){ Statement statement = conn.createStatement(); statement.executeUpdate(sqlCommand); Log.i("mytag","Database has been created!"); } } catch(Exception ex){ Log.i("mytag","Connection failed..."); Log.i("mytag", "" + ex); }

I run on the emulator does not issue exceptions and the application stupidly closes. In a normal java project, everything works. There probably need to replace localhost with something, but I changed it to myip: port - it did not help. MySQL Connector / J 8.0 itself is installed in the project and all classes are visible in a normal project, everything works.

  • so jdbc: mysql: //10.0.2.2: 3306 / qrdb doesn't want either - rywes

1 answer 1

Already as I answered, I will answer again

Android JDBC is very hard to get to work. There are 2 reasons:

  1. This is an anti-pattern (for Android)
  2. Many JDBC drivers (MySQL among them) use native library calls that do not work on Android.
  • What are the alternatives? I need to be deleted to connect to any database from under the android - rywes
  • REST: on the server you raise a web service that connects to the database and communicates with Android - Barmaley