使用Android Studio中的SQLite执行多个WHERE子句的查询

SELECT * FROM table_name WHERE condition1 AND condition2;

// 创建数据库助手类
public class DBHelper extends SQLiteOpenHelper {
    // 构造方法
    public DBHelper(Context context) {
        super(context, "database_name", null, 1);
    }

    // 创建数据库
    @Override
    public void onCreate(SQLiteDatabase db) {
        // 创建表格的SQL语句
        String createTableQuery = "CREATE TABLE table_name (column1 INTEGER, column2 TEXT);";
        db.execSQL(createTableQuery);
    }

    // 升级数据库
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // 删除旧表格并重新创建
        String dropTableQuery = "DROP TABLE IF EXISTS table_name;";
        db.execSQL(dropTableQuery);
        onCreate(db);
    }

    // 查询数据
    public Cursor queryData() {
        SQLiteDatabase db = this.getReadableDatabase();
        String[] columns = {"column1", "column2"};
        String selection = "condition1 AND condition2";
        Cursor cursor = db.query("table_name", columns, selection, null, null, null, null);
        return cursor;
    }
}