我数据库用户表里有好几条登录帐号信息。为什么下面的代码只能读出最后一条信息做登录判定啊。
是读取数据的哪个环节出错了吗?public void onClick(View v) {
String username = null;
String passwprd = null;
SqliteOpenHelper1 sqliteOpenHelper = new SqliteOpenHelper1(
MainActivity.this, "login.db");
SQLiteDatabase db = sqliteOpenHelper.getReadableDatabase();
Cursor cursor = db.query("user", new String[] { "username", "password" }, null, null, null, null, null);
while (cursor.moveToNext()) {
username = cursor.getString(cursor.getColumnIndex("username"));
password= cursor.getString(cursor.getColumnIndex("password"));
}
EditText zhanghao = (EditText) findViewById(R.id.zhanghao);
EditText mima = (EditText) findViewById(R.id.mima);
String mima1 = mima.getText().toString();
String zhanghao1 = zhanghao.getText().toString();
if (zhanghao1.equals(username)&&mima1.equals(password)) {
Intent intent = new Intent(this, Main.class);
startActivity(intent);
} else {
Intent intent2 = new Intent(this, Error.class);
startActivity(intent2);
} }
}
是读取数据的哪个环节出错了吗?public void onClick(View v) {
String username = null;
String passwprd = null;
SqliteOpenHelper1 sqliteOpenHelper = new SqliteOpenHelper1(
MainActivity.this, "login.db");
SQLiteDatabase db = sqliteOpenHelper.getReadableDatabase();
Cursor cursor = db.query("user", new String[] { "username", "password" }, null, null, null, null, null);
while (cursor.moveToNext()) {
username = cursor.getString(cursor.getColumnIndex("username"));
password= cursor.getString(cursor.getColumnIndex("password"));
}
EditText zhanghao = (EditText) findViewById(R.id.zhanghao);
EditText mima = (EditText) findViewById(R.id.mima);
String mima1 = mima.getText().toString();
String zhanghao1 = zhanghao.getText().toString();
if (zhanghao1.equals(username)&&mima1.equals(password)) {
Intent intent = new Intent(this, Main.class);
startActivity(intent);
} else {
Intent intent2 = new Intent(this, Error.class);
startActivity(intent2);
} }
}
解决方案 »
- android中的adb shell指令可以不可以结束一个应用
- Android中如何获得系统相关的信息(比如CPU使用率,内存的总量和已用的数量)
- 求android自定义控件如何添加点击事件,长按事件
- helloworld程序在模拟器可以运行,到真机上提示无法解析,什么原因呢,版本吗
- android资源中hdpi mdpi ldpi存图片的问题
- Android SDK and AVD Manager 打不开
- android开发者的春天
- PC端连接android,搜索设备现在还用adb.exe吗?
- 关于安卓app页面切换的问题,急求大神解决
- SwipeLayout里面关于position的问题
- 在android下写一个cpp文件播放mp3
- 用KSOAP2连接C#的WebService
password= cursor.getString(cursor.getColumnIndex("password"));每次循环会把上一次的覆盖了啊
password= cursor.getString(cursor.getColumnIndex("password"));