package cc.lifelink.cn;
import java.util.ArrayList;
import java.util.List;
import android.app.Activity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.Spinner;
import android.widget.AdapterView.OnItemSelectedListener;
import android.widget.Toast;
public class City_cnActivity extends Activity {
/** Called when the activity is first created. */
private DBManager dbm;
private SQLiteDatabase db;
private Spinner spinner1 = null;
private Spinner spinner2=null;
private Spinner spinner3=null;
private String province=null;
private String city=null;
private String district=null;
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
spinner1=(Spinner)findViewById(R.id.spinner1);
spinner2=(Spinner)findViewById(R.id.spinner2);
spinner3=(Spinner)findViewById(R.id.spinner3);
spinner1.setPrompt("省");
spinner2.setPrompt("城市");
spinner3.setPrompt("地区");
initSpinner1();
}
public void initSpinner1(){
dbm = new DBManager(this);
dbm.openDatabase();
db = dbm.getDatabase();
List<MyListItem> list = new ArrayList<MyListItem>();
try {
String sql = "select * from province";
Cursor cursor = db.rawQuery(sql,null);
cursor.moveToFirst();
while (!cursor.isLast()){
String code=cursor.getString(cursor.getColumnIndex("code"));
byte bytes[]=cursor.getBlob(2);
String name=new String(bytes,"gbk");
MyListItem myListItem=new MyListItem();
myListItem.setName(name);
myListItem.setPcode(code);
list.add(myListItem);
cursor.moveToNext();
}
String code=cursor.getString(cursor.getColumnIndex("code"));
byte bytes[]=cursor.getBlob(2);
String name=new String(bytes,"gbk");
MyListItem myListItem=new MyListItem();
myListItem.setName(name);
myListItem.setPcode(code);
list.add(myListItem);
} catch (Exception e) {
}
dbm.closeDatabase();
db.close();
MyAdapter myAdapter = new MyAdapter(this,list);
spinner1.setAdapter(myAdapter);
spinner1.setOnItemSelectedListener(new SpinnerOnSelectedListener1());
}
public void initSpinner2(String pcode){
dbm = new DBManager(this);
dbm.openDatabase();
db = dbm.getDatabase();
List<MyListItem> list = new ArrayList<MyListItem>();
try {
String sql = "select * from city where pcode='"+pcode+"'";
Cursor cursor = db.rawQuery(sql,null);
cursor.moveToFirst();
while (!cursor.isLast()){
String code=cursor.getString(cursor.getColumnIndex("code"));
byte bytes[]=cursor.getBlob(2);
String name=new String(bytes,"gbk");
MyListItem myListItem=new MyListItem();
myListItem.setName(name);
myListItem.setPcode(code);
list.add(myListItem);
cursor.moveToNext();
}
String code=cursor.getString(cursor.getColumnIndex("code"));
byte bytes[]=cursor.getBlob(2);
String name=new String(bytes,"gbk");
MyListItem myListItem=new MyListItem();
myListItem.setName(name);
myListItem.setPcode(code);
list.add(myListItem);
} catch (Exception e) {
}
dbm.closeDatabase();
db.close();
MyAdapter myAdapter = new MyAdapter(this,list);
spinner2.setAdapter(myAdapter);
spinner2.setOnItemSelectedListener(new SpinnerOnSelectedListener2());
}
public void initSpinner3(String pcode){
dbm = new DBManager(this);
dbm.openDatabase();
db = dbm.getDatabase();
List<MyListItem> list = new ArrayList<MyListItem>();
try {
String sql = "select * from district where pcode='"+pcode+"'";
Cursor cursor = db.rawQuery(sql,null);
cursor.moveToFirst();
while (!cursor.isLast()){
String code=cursor.getString(cursor.getColumnIndex("code"));
byte bytes[]=cursor.getBlob(2);
String name=new String(bytes,"gbk");
MyListItem myListItem=new MyListItem();
myListItem.setName(name);
myListItem.setPcode(code);
list.add(myListItem);
cursor.moveToNext();
}
String code=cursor.getString(cursor.getColumnIndex("code"));
byte bytes[]=cursor.getBlob(2);
String name=new String(bytes,"gbk");
MyListItem myListItem=new MyListItem();
myListItem.setName(name);
myListItem.setPcode(code);
list.add(myListItem);
} catch (Exception e) {
}
dbm.closeDatabase();
db.close();
MyAdapter myAdapter = new MyAdapter(this,list);
spinner3.setAdapter(myAdapter);
spinner3.setOnItemSelectedListener(new SpinnerOnSelectedListener3());
}
class SpinnerOnSelectedListener1 implements OnItemSelectedListener{
public void onItemSelected(AdapterView<?> adapterView, View view, int position,
long id) {
province=((MyListItem) adapterView.getItemAtPosition(position)).getName();
String pcode =((MyListItem) adapterView.getItemAtPosition(position)).getPcode();
initSpinner2(pcode);
initSpinner3(pcode);
}
public void onNothingSelected(AdapterView<?> adapterView) {
// TODO Auto-generated method stub
}
}
class SpinnerOnSelectedListener2 implements OnItemSelectedListener{
public void onItemSelected(AdapterView<?> adapterView, View view, int position,
long id) {
city=((MyListItem) adapterView.getItemAtPosition(position)).getName();
String pcode =((MyListItem) adapterView.getItemAtPosition(position)).getPcode();
initSpinner3(pcode);
}
public void onNothingSelected(AdapterView<?> adapterView) {
// TODO Auto-generated method stub
}
}
class SpinnerOnSelectedListener3 implements OnItemSelectedListener{
public void onItemSelected(AdapterView<?> adapterView, View view, int position,
long id) {
district=((MyListItem) adapterView.getItemAtPosition(position)).getName();
Toast.makeText(City_cnActivity.this, province+" "+city+" "+district, Toast.LENGTH_LONG).show();
}
public void onNothingSelected(AdapterView<?> adapterView) {
// TODO Auto-generated method stub
}
}
}
全国省市县下拉地址选择源码.zip安卓程序源码资源下载
版权申诉
175 浏览量
2022-02-25
13:24:10
上传
评论
收藏 189KB ZIP 举报
yxkfw
- 粉丝: 77
- 资源: 2万+
最新资源
- 基于Javascript和Python的微商城项目设计源码 - MicroMall
- 基于Java的网上订餐系统设计源码 - online ordering system
- 基于Javascript的超级美眉网络资源管理应用模块设计源码
- 基于Typescript和PHP的编程知识储备库设计源码 - study-php
- Screenshot_2024-05-28-11-40-58-177_com.tencent.mm.jpg
- 基于Dart的Flutter小提琴调音器APP设计源码 - violinhelper
- 基于JavaScript和CSS的随寻订购网页设计源码 - web-order
- 基于MATLAB的声纹识别系统设计源码 - VoiceprintRecognition
- 基于Java的微服务插件集合设计源码 - wsy-plugins
- 基于Vue和微信小程序的监理日志系统设计源码 - supervisionLog
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
评论0