安卓列表插入SQLite
时间: 2024-01-04 08:02:34 浏览: 28
将数据插入SQLite数据库表的步骤如下:
1. 创建一个SQLiteOpenHelper子类,用于管理SQLite数据库的创建和版本控制。
```java
public class DatabaseHelper extends SQLiteOpenHelper {
public static final String DATABASE_NAME = "myDatabase.db";
public static final int DATABASE_VERSION = 1;
public static final String TABLE_NAME = "myTable";
public static final String COLUMN_ID = "_id";
public static final String COLUMN_NAME = "name";
public static final String COLUMN_AGE = "age";
public DatabaseHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
String createTable = "CREATE TABLE " + TABLE_NAME + " ("
+ COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
+ COLUMN_NAME + " TEXT, "
+ COLUMN_AGE + " INTEGER)";
db.execSQL(createTable);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
onCreate(db);
}
}
```
2. 在Activity或Fragment中实例化数据库帮助类,并获取可写数据库对象。
```java
DatabaseHelper dbHelper = new DatabaseHelper(this);
SQLiteDatabase db = dbHelper.getWritableDatabase();
```
3. 创建ContentValues对象,并将数据添加到ContentValues对象中。
```java
ContentValues values = new ContentValues();
values.put(DatabaseHelper.COLUMN_NAME, "张三");
values.put(DatabaseHelper.COLUMN_AGE, 20);
```
4. 调用数据库对象的insert方法,将ContentValues对象中的数据插入到数据库表中。
```java
long newRowId = db.insert(DatabaseHelper.TABLE_NAME, null, values);
```
完整的插入数据的代码示例:
```java
DatabaseHelper dbHelper = new DatabaseHelper(this);
SQLiteDatabase db = dbHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(DatabaseHelper.COLUMN_NAME, "张三");
values.put(DatabaseHelper.COLUMN_AGE, 20);
long newRowId = db.insert(DatabaseHelper.TABLE_NAME, null, values);
if (newRowId == -1) {
Toast.makeText(this, "插入数据失败", Toast.LENGTH_SHORT).show();
} else {
Toast.makeText(this, "插入数据成功,行ID为" + newRowId, Toast.LENGTH_SHORT).show();
}
```
相关推荐
![doc](https://img-home.csdnimg.cn/images/20210720083327.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)