构建一个基本的基于 sqlite 的登录/注册应用程序。点击登录后应用程序崩溃。
有什么想法吗?
数据库助手.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);
}
}
点击登录后,该应用程序现在崩溃
错误日志:
android.sqliteapp/com.example.android.sqliteapp.Display}; 您是否在 AndroidManifest.xml 中声明了此活动?在 android.app.Instrumentation.checkStartActivityResult(Instrumentation.java:1805) 在 android.app.Instrumentation.execStartActivity(Instrumentation.java:1523) 在 android.app.Activity.startActivityForResult(Activity.java:4225) 在 android.support。 v4.app.BaseFragmentActivityJB.startActivityForResult(BaseFragmentActivityJB.java:50) at android.support.v4.app.FragmentActivity.startActivityForResult(FragmentActivity.java:79) at android.app.Activity.startActivityForResult(Activity.java:4183) at android .support.v4.app.FragmentActivity.startActivityForResult(FragmentActivity.java:859) at android.app.Activity.startActivity(Activity.java:4522) at android.app.Activity.startActivity(Activity.java:4490) at com。 example.android.sqliteapp。
主活动Java:
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);
}
}
}
显示.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);
}
}
联系方式.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;
}
}
您应该真正传入列名并获取其索引,而不是直接索引。
改变
cursor.getString(2);
至
cursor.getString(cursor.getColumnIndex(COLUMN_UNAME));
等等等等。如果以任何方式更改表或查询,这将使其更加通用。
附带说明一下,您应该更改您的查询,使其仅返回一条匹配的记录到该用户名。而不是所有记录,然后循环查找匹配的记录。
例如
String query = "select * from " + TABLE_NAME + " WHERE uname = " + uname;
编辑:对于您的第二个错误,您收到ActivityNotFoundException
. 在日志中它明确指出have you declared this activity in your AndroidManifest.xml
。解决方案是将您尝试启动的活动添加到您的清单中。 有关如何在此处执行此操作的更多信息
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句