android 数据库创建和封装

最新推荐文章于 2021-09-23 11:39:28 发布

rvncds

最新推荐文章于 2021-09-23 11:39:28 发布

阅读量408

点赞数

分类专栏： android基础知识

本文链接：https://blog.csdn.net/rvncds/article/details/38656125

版权

android基础知识专栏收录该内容

4 篇文章 0 订阅

订阅专栏

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 MyDBAdapter {
	
	public static final String DATABASE_NAME = "calendar_calendar.db";
	public static final String DATABASE_TABLE ="mainTable";
	public static final int    DATABASE_VERSION = 1;
	public static final String KEY_ID="id";
	public static final String KEY_Month_ID="month_id"; 
	public static final String KEY_YEAR = "year";
	public static final String KEY_MONTH = "month";
	public static final String KEY_DAY = "day";
	public static final String KEY_WEEKDAY = "weekday";
	public static final String KEY_YEAR_LUNAR = "year_lunar";
	public static final String KEY_MONTH_LUNAR = "month_lunar";
	public static final String KEY_DAY_LUNAR = "day_lunar";
	public static final String KEY_FESTIVAL = "festival";
	public static final String KEY_ANIMALS = "animals";
	public static final String KEY_YI = "yi";
	public static final String KEY_JI = "ji";
	
	private static final String DATABASE_CREATE = "create table if not exists " + DATABASE_TABLE 
			+ "( " 
			+ KEY_ID + " integer primary key autoincrement, "
			+ KEY_Month_ID + " integer not null, "
			+ KEY_YEAR + " integer not null, " 
			+ KEY_MONTH + " integer not null, "
			+ KEY_DAY  + " integer not null, "
			+ KEY_WEEKDAY + " integer not null, "
			+ KEY_YEAR_LUNAR + " text not null, "
			+ KEY_MONTH_LUNAR + " text not null, "
			+ KEY_FESTIVAL + " text not null, "
			+ KEY_DAY_LUNAR + " text not null, "
			+ KEY_ANIMALS + " text not null, "
			+ KEY_YI + " text not null, "
			+ KEY_JI + " text not null"
			+ ")";
	
	private SQLiteDatabase db; 
	private final Context context; 
	private myDbHelper dbHelper; 

	public MyDBAdapter(Context _context) { 
		context = _context; 
		dbHelper = new myDbHelper(); 
		} 
	public MyDBAdapter open() throws SQLException { 
		db = dbHelper.getWritableDatabase(); 
		return this; 
		} 
	
	public void close() { 
		db.close(); 
		} 
	
	public long insert(ContentValues contentValues) { 
		
		return db.insert(DATABASE_TABLE, null, contentValues);
		
	 } 
	
	public long insert(int month_id, int year, int month, int day, int weekday, 
			String year_lunar, String month_lunar, String day_lunar,
			String animals, String festival,String yi, String ji) { 
			ContentValues contentValues = new ContentValues(); 
			contentValues.put(KEY_Month_ID, month_id);
			contentValues.put(KEY_YEAR, year);
			contentValues.put(KEY_MONTH, month);
			contentValues.put(KEY_DAY, day);
			contentValues.put(KEY_WEEKDAY, weekday);
			contentValues.put(KEY_YEAR_LUNAR, year_lunar);
			contentValues.put(KEY_MONTH_LUNAR, month_lunar);
			contentValues.put(KEY_DAY_LUNAR, day_lunar);
			contentValues.put(KEY_ANIMALS, animals);
			contentValues.put(KEY_FESTIVAL, festival);
			contentValues.put(KEY_YI, yi);
			contentValues.put(KEY_JI, ji);
		
		return db.insert(DATABASE_TABLE, null, contentValues);
		} 
	
	public Cursor query(String[] columns, String selection,
            String[] selectionArgs, String groupBy, String having,
            String orderBy) { 
		return db.query(DATABASE_TABLE,columns,selection,selectionArgs,groupBy,having,orderBy);
		} 

	
	public boolean remove(long rowIndex) { 
		return db.delete(DATABASE_TABLE, KEY_ID + "=" + rowIndex, null) > 0; 
		} 
	
	
	public class myDbHelper extends SQLiteOpenHelper {
		
		public myDbHelper() {
			super(context, DATABASE_NAME, null, DATABASE_VERSION);
		}

		@Override
		public void onCreate(SQLiteDatabase db) {
			db.execSQL(DATABASE_CREATE);
		}
		
		@Override
		public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
			// TODO Auto-generated method stub
			Log.w("MyDBAdapter", "Upgrading from version " + 
					oldVersion + " to " + newVersion +", which will destroy all old data"); 

			db.execSQL("DROP TABLE IF EXISTS " + DATABASE_TABLE); 
			onCreate(db); 
		}
	}
	
}

调用：

MyDBAdapter mdb = new MyDBAdapter(this.getApplicationContext()).open();

mdb.insert...等函数使用