• 使用ContentResolver添加数据、查询数据


    import java.util.ArrayList;
    import java.util.HashMap;
    import java.util.Map;

    import android.os.Bundle;
    import android.provider.UserDictionary.Words;
    import android.app.Activity;
    import android.content.ContentResolver;
    import android.content.ContentValues;
    import android.content.Intent;
    import android.database.Cursor;
    import android.view.Menu;
    import android.view.View;
    import android.view.View.OnClickListener;
    import android.widget.Button;
    import android.widget.EditText;
    import android.widget.Toast;

    public class DictResolver extends Activity {
      ContentResolver contentResolver;
      Button insert;
      Button search;

      @Override
      protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_dict_resolver);
        //获取系统的ContentResolver对象
        contentResolver = getContentResolver();
        insert = (Button) findViewById(R.id.insert);
        search = (Button) findViewById(R.id.search);
        //为insert按钮的单击事件绑定事件监听器
        insert.setOnClickListener(new OnClickListener() {

          @Override
          public void onClick(View v) {
            // 获取用户输入
            String word = ((EditText)findViewById(R.id.word)).getText().toString();
            String detail = ((EditText)findViewById(R.id.detail)).getText().toString();
            //插入生词记录
            ContentValues values = new ContentValues();
            values.put(mediaprovidertest.Words.Word.WORD, word);
            values.put(mediaprovidertest.Words.Word.DETAIL, detail);
            contentResolver.insert(mediaprovidertest.Words.Word.DICT_CONTENT_URI, values);
            //显示提示信息
            Toast.makeText(DictResolver.this, "添加单词成功!", 8000).show();
          }
        });
        //为search按钮的单击事件绑定事件监听器
        search.setOnClickListener(new OnClickListener() {

          @Override
          public void onClick(View v) {
            // 获取用户输入
            String key = ((EditText)findViewById(R.id.key)).getText().toString();
            //执行查询
            Cursor cursor = contentResolver.query(
                mediaprovidertest.Words.Word.DICT_CONTENT_URI,
                null, "word like ? or detail like ?",
                new String[]{"%"+key+"%","%"+key+"%"}, null);
            //创建一个Bundle
            Bundle data = new Bundle();
            data.putSerializable("data", converCursorToList(cursor));
            //创建一个Intent
            Intent intent = new Intent(DictResolver.this, ResultActivity.class);
            intent.putExtras(data);
            //启动Activity
            startActivity(intent);
          }
        });
      }
      private ArrayList<Map<String, String>> converCursorToList(Cursor cursor){
      ArrayList<Map<String, String>> result = new ArrayList<Map<String,String>>();
      //遍历Cursor结果集
      while(cursor.moveToNext()){
        //将结果集中的数据存入ArrayList中
        Map<String, String> map = new HashMap<String, String>();
        //取出查询记录中第2列、第3列的值
        map.put(mediaprovidertest.Words.Word.WORD, cursor.getString(1));
        map.put(mediaprovidertest.Words.Word.DETAIL, cursor.getString(2));
        result.add(map);
      }
      return result;
      }

    }

  • 相关阅读:
    表空间_oracle
    linux_1_Wed May 15 10:18:56 CST 2019
    玩oracle vm virtualBox+mac电脑+isomini7centos
    字符串比较用equal以及==的区别
    送货地图中的数据库操作

    健康,有度
    qa角色记一次测试过程回溯
    jmeter计数器的使用
    jmeter解析response里的json对象和数组
  • 原文地址:https://www.cnblogs.com/jiww/p/5596298.html
Copyright © 2020-2023  润新知