请问在数据库下能建多张表吗?我建了两个表,然后在命令行里查看,结果数据库中只有第一张表,第二张表不存在。。求高人指点!
下面是我的数据库代码:
package com.Login2.db;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
public class MyHelper extends SQLiteOpenHelper{
private static final int VERSION=1;
public MyHelper(Context context, String name, CursorFactory factory,
int version) {
super(context, name, factory, version);
// TODO Auto-generated constructor stub
}
public MyHelper(Context context,String name){
this(context,name,VERSION);
}
public MyHelper(Context context,String name,int version){
this(context, name,null,version);
}
@Override
public void onCreate(SQLiteDatabase db){
db.execSQL("create table information(_id int primary key,name varchar,admin varchar,code varchar,power varchar)");
db.execSQL("create table equipment(_id int primary key,kinds vachar,equip vachar,tempreture vachar,state vachar,on/off vachar)");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
System.out.println("update a Database");
}
}
在上面那两个建表语句中,似乎只有第一句执行了,因为第二张表在命令行里查询结果不存在。。。