显示从编辑文本到微调器的项目并保存到数据库

发布于 2024-10-27 05:19:20 字数 923 浏览 0 评论 0原文

我想显示从 editext 到 spinner 的一个项目并保存到数据库...如何在数据库中存储项目...

我的代码：

spinner 填充

final DBAdapter db = new DBAdapter(this);
db.open();

Spinner spin = (Spinner) findViewById(R.id.spinner1);

AdapterCountries = new ArrayAdapter<CharSequence>(this,
                            android.R.layout.simple_spinner_item);
AdapterCountries.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);

spin.setAdapter(AdapterCountries);



Cursor cursor = db.getAllTitles1();
while (cursor.moveToNext()){
results=cursor.getString(2);
AdapterCountries.add(results);
}
db.close();

，

 Button d_ok=(Button)dialog.findViewById(R.id.d_ok);
 final EditText filename=(EditText)dialog.findViewById(R.id.filename);
 d_ok.setOnClickListener(new OnClickListener(){
        public void onClick(View arg0) {
    //
 }});

任何人都可以帮助我举例

谢谢...

原文

I want to show an item from editext to spinner and save to db... how to store item in the db...

my code :

spinner populating

final DBAdapter db = new DBAdapter(this);
db.open();

Spinner spin = (Spinner) findViewById(R.id.spinner1);

AdapterCountries = new ArrayAdapter<CharSequence>(this,
                            android.R.layout.simple_spinner_item);
AdapterCountries.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);

spin.setAdapter(AdapterCountries);



Cursor cursor = db.getAllTitles1();
while (cursor.moveToNext()){
results=cursor.getString(2);
AdapterCountries.add(results);
}
db.close();

and

 Button d_ok=(Button)dialog.findViewById(R.id.d_ok);
 final EditText filename=(EditText)dialog.findViewById(R.id.filename);
 d_ok.setOnClickListener(new OnClickListener(){
        public void onClick(View arg0) {
    //
 }});

any one can help me with example

Thank you...

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

孤独患者 2024-11-03 05:19:20

如果您还没有，那么我真的认为您应该有一个扩展给定 SQLiteOpenHelper Android 类的 SQL 帮助器类。它确实简化了数据库操作。请参阅：http://developer.android.com/guide/topics /data/data-storage.html#db

强烈推荐。

如果您设置了帮助程序类，并且该类的实例设置为 SQLHelper sql = new SQLHelper(this); ，那么修改数据库就相当简单了。您应该设置一个从按钮 onClickListener 调用的方法（并且可能在 AsyncTask 或后台线程中运行它）：

private void addFileName(final String filename) {
    SQLiteDatabase db = sql.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put(yourKeyHere, filename);
    db.insert(yourDBNameHere, null, values);
}

然后调用该方法并将其从侦听器添加到您的适配器：

d_ok.setOnClickListener(new OnClickListener() {
    public void onClick(View v) {
        addFileName(filename.getText().toString();
        AdapterCountries.add(filename);
    }
});

If you don't have one already, then I really think you should have a SQL helper class extending the given SQLiteOpenHelper Android class. It really simplifies DB operations. See: http://developer.android.com/guide/topics/data/data-storage.html#db

It's heavily recommended.

If you set up the helper class and the instance of that class is set up like SQLHelper sql = new SQLHelper(this); then modifying the database is fairly simple. You should set up a method that you call from your buttons onClickListener (and possibly run it in an AsyncTask or a background thread):

private void addFileName(final String filename) {
    SQLiteDatabase db = sql.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put(yourKeyHere, filename);
    db.insert(yourDBNameHere, null, values);
}

And then call the method and add it to your adapter from the listener:

d_ok.setOnClickListener(new OnClickListener() {
    public void onClick(View v) {
        addFileName(filename.getText().toString();
        AdapterCountries.add(filename);
    }
});

回复收藏 0 原文

~没有更多了~