Android sqlite 更新失败

Question

我有如下表结构

public class DBConnectionTableTVShow {
    public static final String SHOWID = "show_id";
    public static final String SHOWNAME = "show_name";
    public static final String SHOWSEASON = "season_name";
    public static final String EPISODENAME = "episode_name";
    public static final String EPISODESTATUS = "episode_status";

    public static final String DBNAME = "entertainment_tracker";
    public static final String DBTABLE = "tv_show";
    public static final int VERSION = 1;
}

现在我想更新episode_status

我创建了以下方法

public void updateEpisodeStatus(String showName, String seasonName, String episodeNo, String epStat) {
     db.execSQL("UPDATE tv_show SET " +
                "episode_status='"+epStat+"'"+
                "WHERE show_name='"+showName+"' " +
                "AND season_name='"+seasonName+"' " +
                "AND episode_name='"+episodeNo+"'", 
                null);
}

当我尝试使用此方法时出现错误:

java.lang.IllegalArgumentException: Empty bindArgs

如何解决？

Answer 1

删除作为 null 传递的第二个参数，它将起作用。

public void updateEpisodeStatus(String showName, String seasonName, String episodeNo, String epStat) {
     db.execSQL("UPDATE tv_show SET " +
                "episode_status='"+epStat+"'"+
                "WHERE show_name='"+showName+"' " +
                "AND season_name='"+seasonName+"' " +
                "AND episode_name='"+episodeNo+"'");
}