Flex: Package is unexpected error

Question

import mx.controls.Alert;

package dbconfig // error line here
{
    public class DBConn
    {
        private var dbConn:SQLConnection;
        private var dbFile:File;

        public function DBConn()
        {
            this.openConnection(); 
        }

        public function openConnection(){
            dbFile = File.applicationStorageDirectory.resolvePath("accounting.sqlite");
            dbConn = new SQLConnection();

            try 
            {
                dbConn.open(dbFile);
                Alert.show("asdf");
            }
            catch(e:SQLError)
            {
                Alert.show("SQL Error Occured: ", e.message);
            }
        }
    }
}

Answer 1

You need to place the import inside of the package definition:

package dbconfig
{
    import mx.controls.Alert;

    public class DBConn
    {
        private var dbConn:SQLConnection;
        private var dbFile:File;

        public function DBConn()
        {
            this.openConnection(); 
        }

        public function openConnection(){
            dbFile = File.applicationStorageDirectory.resolvePath("accounting.sqlite");
            dbConn = new SQLConnection();

            try 
            {
                dbConn.open(dbFile);
                Alert.show("asdf");
            }
            catch(e:SQLError)
            {
                Alert.show("SQL Error Occured: ", e.message);
            }
        }
    }
}

Answer 2

Yes, unlike Java, you must import all classes you are going to use, even if you fully qualify them. Judging by the tags I assume you know this, but the SQLConnection and File are Air only, so wouldn't run in the normal flash player.

Answer 3

crud and sqlite tutorial here: http://www.peterelst.com/blog/2008/04/07/introduction-to-sqlite-in-adobe-air/