xuxiuxi

2017-08-03 29ea37292f8d9476903c603ba83c4e40afa9f7f3

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
package cn.com.basic.face.util; 
 
import android.database.sqlite.SQLiteConstraintException; 
 
import java.util.List; 
 
import cn.com.basic.face.base.MainActivity; 
import cn.com.basic.face.discern.common.SqliteSqlBean; 
 
public class SqliteSqlUtil { 
 
    public static void insert(List<SqliteSqlBean> sqliteSqlBeenList) { 
        if (sqliteSqlBeenList == null) { 
            return; 
        } 
        SqliteSqlBean sqliteSqlBean = null; 
        for (int i = 0; i < sqliteSqlBeenList.size(); i++) { 
            try { 
                sqliteSqlBean = sqliteSqlBeenList.get(i); 
                System.out.println(sqliteSqlBean.getInsertSql()); 
                MainActivity.getInstance().db.execSQL(sqliteSqlBean.getInsertSql()); 
 
            } catch (Exception e) { 
                if (e instanceof SQLiteConstraintException) { 
                    System.out.println(e.getMessage()); 
                    return; 
                } 
                if (sqliteSqlBean != null) { 
                    String sql = sqliteSqlBean.getInsertSql(); 
                } 
                e.printStackTrace(); 
            } 
        } 
    } 
 
}