How to connect Android with MySQL using Mysql JDBC driver [duplicate]

by

If you want to connect to Mysql database from Android you just need to follow these steps:

  • Download the driver mysql-connector-java-3.0.17-ga-bin.jar
  • Paste it to the folder libs in your android project.
  • Click ConfigureBuildPath->add jar to include the jar to the project.
  • Now you have the driver, but you also need to give permissions in the androidManifest.xml for INTERNET.

  • Use the next code for connecting:

    try{
    Class.forName("com.mysql.jdbc.Driver").newInstance();
}catch(Exception e){
    System.err.println("Cannot create connection");
}
try{
    connection = DriverManager.getConnection("jdbc:mysql://192.168.xx.xx:3306/dbname","root","password");
    Statement statement = connection.createStatement();

    String query = "SELECT column1, column2 FROM table1 WHERE column3 = ";
    query = query +"'" +variable+"'";           
    ResultSet result = statement.executeQuery(query);
}catch(Exception e){
    System.err.println("Error");
}

Advice: If the instance of the drivers doesn’t give any errors but you get an exception with the connection you should try to remove the Target SDK version from your manifest, as for some versions this gives problems.

More Related Contents:

  1. Android: If statement being skipped even if condition is correct
  2. Can we connect remote MySQL database in Android using JDBC? [closed]
  3. Android JDBC not working: ClassNotFoundException on driver
  4. Been staring at my code for an hour and still can't see the issue. Android – Java development [closed]
  5. SQL syntax error in "insert into 'keys'(a,b,c,d,e) values(?,?,?,?,?)" [closed]
  6. NullPointerException in onPostExecute [duplicate]
  7. Setting Singleton property value in Firebase Listener
  8. How can I pass a Bitmap object from one activity to another
  9. Java: Insert multiple rows into MySQL with PreparedStatement
  10. Android: checkbox listener
  11. This app is not authorized to use Firebase Authentication.Please verify that the correct package name and SHA-1 are configured in the Firebase Console
  12. Android: Sending data >20 bytes by BLE
  13. Using Retrofit in Android
  14. Convert seconds value to hours minutes seconds?
  15. Duplicated entries in ListView
  16. Android – Activity Constructor vs onCreate
  17. Round to 2 decimal places [duplicate]
  18. Why use Enums instead of Constants? Which is better in terms of software design and readability
  19. multiple dex files define landroid/support/annotation/AnimRes
  20. Android – Get value from HashMap
  21. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  22. Android Retrofit Design Patterns
  23. Android HTML.fromHTML() with images?
  24. How to correctly write UTF-8 strings into MySQL through JDBC interface
  25. How to add headers to OkHttp request interceptor?
  26. AAPT: error: resource android:attr/fontVariationSettings not found and resource android:attr/ttcIndex not found
  27. How to speed up unzipping time in Java / Android?
  28. How can i replace type_orientation (is deprecated) for android 4.0.3?
  29. Pause the timer and then continue it [duplicate]
  30. calculate number of weeks in a given year

Leave a Comment