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;
}