这是我的getUser方法:
public User getUser(String Email) {
SQLiteDatabase db = this.getReadableDatabase();
String sql = "SELECT * FROM " + DBContract.Users.TABLE_NAME
+ " WHERE " + DBContract.Users.COL_EMAIL + " = " + Email;
try {
Cursor cursor = db.rawQuery(sql, null);
User user = new User();
// Read data, I simplify cursor in one line
if (cursor != null) {
cursor.moveToFirst();
// Get imageData in byte[]. Easy, right?
user.setUserID(Integer.parseInt(cursor.getString(cursor.getColumnIndex(DBContract.Users._ID))));
user.setUserName(cursor.getString(cursor.getColumnIndex(DBContract.Users.COL_NAME)));
user.setUserImage(cursor.getBlob(cursor.getColumnIndex(DBContract.Users.COL_IMAGE)));
user.setUserPassword(cursor.getString(cursor.getColumnIndex(DBContract.Users.COL_PASSWORD)));
user.setUserEmail(cursor.getString(cursor.getColumnIndex(DBContract.Users.COL_EMAIL)));
user.setUserLocation(cursor.getString(cursor.getColumnIndex(DBContract.Users.COL_LOCATION)));
}
cursor.close();
db.close();
return user;
} catch (SQLException e) {
}
return null;
}用户配置文件片段,我在其中调用getUser:
public class UserHomeFragment extends Fragment {
DBHelper dbHelper;
User user;
ImageView userImageView;
TextView userNameTexView;
@Nullable
@Override
public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) {
View v = inflater.inflate(R.layout.user_profile_home_fragment, container, false);
dbHelper = new DBHelper(v.getContext());
user = new User();
userImageView = (ImageView) v.findViewById(R.id.userimg);
userNameTexView = (TextView) v.findViewById(R.id.user_name);
Bundle extras = getActivity().getIntent().getExtras();
assert extras != null;
String userEmail = extras.getString("userEmail");
user = dbHelper.getUser(userEmail);
// Bitmap bitmap = BitmapFactory.decodeByteArray(userImage, 0, userImage.length);
// userImageView.setImageBitmap(bitmap);
userNameTexView.setText(user.getUserName());
return v;
}}为什么getUser返回null?我已经检查过在用户的桌子上有用户。
Error :尝试在空对象引用上调用虚拟方法'java.lang.String com.arfni.ayafinal.model.User.getUserName()‘
发布于 2018-04-06 03:34:30
你遇到的问题是双重的。
主要错误是,您需要将字符串值括在引号中,否则它可能被视为关键字或实体(例如表或列名),或者可能导致语法错误。简而言之,SQL不会执行并导致异常。
复合错误是,异常被捕获,因此该异常被忽略,导致没有创建和返回游标,因此永远不会设置游标变量,因此它将为null,然后当您试图关闭游标时,它将为空,因为它超出了null检查的范围。
此外,您还有一个潜在的问题:如果游标不是null,但为空,那么moveToFirst将不会移动到第一行,因为没有第一行要移动。这是由返回false的moveToFirst方法指示的。在代码中不检查返回的值,因此当您试图获取数据时,会出现异常(在有0行时尝试读取索引0),这也会被捕获,可能会导致混乱。
我建议用以下方法取代getUser方法:
public User getUser(String Email) {
SQLiteDatabase db = this.getReadableDatabase();
String sql = "SELECT * FROM " + DBContract.Users.TABLE_NAME
+ " WHERE " + DBContract.Users.COL_EMAIL + " = " + Email;
Cursor cursor = db.rawQuery(sql, null);
User user = new User();
// Read data, I simplify cursor in one line
if (cursor.moveToFirst()) {
// Get imageData in byte[]. Easy, right?
user.setUserID(Integer.parseInt(cursor.getString(cursor.getColumnIndex(DBContract.Users._ID))));
user.setUserName(cursor.getString(cursor.getColumnIndex(DBContract.Users.COL_NAME)));
user.setUserImage(cursor.getBlob(cursor.getColumnIndex(DBContract.Users.COL_IMAGE)));
user.setUserPassword(cursor.getString(cursor.getColumnIndex(DBContract.Users.COL_PASSWORD)));
user.setUserEmail(cursor.getString(cursor.getColumnIndex(DBContract.Users.COL_EMAIL)));
user.setUserLocation(cursor.getString(cursor.getColumnIndex(DBContract.Users.COL_LOCATION)));
}
cursor.close();
db.close();
return user;
}备注
https://stackoverflow.com/questions/49601823
复制相似问题