java语言写的android系统，用于个人账目管理，课程设计上写的欢迎下载
package moneymanager.moneymanager;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;
/*
*
* 데이터베이스를 관리하는 클래스입니다.
*
*/
public class DBAdapter
{
private static final String TAG = "NotesDbAdapter";
private DatabaseHelper mDbHelper;
private SQLiteDatabase mDb;
// 데이터베이스이름과 테블이름들을 정의
private static final String DATABASE_NAME = "MoneyManagerDB";
private static final int DATABASE_VERSION = 2;
private static final String DATABASE_SETTING_TABLE = "SettingTbl";
private static final String DATABASE_BADGET_TABLE = "BadgetTbl";
private static final String DATABASE_PAYMENT_TABLE = "PaymentTbl";
// 테블안의 항목들을 정의
public static final String KEY_SETTINGTBL_ID = "ID";
public static final String KEY_SETTINGTBL_NAME = "Name";
public static final String KEY_SETTINGTBL_VALUE = "Value";
public static final String KEY_BADGETTBL_ID = "ID";
public static final String KEY_BADGETTBL_ITEM = "Item";
public static final String KEY_BADGETTBL_MONEY = "Money";
public static final String KEY_PAYMENTTBL_ID = "ID";
public static final String KEY_PAYMENTTBL_BADGETID = "BadgetID";
public static final String KEY_PAYMENTTBL_OUTDATE = "OutDate";
public static final String KEY_PAYMENTTBL_MONEY = "Money";
public static final String KEY_PAYMENTTBL_NOTE = "Note";
private final Context mCtx;
private static class DatabaseHelper extends SQLiteOpenHelper
{
DatabaseHelper(Context context)
{
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db)
{
String strCreateTbl;
// SettingTbl생성
strCreateTbl = "CREATE TABLE " + DATABASE_SETTING_TABLE + " ("
+ KEY_SETTINGTBL_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
+ KEY_SETTINGTBL_NAME + " TEXT NOT NULL, "
+ KEY_SETTINGTBL_VALUE + " TEXT NOT NULL);";
db.execSQL(strCreateTbl);
// BadgetTbl생성
strCreateTbl = "CREATE TABLE " + DATABASE_BADGET_TABLE + " ("
+ KEY_BADGETTBL_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
+ KEY_BADGETTBL_ITEM + " TEXT NOT NULL, "
+ KEY_BADGETTBL_MONEY + " INTEGER NOT NULL);";
db.execSQL(strCreateTbl);
// PaymentTbl생성
strCreateTbl = "CREATE TABLE " + DATABASE_PAYMENT_TABLE + " ("
+ KEY_PAYMENTTBL_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
+ KEY_PAYMENTTBL_BADGETID + " INTEGER NOT NULL, "
+ KEY_PAYMENTTBL_OUTDATE + " TEXT NOT NULL, "
+ KEY_PAYMENTTBL_MONEY + " INTEGER NOT NULL, "
+ KEY_PAYMENTTBL_NOTE + " TEXT);";
db.execSQL(strCreateTbl);
}
......
4
2697
133KB
2013-08-28
50
