【移動應用開發(fā)技術(shù)】Android中如何實現(xiàn)SQLite事務(wù)處理結(jié)合Listview列表顯示功能

【移動應用開發(fā)技術(shù)】Android中如何實現(xiàn)SQLite事務(wù)處理結(jié)合Listview列表顯示功能

public

void

Transaction(){

SQLiteDatabase

database=db.getReadableDatabase();

database.beginTransaction();

//開啟事務(wù)

try{

String

sql1="update

student

set

username='lili'

where

userid=2";

String

sql2="update

student

set

username='lucy'

where

userid=3";

database.execSQL(sql1);

database.execSQL(sql2);

database.setTransactionSuccessful();

//設(shè)置事務(wù)的狀態(tài)，這句不寫事務(wù)就會回滾

}finally{

database.endTransaction();

//結(jié)束事務(wù)

}

}/upload/information/20200623/125/127686.png<?xml

version="1.0"

encoding="utf-8"?>

<LinearLayout

xmlns:android="/apk/res/android"

android:orientation="vertical"

android:layout_width="fill_parent"

android:layout_height="fill_parent"

>

<LinearLayout

xmlns:android="/apk/res/android"

android:orientation="horizontal"

android:layout_width="wrap_content"

android:layout_height="wrap_content">

<TextView

android:layout_width="60dip"

android:layout_height="wrap_content"

android:text="用戶id"

/>

<TextView

android:layout_width="60dip"

android:layout_height="wrap_content"

android:text="用戶名"

/>

<TextView

android:layout_width="60dip"

android:layout_height="wrap_content"

android:text="用戶住址"

/>

</LinearLayout>

<ListView

android:layout_width="fill_parent"

android:layout_height="wrap_content"

android:id="@+id/listview"

/>

</LinearLayout><?xml

version="1.0"

encoding="utf-8"?>

<LinearLayout

xmlns:android="/apk/res/android"

android:orientation="horizontal"

android:layout_width="wrap_content"

android:layout_height="wrap_content">

<TextView

android:layout_width="60dip"

android:layout_height="wrap_content"

android:id="@+id/userid"

/>

<TextView

android:layout_width="60dip"

android:layout_height="wrap_content"

android:id="@+id/username"

/>

<TextView

android:layout_width="90dip"

android:layout_height="wrap_content"

android:id="@+id/address"

/>

</LinearLayout>package

org.lxh.db;

import

java.util.*;

import

org.lxh.service.StudentService;

import

org.lxh.vo.Student;

import

android.app.Activity;

import

android.database.Cursor;

import

android.os.Bundle;

import

android.view.View;

import

android.widget.AdapterView;

import

android.widget.AdapterView.OnItemClickListener;

import

android.widget.ListView;

import

android.widget.SimpleAdapter;

import

android.widget.SimpleCursorAdapter;

import

android.widget.Toast;

public

class

DBActivity

extends

Activity

{

private

StudentService

service;

public

void

onCreate(Bundle

savedInstanceState)

{

super.onCreate(savedInstanceState);

setContentView(R.layout.main);

this.service=new

StudentService(this);

ListView

view=(ListView)this.findViewById(R.id.listview);

List<Student>

all=this.service.fiandAll();

List<HashMap<String,Object>>

data=new

ArrayList<HashMap<String,Object>>();

//逐個取出元素

Iterator<Student>

it=all.iterator();

Student

stu=null;

while(it.hasNext()){

stu=new

Student();

stu=it.next();

HashMap<String,Object>

map=new

HashMap<String,Object>();

map.put("userid",

stu.getUserid());

map.put("username",

stu.getUsername());

map.put("address",

stu.getAddress());

data.add(map);

}

//數(shù)據(jù)綁定

SimpleAdapter

adapter=new

SimpleAdapter(this,

data,

R.layout.listview,

new

String[]{"userid","username","address"},new

int[]{R.id.userid,R.id.username,R.id.address});

view.setAdapter(adapter);

//添加列表項監(jiān)聽事件

view.setOnItemClickListener(new

OnItemClickListener(){

public

void

onItemClick(AdapterView<?>

parent,

View

view,int

position,

long

id)

{

ListView

listview=(ListView)parent;

HashMap<String,Object>

hash=(HashMap<String,Object>)listview.getItemAtPosition(position);

Toast.makeText(DBActivity.this,

hash.get("userid").toString(),

1).show();

}});

}HashMap<String,Object>

map=new

HashMap<String,Object>();List<HashMap<String,Object>>

data=new

ArrayList<HashMap<String,Object>>();SimpleAdapter

adapter=new

SimpleAdapter(this,

data,

R.layout.listview,

new

String[]{"userid","username","address"},new

int[]{R.id.userid,R.id.username,R.id.address});

view.setAdapter(adapter);public

List<Student>

fiandAll(){

List<Student>

all=new

ArrayList<Student>();

String

sql="select

*

from

student";

SQLiteDatabase

database=db.getReadableDatabase();

//使用getReadableDatabase取得SQLiteDatabase

Cursor

cursor=database.rawQuery(sql,

null);

//得到游標,類似resultset

Student

stu;

while(cursor.moveToNext()){

//移動游標

int

id=cursor.getInt(cursor.getColumnIndex("userid"));

String

name=cursor.getString(cursor.getColumnIndex("username"));

String

address=cursor.getString(cursor.getColumnIndex("address"));

stu=new

Student();

stu.setUserid(id);

stu.setUsername(name);

stu.setAddress(address);

all.add(stu);

}

cursor.close();

//關(guān)閉游標

return

all;

}public

Cursor

fiandAllCursor(){

List<Student>

all=new

ArrayList<Student>();

String

sql="select

userid

as

_id,username,address

from

student";

SQLiteDatabase

database=db.getReadableDatabase();

//使用getReadableDatabase取得SQLiteDatabase

Cursor

cursor=database.rawQuery(sql,

null);

//得到游標,類似resultset

//cursor.close();

//這里不可以關(guān)閉游標

return

cursor;

}Cursor

all=this.service.fiandAllCursor();

//使用游標適配器

SimpleCursorAdapter

cadapter=new

SimpleCursorAdapter(this,

R.layout.listview,all,

new

String[]{"_id","username","address"},new

int[]{R.id.userid,R.id.username,R.id.address});

view.setAdapter(cadapter);

//添加列表項監(jiān)聽事件

view.setOnItemClickListener(new

OnItemClickListener(){

public

void

onItemClick(Adapte