android数据库的建立

package com.example.account.dao;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;

public class DBOpenHelper extends SQLiteOpenHelper {
    private static final int VERSION = 1;// 定义数据库版本号
    private static final String DBNAME = "account2.db";// 定义数据库名

    public DBOpenHelper(Context context) {
        super(context, DBNAME, null, VERSION);
        // TODO Auto-generated constructor stub
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        // TODO Auto-generated method stub
        db.execSQL("create table tb_pwd(password varchar(20))");

        db.execSQL("create table tb_outaccount (_id integer primary key,money decimal,time varchar(10),"
                + "type varchar(10),address varchar(100),mark varchar(200))");// 创建支出信息表
        db.execSQL("create table tb_inaccount (_id integer primary key,money decimal,time varchar(10),type varchar(10),handler varchar(100),mark varchar(200))");// 创建收入信息表
        db.execSQL("create table tb_flag (_id integer primary key,flag varchar(200))");// 创建便签信息表
        db.execSQL(" create table tb_userinfo(username varchar(100) primary key,userpwd varchar(20) not null, sex varchar(4) not null,sdept varchar(20) ) ");

    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // TODO Auto-generated method stub

    }