作者:林伯勋玉萍竣梅 | 来源:互联网 | 2023-05-18 21:46
Ineedtoupdateavalueinacolumnfromacertaintable.Itriedthis:我需要更新某个表中的列中的值。我试过这个:pu
I need to update a value in a column from a certain table. I tried this :
我需要更新某个表中的列中的值。我试过这个:
public void updateOneColumn(String TABLE_NAME, String Column, String rowId, String ColumnName, String newValue){
String sql = "UPDATE "+TABLE_NAME +" SET " + ColumnName+ " = "+newValue+" WHERE "+Column+ " = "+rowId;
db.beginTransaction();
SQLiteStatement stmt = db.compileStatement(sql);
try{
stmt.execute();
db.setTransactionSuccessful();
}finally{
db.endTransaction();
}
}
and I call this method like this :
我这样称呼这个方法:
db.updateOneColumn("roadmap", "id_roadmap",id,"sys_roadmap_status_mobile_id", "1");
which means that I want to set the value 1
in the column sys_roadmap_status_mobile_id
when id_roadmap = id.
这意味着我想在id_roadmap = id时在sys_roadmap_status_mobile_id列中设置值1。
The problem is that nothing happens. Where is my mistake?
问题是没有任何反应。我的错误在哪里?
2 个解决方案