java - 我有保留窗口，但数据未保存。如何将 boolean 值存储到数据库中？

Question

大家好。我正在尝试制作一个与数据库一起使用的应用程序。我有保留窗口，但数据未保存。如何将复选框中的 boolean 值保存到数据库中？

如何解决这个问题？

这是数据库的代码

public class DataBase extends SQLiteOpenHelper{
    public static final String DATABASE_NAME = "DataOfSchedule.db";
    public static final String TABLE_NAME = "DataOfSchedule_table";
    public static final String COL_1 = "ID";
    public static final String COL_2 = "NAME";
    public static final String COL_3 = "AGE";
    public static final String COL_4 = "SEX_MALE";
    public static final String COL_7 = "SEX_FEMALE";
    public static final String COL_5 = "WEIGHT";
    public static final String COL_6 = "HEIGHT";
    public static final String COL_8 = "TRAUMA";
    public DataBase(Context context){
        super(context, DATABASE_NAME, null,1);
    }
    @Override
    public void onCreate(SQLiteDatabase db){
        db.execSQL("CREATE TABLE" + TABLE_NAME + "(ID INTEGER PRIMARY KEY," +
                " NAME TEXT," +
                " AGE INTEGER NOT NULL DEFAULT 0 , " +
                "SEX_MALE  TEXT NOT NULL \n" +
                "        CHECK( typeof(\"boolean\") = \"text\" AND\n" +
                "               \"boolean\" IN (\"TRUE\",\"FALSE\") ," +
                "SEX_FEMALE  TEXT NOT NULL \n" +
                "        CHECK( typeof(\"boolean\") = \"text\" AND\n" +
                "               \"boolean\" IN (\"TRUE\",\"FALSE\")," +
                "TRAUMA NOT NULL  TEXT NOT NULL \n" +
                "        CHECK( typeof(\"boolean\") = \"text\" AND\n" +
                "               \"boolean\" IN (\"TRUE\",\"FALSE\")," +
                "WEIGHT INTEGER NOT NULL DEFAULT 0," +
                "HEIGHT INTEGER NOT NULL DEFAULT 0)");
    }
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion){
        db.execSQL("DROP TABLE IF EXISTS" + TABLE_NAME);
    }
    public boolean insertData(String name, Integer age, String sex_male, String sex_female, Integer weight, Integer height, String trauma){
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        contentValues.put(COL_2,name);
        contentValues.put(COL_3,age);
        contentValues.put(COL_4,sex_male);
        contentValues.put(COL_5,weight);
        contentValues.put(COL_6,height);
        contentValues.put(COL_7,sex_female);
        contentValues.put(COL_8,trauma);
        long result = db.insert(TABLE_NAME,null,contentValues);
        db.close();
        //To Check Whether Data is Inserted in DataBase
        if(result==-1){
            return false;
        }else{
            return true;
        }
    }
    public Cursor getALLData(){
        SQLiteDatabase db = this.getWritableDatabase();
        Cursor res = db.rawQuery("Select * from "+ TABLE_NAME,null);
        return res;
    }
}

是插入数据的Activity的代码

public class InsertData extends AppCompatActivity {
    DataBase myDb;
    EditText txtName, txtAge , txtWeight, txtHeight;
    CheckBox boxSex_male,boxSex_female,boxTrauma;
    Button btnClick;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_insert_data);
        myDb = new DataBase(this);
        txtName = (EditText) findViewById(R.id.name);
        txtAge = (EditText) findViewById(R.id.age);
        boxSex_male = (CheckBox) findViewById(R.id.sex_m);
        boxTrauma = (CheckBox) findViewById(R.id.trauma);
        boxSex_female = (CheckBox) findViewById(R.id.sex_f);
        txtWeight = (EditText) findViewById(R.id.weight);
        txtHeight = (EditText) findViewById(R.id.height);
        btnClick = (Button) findViewById(R.id.InsertBtn);
        btnClick.setOnClickListener(new View.OnClickListener(){
            @Override
            public void onClick(View v){
                ClickMe();
            }
        });
        if(boxTrauma.isChecked()){
            boxTrauma.setChecked(true);
        }else {
            boxTrauma.setChecked(false);
        }
        if(boxSex_female.isChecked()){
            boxSex_female.setChecked(true);
        }else {
            boxSex_female.setChecked(false);
        }
        if(boxSex_male.isChecked()){
            boxSex_male.setChecked(true);
        }else {
            boxSex_male.setChecked(false);
        }
    }
    private void ClickMe(){
        String name = txtName.getText().toString();
        String age = txtAge.getText().toString();
        String sex_male = boxSex_male.getText().toString();
        String trauma = boxTrauma.getText().toString();
        String sex_female = boxSex_female.getText().toString();
        String weight = txtName.getText().toString();
        String height = txtName.getText().toString();
        int weight_int = Integer.parseInt(weight);
        int age_int = Integer.parseInt(age);
        int height_int = Integer.parseInt(height);
        Boolean result = myDb.insertData(name,age_int,sex_male,sex_female,weight_int,height_int,trauma);
        if (result == true){
            Toast.makeText(this, "Data Inserted Successfully",Toast.LENGTH_SHORT).show();
        }else{
            Toast.makeText(this, "Data Inserted Failed",Toast.LENGTH_SHORT).show();
        }
        Intent i = new Intent(this,ResultData.class);
        startActivity(i);
    }


}

这是我的 HTML

<ScrollView xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:padding="16dp"
    tools:context="daniel_nikulshyn_and_andrew_rybka.myway.InsertData">

<LinearLayout
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical"
    android:layout_alignParentTop="true"
    android:layout_alignParentLeft="true"
    android:layout_alignParentStart="true">
    <TextView
        android:id="@+id/heading"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="@string/insert_heading"
        android:layout_gravity="center"
        android:textSize="16dp"
        android:textColor="#021aee"/>

    <EditText
        android:id="@+id/name"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:hint="@string/insert_name"/>
    <EditText
        android:id="@+id/age"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:hint="@string/insert_age"
        android:numeric="integer"/>
    <EditText
        android:id="@+id/weight"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:hint="@string/insert_weight"
        android:numeric="integer"/>
    <EditText
        android:id="@+id/height"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:hint="@string/insert_height"
        android:numeric="integer"/>

    <TextView
        android:padding="10dp"
        android:text="@string/insert_sex"
        android:layout_gravity="left"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content" />
    <CheckBox
        android:id="@+id/sex_m"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="@string/male"/>
    <CheckBox
        android:id="@+id/sex_f"
        android:text="@string/female"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content" />

    <TextView
        android:padding="10dp"
        android:text="@string/insert_trauma"
        android:layout_gravity="left"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content" />
    <CheckBox
        android:id="@+id/trauma"
        android:text="@string/insert_trauma_subtitle"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_marginBottom="20dp"/>

    <Button
        android:id="@+id/InsertBtn"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:background="@color/colorPrimary"
        android:text="@string/insert_button"
        android:textColor="#f2fde4"
        android:layout_gravity="center"/>
</LinearLayout>

</ScrollView>

Answer 1

让我们把这个问题分解成几篇文章。首先，我们可以处理代码的 SQLite 部分，然后您可以发布一个有关插入值的新问题 - 有太多的代码需要涵盖并使其易于理解。

更改 DataBase 类中的代码(顺便说一句:不是一个好名字!)

为列的变量名称指定一个易于理解的名称。谁记得COL_6是什么？还要考虑到这些可能不需要公开。

public static final String COL_ID = "ID";
public static final String COL_NAME = "NAME";
public static final String COL_AGE = "AGE";
public static final String COL_GENDER = "GENDER";
public static final String COL_WEIGHT = "WEIGHT";
public static final String COL_HEIGHT = "HEIGHT";
public static final String COL_TRAUMA = "TRAUMA";

您可能不想检查该表是否已存在，但我还是添加了检查。我还将 ID 设为 AUTOINCRMENT 列。

@Override
public void onCreate(SQLiteDatabase db){
    db.execSQL("CREATE TABLE IF NOT EXISTS " + TABLE_NAME + " (" +
            COL_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
            COL_NAME + " TEXT," +
            COL_AGE + " INTEGER NOT NULL DEFAULT 0, " +
            COL_GENDER + " INTEGER NOT NULL DEFAULT 0, " +
            COL_TRAUMA + " INTEGER NOT NULL DEFAULT 0, " +
            COL_WEIGHT + " INTEGER NOT NULL DEFAULT 0, " +
            COL_HEIGHT + " INTEGER NOT NULL DEFAULT 0);");
}

更改 insertData 方法以适应对列的静态最终变量的更改以及参数类型的更改:

public boolean insertData(String name, Integer age, Integer sex_male, Integer weight, Integer height, Integer trauma){
    boolean success = false;
    try{
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        contentValues.put(COL_NAME, name);
        contentValues.put(COL_AGE, age);
        contentValues.put(COL_GENDER, sex_male);
        contentValues.put(COL_WEIGHT, weight);
        contentValues.put(COL_HEIGHT, height);
        contentValues.put(COL_TRAUMA, trauma);
        long result = db.insert(TABLE_NAME,null,contentValues);
        db.close();

        if(result != -1) success = true;
    }
    catch(Exception ex){
        Log.e(TAG, ex.getMessage());
    }

    return success;
}

另请注意，无需在 getALLData() 方法中获取 Writeable 数据库:

   public Cursor getALLData(){
        SQLiteDatabase db = this.getReadableDatabase();
        Cursor res = db.rawQuery("Select * from "+ TABLE_NAME, null);
        return res;
    }

现在发布一个关于如何从您的Activity填充数据库的新问题，我们可以从那里开始......