MyDataBase
package com.activity.db;
import com.acyivity.Utils.Utils;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class MyDataBase extends SQLiteOpenHelper {
public MyDataBase(Context context) {
super(context, "gourmetMealshujuku.db", null, 1);
}
@Override
public void onCreate(SQLiteDatabase db) {
/**
* 版本号
*/
db.execSQL("create table " + Utils.BAN_BEN_HAO
+ "(_id integer primary key autoincrement," + "banben,"// 版本
+ "beizhu"// 备注
+ ")");
/**
* 菜单表
*/
db.execSQL("create table " + Utils.CAI_DAN
+ "(_id integer primary key autoincrement," + "dish_id,"
+ "dish_class," + "dish_name," + "image," + "price,"
+ "itrInfo," + "dish_num text default 1," + "tejiacai"
+ "remark)");
/**
* 桌子表
*/
db.execSQL("create table " + Utils.TABLE
+ "(_id integer primary key autoincrement," + "table_name,"// 桌子名称
+ "table_num,"
+ "table_address,"
+ "waiter_num"
+ ")");
/**
* 订单表
*/
db.execSQL("create table " + Utils.ORDER
+ "(_id integer primary key autoincrement," + "dish_id,"
+ "dish_name," + "dish_class,dish_num,price,remark)");
/**
* 创建表 表名:流水账号
*/
db.execSQL("create table " + Utils.LIU_SHUI_HAO
+ "(_id integer primary key autoincrement,liushuihao,remark)");
/**
* 创建表 表名:下单表 用于结账时和下单时 列名:_id、用户名、等级、流水账号、桌号、序号、菜名、单价、数量、价格
*/
db.execSQL("create table "
+ Utils.XIA_DAN
+ "(_id integer primary key autoincrement, username, grade, liushuihao, table_num,xuhao,dish_name,price,dish_num,total_price)");
/**
* 凉菜表
*/
db.execSQL("create table " + Utils.COLD_DISH
+ "(_id integer primary key autoincrement," + "dish_id,"
+ "dish_class," + "dish_name," + "image," + "price,"
+ "itrInfo," + "dish_num text default 1," + "tejiacai"
+ "remark)");
/**
* 热菜表
*/
db.execSQL("create table " + Utils.HOT_DISH
+ "(_id integer primary key autoincrement," + "dish_id,"
+ "dish_class," + "dish_name," + "image," + "price,"
+ "itrInfo," + "dish_num text default 1," + "tejiacai"
+ "remark)");
/**
* 酒类表
*/
db.execSQL("create table " + Utils.JIU
+ "(_id integer primary key autoincrement," + "dish_id,"
+ "dish_class," + "dish_name," + "image," + "price,"
+ "itrInfo," + "dish_num text default 1," + "tejiacai"
+ "remark)");
/**
* 餐具表
*/
db.execSQL("create table " + Utils.CAN_JU
+ "(_id integer primary key autoincrement," + "dish_id,"
+ "dish_class," + "dish_name," + "image," + "price,"
+ "itrInfo," + "dish_num text default 1," + "tejiacai"
+ "remark)");
/**
* 汤类表
*/
db.execSQL("create table " + Utils.TANG_LEI
+ "(_id integer primary key autoincrement," + "dish_id,"
+ "dish_class," + "dish_name," + "image," + "price,"
+ "itrInfo," + "dish_num text default 1," + "tejiacai"
+ "remark)");
/**
* 饮料表
*/
db.execSQL("create table " + Utils.YIN_LIAO
+ "(_id integer primary key autoincrement," + "dish_id,"
+ "dish_class," + "dish_name," + "image," + "price,"
+ "itrInfo," + "dish_num text default 1," + "tejiacai"
+ "remark)");
/**
* 主食表
*/
db.execSQL("create table " + Utils.ZHU_SHI
+ "(_id integer primary key autoincrement," + "dish_id,"
+ "dish_class," + "dish_name," + "image," + "price,"
+ "itrInfo," + "dish_num text default 1," + "tejiacai"
+ "remark)");
}
@Override
public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
// TODO Auto-generated method stub
}
}
另一种
package com.db;
import com.activity.Util.Util;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
public class DBhelper extends SQLiteOpenHelper {
public DBhelper(Context context) {
super(context, "dish.db", null, 1);
}
public static DBhelper mInstance = null;
@Override
public void onCreate(SQLiteDatabase db) {
// 菜单表
String sql = "create table "
+ Util.DB_TABLE_DISH
+ "(_id integer primary key autoincrement,dish_id,dish_class,dish_name,image,price,itrInfo,dish_num text default 1)";
db.execSQL(sql);
// 订单表
String sql1 = "create table "
+ Util.DB_TABLE_ORDER
+ "(_id integer primary key autoincrement,order_id,table_num,isaccount,remark)";
db.execSQL(sql1);
// 桌子表
String sql2 = "create table "
+ Util.DB_TABLE_TABLE
+ "(_id integer primary key autoincrement,table_num,table_name,table_address,table_people)";
db.execSQL(sql2);
// 临时订单表
String sql3 = "create table "
+ Util.DB_TABLE_TEMP_ORDER
+ "(_id integer primary key autoincrement,table_num,dish_id,order_id,number)";
db.execSQL(sql3);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
public static SQLiteOpenHelper getInstance(Context context, CursorFactory factory) {
if(mInstance == null){
mInstance = new DBhelper(context);
}
return mInstance;
}
}