我将使用 RecyclerView 作为部分标题

我想在 SQLite 数据库中插入每个日期和时间数据时创建节标题

我按照以下链接找到了这个解决方案，但没有成功

• Recyclerview Dynamic Sections not using any 3rd lib
• Add two sections in recyclerview android

请引用下图

对于上面的图像数据，使用下面的代码或者部分是静态的:

List<Company> childList = new ArrayList<>();
        List<CompanySectionHeader> sectionHeaders = new ArrayList<>();

        childList = myDb.getAllCompany();
        sectionHeaders.add(new CompanySectionHeader(childList, "WEDNESDAY 4 APRIL", 1));

现在如果假设我输入今天的数据，那么我创建 1 个采用今天日期的节标题

下面的图像数据部分标题是静态的或数据也是:

上面的图像数据正在使用下面的代码:

childList.add(new Company("Ketul Inc.", "11/11/2017 3:46 PM"));
        childList.add(new Company("Atmel Corporation", "09/19/2017 8:46 PM"));
        childList.add(new Company("ABC Technologies", "09/12/2017 7:41 PM"));
        childList.add(new Company("Huron Capital Partners LLC", "09/12/2017 7:25 PM"));
        sectionHeaders = new ArrayList<>();
        //Create a List of SectionHeader DataModel implements SectionHeader
        sectionHeaders.add(new CompanySectionHeader(childList, "SATURDAY 7 APRIL", 2));

下面的代码是我的SectionHeader.Java:

public class CompanySectionHeader implements Section<Company>, Comparable<CompanySectionHeader> {

    List<Company> childList;
    String sectionText;
    int index;

    public CompanySectionHeader(List<Company> childList, String sectionText, int index) {
        this.childList = childList;
        this.sectionText = sectionText;
        this.index = index;
    }

    @Override
    public List<Company> getChildItems() {
        return childList;
    }

    public String getSectionText() {
        return sectionText;
    }

    @Override
    public int compareTo(CompanySectionHeader another) {
        if (this.index > another.index) {
            return -1;
        } else {
            return 1;
        }
    }
}

下面是我的 SQLite 数据库结构:

public String getFromatDate(long dateTime) {
        String formatedDate;
        Calendar calendar = Calendar.getInstance();
        calendar.setTimeInMillis(dateTime);
        Date mDate = calendar.getTime();
        SimpleDateFormat sdf;
        sdf = new SimpleDateFormat("dd/MM/yyyy hh:mm a", new Locale("en"));
        formatedDate = sdf.format(mDate);
        return formatedDate;
    }

    public long insertCompany(Company company){

        //String sql = null;
        SQLiteDatabase db = dbHelper.getWritableDatabase();

        ContentValues values = new ContentValues();

        values.put(DatabaseHelper.KEY_COMPANY_NAME, company.getName());
        values.put(DatabaseHelper.KEY_CREATED_AT, System.currentTimeMillis());
        values.put(DatabaseHelper.KEY_UPDATED_AT, System.currentTimeMillis());
        values.put(DatabaseHelper.KEY_COMPANY_WEBSITE,company.getWebsite());
        values.put(DatabaseHelper.KEY_COMPANY_EMAIL,company.getEmail());
        values.put(DatabaseHelper.KEY_COMPANY_PHONE_HOME,company.getPhoneHome());
        
        long company_id = db.insert(COMPANY, null, values);

        return company_id;
    }

我的问题是如何动态创建节标题

如果你需要任何代码或信息，你可以问我:)

提前致谢:

最佳答案

这里有一个 Json 示例，您只需以这种方式保存、保存和获取数据，在 Json 查看器上运行此示例并查看结构。

对于 SQLIte

public static final String TABLE_NAME = "companies_dates";
public static final String COLUMN_TIMESTAMP = "timestamp"; //primary key
public static final String COLUMN_ID = "id";// primary key



public static final String TABLE_NAME = "companies";

public static final String COLUMN_ID = "id";// primary key
public static final String COLUMN_ID_PARENT = "id_parent"; //foreign key //primary key form table companies_dates
 //or use date as parent_date
public static final String COLUMN_DATE_PARENT = "timestamp";
public static final String COLUMN_TITLE = "company";
public static final String COLUMN_TIMESTAMP = "timestamp";  

//ResponseMain.Java

 public  class  CompaniesResponse{

        ArrayList<Companies> companiesList;

        public ArrayList<Companies> getCompaniesList() {
            return companiesList;
        }

        public void setCompaniesList(ArrayList<Companies> companiesList) {
            this.companiesList = companiesList;
        }
    }

    public  class Companies{


        private String timeStamp;
        ArrayList<CompaniesItem> companiesArrayList;

        public String getTimeStamp() {
            return timeStamp;
        }

        public void setTimeStamp(String timeStamp) {
            this.timeStamp = timeStamp;
        }

        public ArrayList<CompaniesItem> getCompaniesArrayList() {
            return companiesArrayList;
        }

        public void setCompaniesArrayList(ArrayList<CompaniesItem> companiesArrayList) {
            this.companiesArrayList = companiesArrayList;
        }
    }

    public class  CompaniesItem{

        private String title;
        private String id;
        private String timeStamp;
        private String parentId;
        private String parentTimeStamp;

        //getter setters

    }


   @Override
    public void onCreate(Bundle savedInstanceState) {
        //super.onCreate(savedInstanceState);


        CompaniesResponse companiesResponse = new CompaniesResponse();

        Companies companies = new Companies();
       // CompaniesItem companiesItem = new CompaniesItem();

        //companiesItem.setId("1");
       // companiesItem.setTimeStamp("Time Stamp");
      //  ArrayList<CompaniesItem> companiesItemArrayList = new ArrayList<>();
       // companiesItemArrayList.add(companiesItem);

         companiesItemArrayList.add(myDb.getAllCompany());

        companies.setTimeStamp(myDb.getDate());
        companies.setCompaniesArrayList(companiesItemArrayList);

        ArrayList<Companies> companieslist = new ArrayList<>();

        companieslist.add(companies);

        companiesResponse.setCompaniesList(companieslist);


    }

对于 Json

{
 "companies ": [

{
  "date": "12-08.2018",
  "companiesList": [
    {
      "title": "Atmel Corporation",
      "date": "11/11/2017 3:46 PM"
    },
    {
      "title": "Ketul Inc.",
      "date": "11/11/2017 3:46 PM"
    }
  ]
},
{
  "date": "09/19/2017 8:46 PM",
  "companiesList": [
    {
      "title": "Huron Capital Partners LLC",
      "date": "15-06-2018"
    },
    {
      "title": "ABC Technologies",
      "date": "09/12/2017 7:41 PM"
    }
  ]
}


]


}

关于java - RecyclerView 的动态部分标题使用当前日期时间，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/49704131/