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(); // 结束事务
}
}
