建表语句:
String sql = “create table if not exists ” + TABLE_NAME + ” (Id integer primary key, CustomName text, OrderPrice integer, Country text)”;
sqLiteDatabase.execSQL(sql);
或是:
“CREATE TABLE person (_id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR, age SMALLINT)”
或是在table里,封装成一个方法:
public static String getCreateTableSQL(){
ArrayList fields = new ArrayList();
fields.add(new TableField(KEY_ID,”integer primary key autoincrement”));
fields.add(new TableField(KEY_USERID, “text”));
fields.add(new TableField(KEY_NAME, “text”));
fields.add(new TableField(KEY_IMG, “text”));
StringBuilder sb = new StringBuilder();
sb.append(“create table if not exists “);
sb.append(TABLE_NAME);
sb.append(” (“);
TableField curField = null;
for(int i= 0,j=fields.size();i