Android的Sqlite数据库问题

Question

构建一个基本的基于sqlite的登录/注册应用程序。点击登录后App崩溃。

有什么想法吗？

databaseHelper.java：

   package com.example.android.sqliteapp;

   import android.content.ContentValues;
   import android.content.Context;
   import android.database.Cursor;
   import android.database.sqlite.SQLiteDatabase;
   import android.database.sqlite.SQLiteOpenHelper;

 public class DatabaseHelper extends SQLiteOpenHelper {

// Database Version
private static final int DATABASE_VERSION = 1;

// Database Name
private static final String DATABASE_NAME = "contacts.db";

// User table name
private static final String TABLE_NAME = "contacts";

// User Table Columns names
private static final String COLUMN_ID = "id";
private static final String COLUMN_NAME = "name";
private static final String COLUMN_EMAIL = "email";
private static final String COLUMN_UNAME = "uname";
private static final String COLUMN_PASS = "pass";
SQLiteDatabase db;

// create table sql query
private static final String TABLE_CREATE = "create table contacts (id integer primary key not null , " +
        "name text not null, email text not null, uname text not null, pass text not null)";

// constructor
public DatabaseHelper(Context context){
    super(context, DATABASE_NAME, null, DATABASE_VERSION);
}

@Override
public void onCreate(SQLiteDatabase db) {
    db.execSQL(TABLE_CREATE);
    this.db = db;
}

// inserting data from SignUp to DB
public void insertContact(Contact c){
    db = this.getWritableDatabase();
    ContentValues values = new ContentValues();

    String query = "select * from " + TABLE_NAME;
    Cursor cursor = db.rawQuery(query, null);
    int count = cursor.getCount();

    values.put(COLUMN_ID, count);    // each contact will have unique IDs counting from 0 upwards
    values.put(COLUMN_NAME, c.getName());
    values.put(COLUMN_EMAIL, c.getEmail());
    values.put(COLUMN_UNAME, c.getUname());
    values.put(COLUMN_PASS, c.getPass());

    db.insert(TABLE_NAME, null, values); // this will officially insert the contact object into the DB
    db.close(); // close it
}

// this is where the search password method is created
public String searchPass(String uname) {
    db = this.getReadableDatabase();
    String query = "select * from " + TABLE_NAME;
    Cursor cursor = db.rawQuery(query, null);
    String a, b;
    b = "not found";
    if (cursor.moveToFirst()) {

        do {
            a = cursor.getString(cursor.getColumnIndex(COLUMN_UNAME));

            if (a.equals(uname)) {
                b = cursor.getString(cursor.getColumnIndex(COLUMN_PASS));
                break;
            }
        }
        while(cursor.moveToNext());
    }
    return b; // b is the returned password
}


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

    //Drop User Table if exist
    String query = "DROP TABLE IF EXISTS " + TABLE_NAME;
    db.execSQL(query);
    // Create tables again
    this.onCreate(db);
}
}

package com.example.android.sqliteapp;

import android.content.Intent;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.EditText;
import android.widget.Toast;

public class MainActivity extends AppCompatActivity {

DatabaseHelper helper = new DatabaseHelper(this);

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

public void onButtonClick(View v) {

    // if user clicks on LOGIN
    if (v.getId() == R.id.bLogin) {

        // Grab all Username and Password input
        EditText a = (EditText) findViewById(R.id.etUsername);
        String str = a.getText().toString();
        EditText b = (EditText) findViewById(R.id.etPassword);
        String pass = b.getText().toString();

        String password = helper.searchPass(str);
        if (pass.equals(password)) {

            Intent i = new Intent(MainActivity.this, Display.class);
            i.putExtra("Username", str);
            startActivity(i);
        }
        else {
            Toast temp = Toast.makeText(MainActivity.this, "Username and Password don't match!", Toast.LENGTH_SHORT);
            temp.show();

        }


    }

    if (v.getId() == R.id.bSignup) {

        Intent i = new Intent(MainActivity.this, SignUp.class);
        startActivity(i);
    }


}




}

display.java：

package com.example.android.sqliteapp;

import android.os.Bundle;
import android.os.PersistableBundle;
import android.support.annotation.Nullable;
import android.support.v7.app.AppCompatActivity;
import android.widget.TextView;

public class Display extends AppCompatActivity{

@Override
public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.display);

    String username = getIntent().getStringExtra("Username");
    TextView tv = (TextView) findViewById(R.id.tvUsername);
    tv.setText(username);


}
}

contact.java：

package com.example.android.sqliteapp;


public class Contact {

private int id;
private String name;
private String email;
private String uname;
private String pass;

public int getId() {
    return this.id;
}

public void setId(int id) {
    this.id = id;
}

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

public void setName(String name) {
    this.name = name;
}

public String getEmail() {
    return this.email;
}

public void setEmail(String email) {
    this.email = email;
}

public String getUname() {
    return this.uname;
}

public void setUname(String uname) {
    this.uname = uname;
}

public String getPass() {
    return this.pass;
}

public void setPass(String pass) {
    this.pass = pass;
}



}

Answer 1

您应该真正传入列的名称并获取其索引，而不是直接获取索引。

改变

cursor.getString(2);

至

cursor.getString(cursor.getColumnIndex(COLUMN_UNAME));

String query = "select * from " + TABLE_NAME + " WHERE uname = " + uname;