|
|
Android连接远程数据库的避坑指南
今天用Android Studio连接数据库时候，写了个测试连接的按钮，然后连接的时候报错了，报错信息：
2021-09-07 22:45:20.433 7054-7083/cn.xuziao.faceprocess E/AndroidRuntime: FATAL EXCEPTION: Thread-113
Process: cn.xuziao.faceprocess, PID: 7054
java.lang.NoSuchMethodError: No virtual method group(Ljava/lang/String;)Ljava/lang/String; in class Ljava/util/regex/Matcher; or its super classes (declaration of 'java.util.regex.Matcher' appears in /system/framework/core-libart.jar)
at com.mysql.cj.conf.ConnectionUrlParser.isConnectionStringSupported(ConnectionUrlParser.java:152)
at com.mysql.cj.conf.ConnectionUrl.acceptsUrl(ConnectionUrl.java:317)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:186)
at java.sql.DriverManager.getConnection(DriverManager.java:179)
at java.sql.DriverManager.getConnection(DriverManager.java:213)
at cn.xuziao.faceprocess.LoginActivity$1$1.run(LoginActivity.java:38)
at java.lang.Thread.run(Thread.java:818)
然后我当时写的按钮点击执行方法片段
textView.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://172.17.9.241:3306/user_info";
String login_username = "login";
String login_password = "root";
Connection connection = DriverManager.getConnection(url, login_username, login_password);
String sql = "select username from base_info";
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(sql);
while (resultSet.next()){
Log.d(TAG, resultSet.getString(1));
}
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
Toast.makeText(LoginActivity.this, "注册中...", Toast.LENGTH_SHORT).show();
}
});
附上当时的build.gradle文件里面我导入的依赖
dependencies {
implementation 'androidx.appcompat:appcompat:1.2.0'
implementation 'com.google.android.material:material:1.3.0'
implementation 'androidx.constraintlayout:constraintlayout:2.0.4'
testImplementation 'junit:junit:4.+'
androidTestImplementation 'androidx.test.ext:junit:1.1.2'
androidTestImplementation 'androidx.test.espresso:espresso-core:3.3.0'
implementation 'mysql:mysql-connector-java:8.0.26'
}
最后一行是我引入的依赖
然后我就查到，安卓的主线程不能访问网络，具体博客：https://www.cnblogs.com/lyroge/p/3837902.html
引入后的代码：
textView.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
new Thread(new Runnable() {
@Override
public void run() {
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://172.17.9.241:3306/user_info";
String login_username = "login";
String login_password = "root";
Connection connection = DriverManager.getConnection(url, login_username, login_password);
String sql = "select username from base_info";
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(sql);
while (resultSet.next()){
Log.d(TAG, resultSet.getString(1));
}
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
}
}).start();
Toast.makeText(LoginActivity.this, "注册中...", Toast.LENGTH_SHORT).show();
}
});
然后我引入了多线程，还是报错，报错信息跟上面是一样的，那就说明问题不只主线程不能访问网络的问题，然后我就改了好久奇奇怪怪的东西，我就看到我的安卓自带的jdk版本是1.8但是我的MySQL驱动到了8，然后我就去把MySQL驱动换成了5,build.gradle依赖部分改为：
dependencies {
implementation 'androidx.appcompat:appcompat:1.2.0'
implementation 'com.google.android.material:material:1.3.0'
implementation 'androidx.constraintlayout:constraintlayout:2.0.4'
testImplementation 'junit:junit:4.+'
androidTestImplementation 'androidx.test.ext:junit:1.1.2'
androidTestImplementation 'androidx.test.espresso:espresso-core:3.3.0'
implementation 'mysql:mysql-connector-java:5.1.6'
}
然后我发现上面那个报错的问题解决了，然后报了新的错：
W/System.err: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
Last packet sent to the server was 0 ms ago.
at java.lang.reflect.Constructor.newInstance(Native Method)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2103)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at java.lang.reflect.Constructor.newInstance(Native Method)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at java.sql.DriverManager.getConnection(DriverManager.java:179)
at java.sql.DriverManager.getConnection(DriverManager.java:213)
at cn.xuziao.faceprocess.LoginActivity$1$1.run(LoginActivity.java:37)
at java.lang.Thread.run(Thread.java:818)
Caused by: java.net.UnknownHostException: Unable to resolve host &#34;172.17.9.241&#34;: No address associated with hostname
at java.net.InetAddress.lookupHostByName(InetAddress.java:470)
at java.net.InetAddress.getAllByNameImpl(InetAddress.java:252)
at java.net.InetAddress.getAllByName(InetAddress.java:215)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:243)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2026)
... 10 more
W/System.err: Caused by: android.system.GaiException: android_getaddrinfo failed: EAI_NODATA (No address associated with hostname)
at libcore.io.Posix.android_getaddrinfo(Native Method)
at libcore.io.ForwardingOs.android_getaddrinfo(ForwardingOs.java:55)
at java.net.InetAddress.lookupHostByName(InetAddress.java:451)
... 15 more
Caused by: android.system.ErrnoException: android_getaddrinfo failed: ECONNREFUSED (Connection refused)
... 18 more
这个错是被异常捕获机制捕获到的一个错误，说明MySQL驱动是成功导入而且能够使用了，然后通过查资料了解到，要解决这个错误只需要在AndroidManifest.xml文件里面加一行<uses-permission android:name=&#34;android.permission.INTERNET&#34;/>就行了
<?xml version=&#34;1.0&#34; encoding=&#34;utf-8&#34;?>
<manifest xmlns:android=&#34;http://schemas.android.com/apk/res/android&#34;
package=&#34;cn.xuziao.faceprocess&#34;>
<!--要加在application标签的上面-->
<uses-permission android:name=&#34;android.permission.INTERNET&#34;/>
<application
android:allowBackup=&#34;false&#34;
android:icon=&#34;@mipmap/real_launcher_logo&#34;
android:label=&#34;@string/app_name&#34;
android:roundIcon=&#34;@mipmap/ic_launcher_round&#34;
android:supportsRtl=&#34;true&#34;
android:theme=&#34;@style/Theme.FaceProcess&#34;
>
<activity
android:name=&#34;.LoginActivity&#34;
android:exported=&#34;true&#34;
android:theme=&#34;@android:style/Theme.NoTitleBar.Fullscreen&#34;
>
<intent-filter>
<action android:name=&#34;android.intent.action.MAIN&#34; />
<category android:name=&#34;android.intent.category.LAUNCHER&#34; />
</intent-filter>
</activity>
<activity
android:name=&#34;.MainActivity&#34;
android:exported=&#34;true&#34;/>
</application>
</manifest>
然后问题成功解决
总结
1. 安卓连接网络要使用多线程，不能直接用主线程
2. MySQL驱动版本不宜过高，我这边试的5是可以的，8不行，至于6、7暂时还不清楚
之后我又新建了一个Java工程，用的jdk8但是使用MySQL8的驱动是可以正确连接的，不知道Android为什么不行，如果有知道的希望能在评论区一起分享一下
3. 要记得在AndroidManifest.xml文件里面加上<uses-permission android:name=&#34;android.permission.INTERNET&#34;/>这一行 |
|
发表于 2022-9-21 17:54:35