Java Report.getSql方法代码示例

import ro.nextreports.engine.Report; //导入方法依赖的package包/类
protected String getSql(Report report) {
    String sql;
    if (report == null) {
        sql = queryArea.getText();
    } else {
        if (report.getSql() != null) {
            sql = report.getSql();
        } else {
        	try {
        		for (Column col : report.getQuery().getColumns()) {            		
		col.getTable().setDialect(DialectUtil.getDialect(Globals.getConnection()));					
        		}
        	} catch (Exception e) {					
	e.printStackTrace();
	LOG.error(e.getMessage(), e);
}
            sql = report.getQuery().toString();
        }
    }
    if (sql.equals("") || sql.equals(DEFAULT_QUERY)) {
        return null;
    }
    return sql;
}
 

import ro.nextreports.engine.Report; //导入方法依赖的package包/类
public static List<NameType> getAllColumnsForReport(Report report, DataSource ds) throws Exception {

        String sql;
        if (report == null) {
            QueryBuilderPanel builderPanel = Globals.getMainFrame().getQueryBuilderPanel();
            builderPanel.refreshSql();
            sql = builderPanel.getUserSql();
        } else {
            if (report.getSql() != null) {
                sql = report.getSql();
            } else {
                sql = report.getQuery().toString();
            }
        }
        return getAllColumnsForSql(report, sql, ds);
    }
 

import ro.nextreports.engine.Report; //导入方法依赖的package包/类
public static List<String> getAllColumnNamesForReport(Report report, DataSource ds) throws Exception {

        String sql;
        if (report == null) {
            QueryBuilderPanel builderPanel = Globals.getMainFrame().getQueryBuilderPanel();            
            builderPanel.refreshSql();
            sql = builderPanel.getUserSql();            
        } else {
            if (report.getSql() != null) {
                sql = report.getSql();
            } else {
                sql = report.getQuery().toString();
            }
        }
        return getAllColumnNamesForSql(report, sql, ds);
    }
 

import ro.nextreports.engine.Report; //导入方法依赖的package包/类
/**
 * Test if all parameters used in the report are defined
 *
 * @param report report object
 * @throws ParameterNotFoundException if a parameter used in the report is not defined
 */
public void parametersAreDefined(Report report) throws ParameterNotFoundException {
    String[] paramNames;
    String sql = report.getSql();
    if (sql == null) {
        sql = report.getQuery().toString();
    }
    Query query = new Query(sql);
    paramNames = query.getParameterNames();

    List<QueryParameter> parameters = report.getParameters();

    for (String paramName : paramNames) {
        QueryParameter param = null;
        for (QueryParameter p : parameters) {
            if (paramName.equals(p.getName())) {
                param = p;
            }
        }
        if (param == null) {
            throw new ParameterNotFoundException(paramName);
        }
    }
}
 

import ro.nextreports.engine.Report; //导入方法依赖的package包/类
public static String getSql(Report report) {
    String sql;
    if (report.getSql() != null) {
        sql = report.getSql();
    } else {
        sql = report.getQuery().toString();
    }
    return sql;
}
 

import ro.nextreports.engine.Report; //导入方法依赖的package包/类
/**
 * Get sql string from report object
 * 
 * @param report
 *            report
 * @return sql string from report object
 */
public static String getSql(Report report) {
	String sql;
	if (report.getSql() != null) {
		sql = report.getSql();
	} else {
		sql = report.getQuery().toString();
	}
	return sql;
}
 

import ro.nextreports.engine.Report; //导入方法依赖的package包/类
private static Map<String, QueryParameter> getUsedParametersMap(Report report, boolean withHidden, boolean onlyHidden) {  
 	if (report == null) {
 		return new HashMap<String, QueryParameter>();
 	}
     String sql = report.getSql();
     if (sql == null) {
         sql = report.getQuery().toString();
     }
     Query query = new Query(sql);

     String[] paramNames = query.getParameterNames();
     LinkedHashMap<String, QueryParameter> params = new LinkedHashMap<String, QueryParameter>();
     for (QueryParameter qp : report.getParameters()) {
         String name = qp.getName();
         boolean found = false;
         for (String pName : paramNames) {
             if (pName.equals(name)) {
             	if (onlyHidden) {
             		if (qp.isHidden()) {
             			found = true;
             			break;
             		}
             	} else if (!qp.isHidden() || (qp.isHidden() && withHidden)) {
                     found = true;
                     break;
                 }
             }
         }
         // parameter is not used inside query but it is used inside other parameter
         if (!found) {
         	if (getChildDependentParameters(report, qp).size() > 0) {
         		found = true;            	
         	} 
         }
         
         if (onlyHidden) {
         	if  (found) {
         		params.put(name, qp);
         	}
} else {
	if (found || (qp.isHidden() && withHidden)) {
		params.put(name, qp);
	}
}
     }
     return params;
 }