public void gen() {

    try {

      Template conftempalte = VelocityUtil.getTemplate("/gencode/conf/paginesql.vm");
      VelocityContext context = new VelocityContext();

      context.put("conditions", gencodeService.getConditions());
      context.put("sorts", gencodeService.getSortFields());
      context.put("needsort", gencodeService.needsort());
      context.put("tableName", gencodeService.getModuleMetaInfo().getTableName());
      if (gencodeService.isPagineWithDBRownumberOver()) {
        if (sql.getOptype() == Constant.listquery) {
          context.put("pagineWithDBRownumberOver", false);
          context.put("pagineOrderBy", false);
        } else if (sql.getOptype() == Constant.pagineOrderBy) {
          context.put("pagineWithDBRownumberOver", true);
          context.put("pagineOrderBy", true);

        } else if (sql.getOptype() == Constant.paginequery) {
          context.put("pagineWithDBRownumberOver", true);
          context.put("pagineOrderBy", false);
        }
      } else {
        context.put("pagineWithDBRownumberOver", false);
      }
      sql.setSql(
          gencodeService.writetostring(
              context, conftempalte, gencodeService.getModuleMetaInfo().getEncodecharset()));

    } catch (Exception e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
  }