Android Studio - 从SQLite数据库加载RecyclerView,在EditText中输入一个单词。
创始人
2024-08-15 22:00:26
0

以下是一个使用SQLite数据库加载RecyclerView,并在EditText中输入一个单词的Android Studio示例代码:

  1. 首先,在你的项目中添加以下依赖项到你的app的build.gradle文件中:
dependencies {
    implementation 'androidx.recyclerview:recyclerview:1.2.1'
    implementation 'androidx.sqlite:sqlite:2.1.0'
}
  1. 创建一个名为Word的Java类,用于表示数据库中的单词:
public class Word {
    private int id;
    private String word;

    public Word(int id, String word) {
        this.id = id;
        this.word = word;
    }

    public int getId() {
        return id;
    }

    public String getWord() {
        return word;
    }
}
  1. 创建一个名为DatabaseHelper的Java类,用于管理SQLite数据库:
public class DatabaseHelper extends SQLiteOpenHelper {
    private static final String DATABASE_NAME = "words.db";
    private static final int DATABASE_VERSION = 1;
    private static final String TABLE_NAME = "words";
    private static final String COLUMN_ID = "id";
    private static final String COLUMN_WORD = "word";

    public DatabaseHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        String createTable = "CREATE TABLE " + TABLE_NAME + " (" +
                COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
                COLUMN_WORD + " TEXT)";
        db.execSQL(createTable);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
        onCreate(db);
    }

    public void insertWord(String word) {
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        contentValues.put(COLUMN_WORD, word);
        db.insert(TABLE_NAME, null, contentValues);
        db.close();
    }

    public List getAllWords() {
        List wordList = new ArrayList<>();
        SQLiteDatabase db = this.getReadableDatabase();
        Cursor cursor = db.rawQuery("SELECT * FROM " + TABLE_NAME, null);

        if (cursor.moveToFirst()) {
            do {
                int id = cursor.getInt(cursor.getColumnIndex(COLUMN_ID));
                String word = cursor.getString(cursor.getColumnIndex(COLUMN_WORD));
                Word newWord = new Word(id, word);
                wordList.add(newWord);
            } while (cursor.moveToNext());
        }

        cursor.close();
        db.close();

        return wordList;
    }
}
  1. 创建一个名为WordAdapter的Java类,用于将单词列表显示在RecyclerView中:
public class WordAdapter extends RecyclerView.Adapter {
    private List wordList;

    public class WordViewHolder extends RecyclerView.ViewHolder {
        public TextView wordTextView;

        public WordViewHolder(View view) {
            super(view);
            wordTextView = view.findViewById(R.id.wordTextView);
        }
    }

    public WordAdapter(List wordList) {
        this.wordList = wordList;
    }

    @Override
    public WordViewHolder onCreateViewHolder(ViewGroup parent, int viewType) {
        View itemView = LayoutInflater.from(parent.getContext())
                .inflate(R.layout.word_item, parent, false);
        return new WordViewHolder(itemView);
    }

    @Override
    public void onBindViewHolder(WordViewHolder holder, int position) {
        Word word = wordList.get(position);
        holder.wordTextView.setText(word.getWord());
    }

    @Override
    public int getItemCount() {
        return wordList.size();
    }
}
  1. res/layout目录下创建一个名为activity_main.xml的XML布局文件,用于显示RecyclerView和EditText:


    

    
  1. res/layout目录下创建一个名为`word_item

相关内容

热门资讯

长期以来!悦扑克脚本,海贝之城... 长期以来!悦扑克脚本,海贝之城辅助,一贯有辅助神器(哔哩哔哩)海贝之城辅助能透视中分为三种模型:海贝...
揭露透视!拱趴大菠萝挂,来玩a... 揭露透视!拱趴大菠萝挂,来玩app破解(透视)切实真的有辅助软件(哔哩哔哩)1、揭露透视!拱趴大菠萝...
受玩家影响!hh poker软... 受玩家影响!hh poker软件,江西中至小程序黑科技,其实是真的有辅助脚本(哔哩哔哩)1、用户打开...
开挂透视!佛手大菠萝有挂吗,竞... 开挂透视!佛手大菠萝有挂吗,竞技联盟透视插件(透视)好像有辅助技巧(哔哩哔哩)1、进入游戏-大厅左侧...
了解透视!德州局脚本,大菠萝免... 您好,大菠萝免费辅助这款游戏可以开挂的,确实是有挂的,需要了解加去威信【485275054】很多玩家...
目前!pokernow辅助控制... 您好,宝宝浙江游戏真的有辅助嘛这款游戏可以开挂的,确实是有挂的,需要了解加去威信【136704302...
这一现象值得深思!wejoke... 这一现象值得深思!wejoker开挂,拱趴大菠萝系统规律,好像是真的有辅助软件(哔哩哔哩)1、该软件...
解迷透视!epoker免费透视... 解迷透视!epoker免费透视脚本,德州圈脚本(透视)一直是有辅助软件(哔哩哔哩)暗藏猫腻,小编详细...
近日!红龙poker辅助工具,... 近日!红龙poker辅助工具,奇迹永久免费脚本辅助工具,好像有辅助app(哔哩哔哩)1、上手简单,内...
揭露透视!拱趴大菠萝挂,来玩a... 揭露透视!拱趴大菠萝挂,来玩app破解(透视)果然一直总是有辅助方法(哔哩哔哩)在进入拱趴大菠萝挂软...