承接上文,在完成用户登录和注册后;
如果您需要查询在SQLite数据库中的所有注册用户的信息,可进行如下操作;
第一步:建立一个活动UserInfo.java;
public class UserInfo {
private String id;
private String username;
@Override
public String toString() {
return "用户名:"+username + ','+"密码:" + password+','+"电话:"+phone_number+','+"地址:"+address;
}
private String password;
private String phone_number;
private String address;
public UserInfo(String id, String username, String password, String phone_number, String address) {
this.id = id;
this.username = username;
this.password = password;
this.phone_number = phone_number;
this.address = address;
}
}
第二步:在DatabaseHelper.java中添加如下getAll()方法;
public ArrayList getAll() {
SQLiteDatabase db = this.getReadableDatabase();
ArrayList array = new ArrayList();
Cursor cursor = db.query("users", null, null, null, null, null, null);
while (cursor.moveToNext()) {
@SuppressLint("Range") String id = cursor.getString(cursor.getColumnIndex("id"));
@SuppressLint("Range") String username = cursor.getString(cursor.getColumnIndex("username"));
@SuppressLint("Range") String password = cursor.getString(cursor.getColumnIndex("password"));
@SuppressLint("Range") String phone_number = cursor.getString(cursor.getColumnIndex("phone_number"));
@SuppressLint("Range") String address = cursor.getString(cursor.getColumnIndex("address"));
UserInfo userinfo=new UserInfo(id,username,password,phone_number,address);
array.add(userinfo);
}
return array;
}
第三步:建立一个活动UserInfoActivity.java;
import android.annotation.SuppressLint;
import android.os.Bundle;
import android.widget.ArrayAdapter;
import android.widget.ListView;
import androidx.appcompat.app.AppCompatActivity;
import java.util.ArrayList;
public class UserInfoActivity extends AppCompatActivity {
private DatabaseHelper databaseHelper;
private ListView listViewUsers;
private ArrayList<UserInfo> userList;
private ArrayAdapter<UserInfo> userAdapter;
@SuppressLint("MissingInflatedId")
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_user_info);
databaseHelper = new DatabaseHelper(this);
listViewUsers = findViewById(R.id.listViewUsers);
userList = databaseHelper.getAll();
userAdapter = new ArrayAdapter<>(this, android.R.layout.simple_list_item_1, userList);
listViewUsers.setAdapter(userAdapter);
}
}
第四步:建立一个activity_user_info.xml的布局文件;
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="match_parent"
android:layout_height="match_parent">
<ListView
android:id="@+id/listViewUsers"
android:layout_width="match_parent"
android:layout_height="match_parent" />
</LinearLayout>
*注意,需记得在AndroidManifest.java添加UserInfoActivity.java的活动运行配置;
运行结果展示如下:
以上如果出现实例化对象不匹配或者属性不匹配等问题,参考人可通过文章开头的上一个网址进行对照,更改;
若以上存在什么问题,请私信我或者在评论区说出。
祝大家2024年一帆风顺。