Android系統(tǒng)手機(jī)基站信息庫(kù)開發(fā)與設(shè)計(jì)

1、Android 系統(tǒng)手機(jī)基站信息庫(kù)開發(fā)與設(shè)計(jì)基站信息庫(kù)軟件：開發(fā)語(yǔ)言： Java 、開發(fā)工具： Eclipse 、數(shù)據(jù)庫(kù) Sqlite 、運(yùn)行環(huán)境： Android 系統(tǒng)手機(jī)1 、數(shù)據(jù)庫(kù)設(shè)計(jì)：根據(jù)不同需求設(shè)計(jì)不同字段，實(shí)現(xiàn)對(duì)數(shù)據(jù)庫(kù)常規(guī)操作以及級(jí)聯(lián)查詢。2、布局設(shè)計(jì)：在手機(jī)終端合理顯示布局，常用控件：LinearLayout 、 RelativeLayout 、 ListView 、 GridView 、 TextView 、 EditText 、 Button 、 Spinner 等等。3、功能開發(fā)：添加： 首先實(shí)例化對(duì)象通過(guò)EditText 控件 getText().toString()方法

2、獲取數(shù)據(jù)，調(diào)用insert()方法完成數(shù)據(jù)添加功能。public long insert(basestation bts) ContentValues values =new ContentValues();values.put(bts_id ,bts.bts_id );values.put(bts_name, bts. bts_name );values.put(bts_address, bts. bts_address );values.put(bts_lat, bts.bts_lat );values.put(bts_lon, bts.bts_lon );values.put(bts_a

3、zimuth, bts. bts_azimuth );values.put(bts_downtilt,bts. bts_downtilt);values.put(bts_bcch, bts. bts_bcch );values.put(bts_ci ,bts.bts_ci );values.put(bts_bsc, bts.bts_bsc );values.put(bts_lac, bts.bts_lac );values.put(bts_height,bts. bts_height );values.put(bts_remark,bts. bts_remark );values.put(im

4、ageid, bts.imageId );values.put(privacy, bts.privacy );values.put(bts_area, bts. bts_area );return dbInstance .insert(DB_TABLENAME , null , values);刪除：獲取刪除數(shù)據(jù)ID 調(diào)用 deleteMarked() 方法實(shí)現(xiàn)刪除功public void deleteMarked(ArrayList deleteId) StringBuffer strDeleteld =new StringBuffer();strDeleteId.append( _id=)

5、;for (int i=0;ideleteId.size();i+) if (i!=deleteId.size()-1) strDeleteId.append(deleteId.get(i) + or _id=); else strDeleteId.append(deleteId.get(i); dbInstance .delete( DB_TABLENAME, strDeleteId.toString(), null ); ;修改：標(biāo)記需要修改的數(shù)據(jù)，調(diào)用 modify()方法實(shí)現(xiàn)修改功能。public voidmodify(basestation bts) ContentValues va

6、lues =new ContentValues();values.put(bts_id , bts. bts_id );values.put(bts_name , bts. bts_name );values.put(bts_address, bts. bts_address );values.put(bts_lat, bts. bts_lat );values.put(bts_lon , bts. bts_lon );values.put(bts_azimuth, bts. bts_azimuth );values.put(bts_downtilt,bts. bts_downtilt);va

7、lues.put(bts_bcch , bts. bts_bcch );values.put(bts_ci , bts. bts_ci );values.put(bts_bsc , bts. bts_bsc );values.put(bts_lac, bts. bts_lac );values.put(bts_height, bts. bts_height );values.put(bts_remark, bts. bts_remark );values.put(bts_area, bts. bts_area );dbInstance.update( DB_TABLENAME, values,

8、_id=?valueOf (bts. _id );newString口String.查詢：通過(guò) EditText 控件 getText().toString()方法獲取查詢數(shù)據(jù)，調(diào)用getbtss()方法實(shí)現(xiàn)模糊查詢。public getbtss(String condition) ArrayList list =String strSelection =new ArrayList();nString sql = (bts_id like %select * from + condition + DB TABLENAME +where 1=1 and% +or bts_remark like

9、%+ condition +% + orbts_name like % + condition + % or bts_address like % + condition + % +or bts_area like %+ condition +%)+strSelection;Cursor cursor =dblnstance .rawQuery(sql,null );列表顯示：調(diào)用ArrayList getbtss()方法返回list 類型，通過(guò)ListView 控件SimpleAdapter對(duì)list 綁定，然后設(shè)置適配器 Adapter進(jìn)行顯示。boolean privacy) publi

10、c ArrayList getbtss(String condition,ArrayList list = new ArrayList();String strSelection =；;if(privacy) strSelection =and privacy = 1else strSelection =and privacy = 0String sql =selectfrom + DB TABLENAME + where 1=1 and(bts_id like %+ condition +%bts name likeor bts remark like % + condition+ % or

11、+ condition +bts addresslike%or+ condition+ % +or bts area like %+ condition +%)+strSelection;Cursor cursor =dblnstance.rawQuery(sql,null );基站定位：調(diào)用百度地圖API,從數(shù)據(jù)庫(kù)中獲取基站經(jīng)緯度，通 過(guò)繼承ItemizedOverlay覆蓋物方法實(shí)現(xiàn)GeoPoint添加基站經(jīng)緯度 在地圖上顯示扇區(qū)圖?；揪嚯x是通過(guò)Android系統(tǒng)內(nèi)置函數(shù)getDistance()獲取直線距離，并通過(guò)format()方法對(duì)數(shù)據(jù)格式化保 留2位小數(shù)。相鄰基站距離是通過(guò)遍歷數(shù)

12、據(jù)庫(kù)基站經(jīng)緯度與當(dāng)前基站 距離做對(duì)比符合要求的結(jié)果顯示在地圖上。GP淀位：調(diào)用百度地圖API,首先判斷手機(jī)硬件 GP創(chuàng)能是否開啟，如果沒(méi)有開啟則打開 GPS然后聲明locationManager對(duì)象并 實(shí)例化，設(shè)置locationListener 監(jiān)聽器調(diào)用getLocation() 方法再 地圖上顯示當(dāng)前GPSg緯度信息。菜單選項(xiàng)：通過(guò)onCreateOptionsMenu方法創(chuàng)建菜單，返回類型:布爾型，item.setIcon()為每一個(gè)Item 設(shè)置圖標(biāo)，然后為每一個(gè)MenuItem添力口事件 onMenuItemSelected。/*為Menu添加幾個(gè)選項(xiàng)*/Overridepubli

13、c boolean onCreateOptionsMenu(Menu menu) menu.addSubMenu(0, Menu.menu.addSubMenu(0, Menu.menu.addSubMenu(0, Menu./為每一個(gè)Item設(shè)置圖標(biāo)FIRST ,1,FIRST +1,2,FIRST +2, 3,MenuItem item = menu.getItem(Menu. item.setIcon(;MenuItem item1 = menu.getItem(Menu.item1.setIcon(;MenuItem item2 = menu.getItem(Menu.item2.se

14、tIcon(;return super .onCreateOptionsMenu(menu);基站定位)；GPS 定位);相鄰基站);FIRST -1);FIRST );FIRST +1);/* 為每一個(gè)MenuItem添加事件*/Overridepublic boolean onMenuItemSelected(switch (item.getItemId()case Menu. FIRST :int featureId, MenuItem item) Intent intent = getIntent();/從意圖中得到需要的 bts對(duì)象bts = (basestation)intent.

15、getSerializableExtra(bts);intent.setClass(BtsDetail.this ,BtsMap. class );/intent.putExtra(bts_map, map);Bundle bundle = new Bundle();bundle.putSerializable(bts_map , bts );intent.putExtras(bundle);startActivity(intent); break ;演示：1、基本功能使用基本功能：基站信息庫(kù)實(shí)現(xiàn)增加、修改、查詢、刪除、數(shù)據(jù)備份、數(shù)據(jù)還原等功能，查詢可以通過(guò)基站編號(hào)或基站名稱關(guān)鍵字查找基站信息方便快捷。2、點(diǎn)擊 基站定位基站定位功能：可以在地圖