android studio sqlite数据库代码展示
时间: 2023-09-20 11:07:32 浏览: 21
当然,我可以展示关于Android Studio中SQLite数据库的代码。以下是一个简单的示例:
```
// 创建一个SQLite数据库
SQLiteDatabase db = SQLiteDatabase.openOrCreateDatabase("my_database.db", null);
// 创建一个表
String CREATE_TABLE_SQL = "CREATE TABLE IF NOT EXISTS my_table ("
+ "id INTEGER PRIMARY KEY AUTOINCREMENT,"
+ "name TEXT,"
+ "age INTEGER);";
db.execSQL(CREATE_TABLE_SQL);
// 插入数据
String INSERT_SQL = "INSERT INTO my_table (name, age) VALUES ('Tom', 18);";
db.execSQL(INSERT_SQL);
// 查询数据
String QUERY_SQL = "SELECT * FROM my_table;";
Cursor cursor = db.rawQuery(QUERY_SQL, null);
if (cursor.moveToFirst()) {
do {
int id = cursor.getInt(cursor.getColumnIndex("id"));
String name = cursor.getString(cursor.getColumnIndex("name"));
int age = cursor.getInt(cursor.getColumnIndex("age"));
// 处理数据
} while (cursor.moveToNext());
}
// 关闭数据库
db.close();
```
希望可以帮到您。
相关推荐
















