package com.njue;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
public class DBManager extends SQLiteOpenHelper {
public static final String myProvider_table_name="myProvider_table_name";
String sql="create table myProvider_table_name(id integer,name text)";
public DBManager(Context context) {
super(context, "myPrivoder.db", null, 1);
// TODO Auto-generated constructor stub
}
@Override
public void onCreate(SQLiteDatabase arg0) {
// TODO Auto-generated method stub
arg0.execSQL(sql);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
}
}
package com.njue;
import android.content.ContentProvider;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.net.Uri;
public class myProvider extends ContentProvider {
DBManager dbHelper;
@Override
public int delete(Uri arg0, String arg1, String[] arg2) {
// TODO Auto-generated method stub
SQLiteDatabase db=dbHelper.getWritableDatabase();
int id=db.delete(DBManager.myProvider_table_name, arg1, arg2);
if(id!=0)return id;
return 0;
}
@Override
public String getType(Uri uri) {
// TODO Auto-generated method stub
return null;
}
@Override
public Uri insert(Uri uri, ContentValues values) {
// TODO Auto-generated method stub
SQLiteDatabase db=dbHelper.getWritableDatabase();
db.insert(DBManager.myProvider_table_name, "id", values);
return null;
}
@Override
public boolean onCreate() {
// TODO Auto-generated method stub
dbHelper=new DBManager(getContext());
return true;
}
@Override
public Cursor query(Uri uri, String[] projection, String selection,
String[] selectionArgs, String sortOrder) {
// TODO Auto-generated method stub
SQLiteDatabase db=dbHelper.getWritableDatabase();
Cursor c=db.query(DBManager.myProvider_table_name,projection, selection, selectionArgs, null, null, sortOrder);
return c;
}
@Override
public int update(Uri uri, ContentValues values, String selection,
String[] selectionArgs) {
// TODO Auto-generated method stub
SQLiteDatabase db=dbHelper.getWritableDatabase();
int id=db.update(DBManager.myProvider_table_name, values, selection, selectionArgs);
if(id!=0)return id;
return 0;
}
}
<provider android:name="myProvider"
android:authorities="com.njue.myProvider" />
package com.njue;
import android.app.Activity;
import android.content.ContentResolver;
import android.content.ContentValues;
import android.database.Cursor;
import android.net.Uri;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;
public class Content_providerActivity extends Activity {
/** Called when the activity is first created. */
Uri uri;
String AUTHORITY="content://com.njue.myProvider/myProvider_table_name";
ContentResolver cr;
EditText input;
Button insert;
TextView show;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
input=(EditText)findViewById(R.id.input);
insert=(Button)findViewById(R.id.insert);
show=(TextView)findViewById(R.id.show);
uri=uri.parse(AUTHORITY);
cr=this.getContentResolver();
insert.setOnClickListener(new Button.OnClickListener(){
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
ContentValues values=new ContentValues();
values.put("name", input.getText().toString());
cr.insert(uri, values);
Cursor c=cr.query(uri, null, null, null, null);
show.setText("");
c.moveToFirst();
while(c.moveToNext()){
show.append(c.getString(1)+"\r\n");
}
input.setText("");
}});
}
}
机械节能产品生产企业官网模板...
大气智能家居家具装修装饰类企业通用网站模板...
礼品公司网站模板
宽屏简约大气婚纱摄影影楼模板...
蓝白WAP手机综合医院类整站源码(独立后台)...苏ICP备2024110244号-2 苏公网安备32050702011978号 增值电信业务经营许可证编号:苏B2-20251499 | Copyright 2018 - 2025 源码网商城 (www.ymwmall.com) 版权所有