dystroy 2013-02-22 07:11 采纳率: 80%
浏览 3372
已采纳

如何把spinner中的dropdown item存储到sqlite数据库?

我想存储 spinner中的dropdown值到数据库。我可以按照android开发网站的说明中获得dropdown,但是当用户点击保存按钮时,不能把dropdown的值存储到数据库中。请问如何把spinner中的dropdown item存储到sqlite数据库?
我用的是下面的代码:

public class Akshay extends Activity
{
  @Override
  public void onCreate(Bundle savedInstanceState)
  {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.main);
    //Spinner For Selecting Room
    Spinner spinner_room = (Spinner) findViewById(R.id.spinner_for_Room_type_screen_2);
    ArrayAdapter adapter_room = ArrayAdapter.createFromResource(this,
        R.array.room_array, android.R.layout.simple_spinner_item);
    adapter_room.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
    spinner_room.setAdapter(adapter_room);
    spinner_room.setOnItemSelectedListener(new MyOnItemSelectedListener_room());
  }
}

// Listener Implementation of Spinner For Selecting Room 
public class MyOnItemSelectedListener_room implements OnItemSelectedListener
{
  public void onItemSelected(AdapterView parent, View view, int pos, long id)
  {
  }

  public void onNothingSelected(AdapterView parent)
  { // Do nothing.}
  };
}
  • 写回答

2条回答 默认 最新

  • Curie-87 2013-02-22 09:36
    关注
    public class Akshay extends Activity {
    
       public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.configuration);
        // Spinner For Selecting Room
    
        Spinner spinner_room = (Spinner) findViewById(R.id.spinner_for_Room_type_screen_2);
    
        ArrayAdapter<CharSequence> adapter_room = ArrayAdapter.createFromResource(this,
                            R.array.room_array,android.R.layout.simple_spinner_item);
    
        adapter_room.setDropDownViewResourc(android.R.layout.simple_spinner_dropdown_item);
        spinner_room.setAdapter(adapter_room);
    
        spinner_room.setOnItemSelectedListener(new Listener_Of_Selecting_Room_Spinner());
    }
    
    // Listener Implementation of Spinner For Selecting Room
    
    public static class Listener_Of_Selecting_Room_Spinner implements OnItemSelectedListener 
    {
        static String RoomType;
    
        public void onItemSelected(AdapterView<?> parent, View view, int pos,long id) 
        {   
            // By using this you can get the position of item which you
            // have selected from the dropdown 
    
            RoomType = (parent.getItemAtPosition(pos)).toString();
        }
    
        public void onNothingSelected(AdapterView<?> parent) 
        {           
            // Do nothing.
        }
    };
    
    // Listener Implementation For Saving Number Of Board
    private OnClickListener btnListener_Btn_Save_Room_Board = new OnClickListener() 
    {
        public void onClick(View view) 
        {
            DBAdapter dbAdapter1 = new DBAdapter(view.getContext());
    
            String room;
            try {
                dbAdapter1.createDataBase();
                dbAdapter1.openDataBase();
    
                // Here i am using the object RoomType which i have got from 
                // the Listener of spinner
    
                room = Listener_Of_Selecting_Room_Spinner.RoomType;
    
                ContentValues initialValues1 = new ContentValues();
    
                initialValues1.put("RoomType", room);
    
                //Here i am storing it(RoomType) to the database
    
                dbAdapter1.InsertNumberOfBoardInDB("Configuration", null,initialValues1);   
            }
            catch (Exception e) {
            }
            finally {
                dbAdapter1.close();
            }
        }
    };
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 C++使用Gunplot
  • ¥15 这个电路是如何实现路灯控制器的,原理是什么,怎么求解灯亮起后熄灭的时间如图?
  • ¥15 matlab数字图像处理频率域滤波
  • ¥15 在abaqus做了二维正交切削模型,给刀具添加了超声振动条件后输出切削力为什么比普通切削增大这么多
  • ¥15 ELGamal和paillier计算效率谁快?
  • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?
  • ¥15 Arcgis相交分析无法绘制一个或多个图形
  • ¥15 关于#r语言#的问题:差异分析前数据准备,报错Error in data[, sampleName1] : subscript out of bounds请问怎么解决呀以下是全部代码:
  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)