android 数据库 CURD

import android.app.Activity;

import android.content.ContentValues;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.os.Bundle;

import android.view.View;

import android.view.View.OnClickListener;

import android.widget.Button;

 

public class AndroidsqlitedbActivity extends Activity {

    /** Called when the activity is first created. */

    private Button create;

    private Button insert;

    private Button update;

    private Button query;

    private Button delete;

     

    @Override

    public void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.main);

        create = (Button)findViewById(R.id.create);

        insert = (Button)findViewById(R.id.insert);

        update = (Button)findViewById(R.id.update);

        query = (Button)findViewById(R.id.query);

        delete = (Button)findViewById(R.id.delete);

         

        create.setOnClickListener(new CreateListener());

        insert.setOnClickListener(new InsertListener());

        update.setOnClickListener(new UpdateListener());

        query.setOnClickListener(new QueryListener());

        delete.setOnClickListener(new DeleteListener());

    }

     

     

 

     

    @Override

    protected void onDestroy() {

        super.onDestroy();

        //释放和数据库的连接

      //  db.close();

 

    }

 

 

 

 

    /**

     * 创建数据库

     * @author Owner

     *

     */

    class CreateListener implements OnClickListener {

 

        @Override

        public void onClick(View v) {

            DatabaseHelper dbHelper = new DatabaseHelper(AndroidsqlitedbActivity.this, "test_sqlite_db");

            dbHelper.getReadableDatabase();

        }

         

    }

     

    /**

     * 插入一条记录

     * @author Owner

     *

     */

    class InsertListener implements OnClickListener {

 

        @Override

        public void onClick(View v) {

            DatabaseHelper dbHelper = new DatabaseHelper(AndroidsqlitedbActivity.this, "test_sqlite_db");

            ContentValues values = new ContentValues();

            values.put("id", 1);

            values.put("name", "LiXiaoLong");

            values.put("password", "12345");

            SQLiteDatabase db = dbHelper.getWritableDatabase();

            db.insert("user", null, values);

        }

    }

     

    /**

     * 更新一条记录

     * @author Owner

     *

     */

    class UpdateListener implements OnClickListener {

 

        @Override

        public void onClick(View v) {

            ContentValues values = new ContentValues();

            values.put("name", "ZhangXiaoLong");

            DatabaseHelper dbHelper = new DatabaseHelper(AndroidsqlitedbActivity.this, "test_sqlite_db");

            SQLiteDatabase db = dbHelper.getWritableDatabase();

            db.update("user", values, "id=?", new String[]{"1"});

        }

         

    }

     

    /**

     * 查询记录

     * @author Owner

     *

     */

    class QueryListener implements OnClickListener {

 

        @Override

        public void onClick(View v) {

            DatabaseHelper dbHelper = new DatabaseHelper(AndroidsqlitedbActivity.this, "test_sqlite_db");

            SQLiteDatabase db = dbHelper.getReadableDatabase();

            Cursor cursor = db.query("user", new String[]{"id","name","password"}, "id=?", new String[]{"1"}, null,null,null);

             

            while(cursor.moveToNext()) {

                String name = cursor.getString(cursor.getColumnIndex("name"));

                String password = cursor.getString(cursor.getColumnIndex("password"));

                System.out.println(" name: " + name + "password: " + password);

            }

         

        }

         

    }

     

    /**

     * 查询一条记录

     * @author Owner

     *

     */

    class DeleteListener implements OnClickListener {

 

        @Override

        public void onClick(View v) {

            DatabaseHelper dbHelper = new DatabaseHelper(AndroidsqlitedbActivity.this, "test_sqlite_db");

            SQLiteDatabase db = dbHelper.getWritableDatabase();

            db.delete("user", "id=?", new String[]{"1"});

        }

         

    }

}













重载了很多方法，总有一个是你想要的。

002  

003  

004package cn.edu.xtu.tilepuzzle.model;

005  

006import cn.edu.xtu.tilepuzzle.GameDB;

007import android.content.ContentValues;

008import android.content.Context;

009import android.database.Cursor;

010import android.database.sqlite.SQLiteDatabase;

011import android.util.Log;

012  

013  

014public class ClassSQLite {

015  

016  

017Context context;// 应用环境上下文 Activity 是其子类

018  

019public ClassSQLite(Context _context) {

020this.context = _context;

021}

022  

023  

024/**

025* 打开数据库

026* 

027* @DBName 数据库名字

028*/

029public SQLiteDatabase openDBByName(String DBName) {

030SQLiteDatabase db;

031//deleteDBByName(DBName);

032db = context.openOrCreateDatabase(DBName, Context.MODE_PRIVATE,null);

033return db;

034}

035  

036/**

037* 删除数据库

038* 

039* @DBName 数据库名字

040*/

041public boolean deleteDBByName(String DBName) {

042context.deleteDatabase(DBName);

043Log.d("DB","had deleted database:" + DBName);

044return false;

045}

046  

047/**

048* 删除数据库中表的数据

049* @DBName 数据库名字

050* @TableName 表名字

051*/

052public boolean deleteTableByDBName(String DBName, String TableName) {

053SQLiteDatabase dbDatabase = openDBByName(DBName);

054dbDatabase.delete(TableName, null, null);

055close(dbDatabase);

056// checkDBByName(DBName);

057// db.delete(table, whereClause,

058// whereArgs).deleteDatabase(GameDB.DATABASE_TILEPUZZLE_NAME);

059Log.d("DB","had deleted table:" + DBName + "->" + TableName);

060return false;

061}

062  

063/**

064* 检查数据库中的表是否存在

065* 

066* @DBName 数据库名字

067* @TableName 表名字

068*/

069public boolean checkTableIsExistByName(String DBName, String TableName) {

070SQLiteDatabase db_ = openDBByName(DBName);

071String sqlString = "";

072if (TableName.equals(GameDB.TABLE_TILEPUZZLE_GAMEDATA)) {

073sqlString = "CREATE TABLE "+ TableName + GameDB.GAMEDATA_STRUCTURE;

074} elseif (TableName.equals(GameDB.TABLE_TILEPUZZLE_PEOPLEINFO)) {

075sqlString = "CREATE TABLE "+ TableName + GameDB.PEOPLEINFO_STRUCTURE;

076} else

077;

078try {

079db_.execSQL(sqlString);

080Log.d("DB","Create Table:" + TableName);

081if (TableName.equals(GameDB.TABLE_TILEPUZZLE_GAMEDATA))

082this.insertDataToTableByTableName(db_, TableName, GameDB.gameSetData);

083return true;

084} catch(Exception e) {

085Log.d("DB", TableName +" is exists.");

086if (TableName.equals(GameDB.TABLE_TILEPUZZLE_GAMEDATA)) {

087Cursor cursor_ = getDataByTableName(db_, TableName);

088if (cursor_ == null || cursor_.getCount() == 0)

089insertDataToTableByTableName(db_, TableName, GameDB.gameSetData);

090}

091} finally{

092close(db_);

093}

094return false;

095}

096  

097/**

098* 该方法已重载 保存数据到数据库的游戏配置参数表中

099* 

100* @DBName 数据库名字

101* @TableName 表名字

102* @gameSetData_ 游戏数据

103* 

104*/

105public boolean insertDataToTableByTableName(SQLiteDatabase db_, String TableName, String[] gameSetData_) {

106String sql = "insert into "+ TableName + " values(";

107int i = 0;

108for (i = 0; i < gameSetData_.length -1; i++)

109sql += "'"+ gameSetData_[i] + "'"+ ",";

110sql += "'"+ gameSetData_[i] + "');";

111Log.d("DB", sql);

112try {

113db_.execSQL(sql);

114Log.d("DB","insert Table ok");

115return true;

116} catch(Exception e) {

117Log.d("DB","insert Table  err: " + sql);

118return false;

119} finally{

120close(db_);

121}

122}

123  

124/**

125* 该方法已重载 保存数据到数据库的游戏玩家表中

126* 

127* @DBName 数据库名字

128* @TableName 表名字

129* @peopleInfo 个人数据

130*/

131public boolean insertDataToTableByTableName(SQLiteDatabase db_, String TableName, String[][] peopleInfo) {

132  

133ContentValues values=newContentValues();

134try {

135for (int i = 0; i < peopleInfo.length; i++) {

136values=newContentValues();

137values.put("NAME", peopleInfo[i][0]);

138values.put("TIME", peopleInfo[i][1]);

139db_.insert(TableName, null, values);

140}

141Log.d("DB","insert Table ok");

142return true;

143} catch(Exception e) {

144Log.d("DB","insert Table  err: ???");

145return false;

146} finally{

147close(db_);

148}

149}

150  

151/**

152* 该方法已重载 保存数据到数据库的玩家信息表中

153* 

154* @DBName 数据库名字

155* @TableName 表名字

156* @peopleName 个人名字

157* @time 游戏用的时间

158*/

159public boolean insertDataToTableByTableName(SQLiteDatabase db_, String TableName, String peopleName,int time) {

160/*String sql = "";

161try {

162sql = "insert into " + TableName + " values('" + peopleName + "'," + time + ")";

163db_.execSQL(sql);

164Log.d("DB", "insert Table ok");

165return true;

166} catch (Exception e) {

167Log.d("DB", "insert Table  err: " + sql);

168return false;

169} finally {

170close(db_);

171}*/

172ContentValues values = new ContentValues();

173try {

174values.put("NAME", peopleName);

175values.put("TIME", time);

176db_.insert(TableName, null, values);

177return true;

178} catch (Exception e) {

179Log.d("DB", "insert Table  err:?? ");

180return false;

181} finally {

182close(db_);

183}

184}

185  

186/**

187* 获取数据库的表中数据

188* @DBName 数据库名字

189* @TableName 表名字

190* @return 返回Cursor

191*/

192public Cursor getDataByTableName(SQLiteDatabase db_, String TableName) {

193// Cursor cursor = db_.query(TableName, null, null, null, null, null, null);

194String sql = "";

195if (TableName.equals(GameDB.TABLE_TILEPUZZLE_GAMEDATA))

196sql = "select * from " + TableName+";";

197else if (TableName.equals(GameDB.TABLE_TILEPUZZLE_PEOPLEINFO))

198sql = "select * from " + TableName + " order by TIME ASC"+";";

199Cursor cursor = db_.rawQuery(sql, null);

200Log.d("DB", "cursor count:"+cursor.getCount());

201int mycount = cursor.getCount();

202close(db_);

203if (mycount == 0)

204return null;

205else

206return cursor;

207}

208  

209/**

210* 更新数据库中的个人信息

211* @DBName 数据库名字

212* @TableName 表名字

213* @peopleName 个人名字

214* @time 游戏用的时间

215*/

216public boolean updateTableByName(String DBName, String TableName, String peopleName, int time) {

217SQLiteDatabase db_ = openDBByName(DBName);

218ContentValues values = new ContentValues();

219values.put("NAME", peopleName);

220values.put("TIME", time);

221db_.update(TableName, values, "NAME='" + peopleName + "'", null);

222close(db_);

223return false;

224}

225  

226/**

227* 更新数据库中的个人信息

228* 

229* @DBName 数据库名字

230* @TableName 表名字

231* @peopleName 个人名字

232* @time 游戏用的时间

233*/

234public boolean updateTableByName(SQLiteDatabase db_, String TableName, String peopleName, int time) {

235ContentValues values = new ContentValues();

236values.put("NAME", peopleName);

237values.put("TIME", time);

238db_.update(TableName, values, "NAME='" + peopleName + "';", null);

239close(db_);

240return false;

241}

242  

243/**

244* 更新数据库中的游戏配置参数

245* 

246* @DBName 数据库名字

247* @TableName 表名字

248* @gameData 游戏参数

249*/

250public boolean updateTableByName(String DBName, String TableName, String gameData[]) {

251SQLiteDatabase db_ = openDBByName(DBName);

252ContentValues values = new ContentValues();

253values.put("orgImageString", gameData[GameDB.IndexInGameSetDatat_orgImageString]);

254values.put("reversed", gameData[GameDB.IndexInGameSetDatat_reversed]);

255values.put("funny", gameData[GameDB.IndexInGameSetDatat_funny]);

256values.put("addString", gameData[GameDB.IndexInGameSetDatat_addString]);

257values.put("hard", gameData[GameDB.IndexInGameSetDatat_hard]);

258values.put("rows", gameData[GameDB.IndexInGameSetDatat_rows]);

259values.put("columns", gameData[GameDB.IndexInGameSetDatat_columns]);

260try {

261db_.update(TableName, values, null, null);

262Log.d("DB", "更新游戏信息成功：" + gameData);

263return true;

264} catch (Exception e) {

265Log.d("DB", "更新游戏信息失败：" + gameData);

266}finally{

267close(db_);

268}

269return false;

270}

271  

272/**

273* 更新数据库中的游戏配置参数

274* 

275* @DBName 数据库名字

276* @TableName 表名字

277* @gameData 游戏参数

278*/

279public boolean updateTableByName(SQLiteDatabase db_, String TableName, String gameData[]) {

280//SQLiteDatabase db_ = openDBByName(DBName);

281ContentValues values = new ContentValues();

282values.put("orgImageString", gameData[GameDB.IndexInGameSetDatat_orgImageString]);

283values.put("reversed", gameData[GameDB.IndexInGameSetDatat_reversed]);

284values.put("funny", gameData[GameDB.IndexInGameSetDatat_funny]);

285values.put("addString", gameData[GameDB.IndexInGameSetDatat_addString]);

286values.put("hard", gameData[GameDB.IndexInGameSetDatat_hard]);

287values.put("rows", gameData[GameDB.IndexInGameSetDatat_rows]);

288values.put("columns", gameData[GameDB.IndexInGameSetDatat_columns]);

289try {

290Log.d("DB", "开始更新游戏信息：" +TableName);

291//db_.delete(TableName, "orgImageString=?", null);

292//db_.execSQL("delete from "+TableName+"where orgImageString != null;");

293//Log.d("DB", "删除表信息成功：" +TableName);

294//db_.insert(TableName, null, values);

295db_.update(TableName, values, null,null);

296Log.d("DB", "更新游戏信息成功->" +TableName+":"+ gameData.toString());

297return true;

298} catch (Exception e) {

299Log.d("DB", "更新游戏信息失败->" +TableName);

300}finally{

301close(db_);

302}

303return false;

304}

305  

306/**

307* 通过用户名查询玩家信息记录

308* @Cursor Cursor

309* @peopleName 玩家名字

310* @return String 指向结果记录的指针，类似于JDBC 的 ResultSet

311*/

312public String[] getPeopleInfoFromCursor(Cursor cursor, String peopleName) {

313int mycount = cursor.getCount();

314if (mycount == 0)

315return null;

316String[] peopleInfo = new String[2];

317// 要利用所有的返回值得，我们需要把指针移到第一行上

318cursor.moveToFirst();

319// 同样，如果你要移动到返回值的某行上，你可以做如下操作

320// cursor.moveToPosition(position);

321int i = 0;

322for (i = 0; i < mycount; i++) {

323if (cursor.getString(1).endsWith(peopleName)) {

324peopleInfo[0] = cursor.getString(0);

325peopleInfo[1] = cursor.getString(1);

326break;

327}

328// 获取某个值myCursor.getString();

329cursor.moveToNext();

330// myCursor.moveToPrevious();

331}

332cursor.close();

333if (i >= mycount)

334return null;

335return peopleInfo;

336}

337  

338/**

339* 获取所有玩家信息

340* @Cursor Cursor

341* @return String[][]

342*/

343public String[][] getPeopleInfoFromCursor(Cursor cursor) {

344int mycount = cursor.getCount();

345if (mycount == 0)

346return null;

347String[][] peopleInfo = new String[mycount][2];

348// 要利用所有的返回值得，我们需要把指针移到第一行上

349cursor.moveToFirst();

350// 同样，如果你要移动到返回值的某行上，你可以做如下操作

351// cursor.moveToPosition(position);

352int i = 0;

353for (i = 0; i < mycount; i++) {

354peopleInfo[i][0] = cursor.getString(cursor.getColumnIndex("NAME"));

355peopleInfo[i][1] = cursor.getString(cursor.getColumnIndex("TIME"));

356// 获取某个值myCursor.getString();

357cursor.moveToNext();

358// myCursor.moveToPrevious();

359}

360cursor.close();

361return peopleInfo;

362}

363  

364/**

365* 获取游戏参数信息

366* @Cursor Cursor

367* @return String[]

368*/

369public String[] getGameDataFromCursor(Cursor cursor) {

370int mycount = cursor.getCount();

371if (mycount == 0)

372return null;

373String[] gameData = new String[GameDB.gameSetData.length];

374// 要利用所有的返回值得，我们需要把指针移到第一行上

375cursor.moveToFirst();

376//"orgImageString", "reversed", "funny", "addStringg", "hard", "rows","columns" 

377int orgImageString = cursor.getColumnIndex(GameDB.gameSetDataName[GameDB.IndexInGameSetDatat_orgImageString]);

378gameData[GameDB.IndexInGameSetDatat_orgImageString]=cursor.getString(orgImageString);

379Log.d("DB", orgImageString+"->orgImageString:"+cursor.getString(orgImageString));

380  

381int reversed = cursor.getColumnIndex(GameDB.gameSetDataName[GameDB.IndexInGameSetDatat_reversed]);

382gameData[GameDB.IndexInGameSetDatat_reversed]=cursor.getString(reversed);

383Log.d("DB", reversed+"->reversed:"+cursor.getString(reversed));

384  

385int funny = cursor.getColumnIndex(GameDB.gameSetDataName[GameDB.IndexInGameSetDatat_funny]);

386gameData[GameDB.IndexInGameSetDatat_funny]=cursor.getString(funny);

387Log.d("DB", funny+"->funny:"+cursor.getString(funny));

388  

389int addString = cursor.getColumnIndex(GameDB.gameSetDataName[GameDB.IndexInGameSetDatat_addString]);

390gameData[GameDB.IndexInGameSetDatat_addString]=cursor.getString(addString);

391Log.d("DB", addString+"->addString:"+cursor.getString(addString));

392  

393int hard = cursor.getColumnIndex(GameDB.gameSetDataName[GameDB.IndexInGameSetDatat_hard]);

394gameData[GameDB.IndexInGameSetDatat_hard]=cursor.getString(hard);

395Log.d("DB", hard+"->hard:"+cursor.getString(hard));

396  

397int rows = cursor.getColumnIndex(GameDB.gameSetDataName[GameDB.IndexInGameSetDatat_rows]);

398gameData[GameDB.IndexInGameSetDatat_rows]=cursor.getString(rows);

399Log.d("DB", rows+"->rows:"+cursor.getString(rows));

400  

401int columns = cursor.getColumnIndex(GameDB.gameSetDataName[GameDB.IndexInGameSetDatat_columns]);

402gameData[GameDB.IndexInGameSetDatat_columns]=cursor.getString(columns);

403Log.d("DB", columns+"->columns:"+cursor.getString(columns));

404  

405cursor.close();

406return gameData;

407}

408  

409/**

410* 删除数据库中表的个人信息

411* @DBName 数据库名字

412* @TableName 表名字

413* @peopleName 个人名字

414*/

415public boolean deletePeopleInfoByPeopleName(String DBName, String TableName, String peopleName) {

416SQLiteDatabase db_ = openDBByName(DBName);

417db_.delete(TableName, "NAME='" + peopleName + "'", null);

418close(db_);

419return false;

420}

421  

422/**

423* 删除数据库中表的个人信息

424* @db_ 数据库

425* @TableName 表名字

426* @peopleName 个人名字

427*/

428public boolean deletePeopleInfoByPeopleName(SQLiteDatabase db_, String TableName, String peopleName) {

429db_.delete(TableName, "NAME='"+ peopleName + "'",null);

430close(db_);

431return false;

432}

433  

434public void close(SQLiteDatabase db_) {

435db_.close();

436}

437  

438public void SqliteTest() {

439  

440Cursor cursor = getDataByTableName(openDBByName(GameDB.DATABASE_TILEPUZZLE_NAME), GameDB.TABLE_TILEPUZZLE_GAMEDATA);

441String gameData[]=getGameDataFromCursor(cursor);

442String resultString="";

443for(inti=0;i<7;i++){

444resultString+=gameData[i]+";";

445}

446Log.d("DB","SqliteTest:查询->TABLE_TILEPUZZLE_GAMEDATA:"+resultString);

447  

448String temp[]=GameDB.gameSetData;

449temp[1]="Y";

450temp[2]="Y";

451temp[3]="Y";

452temp[4]="Y";

453  

454resultString="";

455for(inti=0;i<7;i++)

456resultString+=temp[i]+";";

457Log.d("DB","SqliteTest:更改游戏参数为->TABLE_TILEPUZZLE_GAMEDATA:"+resultString);

458  

459updateTableByName(openDBByName(GameDB.DATABASE_TILEPUZZLE_NAME), GameDB.TABLE_TILEPUZZLE_GAMEDATA, temp);

460cursor = getDataByTableName(openDBByName(GameDB.DATABASE_TILEPUZZLE_NAME), GameDB.TABLE_TILEPUZZLE_GAMEDATA);

461gameData=getGameDataFromCursor(cursor);

462resultString="";

463for(inti=0;i<7;i++){

464resultString+=gameData[i]+";";

465}

466Log.d("DB","SqliteTest:更新后->TABLE_TILEPUZZLE_GAMEDATA:"+resultString);

467  

468//Log.d("DB", "SqliteTest:删除后->TABLE_TILEPUZZLE_GAMEDATA:"+resultString);

469  

470String tempP[][]=newString[2][2];

471tempP[0][0]="LIUYAOHUA";

472tempP[0][1]="100";

473tempP[1][0]="DAIQING";

474tempP[1][1]="500";

475insertDataToTableByTableName(openDBByName(GameDB.DATABASE_TILEPUZZLE_NAME), GameDB.TABLE_TILEPUZZLE_PEOPLEINFO, tempP);

476Log.d("DB","SqliteTest:插入->TABLE_TILEPUZZLE_PEOPLEINFO:"+tempP);

477  

478cursor = getDataByTableName(openDBByName(GameDB.DATABASE_TILEPUZZLE_NAME), GameDB.TABLE_TILEPUZZLE_PEOPLEINFO);

479String peopleInfo[][]=getPeopleInfoFromCursor(cursor);

480for(inti=0;i<peopleInfo.length;i++){

481Log.d("DB","SqliteTest:查询->TABLE_TILEPUZZLE_PEOPLEINFO:"+peopleInfo[i][0]+" : "+peopleInfo[i][1]);

482}

483  

484updateTableByName(openDBByName(GameDB.DATABASE_TILEPUZZLE_NAME), GameDB.TABLE_TILEPUZZLE_PEOPLEINFO,"LIUYAOHUA", 50);

485updateTableByName(openDBByName(GameDB.DATABASE_TILEPUZZLE_NAME), GameDB.TABLE_TILEPUZZLE_PEOPLEINFO,"DAIQING", 50);

486Cursor cursorUP = getDataByTableName(openDBByName(GameDB.DATABASE_TILEPUZZLE_NAME), GameDB.TABLE_TILEPUZZLE_PEOPLEINFO);

487String peopleInfoUP[][]=getPeopleInfoFromCursor(cursorUP);

488for(inti=0;i<peopleInfoUP.length;i++){

489Log.d("DB","SqliteTest:更新后->TABLE_TILEPUZZLE_PEOPLEINFO:"+peopleInfoUP[i][0]+" : "+peopleInfoUP[i][1]);

490}

491  

492deletePeopleInfoByPeopleName(openDBByName(GameDB.DATABASE_TILEPUZZLE_NAME), GameDB.TABLE_TILEPUZZLE_PEOPLEINFO,"DAIQING");

493Cursor cursorD = getDataByTableName(openDBByName(GameDB.DATABASE_TILEPUZZLE_NAME), GameDB.TABLE_TILEPUZZLE_PEOPLEINFO);

494String peopleInfoD[][]=getPeopleInfoFromCursor(cursorD);

495for(inti=0;i<peopleInfoD.length;i++){

496Log.d("DB","SqliteTest:删除后->TABLE_TILEPUZZLE_PEOPLEINFO:"+peopleInfoD[i][0]+" : "+peopleInfoD[i][1]);

497}

498  

499insertDataToTableByTableName(openDBByName(GameDB.DATABASE_TILEPUZZLE_NAME), GameDB.TABLE_TILEPUZZLE_PEOPLEINFO,"DAIQING",100);

500cursor = getDataByTableName(openDBByName(GameDB.DATABASE_TILEPUZZLE_NAME), GameDB.TABLE_TILEPUZZLE_PEOPLEINFO);

501peopleInfo=getPeopleInfoFromCursor(cursor);

502for(inti=0;i<peopleInfo.length;i++){

503Log.d("DB","SqliteTest:删除再次增加用户信息查询->TABLE_TILEPUZZLE_PEOPLEINFO:"+peopleInfo[i][0]+" : "+peopleInfo[i][1]);

504}

505  

506}

507  

508}