DBOpenHelper用法

DBOpenHelper用法
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DBOpenHelper extends SQLiteOpenHelper{
	
	public static final String DB_NAME = "IntelinkSQL.db";
	public static final int DB_VERSION = 1;

	public DBOpenHelper(Context context) {
		super(context, DB_NAME, null, DB_VERSION);
	}

	@Override
	public void onCreate(SQLiteDatabase database) {
		
		database.execSQL("CREATE TABLE IF NOT EXISTS TAB_ADDRESS_INFO(_id integer primary key autoincrement, address VARCHAR2(100));");
		
	}

	@Override
	public void onUpgrade(SQLiteDatabase database, int oldVersion, int newVersion) {
		
	}

}

  • 1
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
基于android的营养食品系统 private static final String DB NAME "people db"; private static final String DB TABLE "peopleinfo"; private static final int DB VERSION 1; public static final String KEY ID " id"; public static final String KEY NAME "name"; public static final String KEY MATCH "match"; public static final String KEY PHOTOSRC "photosrc"; public static final String KEY INTRODUCTION "introduction"; private SQLiteDatabase db; private final Context context; private DBOpenHelper dbOpenHelper; public OpenHelper Context context { context context; } Close the database public void close { if db null { db close ; db null; } } Open the database public void open throws SQLiteException { dbOpenHelper new DBOpenHelper context DB NAME null DB VERSION ; try { db dbOpenHelper getWritableDatabase ; } catch SQLiteException ex { db dbOpenHelper getReadableDatabase ; } } 插入数据 public long insert People people { ContentValues newValues new ContentValues ; newValues put KEY NAME people Name ; newValues put KEY MATCH people Match ; newValues put KEY PHOTOSRC people PhotoSrc ; newValues put KEY INTRODUCTION people Introduction ; return db insert DB TABLE null newValues ; } 显示所有数据 public People[] queryAllData { Cursor results db query DB TABLE new String[] { KEY ID KEY NAME KEY MATCH KEY PHOTOSRC KEY INTRODUCTION } null null null null null ; return ConvertToPeople results ; }">基于android的营养食品系统 private static final String DB NAME "people db"; private static final String DB TABLE "peopleinfo"; private static final int DB VERSION 1; public static final String KEY ID " id"; public static final String KEY NAME &quot [更多]

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值