android - 我需要在 db.execSQL(sql) 之后添加 db.close() 吗？

Question

我通过示例代码定制了一个 SQLiteOpenHelper，我想我应该在 db.execSQL(sql) 之后添加 db.close()，对吗？

public class RuleNumber extends SQLiteOpenHelper{

   private final static String DBName="smsforwardrulenumber.db";
   private final static String TableRuleNumber="rulenumber";

    public RuleNumber(Context context) {
        super(context, DBName, null, DBPublicPar.DBVersion);  
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        // TODO Auto-generated method stub
        String sql= "Create table " 
                + TableRuleNumber
                +" (numberID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,"
                +"ruleID INTEGER NOT NULL,"
                +"numberType INTEGER NOT NULL,"
                +"number TEXT NOT NULL"
                + ");";     
        db.execSQL(sql);
    }

Answer 1

来自 Android Documentation :

Releases a reference to the object, closing the object if the last reference was released.

如果您不想使用同一个实例(又名数据库连接)-关闭它。

但是如果你运行多个查询，你可以在最后关闭连接。