从SQL Lite DB动态创建ListView行

// 创建SQLite数据库助手类
public class DatabaseHelper extends SQLiteOpenHelper {
    // 构造方法
    public DatabaseHelper(Context context) {
        super(context, "mydatabase.db", null, 1);
    }

    // 创建数据库表
    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("CREATE TABLE mytable (_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT)");
    }

    // 数据库版本升级
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // 更新数据库表结构
    }
}

// 在Activity中使用数据库和ListView
public class MainActivity extends AppCompatActivity {
    private ListView listView;
    private SQLiteDatabase database;

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

        // 连接数据库
        DatabaseHelper dbHelper = new DatabaseHelper(this);
        database = dbHelper.getWritableDatabase();

        // 执行查询
        Cursor cursor = database.query("mytable", null, null, null, null, null, null);

        // 创建适配器
        SimpleCursorAdapter adapter = new SimpleCursorAdapter(this,
                android.R.layout.simple_list_item_1,
                cursor,
                new String[]{"name"},
                new int[]{android.R.id.text1},
                0);

        // 绑定适配器
        listView = findViewById(R.id.listView);
        listView.setAdapter(adapter);
    }
}