android数据库、安卓数据库读写

来源：互联网发布：网络号和主机号怎么算编辑：程序博客网时间：2024/06/05 06:53
这是一个简单的安卓数据库的创建、删除、插入和查询
话再次不多说，上代码：
package CGDBUtils;import java.util.ArrayList;import java.util.List;import Data.BaseData;import android.content.ContentValues;import android.content.Context;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteOpenHelper;/** * Author: wangliu_petter 叉哥 * QQ:1206420658 * Date: 16-3-24 * Time: 18:00 */public class DBHelper extends SQLiteOpenHelper{private final static int DB_VERSON = 7;//数据库版本信息private Context mcContext = null;//��Table1private final static String TABLE_1="table1";private final static String Table1_appId="appId";private final static String Table1_appName="appName";private final static String Table1_pkgName="pkgName";private final static String Table1_country="country";private final static String Table1_language="language";public DBHelper(Context context) {super(context, null, null, DB_VERSON);// TODO Auto-generated constructor stubthis.mcContext = context;}@Overridepublic void onCreate(SQLiteDatabase db) {createTable(db);}@Overridepublic void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {dropTable(db);}public void createTable(SQLiteDatabase db) {}public void dropTable(SQLiteDatabase db) {}//创建数据库private void createTable1(SQLiteDatabase db){String sql="create table if not exists " + TABLE_1 + "(" + Table1_appId+ " integer primary key autoincrement, " + Table1_appName + " text, "+ Table1_pkgName + " text, "+ Table1_country + " text, "                + Table1_language + " text); "; }//删除数据库private void dropTable1(SQLiteDatabase db){try {db.execSQL("drop table if exists  " + TABLE_1);} catch (Exception e) {// TODO: handle exception}}//插入数据库public boolean insertTable1(BaseData data){if(data==null){return false;}SQLiteDatabase db = null;ContentValues values = new ContentValues();values.put(Table1_appId, data.appId);values.put(Table1_appName, data.appName);values.put(Table1_pkgName, data.pkgName);values.put(Table1_country, data.country);values.put(Table1_language, data.language);long row = -1;try {db = getWritableDatabase();row = db.insert(TABLE_1, null, values);db.close();db = null;} catch (Exception e) {e.printStackTrace();} finally {if (db != null) {db.close();}}return (row == -1) ? false : true;}//从数据库中取数据public List<BaseData> getBaseDatalist() {List<BaseData> list=new ArrayList<BaseData>();String sql = "select * from " + TABLE_1 ; //+" where "+Col_showtype +" = 2";Cursor cursor = null;SQLiteDatabase db = null;         try {         db = getReadableDatabase(); cursor = db.rawQuery(sql, null); if (cursor != null) { while (cursor.moveToNext()) {BaseData data = new BaseData();data.appId = cursor.getInt(cursor.getColumnIndex(Table1_appId));data.appName=cursor.getString(cursor.getColumnIndex(Table1_appName));data.pkgName=cursor.getString(cursor.getColumnIndex(Table1_pkgName));data.country=cursor.getString(cursor.getColumnIndex(Table1_country));data.language=cursor.getString(cursor.getColumnIndex(Table1_language));list.add(data);//InsertManager.getInstance().adInsertDatalist.add(data);   } }} catch (Exception e) {// TODO: handle exceptione.printStackTrace();}finally{if (cursor != null) {cursor.close();}if (db != null) {db.close();}}return list;}}
1 0