DbHelper.java
1.04 KB
package com.ectrip.cyt.db;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class DbHelper extends SQLiteOpenHelper {
private static String Db_Name = "ectrip.db";
private static int Db_Version = 7;
public DbHelper(Context context) {
super(context, Db_Name, null, Db_Version);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE IF NOT EXISTS ec_configs"
+ "(ec_cid NVARCHAR,ec_ip NVARCHAR,ec_passwd NVARCHAR,ec_mac NVARCHAR,ec_key NVARCHAR,ec_name NVARCHAR,ec_isPrint INT)");
//数据表名为ec_save_print,字段为ec_id,ec_time,ec_content,
db.execSQL("CREATE TABLE IF NOT EXISTS ec_save_print"
+ "(ec_id INTEGER PRIMARY KEY AUTOINCREMENT,ec_time NVARCHAR,ec_content NVARCHAR,ec_order_id NVARCHAR)");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS ec_configs");
db.execSQL("DROP TABLE IF EXISTS ec_save_print");
onCreate(db);
}
}