Android(安卓)SQLite 数据库、表的增、删、改、查操作

原创作品，允许转载，转载时请务必以超链接形式标明文章原始出处：http://blog.csdn.net/love254443233/article/details/7494398 、作者信息和本声明。否则将追究法律责任。
重载了很多方法，总有一个是你想要的。
package cn.edu.xtu.tilepuzzle;import android.content.ContentValues;import android.content.Context;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import android.util.Log;public class SQLite {private static Context context;// 应用环境上下文 Activity 是其子类private final static String DBName=GameDB.DATABASE_TILEPUZZLE_NAME;private final static String userTableName=GameDB.TABLE_TILEPUZZLE_PEOPLEINFO;private final static String gameSetTableName=GameDB.TABLE_TILEPUZZLE_GAMEDATA;public SQLite(Context _context) {context = _context;}/** * 打开数据库 *  * @DBName 数据库名字 */public SQLiteDatabase openDBByName(String DBName) {SQLiteDatabase db;//deleteDBByName(DBName);db = context.openOrCreateDatabase(DBName, Context.MODE_PRIVATE, null);return db;}/** * 打开数据库 *  * @DBName 数据库名字 */public void createDBByName(String DBName) {SQLiteDatabase db;//deleteDBByName(DBName);db = context.openOrCreateDatabase(DBName, Context.MODE_PRIVATE, null);db.close();}/** * 删除数据库 *  * @DBName 数据库名字 */public boolean deleteDBByName(String DBName) {context.deleteDatabase(DBName);Log.d("DB", "had deleted database:" + DBName);return false;}/** * 删除数据库中表的数据 * @TableName 表名字 */public boolean deleteTableByName(String TableName) {SQLiteDatabase dbDatabase = openDBByName(DBName);dbDatabase.delete(TableName, null, null);close(dbDatabase);Log.d("DB", "had deleted table:" + DBName + "->" + TableName);return false;}public boolean isExistTableByName(String TableName) {SQLiteDatabase db_ = openDBByName(DBName);String sqlString = "select * from " + TableName;try {db_.execSQL(sqlString);//Log.d("DB", "Create Table:" + TableName);return true;} catch (Exception e) {//Log.d("DB", TableName + " is exists.");return false;} finally {close(db_);}}/** * 检查数据库中的表是否存在 * @TableName 表名字 */public boolean checkTableIsExistByName(String TableName) {SQLiteDatabase db_ = openDBByName(DBName);String sqlString = "";/*if (TableName.equals(GameDB.TABLE_TILEPUZZLE_GAMEDATA)) {sqlString = "CREATE TABLE " + TableName + GameDB.GAMEDATA_STRUCTURE;} else */if (TableName.equals(GameDB.TABLE_TILEPUZZLE_PEOPLEINFO)) {sqlString = "CREATE TABLE " + TableName + GameDB.PEOPLEINFO_STRUCTURE;} try {db_.execSQL(sqlString);//Log.d("DB", "Create Table:" + TableName);/*if (TableName.equals(GameDB.TABLE_TILEPUZZLE_GAMEDATA))this.addGameData( GameDB.gameSetData);*/return true;} catch (Exception e) {//Log.d("DB", TableName + " is exists.");//if (TableName.equals(GameDB.TABLE_TILEPUZZLE_GAMEDATA)) {//Cursor cursor_ = getCursorByTableName(TableName);//if (cursor_ == null || cursor_.getCount() == 0)//addGameData(GameDB.gameSetData);//}return false;} finally {close(db_);}}/** * 在数据库中创建表 * @TableName 表名字 */public boolean createTableByName(String TableName){SQLiteDatabase db_ = openDBByName(DBName);String sqlString = "";if (TableName.equals(GameDB.TABLE_TILEPUZZLE_GAMEDATA)) {sqlString = "CREATE TABLE " + TableName + GameDB.GAMEDATA_STRUCTURE;} else if (TableName.equals(GameDB.TABLE_TILEPUZZLE_PEOPLEINFO)) {sqlString = "CREATE TABLE " + TableName + GameDB.PEOPLEINFO_STRUCTURE;} else;try {db_.execSQL(sqlString);//Log.d("DB ", TableName + " had created.");return true;} catch (Exception e) {//Log.d("DB ", TableName + " is exists. don't create.");return false;} finally {close(db_);}}/** * 该方法已重载 保存数据到数据库的游戏配置参数表中 * @gameSetData_ 游戏数据 *  */public boolean addGameData(String[] gameSetData_) {SQLiteDatabase db_=openDBByName(DBName);String TableName=gameSetTableName; String sql = "insert into " + TableName + " values(";int i = 0;for (i = 0; i < gameSetData_.length - 1; i++)sql += "'" + gameSetData_[i] + "'" + ",";sql += "'" + gameSetData_[i] + "');";Log.d("DB", sql);try {db_.execSQL(sql);//Log.d("DB", "insert Table ok");return true;} catch (Exception e) {//Log.d("DB", "insert Table  err: " + sql);return false;} finally {close(db_);}}/** * 该方法已重载 保存数据到数据库的游戏玩家表中 *  * @DBName 数据库名字 * @TableName 表名字 * @peopleInfo 个人数据 */public boolean addUserInfo(String[][] peopleInfo) {SQLiteDatabase db_=openDBByName(DBName);ContentValues values=new ContentValues();try {for (int i = 0; i < peopleInfo.length; i++) {values=new ContentValues();values.put("NAME", peopleInfo[i][0]);values.put("TIME", peopleInfo[i][1]);db_.insert(userTableName, null, values);}Log.d("DB", "insert Table ok");return true;} catch (Exception e) {Log.d("DB", "insert Table  err: ???");return false;} finally {close(db_);}}/** * 该方法已重载 保存数据到数据库的玩家信息表中 *  * @DBName 数据库名字 * @TableName 表名字 * @peopleName 个人名字 * @time 游戏用的时间 */public boolean addUserInfoTable(SQLiteDatabase db_, String TableName, String peopleName, int time) {ContentValues values = new ContentValues();try {values.put("NAME", peopleName);values.put("TIME", time);db_.insert(TableName, null, values);return true;} catch (Exception e) {Log.d("DB", "insert Table  err:?? ");return false;} finally {close(db_);}}/** * 该方法已重载 保存数据到数据库的玩家信息表中 *  * @DBName 数据库名字 * @TableName 表名字 * @peopleName 个人名字 * @time 游戏用的时间 */public  boolean addUserInfo(String peopleName, long time) {SQLiteDatabase db_=openDBByName(DBName);ContentValues values = new ContentValues();try {values.put("NAME", peopleName);values.put("TIME", time);db_.insert(userTableName, null, values);return true;} catch (Exception e) {Log.d("DB", "insert Table  err:?? ");return false;} finally {close(db_);}}/** * 获取数据库的表中数据 * @DBName 数据库名字 * @TableName 表名字 * @return 返回Cursor */public Cursor getDataByTableName(SQLiteDatabase db_, String TableName) {// Cursor cursor = db_.query(TableName, null, null, null, null, null, null);String sql = "";if (TableName.equals(GameDB.TABLE_TILEPUZZLE_GAMEDATA))sql = "select * from " + TableName+";";else if (TableName.equals(GameDB.TABLE_TILEPUZZLE_PEOPLEINFO))sql = "select * from " + TableName + " order by TIME ASC"+";";Cursor cursor = db_.rawQuery(sql, null);Log.d("DB", "cursor count:"+cursor.getCount());int mycount = cursor.getCount();close(db_);if (mycount == 0)return null;elsereturn cursor;}/** * 获取数据库的表中数据 * @DBName 数据库名字 * @TableName 表名字 * @return 返回Cursor */public Cursor getCursorByTableName(String TableName) {SQLiteDatabase db_=openDBByName(DBName) ;// Cursor cursor = db_.query(TableName, null, null, null, null, null, null);String sql = "";if (TableName.equals(GameDB.TABLE_TILEPUZZLE_GAMEDATA))sql = "select * from " + TableName+";";else if (TableName.equals(GameDB.TABLE_TILEPUZZLE_PEOPLEINFO))sql = "select * from " + TableName + " order by TIME ASC"+";";Cursor cursor = db_.rawQuery(sql, null);Log.d("DB", "cursor count:"+cursor.getCount());int mycount = cursor.getCount();close(db_);if (mycount == 0)return null;elsereturn cursor;}/** * 更新数据库中的个人信息 * @DBName 数据库名字 * @TableName 表名字 * @peopleName 个人名字 * @time 游戏用的时间 */public boolean updateTableByName(String DBName, String TableName, String peopleName, int time) {SQLiteDatabase db_ = openDBByName(DBName);ContentValues values = new ContentValues();values.put("NAME", peopleName);values.put("TIME", time);db_.update(TableName, values, "NAME='" + peopleName + "'", null);close(db_);return false;}/** * 更新数据库中的个人信息 *  * @DBName 数据库名字 * @TableName 表名字 * @peopleName 个人名字 * @time 游戏用的时间 */public boolean updateUserInfoByNameAndTime(String peopleName, int time) {SQLiteDatabase db_=openDBByName(DBName);ContentValues values = new ContentValues();values.put("NAME", peopleName);values.put("TIME", time);db_.update(userTableName, values, "NAME='" + peopleName + "';", null);close(db_);return false;}/** * 更新数据库中的游戏配置参数 *  * @DBName 数据库名字 * @TableName 表名字 * @gameData 游戏参数 */public boolean updateGameSetData(String gameData[]) {//SQLiteDatabase db_ = openDBByName(DBName);SQLiteDatabase db_=openDBByName(DBName);String TableName=gameSetTableName; ContentValues values = new ContentValues();values.put("orgImageID", gameData[GameDB.IndexInGameSetDatat_orgImageID]);values.put("reversed", gameData[GameDB.IndexInGameSetDatat_reversed]);values.put("funny", gameData[GameDB.IndexInGameSetDatat_funny]);values.put("addString", gameData[GameDB.IndexInGameSetDatat_addString]);values.put("hard", gameData[GameDB.IndexInGameSetDatat_hard]);values.put("rows", gameData[GameDB.IndexInGameSetDatat_rows]);values.put("columns", gameData[GameDB.IndexInGameSetDatat_columns]);try {Log.d("DB", "开始更新游戏信息：" +TableName);db_.update(TableName, values, null,null);Log.d("DB", "更新游戏信息成功->" +TableName+":"+ gameData.toString());return true;} catch (Exception e) {Log.d("DB", "更新游戏信息失败->" +TableName);}finally{close(db_);}return false;}/** * 获取所有玩家信息 */public String[][] getUserInfo(){Cursor cursor=getCursorByTableName(userTableName);int mycount = cursor.getCount();if (mycount == 0)return null;String[][] peopleInfo = new String[mycount][2];// 要利用所有的返回值得，我们需要把指针移到第一行上cursor.moveToFirst();// 同样，如果你要移动到返回值的某行上，你可以做如下操作// cursor.moveToPosition(position);int i = 0;for (i = 0; i < mycount; i++) {peopleInfo[i][0] = cursor.getString(cursor.getColumnIndex("NAME"));peopleInfo[i][1] = cursor.getString(cursor.getColumnIndex("TIME"));// 获取某个值myCursor.getString();cursor.moveToNext();// myCursor.moveToPrevious();}cursor.close();return peopleInfo;}/** * 获取游戏参数信息 * @Cursor Cursor * @return String[] */public String[] getGameData() {Cursor cursor=getCursorByTableName(gameSetTableName);int mycount = cursor.getCount();if (mycount == 0)return null;String[] gameData = new String[GameDB.gameSetData.length];// 要利用所有的返回值得，我们需要把指针移到第一行上cursor.moveToFirst();//"orgImageID", "reversed", "funny", "addStringg", "hard", "rows","columns" ,"sensor"int orgImageID = cursor.getColumnIndex(GameDB.gameSetDataName[GameDB.IndexInGameSetDatat_orgImageID]);gameData[GameDB.IndexInGameSetDatat_orgImageID]=cursor.getString(orgImageID);Log.d("DB", orgImageID+"->orgImageID:"+cursor.getString(orgImageID));int reversed = cursor.getColumnIndex(GameDB.gameSetDataName[GameDB.IndexInGameSetDatat_reversed]);gameData[GameDB.IndexInGameSetDatat_reversed]=cursor.getString(reversed);Log.d("DB", reversed+"->reversed:"+cursor.getString(reversed));int funny = cursor.getColumnIndex(GameDB.gameSetDataName[GameDB.IndexInGameSetDatat_funny]);gameData[GameDB.IndexInGameSetDatat_funny]=cursor.getString(funny);Log.d("DB", funny+"->funny:"+cursor.getString(funny));int addString = cursor.getColumnIndex(GameDB.gameSetDataName[GameDB.IndexInGameSetDatat_addString]);gameData[GameDB.IndexInGameSetDatat_addString]=cursor.getString(addString);Log.d("DB", addString+"->addString:"+cursor.getString(addString));int hard = cursor.getColumnIndex(GameDB.gameSetDataName[GameDB.IndexInGameSetDatat_hard]);gameData[GameDB.IndexInGameSetDatat_hard]=cursor.getString(hard);Log.d("DB", hard+"->hard:"+cursor.getString(hard));int rows = cursor.getColumnIndex(GameDB.gameSetDataName[GameDB.IndexInGameSetDatat_rows]);gameData[GameDB.IndexInGameSetDatat_rows]=cursor.getString(rows);Log.d("DB", rows+"->rows:"+cursor.getString(rows));int columns = cursor.getColumnIndex(GameDB.gameSetDataName[GameDB.IndexInGameSetDatat_columns]);gameData[GameDB.IndexInGameSetDatat_columns]=cursor.getString(columns);Log.d("DB", columns+"->columns:"+cursor.getString(columns));int sensor = cursor.getColumnIndex(GameDB.gameSetDataName[GameDB.IndexInGameSetDatat_sensor]);gameData[GameDB.IndexInGameSetDatat_sensor]=cursor.getString(sensor);Log.d("DB", sensor+"->sensor:"+cursor.getString(sensor));cursor.close();return gameData;}/** * 删除数据库中表的个人信息 * @peopleName 个人名字 */public boolean deletePeopleInfoByPeopleName(String peopleName) {SQLiteDatabase db_ = openDBByName(DBName);db_.delete(userTableName, "NAME='" + peopleName + "'", null);close(db_);return false;}public static void close(SQLiteDatabase db_) {db_.close();}public void SqliteTest() {String gameData[]=getGameData();String resultString="";for(int i=0;i<7;i++){resultString+=gameData[i]+";";}Log.d("DB", "SqliteTest:查询->TABLE_TILEPUZZLE_GAMEDATA:"+resultString);String temp[]=GameDB.gameSetData;temp[1]="Y";temp[2]="Y";temp[3]="Y";temp[4]="Y";resultString="";for(int i=0;i<7;i++)resultString+=temp[i]+";";Log.d("DB", "SqliteTest:更改游戏参数为->TABLE_TILEPUZZLE_GAMEDATA:"+resultString);//updateGameSetData(temp);gameData=getGameData();resultString="";for(int i=0;i<7;i++){resultString+=gameData[i]+";";}Log.d("DB", "SqliteTest:更新后->TABLE_TILEPUZZLE_GAMEDATA:"+resultString);//Log.d("DB", "SqliteTest:删除后->TABLE_TILEPUZZLE_GAMEDATA:"+resultString);String tempP[][]=new String[2][2];tempP[0][0]="LIUYAOHUA";tempP[0][1]="100";tempP[1][0]="DAIQING";tempP[1][1]="500";addUserInfo(tempP);Log.d("DB", "SqliteTest:插入->TABLE_TILEPUZZLE_PEOPLEINFO:"+tempP);String peopleInfo[][]=getUserInfo();for(int i=0;iTABLE_TILEPUZZLE_PEOPLEINFO:"+peopleInfo[i][0]+" : "+peopleInfo[i][1]);}updateUserInfoByNameAndTime("LIUYAOHUA", 50);updateUserInfoByNameAndTime("DAIQING", 50);String peopleInfoUP[][]=getUserInfo();for(int i=0;iTABLE_TILEPUZZLE_PEOPLEINFO:"+peopleInfoUP[i][0]+" : "+peopleInfoUP[i][1]);}deletePeopleInfoByPeopleName("DAIQING");String peopleInfoD[][]=getUserInfo();for(int i=0;iTABLE_TILEPUZZLE_PEOPLEINFO:"+peopleInfoD[i][0]+" : "+peopleInfoD[i][1]);}addUserInfo("DAIQING",100); peopleInfo=getUserInfo();for(int i=0;iTABLE_TILEPUZZLE_PEOPLEINFO:"+peopleInfo[i][0]+" : "+peopleInfo[i][1]);}}/** * 通过用户名查询玩家信息记录 * @Cursor Cursor * @peopleName 玩家名字 * @return String 指向结果记录的指针，类似于JDBC 的 ResultSet */public String[] getPeopleInfoFromCursor(Cursor cursor, String peopleName) {int mycount = cursor.getCount();if (mycount == 0)return null;String[] peopleInfo = new String[2];// 要利用所有的返回值得，我们需要把指针移到第一行上cursor.moveToFirst();// 同样，如果你要移动到返回值的某行上，你可以做如下操作// cursor.moveToPosition(position);int i = 0;for (i = 0; i < mycount; i++) {if (cursor.getString(1).endsWith(peopleName)) {peopleInfo[0] = cursor.getString(0);peopleInfo[1] = cursor.getString(1);break;}// 获取某个值myCursor.getString();cursor.moveToNext();// myCursor.moveToPrevious();}cursor.close();if (i >= mycount)return null;return peopleInfo;}/** * 获取所有玩家信息 * @Cursor Cursor * @return String[][] */public String[][] getUserInfoFromCursor(Cursor cursor) {int mycount = cursor.getCount();if (mycount == 0)return null;String[][] peopleInfo = new String[mycount][2];// 要利用所有的返回值得，我们需要把指针移到第一行上cursor.moveToFirst();// 同样，如果你要移动到返回值的某行上，你可以做如下操作// cursor.moveToPosition(position);int i = 0;for (i = 0; i < mycount; i++) {peopleInfo[i][0] = cursor.getString(cursor.getColumnIndex("NAME"));peopleInfo[i][1] = cursor.getString(cursor.getColumnIndex("TIME"));// 获取某个值myCursor.getString();cursor.moveToNext();// myCursor.moveToPrevious();}cursor.close();return peopleInfo;}/** * 获取游戏参数信息 * @Cursor Cursor * @return String[] */public String[] getGameDataFromCursor(Cursor cursor) {int mycount = cursor.getCount();if (mycount == 0)return null;String[] gameData = new String[GameDB.gameSetData.length];// 要利用所有的返回值得，我们需要把指针移到第一行上cursor.moveToFirst();//"orgImageID", "reversed", "funny", "addStringg", "hard", "rows","columns" int orgImageID = cursor.getColumnIndex(GameDB.gameSetDataName[GameDB.IndexInGameSetDatat_orgImageID]);gameData[GameDB.IndexInGameSetDatat_orgImageID]=cursor.getString(orgImageID);Log.d("DB", orgImageID+"->orgImageID:"+cursor.getString(orgImageID));int reversed = cursor.getColumnIndex(GameDB.gameSetDataName[GameDB.IndexInGameSetDatat_reversed]);gameData[GameDB.IndexInGameSetDatat_reversed]=cursor.getString(reversed);Log.d("DB", reversed+"->reversed:"+cursor.getString(reversed));int funny = cursor.getColumnIndex(GameDB.gameSetDataName[GameDB.IndexInGameSetDatat_funny]);gameData[GameDB.IndexInGameSetDatat_funny]=cursor.getString(funny);Log.d("DB", funny+"->funny:"+cursor.getString(funny));int addString = cursor.getColumnIndex(GameDB.gameSetDataName[GameDB.IndexInGameSetDatat_addString]);gameData[GameDB.IndexInGameSetDatat_addString]=cursor.getString(addString);Log.d("DB", addString+"->addString:"+cursor.getString(addString));int hard = cursor.getColumnIndex(GameDB.gameSetDataName[GameDB.IndexInGameSetDatat_hard]);gameData[GameDB.IndexInGameSetDatat_hard]=cursor.getString(hard);Log.d("DB", hard+"->hard:"+cursor.getString(hard));int rows = cursor.getColumnIndex(GameDB.gameSetDataName[GameDB.IndexInGameSetDatat_rows]);gameData[GameDB.IndexInGameSetDatat_rows]=cursor.getString(rows);Log.d("DB", rows+"->rows:"+cursor.getString(rows));int columns = cursor.getColumnIndex(GameDB.gameSetDataName[GameDB.IndexInGameSetDatat_columns]);gameData[GameDB.IndexInGameSetDatat_columns]=cursor.getString(columns);Log.d("DB", columns+"->columns:"+cursor.getString(columns));cursor.close();return gameData;}/** * 删除数据库中表的个人信息 * @DBName 数据库名字 * @TableName 表名字 * @peopleName 个人名字 */public boolean deletePeopleInfoByPeopleName(String DBName, String TableName, String peopleName) {SQLiteDatabase db_ = openDBByName(DBName);db_.delete(TableName, "NAME='" + peopleName + "'", null);close(db_);return false;}/** * 删除数据库中表的个人信息 * @db_ 数据库 * @TableName 表名字 * @peopleName 个人名字 */public boolean deletePeopleInfoByPeopleName(SQLiteDatabase db_, String TableName, String peopleName) {db_.delete(TableName, "NAME='" + peopleName + "'", null);close(db_);return false;}/** * 删除数据库中表的个人信息 * @db_ 数据库 * @TableName 表名字 * @peopleName 个人名字 *//*public boolean deletePeopleInfoByPeopleName(SQLiteDatabase db_, String peopleName) {db_.delete(this.UserTableName, "NAME='" + peopleName + "'", null);close(db_);return false;}*//** * 删除数据库中表的数据 * @DBName 数据库名字 * @TableName 表名字 */public boolean deleteTableByDBName(String DBName, String TableName) {SQLiteDatabase dbDatabase = openDBByName(DBName);dbDatabase.delete(TableName, null, null);close(dbDatabase);// checkDBByName(DBName);// db.delete(table, whereClause,// whereArgs).deleteDatabase(GameDB.DATABASE_TILEPUZZLE_NAME);Log.d("DB", "had deleted table:" + DBName + "->" + TableName);return false;}/** * 更新数据库中的个人信息 *  * @DBName 数据库名字 * @TableName 表名字 * @peopleName 个人名字 * @time 游戏用的时间 */public boolean updateTableByName(SQLiteDatabase db_, String TableName, String peopleName, int time) {ContentValues values = new ContentValues();values.put("NAME", peopleName);values.put("TIME", time);db_.update(TableName, values, "NAME='" + peopleName + "';", null);close(db_);return false;}/** * 更新数据库中的游戏配置参数 *  * @DBName 数据库名字 * @TableName 表名字 * @gameData 游戏参数 */public boolean updateTableByName(String DBName, String TableName, String gameData[]) {SQLiteDatabase db_ = openDBByName(DBName);ContentValues values = new ContentValues();values.put("orgImageID", gameData[GameDB.IndexInGameSetDatat_orgImageID]);values.put("reversed", gameData[GameDB.IndexInGameSetDatat_reversed]);values.put("funny", gameData[GameDB.IndexInGameSetDatat_funny]);values.put("addString", gameData[GameDB.IndexInGameSetDatat_addString]);values.put("hard", gameData[GameDB.IndexInGameSetDatat_hard]);values.put("rows", gameData[GameDB.IndexInGameSetDatat_rows]);values.put("columns", gameData[GameDB.IndexInGameSetDatat_columns]);try {db_.update(TableName, values, null, null);Log.d("DB", "更新游戏信息成功：" + gameData);return true;} catch (Exception e) {Log.d("DB", "更新游戏信息失败：" + gameData);}finally{close(db_);}return false;}/** * 该方法已重载 保存数据到数据库的游戏配置参数表中 *  * @DBName 数据库名字 * @TableName 表名字 * @gameSetData_ 游戏数据 *  */public boolean addDataToGameTable(SQLiteDatabase db_, String TableName, String[] gameSetData_) {String sql = "insert into " + TableName + " values(";int i = 0;for (i = 0; i < gameSetData_.length - 1; i++)sql += "'" + gameSetData_[i] + "'" + ",";sql += "'" + gameSetData_[i] + "');";Log.d("DB", sql);try {db_.execSQL(sql);Log.d("DB", "insert Table ok");return true;} catch (Exception e) {Log.d("DB", "insert Table  err: " + sql);return false;} finally {close(db_);}}/** * 该方法已重载 保存数据到数据库的游戏玩家表中 *  * @DBName 数据库名字 * @TableName 表名字 * @peopleInfo 个人数据 */public boolean addUserInfoTable(SQLiteDatabase db_, String TableName, String[][] peopleInfo) {ContentValues values=new ContentValues();try {for (int i = 0; i < peopleInfo.length; i++) {values=new ContentValues();values.put("NAME", peopleInfo[i][0]);values.put("TIME", peopleInfo[i][1]);db_.insert(TableName, null, values);}Log.d("DB", "insert Table ok");return true;} catch (Exception e) {Log.d("DB", "insert Table  err: ???");return false;} finally {close(db_);}}}
更多相关文章

随机推荐
