sujinwen

2017-07-21 9f86ecd1435f386b778538df5eb0d769c3171db0

 VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/PhoneCallDao.java

@@ -1,5 +1,6 @@
package cn.com.basic.face.service.sqlite;



import android.content.ContentValues;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;



@@ -81,9 +82,6 @@
            e.printStackTrace();

        } finally {

            db.endTransaction();

            if(db != null && db.isOpen()){

                db.close();

            }

        }

        return resultBean;

    }

@@ -99,22 +97,17 @@
        try {

            StringBuilder sb = new StringBuilder(40);

            SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

            sb.append("insert into phone_call (date,caller_id,callee_id,device_id) values (")

                    .append(sdf.format(new Date()))

                    .append(" , ").append(visitor.getRegisterId()).append(" , ")

                    .append(interviewee.getRegisterId())

                    .append(" , ")

                    .append(BaseApplication.getInstance().getAndroidDevice().getDeviceId())

                    .append(")");

            db.rawQuery(sb.toString(),new String[]{});

            ContentValues cv = new ContentValues();

            cv.put("date",sdf.format(new Date()));

            cv.put("caller_id",visitor.getRegisterId());

            cv.put("callee_id",interviewee.getRegisterId());

            cv.put("device_id",BaseApplication.getInstance().getAndroidDevice().getDeviceId());

            db.insert("phone_call",null,cv);

            db.setTransactionSuccessful();

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            db.endTransaction();

            if(db != null && db.isOpen()){

                db.close();

            }

        }

    }