正在更新sqlite-near“where”：语法错误（代码1 SQLITE_ERROR):

Question

我最近在我的SQLite数据库中添加了一个列，由于添加了这个列，我有一个按钮，它将一个数据库列的值设置为“1”或“0”，当这个按钮尝试使用updateData（）时，我的应用程序开始崩溃，所以我认为这是我的问题所在，是updateData（）的代码或语法问题

显示错误=

android.database.sqlite.sqliteException：near“WHERE”：语法错误（代码1 SQLITE_ERROR):，编译时：UPDATE my_manager SET location_name='blarney stone',location_county='cork',location_description='jj',location_route='1',location_position='2',location_longg='null',location_lat='null',location_url='jj',location_url2='jj',location_url3

 void updateData(String id, String row_id, String name, String county, String description, String 
  in_route, String position, String lat, String longg, String url, String url2, String url3) {
    System.out.println(TABLE_NAME+"; "+row_id +"; "+ name +"; "+ county+"; "+ description+"; " + lat 
   +"; "+ longg+"; "+ url +"; "+ url2 +"; "+ url3 +"; ");
    SQLiteDatabase db = this.getReadableDatabase();
    db.execSQL("UPDATE " + "my_manager" + " SET location_name = "+"'"+ name + "' " + ", " +
            "location_county = " + "'"+ county + "'"+ "," +
            "location_description = " + "'"+ description +  "'" + "," +
            "location_route = " + "'"+ in_route +  "'" + "," +
            "location_position = " + "'"+ position +  "'" + "," +
            "location_longg = " + "'"+ longg +  "'" + "," +
            "location_lat = " + "'"+ lat +  "'" + "," +
            "location_url = " + "'"+ url +  "'" + "," +
            "location_url2 = " + "'"+ url2 +  "'" + "," +
            "location_url3 = " + "'"+ url3 +  "'" + "," + " WHERE location_id = "+"'"+ row_id+"'");

Answer 1

对不起，我的朋友，不要认为这是一个坏的，但你如何避免很多不必要的“+”，如果可能的话。

void updateData("UPDATE my_manager SET location_name = '"+ name + "', " +
            "location_county = '"+ county + "', " +
            "location_description = '"+ description +  "'," +
            "location_route = '"+ in_route +  "', " +
            "location_position = '" + position + "', " +
            "location_longg = '" + longg + "'," +
            "location_lat = '" + lat +  "'," +
            "location_url = '" + url +  "', " +
            "location_url2 = '"+ url2 +  "', " +
            "location_url3 = '"+ url3 +  "' WHERE location_id = '"+ row_id+"'");