在SQLite数据库中存储数组数组。-StoringanArrayListofArraysinSQLiteDatabase

1  

Create several tables.

创建多个表。

One table ('Cource') contains field 'name' and field with reference('id' field) to row in table 'Tee'.

一个表('Cource')包含字段'name'和引用字段('id'字段)以在表'Tee'中行。

Table 'Tee' contains fields 'id', 'name', 'slop', 'rating', 'par' and 'hcp'.

表'Tee'包含字段'id'、'name'、'slop'、'rating'、'par'和'hcp'。

Since it is impossible to store an array in a table row you can:

由于不可能将数组存储在表行中，因此可以:

• convert array to string
• 将数组转换为字符串

• create a field for each item in array

  为数组中的每个项创建一个字段

  StringBuilder b = new StringBuilder(); for(int i = 0; i

  新StringBuilder b = new StringBuilder();for(int i = 0;我 <数组。长度- 1;i++) {if(i !="0)" {b.b end("，");} b.append(阵列[我]);} string stringarr="b.toString();

0  

You have to create the framework for retrieving data.

您必须创建检索数据的框架。

Each course you should treat like one object.

每一门课你都应该像对待一个对象一样对待。

  public class Tee {

    private String Name;
    private int Slope;

    private double Rating;
    private int[] Par={0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0};
    private int[] HCP={0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0};

    public Tee(String name,int slope,double Rating,int[] par,int[] hcp)
    {

     this.name=name;
     this.slope=slope;
     this.Rating=rating;
     this.PAR=par;
     this.HCP=hcp;
   }

public String GetName()
{
return this.name;
}
....

public int[] GetHCP()
{
return this.HCP;
}
}

And Use for loop for inserting data into the database

用于将数据插入数据库的循环

for(int i=0;i