Android：无法使用DbHelper和Contract类将数据插入SQLite [英] Android: Unable to insert data into SQLite using DbHelper and Contract class

问题描述

public class Main2Activity extends AppCompatActivity {
    private EditText editText1, editText2, editText3, editText4;
    private Button button;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        editText1 = (EditText) findViewById(R.id.editText);
        editText2 = (EditText) findViewById(R.id.editText2);
        editText3 = (EditText) findViewById(R.id.editText3);
        editText4 = (EditText) findViewById(R.id.editText4);

        button = (Button) findViewById(R.id.button3);

        button.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                String un, pw, cpw, ph;

                un = editText1.getText().toString();
                pw = editText2.getText().toString();
                cpw = editText3.getText().toString();
                ph = editText4.getText().toString();

                DbHelper dbHelpero = new DbHelper(Main2Activity.this);
                SQLiteDatabase db = dbHelpero.getWritableDatabase();

                ContentValues values = new ContentValues();
                values.put(Entry.C_UNAME, un);
                values.put(Entry.C_PASS, pw);
                values.put(Entry.C_CPASS, cpw);
                values.put(Entry.C_PNO, ph);

                long newRowId = db.insert(Entry.TABLE_NAME, null, values);

                if (newRowId == -1) {
                    Toast.makeText(getApplicationContext(), "Error while adding", Toast.LENGTH_SHORT).show();
                } else {
                    Toast.makeText(getApplicationContext(), "Yo Registration is complete", Toast.LENGTH_SHORT).show();
                }
            }
        });
    }
}

这是Contract.java

Here is the Contract.java

public class Contract {

    private Contract() {

    }

    public static final class Entry implements BaseColumns {
        public final static String TABLE_NAME = "details";
        public final static String _ID = BaseColumns._ID;
        public final static String C_UNAME = "uname";
        public final static String C_PASS = "pw";
        public final static String C_CPASS = "cpw";
        public final static String C_PNO = "pno";

    }
}

和DbHelper.java

And the DbHelper.java

public class DbHelper extends SQLiteOpenHelper {
    public static final String LOG_TAG = DbHelper.class.getSimpleName();
    public final static String DATABASE_NAME = "contacts.db";
    private static final int DATABASE_VERSION = 1;

    public DbHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        String CREATE_TABLE = "CREATE TABLE " + Entry.TABLE_NAME + " ("
                + Entry._ID + " TEXT PRIMARY KEY AUTOINCREMENT, "
                + Entry.C_UNAME + " TEXT, "
                + Entry.C_PASS + " TEXT, "
                + Entry.C_CPASS + " TEXT, "
                + Entry.C_PNO + " TEXT" + ")";

        db.execSQL(CREATE_TABLE);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }
}

没有语法错误但是应用程序仍在崩溃。

There are no syntax errors but still, the app is crashing.

推荐答案

将CREATE_TABLE查询替换为：

Replace your CREATE_TABLE query with:

String CREATE_TABLE = "CREATE TABLE " + Entry.TABLE_NAME + " ("
                + Entry._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
                + Entry.C_UNAME + " TEXT, "
                + Entry.C_PASS + " TEXT, "
                + Entry.C_CPASS + " TEXT, "
                + Entry.C_PNO + " TEXT" + ")";

---

你不能拥有 TEXT 类型有 AUTOINCREMENT 属性，因为您目前在 _ID 字段中拥有该属性。您需要将其更改为 INTEGER ，以便可以将其用作 PRIMARY KEY ，然后将其设置为 AUTOINCREMENT

---

You can't have a TEXT type have an AUTOINCREMENT property as you currently have it on your _ID field. You need to change it to be an INTEGER so it can be used as PRIMARY KEY and then have it AUTOINCREMENT

这篇关于Android：无法使用DbHelper和Contract类将数据插入SQLite的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！