//获取内容访问者
ContentResolver cr=getContentResolver();
Uri uri=Uri.parse("content://com.zking.administrator.g160618_android16_sqlite.LOGIN");
Cursor cursor=cr.query(uri,null,null,null,null);
while(cursor.moveToNext()){
int uid=cursor.getInt(cursor.getColumnIndex("uid"));
String uname=cursor.getString(cursor.getColumnIndex("uname")) ;
String upass=cursor.getString(cursor.getColumnIndex("upass")) ;
Log.i("test",uid+" "+uname+" "+upass);
}
}
private EditText et_main_uname;
private EditText et_main_upass;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
et_main_uname = (EditText) findViewById(R.id.et_main_uname);
et_main_upass = (EditText) findViewById(R.id.et_main_upass);
}
public void operation(View view){
String uname=et_main_uname.getText().toString();
String upass=et_main_upass.getText().toString();
DBHelper dbHelper=new DBHelper(this,"G160618.db",null,2);
SQLiteDatabase sqLiteDatabase=dbHelper.getWritableDatabase();
//添加1
for (int i = 0; i <100 ; i++) {
sqLiteDatabase.execSQL("insert into login(uname,upass) values('"+uname+i+"','"+upass+"')");
}
Toast.makeText(this, "OK", Toast.LENGTH_SHORT).show();
}
}
package com.zking.administrator.g160618_android16_sqlite;
import android.content.ContentProvider;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.net.Uri;
import android.support.annotation.NonNull;
import android.support.annotation.Nullable;
import android.util.Log;
import com.zking.db.DBHelper;
/**
* Created by Administrator on 2017/7/17 0017.
*/
public class MyProvider extends ContentProvider {
@Override
public boolean onCreate() {
Log.i("test","onCreate");
return false;
}
@Nullable
@Override
public Cursor query(@NonNull Uri uri, @Nullable String[] projection, @Nullable String selection, @Nullable String[] selectionArgs, @Nullable String sortOrder) {
Log.i("test","query");
//把数据查询出来
DBHelper dbHelper=new DBHelper(getContext(),"G160618.db",null,2);
SQLiteDatabase sqLiteDatabase=dbHelper.getReadableDatabase();
//sqLiteDatabase.rawQuery("select * from login",null);
return sqLiteDatabase.rawQuery("select * from login",null);
}
@Nullable
@Override
public String getType(@NonNull Uri uri) {
Log.i("test","getType");
return null;
}
@Nullable
@Override
public Uri insert(@NonNull Uri uri, @Nullable ContentValues values) {
Log.i("test","insert");
return null;
}
@Override
public int delete(@NonNull Uri uri, @Nullable String selection, @Nullable String[] selectionArgs) {
Log.i("test","delete");
return 0;
}
@Override
public int update(@NonNull Uri uri, @Nullable ContentValues values, @Nullable String selection, @Nullable String[] selectionArgs) {
Log.i("test","update");
return 0;
}
}