首页 > 移动平台 > 详细

Android SQLite

时间:2015-07-04 10:56:15      阅读:270      评论:0      收藏:0      [点我收藏+]
private MySQLiteOpenHelper dbHelper=null;
int version = 1;
   
//table name
String tables[]={"t_favorateExposant"};
//fields’ name of the table
String fieldNames[][] =
{
    { "f_id", "f_name", "f_stand", "f_activity", "f_present", "f_tel", "f_fax", "f_email", "f_website"}
};
//fields’ type of the table
String fieldTypes[][] =
{
    { "INTEGER PRIMARY KEY AUTOINCREMENT", "text", "text", "text", "text", "text", "text", "text", "text"}
};
//columns’name, for which we search the values  
String resultColumn[] = {"f_id", "f_name"};
//create database
dbHelper = new MySQLiteOpenHelper(this, "dbSalon", null, version, tables, fieldNames, fieldTypes);
//recherché
String selectionArgs[] = {selectedExpoName};
Cursor c = dbHelper.select(tables[0], resultColumn, "f_name=?", selectionArgs, null, null, null);
 
//delete
if (c.moveToFirst())
{
        String where = "f_id=?";
        String whereValue[] = {c.getString(0)};
        int col = dbHelper.delete(tables[0], where, whereValue);
        holder.star.setImageResource(R.drawable.p03a_exposants_checkbox);
}
 
//insert
else
{
    String f2[] = {"f_name", "f_stand", "f_activity", "f_present", "f_tel", "f_fax", "f_email", "f_website"};
    for (int i = 0; i < exposantList.size();i++)
    {
       if(!exposantList.get(i).getSociete().equals(selectedExpoName))
        {continue;}
                        
       activity = exposantList.get(i).getActivite();
       present = exposantList.get(i).getPresentation();
       tel = exposantList.get(i).getTelephone();
       fax = exposantList.get(i).getFax();
       email  = exposantList.get(i).getEmail();
       website = exposantList.get(i).getAdresseSiteWeb();
    }
                       
    String value[] = {selectedExpoName,selectedStand,activity,present,tel,fax,email,website};
    long rowid = dbHelper.insert(tables[0], f2, value);
    holder.star.setImageResource(R.drawable.p03a_exposants_checkbox_selected);
}

 

Android SQLite

原文:http://www.cnblogs.com/qionglouyuyu/p/4620220.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!