android sqlite json,android – 将SQLite转换为JSON

参考

Link

private JSONArray getResults()

{

String myPath = DB_PATH + DB_NAME;// Set path to your database

String myTable = TABLE_NAME;//Set name of your table

//or you can use `context.getDatabasePath("my_db_test.db")`

SQLiteDatabase myDataBase = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READONLY);

String searchQuery = "SELECT * FROM " + myTable;

Cursor cursor = myDataBase.rawQuery(searchQuery, null );

JSONArray resultSet = new JSONArray();

cursor.moveToFirst();

while (cursor.isAfterLast() == false) {

int totalColumn = cursor.getColumnCount();

JSONObject rowObject = new JSONObject();

for( int i=0 ; i< totalColumn ; i++ )

{

if( cursor.getColumnName(i) != null )

{

try

{

if( cursor.getString(i) != null )

{

Log.d("TAG_NAME", cursor.getString(i) );

rowObject.put(cursor.getColumnName(i) , cursor.getString(i) );

}

else

{

rowObject.put( cursor.getColumnName(i) , "" );

}

}

catch( Exception e )

{

Log.d("TAG_NAME", e.getMessage() );

}

}

}

resultSet.put(rowObject);

cursor.moveToNext();

}

cursor.close();

Log.d("TAG_NAME", resultSet.toString() );

return resultSet;

}