spinner 从数据库读取数据并实现二级联动。 .
来源:互联网 发布:国际象棋分析软件 编辑:程序博客网 时间:2024/05/21 21:36
这里主要实现了。省份和城市的二级关联。选择省份。二级对应的就是省份所有的城市
下面看代码;
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 从数据库读取数据并实现二级联动。 .
- 数据库读取数据,二级联动
- Spinner 从数据库中读取数据并实现2级互动
- Android利用Spinner从数据库中读取数据并实现2级互动
- Android Spinner实现二级联动
- 从数据库读取数据放入Spinner
- 在一个jsp页面实现二级下拉框联动,实时读取数据库数据
- 在一个jsp页面实现二级下拉框联动,实时读取数据库数据
- 实现jsp页面二级下拉框联动,实时读取数据库数据
- Struts2中<s:doubleselect>标签从MySQL数据库中查询出数据实现二级联动
- Spinner 二级联动
- Spinner的二级联动
- Spinner的二级联动
- spinner二级联动
- 在一个jsp页面实现二级下拉框联动,实时读取数据库数据(用javascript实现)
- 网页实现从数据库读取数据并简单分页
- 动态二级下拉框联动(二级数据从数据库中获取)
- Android中Spinner二级联动动态加载数据
- Linux0.12-文件系统-高速缓冲区的管理
- MySQL字符集问题总结
- siege做并发请求得到折线图
- 一个项目管理控制软件的介绍
- C++学习总结 写C++程序时的注意事项
- spinner 从数据库读取数据并实现二级联动。 .
- 流星的秘密
- Android技术的生态系统及其安全机制
- c语言学习
- const 的用法(持续更新)
- 编码解析sping的bean原理
- 转 阿里巴巴离职DBA 35岁总结的职业生涯
- iphone和http服务器的通信(详细)
- 通过源码文件安装软件