如何在数据库中隐藏列 [英] how to hide a column in database

问题描述

这是我的原始代码：

String sqlQuery = "SELECT * FROM data where company = '"+ Selecteditem +"'"  ;

SQLiteDatabase db = this.getWritableDatabase();
Cursor c = db.rawQuery(sqlQuery, null);

if (c.moveToFirst()){
   do{
      temp_array.add(c.getString(c.getColumnIndex("name")) +
                     "," + c.getString(c.getColumnIndex("code")) +
                     "," + c.getString(c.getColumnIndex("company")) 
                    );

我想在列表中隐藏公司，我更改 * 到名称，代码但没有成功，我删除**，+ c.getString（c.getColumnIndex（company）） *此行无效，

I want to hide company on the list, I change "*" to name, code but without success, I delete " **"," + c.getString(c.getColumnIndex("company"))** " this line no success,

该怎么办请帮助我

推荐答案

您可以删除公司字符串，将 c.getString（c.getColumnIndex（company））替换为空字符串。

You can just remove the company string, by replacing c.getString(c.getColumnIndex("company")) with an empty string "".

String sqlQuery = "SELECT * FROM data where company = '" + Selecteditem + "'";

SQLiteDatabase db = this.getWritableDatabase();
Cursor c = db.rawQuery(sqlQuery, null);

if (c.moveToFirst()) {
    do {
        temp_array.add(c.getString(c.getColumnIndex("name")) +
            "," + c.getString(c.getColumnIndex("code")) +
            "," + ""
        );

另一个解决方案是只选择您需要的列：

Another solution is to select only the columnn you need:

String sqlQuery = "SELECT name, code FROM data where company = '" + Selecteditem + "'";

SQLiteDatabase db = this.getWritableDatabase();
Cursor c = db.rawQuery(sqlQuery, null);

if (c.moveToFirst()) {
    do {
        temp_array.add(c.getString(c.getColumnIndex("name")) +
            "," + c.getString(c.getColumnIndex("code"))
        );

这篇关于如何在数据库中隐藏列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！