Blame view

src/com/ectrip/cyt/db/DbHelper.java 1.04 KB
3c2353cd   杜方   1、畅游通核销app源码提交;
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
  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);
  	}
  
  }