sqlite基于安卓的疫苗预约app
时间: 2023-06-01 15:04:06 浏览: 53
作为一个AI语言模型,我无法为您提供完整的基于安卓的疫苗预约app。但是,我可以为您提供一些使用SQLite作为数据库的示例代码,以便您了解如何在安卓应用程序中使用SQLite。
以下是一个使用SQLite的疫苗预约app的示例代码:
1. 创建SQLite数据库和表
```java
public class VaccineDatabaseHelper extends SQLiteOpenHelper {
private static final String DATABASE_NAME = "vaccine.db";
private static final int DATABASE_VERSION = 1;
private static final String TABLE_NAME = "vaccines";
private static final String COLUMN_ID = "_id";
private static final String COLUMN_NAME = "name";
private static final String COLUMN_AGE = "age";
private static final String COLUMN_DATE = "date";
public VaccineDatabaseHelper(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, " +
COLUMN_DATE + " TEXT)";
db.execSQL(createTable);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
onCreate(db);
}
}
```
2. 添加疫苗预约数据
```java
public class VaccineDataSource {
private SQLiteDatabase database;
private VaccineDatabaseHelper dbHelper;
public VaccineDataSource(Context context) {
dbHelper = new VaccineDatabaseHelper(context);
}
public void open() throws SQLException {
database = dbHelper.getWritableDatabase();
}
public void close() {
dbHelper.close();
}
public void addVaccine(Vaccine vaccine) {
ContentValues values = new ContentValues();
values.put(VaccineDatabaseHelper.COLUMN_NAME, vaccine.getName());
values.put(VaccineDatabaseHelper.COLUMN_AGE, vaccine.getAge());
values.put(VaccineDatabaseHelper.COLUMN_DATE, vaccine.getDate());
database.insert(VaccineDatabaseHelper.TABLE_NAME, null, values);
}
}
```
3. 查询疫苗预约数据
```java
public class VaccineListActivity extends AppCompatActivity {
private ListView listView;
private VaccineDataSource dataSource;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_vaccine_list);
listView = findViewById(R.id.vaccine_list);
dataSource = new VaccineDataSource(this);
dataSource.open();
List<Vaccine> vaccines = dataSource.getAllVaccines();
ArrayAdapter<Vaccine> adapter = new ArrayAdapter<>(this,
android.R.layout.simple_list_item_1, vaccines);
listView.setAdapter(adapter);
}
}
public class VaccineDataSource {
private SQLiteDatabase database;
private VaccineDatabaseHelper dbHelper;
public VaccineDataSource(Context context) {
dbHelper = new VaccineDatabaseHelper(context);
}
public void open() throws SQLException {
database = dbHelper.getWritableDatabase();
}
public void close() {
dbHelper.close();
}
public List<Vaccine> getAllVaccines() {
List<Vaccine> vaccines = new ArrayList<>();
Cursor cursor = database.query(VaccineDatabaseHelper.TABLE_NAME,
new String[]{VaccineDatabaseHelper.COLUMN_ID,
VaccineDatabaseHelper.COLUMN_NAME,
VaccineDatabaseHelper.COLUMN_AGE,
VaccineDatabaseHelper.COLUMN_DATE},
null, null, null, null, null);
cursor.moveToFirst();
while (!cursor.isAfterLast()) {
Vaccine vaccine = new Vaccine();
vaccine.setId(cursor.getInt(cursor.getColumnIndex(VaccineDatabaseHelper.COLUMN_ID)));
vaccine.setName(cursor.getString(cursor.getColumnIndex(VaccineDatabaseHelper.COLUMN_NAME)));
vaccine.setAge(cursor.getInt(cursor.getColumnIndex(VaccineDatabaseHelper.COLUMN_AGE)));
vaccine.setDate(cursor.getString(cursor.getColumnIndex(VaccineDatabaseHelper.COLUMN_DATE)));
vaccines.add(vaccine);
cursor.moveToNext();
}
cursor.close();
return vaccines;
}
}
```
这些示例代码可以帮助您了解如何在安卓应用程序中使用SQLite。请注意,这只是一个示例,您需要根据您的需求进行修改和调整。
相关推荐
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.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)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![doc](https://img-home.csdnimg.cn/images/20210720083327.png)
![mp4](https://img-home.csdnimg.cn/images/20210720083504.png)