要在Android Studio中连接MySQL数据库,您需要遵循以下步骤:
build.gradle文件中添加了MySQL驱动程序的依赖项。在dependencies块中添加以下代码:implementation 'mysql:mysql-connector-java:5.1.47'
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class MySQLConnection {
public static Connection getConnection() {
Connection connection = null;
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://your_mysql_server_ip:your_mysql_server_port/your_database_name";
String username = "your_mysql_username";
String password = "your_mysql_password";
connection = DriverManager.getConnection(url, username, password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return connection;
}
}
确保将your_mysql_server_ip,your_mysql_server_port,your_database_name,your_mysql_username和your_mysql_password替换为您的MySQL服务器和数据库的实际值。
getConnection()方法以获取连接对象:Connection connection = MySQLConnection.getConnection();
if (connection != null) {
// 连接成功
} else {
// 连接失败
}
这些步骤应该能够帮助您在Android Studio中连接到MySQL数据库。如果仍然无法连接,您可能需要检查MySQL服务器的配置和网络连接。