android单选控件spinner与数据库结合综合实例
本示例说明:
1.实现单选按钮与后台数据绑定,通过Id绑定.

2.实现显示时默认选中项控制.

3.实现修改后保存,根据id保存.

4.数据库处理使用AHibernate1.1,详见: http://blog.csdn.net/lk_blog/article/details/8201449

android使用Dialog实现复选功能与数据库结合综合实例见下篇博客: http://blog.csdn.net/lk_blog/article/details/8515403

本示例效果图:

主要代码:spinner.xml

package com.tgb.lk.demo.dao.impl;import java.util.ArrayList;import java.util.List;import java.util.Map;import com.tgb.lk.ahibernate.dao.impl.BaseDaoImpl;import com.tgb.lk.demo.model.Student;import com.tgb.lk.demo.util.CItem;import com.tgb.lk.demo.util.DBHelper;import android.content.Context;//本文数据库处理引用jar包AHibernate1.1处理.//AHibernate的详细使用教程示例地址: http://blog.csdn.net/lk_blog/article/details/7455992//AHibernate源码交流地址: http://blog.csdn.net/lk_blog/article/details/7456125//AHibernate jar包下载及源代码下载地址: http://download.csdn.net/detail/lk_blog/4222048public class StudentDaoImpl extends BaseDaoImpl<Student> {public StudentDaoImpl(Context context) {super(new DBHelper(context), Student.class);}public List<CItem> getCItemStudents(int classId) {String sql = "select _id,name,classesid from t_student";List<Map<String, String>> list = query2MapList(sql, null);List<CItem> retList = new ArrayList<CItem>();for (Map<String, String> map : list) {CItem item = new CItem();item.setId(map.get("_id"));item.setValue(map.get("name"));item.setFlag(map.get("classesid").equals(String.valueOf(classId)) ? true : false);retList.add(item);}return retList;}// 返回一个List,List中的对象是以sql中的列的小写形式为key的Map.(本例中 _id,name,classes为key)public List<Map<String, String>> queryAllStudent() {String sql = "select s._id id, s.name stu_name,c.name cls_name from t_student s left join t_classes c on s.classesid = c._id";return super.query2MapList(sql, null);}public void deleteAll() {super.execSql("delete from t_student", null);}}

源代码下载地址: http://download.csdn.net/detail/lk_blog/5005962

限于本人水平有限,很多地方写的并不完美,希望大家不吝赐教.如果觉得本文对您有帮助请顶支持一下,如果有不足之处欢迎留言交流,希望在和大家的交流中得到提高.