Java SQLiteConstraintException.printStackTrace方法代码示例

import android.database.sqlite.SQLiteConstraintException; //导入方法依赖的package包/类
public boolean insertAchievementExplorer(final Context preferenceContext, String email, int idAchievement) {
    try{
        setAction(false);
        AchievementExplorerRequest achievementExplorerRequest = new AchievementExplorerRequest(email, idAchievement);
        achievementExplorerRequest.requestUpdateAchievements(preferenceContext, new AchievementExplorerRequest.Callback() {
            @Override
            public void callbackResponse(boolean response) {
                setResponse(true);
                setAction(true);
            }

            @Override
            public void callbackResponse(List<Achievement> achievements) {}
        });
    }catch(SQLiteConstraintException exception){
        exception.printStackTrace();
    }

    return true;
}
 

import android.database.sqlite.SQLiteConstraintException; //导入方法依赖的package包/类
public boolean insertManga(Manga manga) {
    SQLiteDatabase db = this.getWritableDatabase();
    ContentValues contentValues = new ContentValues();

    contentValues.put(TABLE_MANGA_NAME, manga.getName());
    contentValues.put(TABLE_MANGA_URL, manga.getUrl());
    contentValues.put(TABLE_MANGA_IMAGE, manga.getImage());
    contentValues.put(TABLE_MANGA_LATEST, manga.getLatest());
    try {
        db.insertOrThrow(TABLE_MANGA, null, contentValues);
    } catch (SQLiteConstraintException e) {
        e.printStackTrace();
        System.out.println("Failed to insert");
        return false;
    }
    System.out.println("inserted");
    return true;
}
 

import android.database.sqlite.SQLiteConstraintException; //导入方法依赖的package包/类
public boolean insertRecentChapter(Manga manga, Chapter chapter) {
    SQLiteDatabase db = this.getWritableDatabase();
    deleteRecentChapter(manga.getName());

    ContentValues contentValues = new ContentValues();
    contentValues.put(TABLE_RECENT_MANGA_NAME, manga.getName());
    contentValues.put(TABLE_RECENT_MANGA_IMAGE, manga.getImage());
    contentValues.put(TABLE_RECENT_MANGA_URL, manga.getUrl());
    contentValues.put(TABLE_RECENT_CHAPTER_NAME, chapter.getName());
    contentValues.put(TABLE_RECENT_CHAPTER_URL, chapter.getUrl());

    try {
        db.insertOrThrow(TABLE_RECENT, null, contentValues);
    } catch (SQLiteConstraintException e) {
        e.printStackTrace();
        System.out.println("recent not inserted");
        return false;
    }
    System.out.println("recent inserted");
    return true;
}
 

import android.database.sqlite.SQLiteConstraintException; //导入方法依赖的package包/类
public void insert(CustomRules rule)
{
    try
    {
        rulesDao.insert(rule);
    }
    catch (SQLiteConstraintException ex)
    {
        ex.printStackTrace();
    }
}
 

import android.database.sqlite.SQLiteConstraintException; //导入方法依赖的package包/类
public void insertOrUpdate(CustomRules rule)
{
    try
    {
        rulesDao.insertOrReplace(rule);
    }
    catch (SQLiteConstraintException ex)
    {
        ex.printStackTrace();
    }
}
 

import android.database.sqlite.SQLiteConstraintException; //导入方法依赖的package包/类
public boolean deleteMyCamera(MyCameraInfo myCamera) {
    try {
        mDatabase.execSQL("DELETE FROM MyCamera WHERE IP=? AND PORT=?", new String[]{myCamera.getIP(), myCamera.getPort() + ""});
        return true;
    } catch (SQLiteConstraintException e) {
        e.printStackTrace();
    }
    return false;
}
 

import android.database.sqlite.SQLiteConstraintException; //导入方法依赖的package包/类
public boolean saveMyCamera(MyCameraInfo myCameraInfo) {
    try {
        mDatabase.execSQL("INSERT INTO MyCamera(IP,PORT,PASSWORD,NOTE,DEVICE_ID,CAM_NUMBER,TYPE) VALUES (?,?,?,?,?,?,?)",
                new String[]{myCameraInfo.getIP(), myCameraInfo.getPort() + "", myCameraInfo.getPassword(), myCameraInfo.getNote(),
                        myCameraInfo.getDeviceId(), myCameraInfo.getCamNumber() + "", myCameraInfo.getType() + ""});
        return true;
    } catch (SQLiteConstraintException e) {
        e.printStackTrace();
    }
    return false;
}
 

import android.database.sqlite.SQLiteConstraintException; //导入方法依赖的package包/类
public boolean updateMyCamera(String oldIP, int oldPort, MyCameraInfo myCameraInfo) {
    try {
        mDatabase.execSQL("UPDATE MyCamera SET IP=?,PORT=?,PASSWORD=?,NOTE=?,DEVICE_ID=?,CAM_NUMBER=?,TYPE=? WHERE IP=? AND PORT=?", new String[]{
                myCameraInfo.getIP(), myCameraInfo.getPort() + "", myCameraInfo.getPassword(), myCameraInfo.getNote(), myCameraInfo.getDeviceId(), myCameraInfo.getCamNumber() + "", myCameraInfo.getType() + "",
                oldIP, oldPort + ""
        });
        return true;
    } catch (SQLiteConstraintException e) {
        e.printStackTrace();
    }
    return false;
}
 

import android.database.sqlite.SQLiteConstraintException; //导入方法依赖的package包/类
@Override
protected Void doInBackground(Void... params) {
    String sql = "INSERT INTO " + TB_USER_SEX + " VALUES(\"" + userId + "\", " + sex
            + ")";
    try {
        db.execSQL(sql);
    } catch (SQLiteConstraintException e) {
        e.printStackTrace();
    }
    db.close();
    return null;
}