如何洗牌一个对象

How to shuffle an Object

本文关键字:一个对象 何洗牌      更新时间:2023-09-26

我试着洗牌一个对象,但我没有得到它。

这是我的代码:

db.transaction(function (db) {
    db.executeSql("SELECT * FROM xxx WHERE CxId = '" + xId + "'", [], function (db, result) {
        var s = result[Math.floor(Math.random() * result.rows.length)];
        for (var i = 0, item = null; i < s.rows.length; i++) {
            item = s.rows.item(i);
            var sql =
                "INSERT INTO xxxx (xId, xxId, xxxx, xxxx, xxxx) " +
                    "VALUES (?, ?, ?, ?, ?)";
            var params = [item['xId'], item['xxId'], item['xxxxx'], 0, null];
            db.executeSql(sql, params);
        }
    });
});

如何洗牌结果?

结果中有以下数据:

ID_______Answer_______Result

1 _______xxxxx________true

2 _______yyyyy________true

3 _______uuuuu________false

当我随机化它时,结果应该是:

ID_______Answer_______Result

3 _______uuuuu________false

2 _______yyyyy________true

1 _______xxxxx________true

ID_______Answer_______Result

2 _______yyyyy________true

3 _______uuuuu________false

1 _______xxxxx________true

尝试在SQL中添加ORDER BY RAND()