public static void main(String[] args) {

    SqlMapClient sqlMapClient = SqlConfig.getAtSqlMapInstance();
    try {
      sqlMapClient.startTransaction();
      ProviderAccountDao dao = new ProviderAccountDao(sqlMapClient);
      //			update for delete
      ProviderAccount oldAccount = new ProviderAccount();
      oldAccount.setTxnId("54321");
      oldAccount.setDeleted(1L);
      oldAccount.setUpdatedBy("test");
      oldAccount.setUpdatedDate(new Date());
      dao.updateDeleted(oldAccount);
      //			insert new record
      sqlMapClient.commitTransaction();
    } catch (Exception e) {
      try {
        sqlMapClient.endTransaction();
      } catch (SQLException e1) {

      }
    }
  }
 public ReservedTelcoDao() {
   sqlMapClient = SqlConfig.getAtSqlMapInstance();
 }
 public SimTransactionDao() {
   sqlMapClient = SqlConfig.getAtSqlMapInstance();
 }
 public ProviderAccountDao() {
   sqlMapClient = SqlConfig.getAtSqlMapInstance();
 }