Android studio 奶茶点单设计代码
时间: 2024-04-21 11:18:38 浏览: 13
根据提供的引用内容,Android Studio奶茶点单设计代码可以包括以下功能:
1. 创建本地数据库:
```java
// 创建数据库
SQLiteDatabase db = openOrCreateDatabase("menu.db", Context.MODE_PRIVATE, null);
// 创建表
db.execSQL("CREATE TABLE IF NOT EXISTS menu (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, price REAL)");
```
2. 插入商品:
```java
// 插入商品
String name = "奶茶";
double price = 10.0;
db.execSQL("INSERT INTO menu (name, price) VALUES ('" + name + "', " + price + ")");
```
3. 更新指定商品的价格:
```java
// 更新指定商品的价格
String name = "奶茶";
double newPrice = 12.0;
db.execSQL("UPDATE menu SET price = " + newPrice + " WHERE name = '" + name + "'");
```
4. 查询指定商品的价格:
```java
// 查询指定商品的价格
String name = "奶茶";
Cursor cursor = db.rawQuery("SELECT price FROM menu WHERE name = '" + name + "'", null);
if (cursor.moveToFirst()) {
double price = cursor.getDouble(cursor.getColumnIndex("price"));
// 处理查询结果
}
cursor.close();
```
5. 查询整个菜单:
```java
// 查询整个菜单
Cursor cursor = db.rawQuery("SELECT * FROM menu", null);
while (cursor.moveToNext()) {
String name = cursor.getString(cursor.getColumnIndex("name"));
double price = cursor.getDouble(cursor.getColumnIndex("price"));
// 处理查询结果
}
cursor.close();
```
6. 删除指定商品:
```java
// 删除指定商品
String name = "奶茶";
db.execSQL("DELETE FROM menu WHERE name = '" + name + "'");
```