问题描述:
java.lang.NoClassDefFoundError: Failed resolution of: Ljava/sql/SQLType
Didn't find class "java.sql.SQLType"
问题原因: MySQL 连接数据库jar包版本过高
解决方式: 改用 mysql- connector-java:5.1.49
具体步骤:
1. build.gradle(Module:app)文件的dependencies项中加入依赖
implementation 'mysql:mysql-connector-java:5.1.49'
2. 将连接数据库url语句改为
public static Connection getConnection(){
try{
Class.forName("com.mysql.jdbc.Driver"); // 改这行
return DriverManager.getConnection("jdbc:mysql://10.0.2.2:3306/数据库名?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false&allowPublicKeyRetrieval=true",
"root",
"12345678");
}catch(Exception e){
e.printStackTrace();
}
return null;
}