添加方法更改

dupengyue

2017-07-20 8135e09544d1c9e57a76f79390abad0d48b5a13f

添加方法更改

git-svn-id: http://192.168.1.226/svn/proxy@777 454eff88-639b-444f-9e54-f578c98de674

 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();

            }

        }

    }