public void add(List<Shopping> columns) { db.beginTransaction(); // 开始事务 /** 数据库SQL语句 添加一个表 * */ String Happy = "create table Happy (" + "_id INTEGER PRIMARY KEY AUTOINCREMENT," + "id TEXT," + "name TEXT," + "logo TEXT," + "xpoint TEXT," + "ypoint TEXT," + "api_address TEXT," + "mzeatvip TEXT," + "avg_point TEXT," + "tel TEXT," + "Characteristic TEXT," + "open_time TEXT," + "comment_count TEXT," + "brand_id TEXT," + "distance TEXT," + "mobile_brief TEXT" + ");"; db.execSQL("DROP TABLE IF EXISTS Happy"); db.execSQL(Happy); try { for (Shopping column : columns) { db.execSQL( "INSERT INTO Happy VALUES(null, ?, ?, ?,?,?,?,?,?,?,?,?,?,?,?,?)", new Object[] { column.getId(), column.getName(), column.getLogo(), column.getXpoint(), column.getYpoint(), column.getApi_address(), column.getMzeatvip(), column.getAvg_point(), column.getTel(), column.getCharacteristic(), column.getOpen_time(), column.getComment_count(), column.getBrand_id(), column.getDistance(), column.getMobile_brief() }); } db.setTransactionSuccessful(); // 设置事务成功完成 } finally { db.endTransaction(); // 结束事务 } }