直接上代码:
public List<String> readData(String name) { List<String> list = new ArrayList<>(); try { //数据库地址 String url = Environment.getExternalStorageDirectory().getAbsolutePath() + "/test.db"; // 打开数据库 SQLiteDatabase db = SQLiteDatabase.openOrCreateDatabase(url, null); // 查询表结构 Cursor cursor = db.query(name, null, null, null, null, null, null); // 获取列名 String[] columnNames = cursor.getColumnNames(); for (int i = 0; i < columnNames.length; i++) { list.add(columnNames[i]); } // 关闭Cursor和数据库 cursor.close(); db.close(); } catch (Exception e) { e.printStackTrace(); } return list; } 输出 System.out.println(); public List<String> readData(String name) {