大佬教程收集整理的这篇文章主要介绍了Android 中SQLite技术实例详解,大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
轻量级:sqlite数据库是一个轻量级的数据库,适用于少量数据的CURD;
文件本质:sqlite数据库支持大部分sql语法,允许使用sql语句操作数据库,其本质是一个文件,不需要安装启动。
二.简单的数据库语句知识
在Android平台上,集成了一个嵌入式关系型数据库―sqlite,sqlite3支持NULL,IntegeR,REAL(浮点数字),TEXT(字符串文本)和BLOB(二进制对象)数据类型,实际上sqlite3也接受varchar(n),char(n),decimal(p,s)等数据类型,只不过在运算或保存时会转成对应的五种数据类型.
sqlite最大的特点是你可以把各种类型的数据保存到任何字段中,而不用关心字段声明的数据类型是什么。
实例代码:
import java.util.ArrayList; import java.util.Iterator; import com.hucc.huccgps.R; import android.app.Activity; import android.app.Dialog; import android.content.Context; import android.content.Intent; import android.content.SharedPreferences; import android.net.Uri; import android.os.bundle; import android.util.Log; import android.view.LayoutInflater; import android.view.View; import android.view.View.onClickListener; import android.view.ViewGroup; import android.view.Window; import android.widget.AdapterView; import android.widget.AdapterView.onItemClickListener; import android.widget.baseAdapter; import android.widget.button; import android.widget.EditText; import android.widget.ImageView; import android.widget.ListView; import android.widget.TextView; import android.widget.Toast; public class MainActivity extends Activity { private static final String TAG = "JGPS/MainActivity"; private TextView mAdd_white = null; private ListView mWhiteListView = null; private Context mContext = null; privatE int mPosition; private DBHelper mDBHelper = null; private Whitelistadapter mAdapter = null; private ArrayList<Item> mWhiteListItem = new ArrayList<Item>(); @Override protected void onCreate(Bundle savedInstanceStatE) { Log.d("JGPS/Start","onCreate"); super.onCreate(savedInstanceStatE); setContentView(R.layout.relative_main); this.mDBHelper = new DBHelper(this); this.mContext = this; this.mWhiteListItem = new ArrayList<Item>(); this.mWhiteListView = (ListView)findViewById(R.id.list_view); initData(); this.mWhiteListView.setOnItemClickListener(new OnItemClickListener() { @Override public void onItemClick(AdapterView<?> paramAdapterView,View paramView,int paramInt,long paramLong) { Log.d("JGPS/MainActivity",""+paramint); MainActivity.this.updateWhiteList((Item)MainActivity.this.mWhiteListItem.get(paramint)); } }); if (this.mAdd_white == null) return; mAdd_white.setOnClickListener(new OnClickListener() { @Override public void onClick(View arg0) { MainActivity.this.addContactList(); } }); Log.d("JGPS/end","onCreate"); } private void initData() { this.mWhiteListItem = this.mDBHelper.getRelativesList(); if (this.mWhiteListItem.size() != 3) { for (int i = 1; i < 4; i++) { Log.d("JGPS/MainActivity","initData,id=" + i); Item localItem1 = new Item(); localItem1.setName(""); localItem1.setnumber(""); addItemToList(localItem1); updateSetTing(i,""); } this.mWhiteListItem = this.mDBHelper.getRelativesList(); } Iterator localIterator = this.mWhiteListItem.iterator(); while (localIterator.hasNext()) { Item localItem2 = (Item) localIterator.next(); Log.d("JGPS/MainActivity",id=" + localItem2.getId() + ",name = " + localItem2.getName() + ",number=" + localItem2.getnumber()); } this.mAdapter = new Whitelistadapter(this,this.mWhiteListItem); this.mWhiteListView.setAdapter(mAdapter); } private void updateSetTing(int id,String phoneNum) { switch (id) { case 1: putSTing("phone_num1",phoneNum); break; case 2: putSTing("phone_num2",phoneNum); break; case 3: putSTing("phone_num3",phoneNum); break; default: Log.d("JGPS/MainActivity","Wrong relative number id"); } } private void putSTing(String paramString1,String paramString2) { SharedPreferences.Editor localEditor = getSharedPreferences("sos_config",0).edit(); localEditor.putString(paramString1,paramString2); localEditor.apply(); } protected void updateWhiteList(Item paramItem) { final Item item = paramItem; Log.d("JGPS/MainActivity","updateWhiteList------" + item.getId()); final Dialog localDialog = new Dialog(this,R.style.dialog); localDialog.show(); Window localWindow = localDialog.getWindow(); localWindow.setContentView(R.layout.dialog_editor); Button localButton1 = (Button) localWindow.findViewById(R.id.btn_ok); Button localButton2 = (Button) localWindow.findViewById(R.id.btn_cancel); final EditText phone = (EditText)localWindow.findViewById(R.id.phonE); final EditText name = (EditText)localWindow.findViewById(R.id.Name); name.setText(item.getName()); phone.setText(item.getnumber()); ((TextView)localWindow.findViewById(R.id.titlE)).setText(R.String.edit_whitE); localButton1.setOnClickListener(new OnClickListener() { @Override public void onClick(View paramView) { if (phone.getText().toString().trim().length() == 0) { Toast.makeText(mContext,R.String.toast_tel,2000).show(); return; } if (name.getText().toString().trim().length() == 0) { Toast.makeText(mContext,R.String.name_null,2000).show(); return; } MainActivity.this.updateContacTinDB(item.getId(),name.getText().toString(),phone.getText().toString()); int id = Integer.parseInt(item.getId()); updateSetTing(id,phone.getText().toString()); Toast.makeText(mContext,R.String.edit_success,2000).show(); localDialog.cancel(); } }); localButton2.setOnClickListener(new OnClickListener() { @Override public void onClick(View paramView) { localDialog.cancel(); } }); } protected void updateContacTinDB(String paramString1,String paramString2,String paramString3) { Item localItem = new Item(); localItem.setId(paramString1); localItem.setName(paramString2); localItem.setnumber(paramString3); updateItemList(localItem); } private void updateItemList(Item paramItem) { Item localItem2; Iterator localIterator1 = this.mWhiteListItem.iterator(); while (localIterator1.hasNext()) { localItem2 = (Item) localIterator1.next(); if (localItem2.getId().equals(paramItem.getId())) { localItem2.setName(paramItem.getName()); localItem2.setnumber(paramItem.getnumber()); this.mDBHelper.updateRelativesItem(paramItem); } } Log.d("JGPS/MainActivity","updateItemInList ---------"); this.mAdapter = new Whitelistadapter(this,this.mWhiteListItem); this.mWhiteListView.setAdapter(mAdapter); } private void addContactList() { final Dialog dialog = new Dialog(this,R.style.dialog); dialog.show(); Window window = dialog.getWindow(); window.setContentView(R.layout.dialog_editor); Button btn1 = (Button)window.findViewById(R.id.btn_ok); Button btn2 = (Button)window.findViewById(R.id.btn_cancel); final EditText phone = (EditText)window.findViewById(R.id.phonE); final EditText name = (EditText)window.findViewById(R.id.Name); btn1.setOnClickListener(new OnClickListener() { @Override public void onClick(View arg0) { if (phone.getText().toString().trim().length() == 0) { Toast.makeText(mContext,2000).show(); return; } if (name.getText().toString().trim().length() == 0) { Toast.makeText(mContext,2000).show(); return; } if (MainActivity.this.mWhiteListItem.size()>3) { String str = MainActivity.this.getresources().getString(R.String.full1)+ " " + 3 + " " + MainActivity.this.getresources().getString(R.String.full2); Toast.makeText(mContext,str,2000).show(); dialog.cancel(); return; } MainActivity.this.addContactToDB(name.getText().toString(),phone.getText().toString()); dialog.cancel(); } }); btn2.setOnClickListener(new OnClickListener() { @Override public void onClick(View arg0) { dialog.cancel(); } }); } protected void deleteContactFromDB(String paramString) { updateContacTinDB(paramString,"",""); Log.d("JGPS/MainActivity","===addItemToList = "+paramString); int id = Integer.parseInt(paramString); updateSetTing(id,paramString); Toast.makeText(this.mContext,R.String.delete_success,2000).show(); } @Override protected void onStart() { Log.d("JGPS/MainActivity","onStart()"); super.onStart(); } protected void startContacTintent(int paramint) { Log.d("JGPS/MainActivity","onClick " + paramint); this.mPosition = paramInt; Intent localIntent = new Intent("android.intent.action.PICK"); localIntent.setType("vnd.android.cursor.dir/phone_v2"); startActivityForResult(localIntent,100); } protected void addContactToDB(String paramString1,String paramString2) { Iterator localIterator = this.mWhiteListItem.iterator(); while (localIterator.hasNext()) { if(((Item)localIterator.next()).getnumber().equals(paramString2)){ Toast.makeText(mContext,R.String.replace,2000).show(); return; } } Item localItem = new Item(); localItem.setName(paramString1); localItem.setnumber(paramString2); addItemToList(localItem); Toast.makeText(mContext,2000).show(); } private void addItemToList(Item localItem) { Log.d("JGPS/MainActivity","addItemToList,name = " + localItem.getName() + ",number=" + localItem.getnumber()); this.mDBHelper.addRelativesItem(localItem); this.mWhiteListItem = this.mDBHelper.getRelativesList(); this.mAdapter = new Whitelistadapter(this,this.mWhiteListItem); this.mWhiteListView.setAdapter(mAdapter); } public void startActivityForResult(Intent paramIntent,int paramint) { super.startActivityForResult(paramIntent,paramint); } private class Whitelistadapter extends BaseAdapter{ private Context context; private LayoutInflater mInflater; private ArrayList<Item> listItem; public Whitelistadapter(Context context1,ArrayList<Item> whiteListItem) { this.context = context1; this.listItem = whiteListItem; this.mInflater = LayoutInflater.from(context); } public int getCount() { if ((this.listItem !=null) && (this.listItem.size() > 0)) { return 3; } return 0; } public Object getItem(int paramint) { if ((this.listItem != null) && (this.listItem.size() > 0)) return this.listItem.get(paramint); return null; } public long getItemId(int paramint) { return 0L; } @Override public View getView(int paramInt,ViewGroup paramViewGroup) { Log.d("JGPS/MainActivity","getView,position=" + paramInt + ",name=" + ((Item)this.listItem.get(paramint)).getName() + ",num=" + ((Item)this.listItem.get(paramint)).getnumber()); if (paramView == null) { final ViewHolder localViewHolder = new ViewHolder(); paramView = this.mInflater.inflate(R.layout.relative_list_item,null); localViewHolder.ivCall = (ImageView)paramView.findViewById(R.id.imageView_call); localViewHolder.ivdelete = (ImageView)paramView.findViewById(R.id.imageView_Delete); localViewHolder.ivSELEct = (ImageView)paramView.findViewById(R.id.recipients_picker); localViewHolder.txtView_name = (TextView)paramView.findViewById(R.id.txtView_Name); localViewHolder.txtView_tel = (TextView)paramView.findViewById(R.id.txtView_number); paramView.setTag(localViewHolder); localViewHolder.position = paramInt; localViewHolder.ivSELEct.setTag(localViewHolder); if ((this.listItem.get(paramint)== null)|| (((Item)this.listItem.get(paramint)).getnumber() == null) || (((Item)this.listItem.get(paramint)).getnumber().equals(""))) { localViewHolder.ivCall.setVisibility(View.GONE); localViewHolder.ivSELEct.setVisibility(View.VISIBLE); String str1 = MainActivity.this.getString(R.String.family_String); String str2 = str1 + (paramInt + 1) + ":"; localViewHolder.txtView_name.setText(str2); localViewHolder.txtView_tel.setText(R.String.click_to_add); }else { localViewHolder.ivCall.setVisibility(View.VISIBLE); localViewHolder.ivSELEct.setVisibility(View.GONE); localViewHolder.txtView_name.setText(((Item)this.listItem.get(paramint)).getName()); localViewHolder.txtView_tel.setText(((Item)this.listItem.get(paramint)).getnumber()); } localViewHolder.ivSELEct.setOnClickListener(new OnClickListener() { @Override public void onClick(View paramView) { MainActivity.Whitelistadapter.ViewHolder localViewHolder = (MainActivity.Whitelistadapter.ViewHolder)paramView.getTag(); Log.d("JGPS/MainActivity",mPosition=" + MainActivity.this.mPosition); MainActivity.this.startContacTintent(localViewHolder.position); } }); if ((!(((Item)this.listItem.get(paramint)).getName().equals(""))) || (!(((Item)this.listItem.get(paramint)).getnumber().equals("")))) { localViewHolder.ivdelete.setVisibility(View.VISIBLE); }else { localViewHolder.ivdelete.setVisibility(View.GONE); } localViewHolder.ivCall.setOnClickListener(new OnClickListener() { @Override public void onClick(View paramView) { Intent localIntent = new Intent("android.intent.action.CALL",Uri.parse("tel:" + ((Item)MainActivity.Whitelistadapter.this.listItem.get(localViewHolder.position)).getnumber())); MainActivity.Whitelistadapter.this.context.startActivity(localIntent); } }); localViewHolder.ivdelete.setOnClickListener(new OnClickListener() { @Override public void onClick(View paramView) { if(paramView.getId() != R.id.imageView_Delete) return; final String str = ((Item)MainActivity.Whitelistadapter.this.listItem.get(localViewHolder.position)).getId(); Log.d("JGPS/MainActivity","delete item onClick,Strid=" + str + ",position=" + localViewHolder.position); final Dialog localDialog = new Dialog(MainActivity.Whitelistadapter.this.context,R.style.dialog); localDialog.show(); Window localWindow = localDialog.getWindow(); localWindow.setContentView(R.layout.dialog_Delete); ((TextView)localWindow.findViewById(R.id.txtView_Delete)).setText(MainActivity.Whitelistadapter.this.context.getresources().getString(R.String.delete_onE) + "'" + ((Item)MainActivity.Whitelistadapter.this.listItem.get(localViewHolder.position)).getName() + "'" + MainActivity.Whitelistadapter.this.context.getresources().getString(R.String.delete_two)); Button localButton1 = (Button) localWindow.findViewById(R.id.btn_ok); Button localButton2 = (Button) localWindow.findViewById(R.id.btn_cancel); localButton1.setOnClickListener(new OnClickListener() { @Override public void onClick(View paramView) { MainActivity.this.deleteContactFromDB(str); localDialog.cancel(); } }); localButton2.setOnClickListener(new OnClickListener() { @Override public void onClick(View paramView) { localDialog.cancel(); } }); } }); }else { } return paramView; } public class ViewHolder{ public ImageView ivCall; public ImageView ivdelete; public ImageView ivSELEct; public int position; public TextView txtView_name; public TextView txtView_tel; } } } import java.util.ArrayList; import android.content.ContentValues; import android.content.Context; import android.database.cursor; import android.database.sqlite.sqliteDatabase; import android.database.sqlite.sqliteOpenHelper; import android.util.Log; public class DBHelper extends sqliteOpenHelper { public static final String table_RELATIVES_CONTENT = "RelativesContent"; public static final int version = 1; //版本 public static final String dbname = "SosDB"; //数据库的名字 public static Context mContext = null; public sqliteDatabase db = null; public DBHelper(Context paramContext) { super(paramContext,"SosDB",null,1); mContext = paramContext; } // 创建数据库表 @Override public void onCreate(sqliteDatabase paramsqliteDatabasE) { paramsqliteDatabase.execsql("create table RelativesContent(id INTEGER PRIMary key autoincrement,@R_198_4687@t,number text)"); closeDatabase(); } private void closeDatabase() { if (this.db == null) return; this.db.close(); } @Override public void onUpgrade(sqliteDatabase paramsqliteDatabase,int paramInt1,int paramInt2) { onCreate(paramsqliteDatabasE); } //查询方法 public ArrayList<Item> getRelativesList() { String idf = null; String namef = null; String numf = null; ArrayList localArrayList = new ArrayList(); openDatabase(); cursor localcursor = this.db.query("RelativesContent",null); if(localcursor == null) return localArrayList; while (localcursor.moveToNext()) { Item localItem = new Item(); idf = localcursor.getString(localcursor.getcolumnIndex("id")); namef = localcursor.getString(localcursor.getcolumnIndex("name")); numf = localcursor.getString(localcursor.getcolumnIndex("number")); localItem.setId(idf); Log.d("JGPS/MainActivity","dbid=" + idf); if ((namef == null) || ("".equals(namef))) { localItem.setName(""); }else { localItem.setName(namef); } if ((numf == null) || ("".equals(numf))) { localItem.setnumber(""); }else { localItem.setnumber(numf); } localArrayList.add(localItem); } return localArrayList; } //写入数据 private void openDatabase() { this.db = super.getWritableDatabase(); } //添加数据 public Boolean addRelativesItem(Item localItem) { openDatabase(); ContentValues localContentValues = new ContentValues(); localContentValues.put("name",localItem.getName()); localContentValues.put("number",localItem.getnumber()); long l = this.db.insert("RelativesContent",localContentValues); closeDatabase(); return (1<=0L); } //更新数据 public Boolean updateRelativesItem(Item paramItem) { openDatabase(); ContentValues localContentValues = new ContentValues(); localContentValues.put("name",paramItem.getName()); localContentValues.put("number",paramItem.getnumber()); sqliteDatabase localsqliteDatabase = this.db; String[] arrayOfString = new String[1]; arrayOfString[0] = paramItem.getId(); long l = localsqliteDatabase.update("RelativesContent",localContentValues,"id=?",arrayOfString); closeDatabase(); return (1 <= 0L); } } import java.io.serializable; public class Item implements serializable{ private String _id; private String name; private String number; public Item() { // TODO Auto-generated constructor stub } public void Item(String paramString1,String paramString3) { this._id = paramString1; this.name = paramString2; this.number = paramString3; } public String getId() { return _id; } public void setId(String paramString) { this._id = paramString; } public String getName() { return name; } public void setName(String paramString) { this.name = paramString; } public String getnumber() { return number; } public void setnumber(String paramString) { this.number = paramString; } }
这是基本的数据程序。
XML
relative_main
<LinearLayout android:orientation="vertical" android:BACkground="@color/BACkground_color" android:layout_width="fill_parent" android:layout_height="fill_parent" xmlns:android="http://scheR_269_11845@as.android.com/apk/res/android"> <RelativeLayout android:BACkground="@drawable/title_bar" android:layout_width="fill_parent" android:layout_height="50.0sp"> <TextView android:textSize="@dimen/title_size" android:textStyle="bold" android:textColor="@color/title_color" android:gravity="center" android:layout_gravity="center" android:layout_width="wrap_content" android:layout_height="50.0sp" android:text="@String/relative_name" android:layout_centerInParent="true" /> </RelativeLayout> <RelativeLayout android:id="@+id/white_content" android:layout_width="fill_parent" android:layout_height="wrap_content"> <ListView android:id="@+id/list_view" android:scrollbars="none" android:layout_width="fill_parent" android:layout_height="fill_parent" android:scrollingCache="true" android:cachecolorHint="#00000000" android:divider="@null" android:fastScrollEnabled="false" /> </RelativeLayout> </LinearLayout> dialog_editor <?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://scheR_269_11845@as.android.com/apk/res/android" android:gravity="center" android:orientation="vertical" android:id="@+id/linearlayout_dialog" android:layout_width="300.0dip" android:layout_height="wrap_content"> <TextView android:textSize="20.0sp" android:textColor="#ffffffff" android:gravity="center" android:id="@+id/title" android:BACkground="@drawable/popup_topbg" android:layout_width="fill_parent" android:layout_height="60.0dip" android:text="@String/add_white" /> <LinearLayout android:orientation="vertical" android:BACkground="@drawable/simple_dialog_list_item_bg" android:paddingLeft="5.0dip" android:paddingTop="5.0dip" android:paddingRight="5.0dip" android:layout_width="fill_parent" android:layout_height="wrap_content"> <LinearLayout android:orientation="horizontal" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_marginLeft="8.0dip" android:layout_marginTop="6.0dip" android:layout_marginRight="6.0dip" android:layout_marginBottom="2.0dip"> <TextView android:textSize="16.0sp" android:textColor="#ff000000" android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="@String/name" /> <EditText android:gravity="left|center" android:id="@+id/name" android:BACkground="@drawable/text_input" android:layout_width="210.0dip" android:layout_height="wrap_content" android:layout_marginLeft="8.0dip" android:hint="@String/name_hint" android:singleLine="true" /> </LinearLayout> <LinearLayout android:layout_gravity="center" android:orientation="horizontal" android:layout_width="fill_parent" android:layout_height="wrap_content" android:layout_marginLeft="8.0dip" android:layout_marginRight="6.0dip"> <TextView android:textSize="16.0sp" android:textColor="#ff000000" android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="@String/address" /> <EditText android:gravity="left|center" android:id="@+id/phone" android:BACkground="@drawable/text_input" android:layout_width="210.0dip" android:layout_height="wrap_content" android:layout_marginLeft="8.0dip" android:hint="@String/address_hint" android:singleLine="true" android:inputType="phone" /> </LinearLayout> <include layout="@layout/divider" /> <LinearLayout android:orientation="horizontal" android:layout_width="fill_parent" android:layout_height="54.0dip"> <Button android:textSize="20.0sp" android:id="@+id/btn_ok" android:layout_width="fill_parent" android:layout_height="fill_parent" android:text="@String/ok" android:layout_weight="5.0" style="@style/dialog_item" /> <View android:BACkground="#ffbcc2c5" android:layout_width="2.0px" android:layout_height="fill_parent" /> <Button android:textSize="20.0sp" android:id="@+id/btn_cancel" android:layout_width="fill_parent" android:layout_height="fill_parent" android:text="@String/cancel" android:layout_weight="5.0" style="@style/dialog_item" /> </LinearLayout> </LinearLayout> </LinearLayout>
relative_list_item
<LinearLayout xmlns:android="http://scheR_269_11845@as.android.com/apk/res/android" android:gravity="center_vertical" android:orientation="horizontal" android:layout_width="fill_parent" android:layout_height="40.0dip" style="@style/list_item_BACkground"> <LinearLayout android:gravity="center_vertical" android:orientation="horizontal" android:id="@+id/ll_line1" android:paddingLeft="5.0dip" android:paddingRight="5.0dip" android:layout_width="0.0dip" android:layout_height="wrap_content" android:layout_weight="1.0"> <TextView android:textSize="@dimen/list_font_size_0" android:textStyle="bold" android:textColor="@color/list_item_text" android:ellipsize="end" android:gravity="center" android:id="@+id/txtView_name" android:paddingBottom="3.0dip" android:layout_width="wrap_content" android:layout_height="wrap_content" android:maxWidth="80.0dip" android:singleLine="true" /> <TextView android:textSize="@dimen/list_font_size_1" android:textStyle="bold" android:textColor="@color/list_item_text" android:ellipsize="end" android:gravity="center" android:id="@+id/txtView_number" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_marginLeft="10.0dip" android:singleLine="true" /> </LinearLayout> <ImageView android:layout_gravity="center_vertical" android:id="@+id/imageView_call" android:BACkground="@drawable/btn_dial_action" android:paddingLeft="8.0dip" android:paddingTop="8.0dip" android:paddingRight="8.0dip" android:paddingBottom="8.0dip" android:layout_width="wrap_content" android:layout_height="wrap_content" android:src="@drawable/call_phone" />" <ImageView android:layout_gravity="center_vertical" android:id="@+id/recipients_picker" android:BACkground="@drawable/add_contact_SELEctor" android:layout_width="65.0dip" android:layout_height="65.0dip" android:layout_marginLeft="2.0dip" android:layout_marginRight="2.0dip" android:scaleType="fitXY" /> <View android:id="@+id/imageView_divider" android:BACkground="#2b2b2b2b" android:layout_width="2.0dip" android:layout_height="40.0dip" /> <ImageView android:layout_gravity="right|center" android:id="@+id/imageView_delete" android:paddingLeft="8.0dip" android:paddingTop="8.0dip" android:paddingRight="8.0dip" android:paddingBottom="8.0dip" android:layout_width="wrap_content" android:layout_height="wrap_content" android:src="@drawable/del_cross" /> </LinearLayout>
dialog_delete
<LinearLayout xmlns:android="http://scheR_269_11845@as.android.com/apk/res/android" android:gravity="center" android:orientation="vertical" android:id="@+id/linearLayout_dialog" android:layout_width="300.0dip" android:layout_height="wrap_content"> <TextView android:textSize="20.0sp" android:textColor="#ffffffff" android:gravity="center" android:BACkground="@drawable/popup_topbg" android:layout_width="fill_parent" android:layout_height="60.0dip" android:text="@String/tips" /> <LinearLayout android:orientation="vertical" android:BACkground="@drawable/simple_dialog_list_item_bg" android:paddingLeft="5.0dip" android:paddingTop="12.0dip" android:paddingRight="5.0dip" android:layout_width="fill_parent" android:layout_height="wrap_content"> <TextView android:textSize="20.0sp" android:textColor="#ff000000" android:id="@+id/txtView_delete" android:paddingBottom="12.0dip" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_marginLeft="8.0dip" android:layout_marginRight="6.0dip" /> <include layout="@layout/divider" /> <LinearLayout android:orientation="horizontal" android:layout_width="fill_parent" android:layout_height="54.0dip"> <Button android:textSize="20.0sp" android:id="@+id/btn_ok" android:layout_width="fill_parent" android:layout_height="fill_parent" android:text="@String/dialog_yes" android:layout_weight="5.0" style="@style/dialog_item" /> <View android:BACkground="#ffbcc2c5" android:layout_width="2.0px" android:layout_height="fill_parent" /> <Button android:textSize="20.0sp" android:id="@+id/btn_cancel" android:layout_width="fill_parent" android:layout_height="fill_parent" android:text="@String/dialog_no" android:layout_weight="5.0" style="@style/dialog_item" /> </LinearLayout> </LinearLayout> </LinearLayout>
这是一个简单的demo,我这里就不详细说明数据库的细节了,对于已经很熟悉数据库的,可以查看android官网有说明的,
感谢阅读,希望能帮助到大家,谢谢大家对本站的支持!
以上是大佬教程为你收集整理的Android 中SQLite技术实例详解全部内容,希望文章能够帮你解决Android 中SQLite技术实例详解所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。