首页 文章

从android中的SQLite数据库请求多个单元格

提问于
浏览
2

我试图从我的数据库中的两个不同单元格调用数据,然后将它们组合并在活动中打印出来 .

我使用以下代码:

public Cursor getGermanDescription(String id) {
    String[] args = { id };
    return (getReadableDatabase()
            .rawQuery(
                    "SELECT _id,Column1,Column2 FROM Databasing_Details WHERE _id=?",
                    args));

有了上面我只得到Column1但不是Column2的内容 . 我将String id传递给另一个活动 .

我的游标适配器是:

@Override public void onCreate(Bundle savedInstanceState){try {super.onCreate(savedInstanceState);的setContentView(R.layout.main);

//Get our passed variable from our intent's EXTRAS
    passedVar=getIntent().getStringExtra(ListViewTwo.ID_EXTRA);

    //this is our ListView element, obtained by id from our XML layout
    ListView myListView = (ListView)findViewById(R.id.list_view);

    String string = passedVar;  
    int passedInt = Integer.parseInt(string); 

    if (passedInt==1) { passedVar1 = true;

    }
    //create our database Helper
    dbDescriptionHelper=new DatabaseHelper(this);
    //a set of results from a database query
    ourCursor=dbDescriptionHelper.getGermanDescription(passedVar);

    //tell android to start managing the cursor,
    startManagingCursor(ourCursor);
    //create our adapter
    adapter=new SlangAdapter(ourCursor);
    //set the adapter!!!
    myListView.setAdapter(adapter);

    } catch (Exception e) {

        Log.e("ERROR", "ERROR IN CODE: " + e.toString());

        e.printStackTrace();
    }

    return;
}


class SlangAdapter extends CursorAdapter {
    SlangAdapter(Cursor c) {
      super(ListViewFinal.this, c);
    }
    @Override

    public void bindView(View row, Context ctxt,
                       Cursor c) {
        DescriptionHolder holder=(DescriptionHolder)row.getTag();
        holder.populateFrom(c, dbDescriptionHelper);
    }
    @Override
    public View newView(Context ctxt, Cursor c,
                       ViewGroup parent) {
      LayoutInflater inflater=getLayoutInflater();
      View row=inflater.inflate(R.layout.main_row, parent, false);
      DescriptionHolder holder=new DescriptionHolder(row);
      row.setTag(holder);
      return(row);
    }
  }

static class DescriptionHolder {
    private TextView name=null;

    DescriptionHolder(View row) {
        name=(TextView)row.findViewById(R.id.row);
    }

    void populateFrom(Cursor c, DatabaseHelper r) {
        name.setText(r.getName(c));
    }
}

有人可以指出我出错的地方吗 .

1 回答

  • 1

    好的,我找到了答案 .

    我的语法不正确,我需要为光标写的是:

    public Cursor getGermanDescription(String id) {
        String[] args = { id };
        return (getReadableDatabase()
                .rawQuery(
                        "SELECT _id, ObjectDescriptionGerman ||'\n\n'|| ObjectDescription  FROM Databasing_Details WHERE _id=?",
                        args));
    
    }
    

    ||需要使用而不是“,”或“AND” . 我还在我的两个返回值之间插入换行符,所以我不需要在我的数据库中执行此操作 .

相关问题