ceolkp.blogg.se

Ps： I use the installation package provided by the teacher, The version is different. Two 、 Install database management tools navicatĭownload Navicat（ For permanent use, you need to buy ）： Wait for the installation of each component.

To Official website download mysql（ I use the installation package issued by the teacher, The version may be different ）Ĭlick on msi file, The version is mysql5.7. 2.IDEA establish java project, Import.Two 、 Install database management tools navicat.

This assumes your MySQL server is installed and configured on your computer with IP address 192.168.1.10ĮDIT: I can't really recommend this approach for a production application though, because I'm afraid what a hacker who can decompile your code can do with it. So, what you may want to see is something like. This goes without saying that you must use the IP of that computer and have the MySQL port (3306) open on your computer. Now I don't know if you can install MySQL on Android, but you may want to install a MySQL server on your computer. īy specifying 127.0.0.1 on your Android device, you're trying to connect to a MySQL server on your device. But first, you have a ClassNotFound exception, which means you haven't imported the library.Īnd when you get the driver to work, there's more problem in this part. I assume you're trying to directly connect to a MySQL database from your Android device. : No suitable driver found forĪt (DriverManager.java:689)Īt (DriverManager.java:247)Īt MySQLConnectionExample.main(MySQLConnectionExample.java:22) When I remove "Class.forName("")" from the program this is the error i get An error occurred. Error after execution : Īt (URLClassLoader.java:381)Īt (ClassLoader.java:424)Īt $AppClassLoader.loadClass(Launcher.java:335)Īt (ClassLoader.java:357)Īt 0(Native Method)Īt (Class.java:264)Īt MySQLConnectionExample.main(MySQLConnectionExample.java:16) PreparedStatement prest = conn1.prepareStatement(sql) String sql = " select address from pharmacy" String url1 = "jdbc:mysql://127.0.0.1:3306/demo" Ĭonn1 = DriverManager.getConnection(url1, user, password) I'm new to Android Studio and I hope you don't consider my question silly.I am trying to write a small program in the terminal of the android studio.When I try to run the same program in my terminal(not android studio) it's working fine.I added the MySQL-connector.jar file in android studio lib by going through this mysql JDBC driver to the android studio.But it didn't work.Please help me.Thanks in advance.