Example usage for javax.servlet.jsp.jstl.sql ResultSupport toResult

Introduction

In this page you can find the example usage for javax.servlet.jsp.jstl.sql ResultSupport toResult.

Prototype

public static Result toResult(ResultSet rs) 

Source Link

Document

Converts a ResultSet object to a Result object.

Usage

From source file:org.rti.zcore.dar.utils.DatabaseUtils.java

/**
 * Runs sql query and returns Result - see jstl docs on how to process Result.
 *
 * @param conn/* w  ww  .j  a  va  2 s  .  co m*/
 * @param sql
 * @return Result
 * @throws ServletException
 */
public static Result executeQuery(Connection conn, String sql) throws Exception {

    ResultSet rs = null;
    Result results = null;
    try {
        Statement s = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
        rs = s.executeQuery(sql);
        results = ResultSupport.toResult(rs);
        rs.close();
    } catch (Exception ex) {
        log.info("Sql: " + sql);
        log.error(ex);
        throw new ServletException("Cannot retrieve results:", ex);
    }
    return results;
}

---