• Android SQLite


    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);
    }
  • 相关阅读:
    if __name__ == '__main__' 用法理解
    VSCode 使用
    sys.argv用法简介
    [Python3] RSA的加解密和签名/验签实现 -- 使用pycrytodome
    python requests 超时与重试
    collections模块之defaultdict()与namedtuple()方法简单介绍
    setdefault函数的用法及理解
    python并发编程之IO模型 同步 异步 阻塞 非阻塞
    django+uWSGI+nginx的工作原理流程与部署过程
    Nginx静态服务配置---详解root和alias指令
  • 原文地址:https://www.cnblogs.com/qionglouyuyu/p/4620220.html
Copyright © 2020-2023  润新知