1 package com.android.client;
 2 import android.content.Context;
 3 import android.database.sqlite.SQLiteDatabase;
 4 import android.database.sqlite.SQLiteOpenHelper;
 5 import android.database.sqlite.SQLiteDatabase.CursorFactory;
 6 
 7 public    class    DatabaseHelper    extends    SQLiteOpenHelper{
 8     /*public static final String TB_XINLANGWEIBO="XINLANGWEIBO";
 9     public static final String TB_QQGROUP="QQGROUP";
10     public static final String TB_WEB="WEB";
11     public static final String TB_QQLIST="QQLIST";
12     public static final String TB_CLIENTPUB="CLIENTPUB";
13 
14     public static final String XINLANGWEIBO_ID="_id";
15     public static final String QQGROUP_ID="_id";
16     public static final String WEB_ID="_id";
17     public static final String CLIENTPUB_ID="_id";
18 
19     public static final String QQLIST_ID="_id";
20     public static final String QQLIST_NICK="NICK";*/
21     public static final String TB_BUSINESS="BUSINESS";
22     
23     public static final String ID="_id"; 
24     public static final String CLASS="CLASS";
25     public static final String CONTENT="CONTENT";
26     public static final String FROM="FRM";
27     public static final String WHO="WHO";
28     
29     
30     public DatabaseHelper(Context context,String name,CursorFactory factory,int version){
31         super(context,name,factory,version);
32     }
33     
34     @Override
35     public void onCreate(SQLiteDatabase arg0){
36         //arg0.execSQL("CREATE TABLE IF NOT EXISTS "+TB_XINLANGWEIBO+"(_id INTEGER PRIMARY KEY AUTOINCREMENT,CONTENT TEXT);");
37         //arg0.execSQL("CREATE TABLE IF NOT EXISTS "+TB_QQGROUP+"(_id INTEGER PRIMARY KEY AUTOINCREMENT,CONTENT TEXT);");
38         //arg0.execSQL("CREATE TABLE IF NOT EXISTS "+TB_WEB+"(_id INTEGER PRIMARY KEY AUTOINCREMENT,CONTENT TEXT);");
39         
40         //arg0.execSQL("CREATE TABLE IF NOT EXISTS "+TB_QQLIST+"(_id TEXT PRIMARY KEY,NICK TEXT);");
41         //arg0.execSQL("CREATE TABLE IF NOT EXISTS "+TB_CLIENTPUB+"(_id INTEGER PRIMARY KEY AUTOINCREMENT,CONTENT TEXT);");
42         arg0.execSQL("CREATE TABLE IF NOT EXISTS "+TB_BUSINESS+"(_id INTEGER PRIMARY KEY AUTOINCREMENT,CLASS TEXT,CONTENT TEXT,FRM TEXT,WHO TEXT);");
43 
44         
45     }
46     @Override
47     public void onUpgrade(SQLiteDatabase db,int oldVertion,int newVersion){
48         //db.execSQL("DROP TABLE IF EXISTS"+TB_XINLANGWEIBO);
49         //db.execSQL("DROP TABLE IF EXISTS"+TB_QQGROUP);
50         //db.execSQL("DROP TABLE IF EXISTS"+TB_WEB);
51         //db.execSQL("DROP TABLE IF EXISTS"+TB_QQLIST);
52         onCreate(db);
53         
54     }
55 }