解决方法

static sqliteDatabase openorCreateDatabase(String path,sqliteDatabase.CursorFactory factory) //打开数据库 
Cursor query(String table,String[] columns,String selection,String[] selectionArgs,String groupBy,String having,String orderBy,String limit) //执行查询sql 
void execsql(String sql) //执行非查询sql 

//执行select type,name from sqlite_master where name='colaconfig' 
String col[] = {"type","name" }; 
 Cursor c =db.query("sqlite_master",col,"name='colaconfig'",null,null); 
 int n=c.getCount(); 
//执行多表查询 
//select fee,desc from acctite a,bills b where a.id=b.id 
String col2[] = {"fee","desc" }; 
Cursor c2 =db.query("acctitem a,bills b","a.id=b.id",null); 
int n2=c2.getCount(); 
Log.v("cola","c2.getCount="+n2+""); 
 
c2.movetoFirst(); 
int k = 0; 
while(!c2.isAfterLast()){ 
 String ss = c2.getString(0) +","+ c2.getString(1);  
 c2.movetoNext(); 
  
 Log.v("cola","ss="+ss+""); 
} 

public void initApp(){ 
 BilldbHelper billdb=new BilldbHelper(this); 
 billdb.FirstStart(); 
 billdb.close(); 
} 

package com.cola.ui; 
import android.content.Context; 
import android.database.Cursor; 
import android.database.sqlite.sqliteDatabase; 
import android.util.Log; 
/** 
 * Provides access to a database of notes. Each note has a title,the note 
 * itself,a creation date and a modified data. 
 */ 
public class BilldbHelper { 
 private static final String TAG = "Cola_BilldbHelper"; 
 private static final String DATABASE_NAME = "cola.db"; 
 
 sqliteDatabase db; 
 Context context; 
 
 BilldbHelper(Context _context) { 
 context=_context; 
 db=context.openorCreateDatabase(DATABASE_NAME,null); //创建数据库 
 Log.v(TAG,"db path="+db.getPath()); 
 } 
 
 public void CreateTable_acctitem() { 
 try{ 
 db.execsql("CREATE TABLE acctitem (" //创建账目表 
  + "ID INTEGER PRIMARY KEY," 
  + "PID integer," 
  + "NAME TEXT," 
  + "TYPE INTEGER"  
  + ");"); 
 Log.v("cola","Create Table acctitem ok"); 
 }catch(Exception e){ 
 Log.v("cola","Create Table acctitem err,table exists."); 
 } 
 } 
 
 public void CreateTable_bills() { 
 try{ 
 db.execsql("CREATE TABLE bills (" 
  + "ID INTEGER PRIMARY KEY," 
  + "fee integer," 
  + "userid integer," 
  + "sdate TEXT," 
  + "stime TEXT," 
  + "desc TEXT"  
  + ");"); 
 Log.v("cola",table exists."); 
 } 
 } 
 
 public void CreateTable_colaconfig() { 
 try{ 
 db.execsql("CREATE TABLE colaconfig (" 
  + "ID INTEGER PRIMARY KEY," 
  + "NAME TEXT" 
  + ");"); 
 Log.v("cola","Create Table colaconfig ok"); 
 }catch(Exception e){ 
 Log.v("cola",table exists."); 
 } 
 } 
 
 public void Initacctitem() { 
 
 db.execsql("insert into acctitem values (100,'收入',0)"); 
 db.execsql("insert into acctitem values (100100,100,'工资',0)"); 
 db.execsql("insert into acctitem values (200,'支出',1)"); 
 db.execsql("insert into acctitem values (200100,200,'生活用品',1)"); 
 db.execsql("insert into acctitem values (200101,'水电煤气费',1)"); 
 db.execsql("insert into acctitem values (200103,'汽油费',1)"); 
 Log.v("cola","insert into ok"); 
 
 } 
 
 
 public void QueryTable_acctitem(){ 
 
 } 
 
 public void FirstStart(){ 
 //如果是第一次启动,就不存在colaconfig这张表. 
 try{ 
 String col[] = {"type",null); 
 int n=c.getCount(); 
 if (c.getCount()==0){ 
 CreateTable_acctitem(); 
 CreateTable_colaconfig(); 
 CreateTable_bills(); 
 Initacctitem(); 
  
 } 
 
 Log.v("cola","c.getCount="+n+""); 
 
 
 
 }catch(Exception e){ 
 Log.v("cola","e="+e.getMessage()); 
 } 
 
 } 
 
 public void close(){ 
 db.close(); 
 } 
}