简介：Android手机点餐系统是一款专为餐饮业设计的应用程序，顾客可通过智能手机轻松浏览菜单、下单和支付，提升就餐体验与效率。
package cn.iimob.waiters.db;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class DB_Table_Number extends SQLiteOpenHelper {
private static final String DB_NAME = tablenumber.db;
private static final String TBL_NAME = TableNumber;
private static final String CREATE_TBL = create table TableNumber(_id integer primary key autoincrement,number text);
public SQLiteDatabase db;
public DB_Table_Number(Context c) {
super(c, DB_NAME, null, 2);
}
@Override
public void onCreate(SQLiteDatabase db) {
this.db = db;
db.execSQL(CREATE_TBL);
}
public void insert(ContentValues values) {
SQLiteDatabase db = getWritableDatabase();
db.insert(TBL_NAME, null, values);
db.close();
}
public Cursor query() {
SQLiteDatabase db = getWritableDatabase();
Cursor c = db.query(TBL_NAME, null, null, null, null, null, null);
return c;
}
public String select(String s){
SQLiteDatabase db = getWritableDatabase();
String sql=select * from TableNumber where number=+s+;
Cursor cursor=db.rawQuery(sql,null);
if (cursor !=null) {
String temp = ;
int i=0;
while(cursor.moveToNext()) {
temp+=cursor.getString(0);
}
db.close();
return temp;
}
public void delete(String s) {
SQLiteDatabase db = getWritableDatabase();
String sql=delete from TableNumber where number=+s+;
try{
db.execSQL(sql);
db.close();
}catch(Exception e){
e.printStackTrace();
}
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
}
public void clean(){
this.getWritableDatabase().execSQL(DROP TABLE IF EXISTS +TBL_NAME);
onCreate(this.getWritableDatabase());
this.getWritableDatabase().close();
}
}
5星
