安卓获取mysql数据库

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class MainActivity extends AppCompatActivity {
    private static final String DB_URL = "jdbc:mysql://服务器IP地址:端口号/数据库名称";
    private static final String DB_USER = "用户名";
    private static final String DB_PASSWORD = "密码";

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        // 在后台线程中进行数据库操作
        new Thread(new Runnable() {
            @Override
            public void run() {
                Connection conn = null;
                Statement stmt = null;
                ResultSet rs = null;

                try {
                    // 加载驱动
                    Class.forName("com.mysql.jdbc.Driver");

                    // 连接数据库
                    conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD);

                    // 执行查询
                    stmt = conn.createStatement();
                    String sql = "SELECT * FROM 表名";
                    rs = stmt.executeQuery(sql);

                    // 处理结果
                    while (rs.next()) {
                        String column1 = rs.getString("列名1");
                        String column2 = rs.getString("列名2");
                        // 其他列...

                        // 可以将查询结果通过回调方式传递到UI线程中进行界面更新
                        runOnUiThread(new Runnable() {
                            @Override
                            public void run() {
                                // 更新界面显示
                            }
                        });
                    }
                } catch (Exception e) {
                    e.printStackTrace();
                } finally {
                    // 关闭数据库资源
                    try {
                        if (rs != null) {
                            rs.close();
                        }
                        if (stmt != null) {
                            stmt.close();
                        }
                        if (conn != null) {
                            conn.close();
                        }
                    } catch (Exception e) {
                        e.printStackTrace();
                    }
                }
            }
        }).start();
    }
}