Spinner 从数据库中读取数据并实现2级互动
来源:互联网 发布:top域名好吗 编辑:程序博客网 时间:2024/06/07 15:04
这里主要实现了。省份和城市的二级关联。选择省份。二级对应的就是省份所有的城市
下面看代码;
1.activity
@Override
protected void onCreate(Bundle savedInstanceState) {
// TODO Auto-generated method stub
super.onCreate(savedInstanceState);
setContentView(R.layout.test_layout);
this.mContext = this;
Map<Integer,List> data = ProvinceDB.getProvince();//得到数据库数据
provinceList = data.get(1);
provinceData = data.get(0);
ArrayAdapter provinceAdapter = new ArrayAdapter(mContext,android.R.layout.simple_spinner_item,provinceList);
provinceAdapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item); // 样式
spProvince.setAdapter(provinceAdapter);
spProvince.setOnItemSelectedListener(itemSelectedListener);
}
// 选择省份 联动 对应城市
private OnItemSelectedListener itemSelectedListener = new OnItemSelectedListener() {
@Override
public void onItemSelected(AdapterView<?> parent, View view,
int position, long id) {
Spinner spProvince = (Spinner) parent;
String selProvince = (String) spProvince.getItemAtPosition(position);
ArrayAdapter cityAdapter = null;
Map<String,Integer> data = (Map)provinceData.get(position);//根据所选择的得到对应的省份id 然后得到城市
int pid = data.get(selProvince);//得到省份的id
List cityList = ProvinceDB.getCityByPid(pid);
cityAdapter = new ArrayAdapter(mContext,android.R.layout.simple_spinner_item,cityList);
cityAdapter
.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
spCity.setAdapter(cityAdapter);
spCity.setOnItemSelectedListener(citySelectedListener);
}
@Override
public void onNothingSelected(AdapterView<?> parent) {
// TODO Auto-generated method stub
}
};
String selectedCity = null;
private OnItemSelectedListener citySelectedListener = new OnItemSelectedListener() {
@Override
public void onItemSelected(AdapterView<?> parent, View view,
int position, long id) {
Spinner spCity = (Spinner) parent;
selectedCity = (String) spCity.getItemAtPosition(position);
}
@Override
public void onNothingSelected(AdapterView<?> parent) {
// TODO Auto-generated method stub
}
};
2.DB类查询数据
public class ProvinceDB {
public static Map<Integer,List> getProvince(){
String sql = "select N_PROVID ,S_PROVNAME from dict_province ";
SQLiteDatabase db = null;
Cursor c = null;
Map<Integer,List> provinceData = new HashMap<Integer,List>();
List provinceList = null;
try{
db = DatabaseHelper.getDatabase();
c = db.rawQuery(sql, null);
List provinceList1 = new ArrayList();
List provinceList2 = new ArrayList();
while(c.moveToNext()){
Map provinceMap = new HashMap();
provinceMap.put(c.getString(1), c.getInt(0));
provinceList1.add(provinceMap);
provinceList2.add(c.getString(1));
}
provinceData.put(0, provinceList1);
provinceData.put(1, provinceList2);
}catch(Exception e){
e.printStackTrace();
}finally{
if(c!=null){
c.close();
}
if(db!=null){
db.close();
}
}
return provinceData;
}
public static List<String> getCityByPid(int id){
String sql = "select S_CITYNAME from dict_city where N_PROVID= "+id;
SQLiteDatabase db = null;
Cursor c = null;
List<String> cityList = null;
try{
db = DatabaseHelper.getDatabase();
c = db.rawQuery(sql, null);
cityList = new ArrayList<String>();
while(c.moveToNext()){
cityList.add(c.getString(0));
}
}catch(Exception ex){
ex.printStackTrace();
}finally{
if(c!=null){
c.close();
}
if(db!=null){
db.close();
}
}
return cityList;
}
}
3.test_layout.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="fill_parent" android:layout_height="fill_parent"
android:orientation="vertical">
<LinearLayout android:layout_width="fill_parent"
android:layout_height="wrap_content">
<Spinner android:id="@+id/sp_bslProvice" android:layout_width="wrap_content"
android:layout_height="wrap_content" android:layout_weight="1" />
<Spinner android:id="@+id/sp_bslCity" android:layout_width="wrap_content"
android:layout_height="wrap_content" android:layout_weight="1" />
</LinearLayout>
下面看代码;
1.activity
@Override
protected void onCreate(Bundle savedInstanceState) {
// TODO Auto-generated method stub
super.onCreate(savedInstanceState);
setContentView(R.layout.test_layout);
this.mContext = this;
Map<Integer,List> data = ProvinceDB.getProvince();//得到数据库数据
provinceList = data.get(1);
provinceData = data.get(0);
ArrayAdapter provinceAdapter = new ArrayAdapter(mContext,android.R.layout.simple_spinner_item,provinceList);
provinceAdapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item); // 样式
spProvince.setAdapter(provinceAdapter);
spProvince.setOnItemSelectedListener(itemSelectedListener);
}
// 选择省份 联动 对应城市
private OnItemSelectedListener itemSelectedListener = new OnItemSelectedListener() {
@Override
public void onItemSelected(AdapterView<?> parent, View view,
int position, long id) {
Spinner spProvince = (Spinner) parent;
String selProvince = (String) spProvince.getItemAtPosition(position);
ArrayAdapter cityAdapter = null;
Map<String,Integer> data = (Map)provinceData.get(position);//根据所选择的得到对应的省份id 然后得到城市
int pid = data.get(selProvince);//得到省份的id
List cityList = ProvinceDB.getCityByPid(pid);
cityAdapter = new ArrayAdapter(mContext,android.R.layout.simple_spinner_item,cityList);
cityAdapter
.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
spCity.setAdapter(cityAdapter);
spCity.setOnItemSelectedListener(citySelectedListener);
}
@Override
public void onNothingSelected(AdapterView<?> parent) {
// TODO Auto-generated method stub
}
};
String selectedCity = null;
private OnItemSelectedListener citySelectedListener = new OnItemSelectedListener() {
@Override
public void onItemSelected(AdapterView<?> parent, View view,
int position, long id) {
Spinner spCity = (Spinner) parent;
selectedCity = (String) spCity.getItemAtPosition(position);
}
@Override
public void onNothingSelected(AdapterView<?> parent) {
// TODO Auto-generated method stub
}
};
2.DB类查询数据
public class ProvinceDB {
public static Map<Integer,List> getProvince(){
String sql = "select N_PROVID ,S_PROVNAME from dict_province ";
SQLiteDatabase db = null;
Cursor c = null;
Map<Integer,List> provinceData = new HashMap<Integer,List>();
List provinceList = null;
try{
db = DatabaseHelper.getDatabase();
c = db.rawQuery(sql, null);
List provinceList1 = new ArrayList();
List provinceList2 = new ArrayList();
while(c.moveToNext()){
Map provinceMap = new HashMap();
provinceMap.put(c.getString(1), c.getInt(0));
provinceList1.add(provinceMap);
provinceList2.add(c.getString(1));
}
provinceData.put(0, provinceList1);
provinceData.put(1, provinceList2);
}catch(Exception e){
e.printStackTrace();
}finally{
if(c!=null){
c.close();
}
if(db!=null){
db.close();
}
}
return provinceData;
}
public static List<String> getCityByPid(int id){
String sql = "select S_CITYNAME from dict_city where N_PROVID= "+id;
SQLiteDatabase db = null;
Cursor c = null;
List<String> cityList = null;
try{
db = DatabaseHelper.getDatabase();
c = db.rawQuery(sql, null);
cityList = new ArrayList<String>();
while(c.moveToNext()){
cityList.add(c.getString(0));
}
}catch(Exception ex){
ex.printStackTrace();
}finally{
if(c!=null){
c.close();
}
if(db!=null){
db.close();
}
}
return cityList;
}
}
3.test_layout.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="fill_parent" android:layout_height="fill_parent"
android:orientation="vertical">
<LinearLayout android:layout_width="fill_parent"
android:layout_height="wrap_content">
<Spinner android:id="@+id/sp_bslProvice" android:layout_width="wrap_content"
android:layout_height="wrap_content" android:layout_weight="1" />
<Spinner android:id="@+id/sp_bslCity" android:layout_width="wrap_content"
android:layout_height="wrap_content" android:layout_weight="1" />
</LinearLayout>
- Spinner 从数据库中读取数据并实现2级互动
- Android利用Spinner从数据库中读取数据并实现2级互动
- spinner 从数据库读取数据并实现二级联动。 .
- 从数据库读取数据放入Spinner
- 网页实现从数据库读取数据并简单分页
- C#从数据库中读取二进制数据,并显示图片
- 从Excel中读取数据并导入数据库
- PHP从数据库中读取数据并打印
- [C#] 从数据库读取数据并输出
- 从cmos中读取数据并显示
- 从资源库中读取数据 并播放
- 从数据库中读取数据,并写入xml文件中(dom4j)
- 使用Apache POI创建Excel,并从数据库中读取数据写入到Excel文件中
- ASP.net 从数据库中读取html格式的数据并显示在页面中
- 从xml文档中读取数据并插入mysql数据库中
- c#从excel中读取数据并添加到数据库中
- java SpringMVC中 POI读取数据库数据并写入Excel表格中,并实现下载功能
- android中TextView中文字从数据库中读取并实现换行
- setBackgroundDrawable和setBackgroundColor的用法
- 数据挖掘经典图书:多角度领略数据挖掘的方法和技术
- remember mexAtExit(&MyExit);
- 【djysim】djyos模拟器-djysim,初步搞定,可以在djysim上面跑GUI了
- DX90SDK SDK源码分析(一) 拉模式的例子
- Spinner 从数据库中读取数据并实现2级互动
- 获取wifi网络中,终端上的ip地址的方法
- Ext.Net 1.x_Ext.Net.Panel组合MSCHART
- linux 之find命令的使用
- Asp.net实现流下载
- js面向对象
- AlertDialog详解
- IIS7.5增加JSON文件解析 .
- 个人收藏:40个UI设计工具和资源