SQLite使用

1、创建

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

public class DB extends SQLiteOpenHelper{

	static String DB_Name = "mys.db";
	static int version = 1;

	public DB(Context context) {
		super(context,DB_Name,null,version);
	}
	public static DB getInstance(Context context){
		DB dbOpenHelper=null;
		if (dbOpenHelper==null) {
			dbOpenHelper=new DB(context) ;
		}
		return dbOpenHelper;
		
	}
	

	@Override
	public void onCreate(SQLiteDatabase db) {
		// TODO Auto-generated method stub
		String sql = "create table if not exists p ( _id integer primary key,"
				+ "name char(20),a char(20),b char(20),c char(20),d char(20)," +
				                   "e char(1),f char(1),g char(1) ) ";
		String[] sqls=new String[]{ 
				 "insert into p  values(1,'标准','12','1','2')",};
		
		
		db.execSQL(sql);
		for (String string : sqls) {
			db.execSQL(string);
		}
		
		
		
	}

	@Override
	public void onUpgrade(SQLiteDatabase db,int oldVersion,int newVersion) {
		// TODO Auto-generated method stub
		db.execSQL("drop table if exists tm");
		onCreate(db);
		
	}

}

SQLiteDatabase database=DB.getInstance(context).getReadableDatabase();
		String sql = "select * from p";
		Cursor result = database.rawQuery(sql,null);
		System.out.println(result.getColumnCount());
		System.out.println(result.getCount());
		result.moveToFirst();
		
		while (true) {
			String test= result.getString(0);//获取该行的第一个数
		
			
           //当表中数据为空时，将不停地循环
			if (result.isLast() || result.getCount()==0) {
				break;
			}
			
			result.moveToNext();
		}
		result.close();
		database.close();

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!