DB related: backup, restore, quary, update

1. On common layer,  define DBRestoreUtils, and DBUtils

2.  On page layer, use above

    public void backUpDemo() throws Exception{
        Connection cn = DBUtils.getConnection("oracle_");
        String backUpID = DBRestoreUtils.backup(cn,
            "query SQL");
        
        LocalContext.put(backUpName, backUpID);
    }



    public void restoreDB(String backUpName) throws Exception {
        Connection cn = DBUtils.getConnection("oracle_");
        cn.setAutoCommit(true);
        String backupID = (String)LocalContext.get(backUpName);
        DBRestoreUtils.restore(cn, backupID);
        DBRestoreUtils.deleteBackup(backupID);      
    }


    public void updateLastMonthRating( throws Exception{
        Connection cn = DBUtils.getConnection("oracle_");
        cn.setAutoCommit(true);
        DBUtils.update(cn, "update SQL");
        DBUtils.close(cn);
    }


    public String getText(String text) throws Exception{
       Connection cn = DBUtils.getConnection("oracle_");
        
        List<Map<String, String>> record = DBUtils.query(cn,"select purp_txt AS TEXT from tableName where xxxx");
        String txt = null;
        for (Map<String, String> row : record) {
            txt = row.get("TEXT ");
            log.info("TEXT: " + txt);
        }
        DBUtils.close(cn);
        
        return txt;
    }