根据第2章,更新操作即:更改某项内容,实际是 SQLiteDatabase的updata操作
布局文件:updatauserdata.xml
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="fill_parent"
android:layout_height="fill_parent"
android:padding="10px"
>
<EditText
android:id="@+id/updata_input_userid"
android:layout_centerHorizontal="true"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:hint="input user id"/>
<LinearLayout
android:id="@+id/linearlayout_input_username"
android:layout_below="@id/updata_input_userid"
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:orientation="horizontal"
>
<TextView
android:id="@+id/updata_user_name"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="user name:"
/>
<EditText
android:id="@+id/updata_input_new_username"
android:layout_width="fill_parent"
android:layout_height="wrap_content"
/>
</LinearLayout>
<LinearLayout
android:id="@+id/linearlayout_input_usernumber"
android:layout_below="@id/linearlayout_input_username"
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:orientation="horizontal"
>
<TextView
android:id="@+id/updata_user_number"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="user number"
/>
<EditText
android:id="@+id/updata_input_usernumber"
android:layout_width="fill_parent"
android:layout_height="wrap_content"
/>
</LinearLayout>
<Button
android:id="@+id/updata_commit"
android:layout_below="@id/linearlayout_input_usernumber"
android:layout_alignParentRight="true"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="updata"/>
</RelativeLayout>
Activity 上代码:
package com.example.listviewdatabase;
import android.app.Activity;
import android.content.ContentValues;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
public class UpdataUserDataDialog extends Activity {
private Button updata_commit = null;
private EditText updata_input_userid = null;
private EditText updata_input_username = null;
private EditText updata_input_usernumber = null;
@Override
protected void onCreate(Bundle savedInstanceState) {
// TODO Auto-generated method stub
super.onCreate(savedInstanceState);
setContentView(R.layout.updatauserdata);
updata_commit = (Button) findViewById(R.id.updata_commit);
updata_commit.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View arg0) {
// TODO Auto-generated method stub
updata_input_userid = (EditText) findViewById(R.id.updata_input_userid);
updata_input_username = (EditText) findViewById(R.id.updata_input_new_username);
updata_input_usernumber = (EditText) findViewById(R.id.updata_input_usernumber);
int user_id = Integer.parseInt(updata_input_userid.getText()
.toString());
String name_new = updata_input_username.getText().toString();
String number_new = updata_input_usernumber.getText()
.toString();
DataBaseHelper dbh = new DataBaseHelper(
UpdataUserDataDialog.this, null);
SQLiteDatabase db = dbh.getWritableDatabase();
ContentValues value = new ContentValues();
value.put("name", name_new);
value.put("number", number_new);
dbh.updataDataBase(db, user_id, value);
db.close();
dbh.close();
UpdataUserDataDialog.this.finish();
}
});
}
}
SQLiteDatabase:
public void updataDataBase(SQLiteDatabase db,int id,ContentValues values){
String[] args = {String.valueOf(id)};
db.update(TABLE_NAME, values,"_id=?",args);
}
此文章是本人学习笔记,能力有限,相互学习,欢迎点评,谢谢...