Tow different ways of accessing Datasource in Alphablox

There are two ways to access data source in Alphablox,  first one, working directly with sql statement, second one, working with java.sql.ResultSet. Here is an example:

The following java code has two functions:
1). Set connection with database and return ResultSet
2). Return Sql Statement which will be executed by Alphablox Server

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import com.alphablox.blox.data.rdb.JDBCConnection;

public class SQLSets {
   
    private String datasource = "basis";
   
    public ResultSet getSpectator(String team) throws Exception {
        String mysql = getSpectatorSql(team);
        PreparedStatement prepstm = null;
        Connection conn;
       
        JDBCConnection jdbcConn = new  JDBCConnection();
        jdbcConn.setDataSourceName(datasource);
        conn = jdbcConn.createConnection();
       
        prepstm = conn.prepareStatement(mysql);
        ResultSet resSet = prepstm.executeQuery();
       
        return resSet;
    }
   
    public String getSpectatorSql(String team){
       
         String mysql = "select .. from .. where.. ";
         return mysql;
    }
}



On the following JSP Page, two ways of accessing data source will be presented:

<%

      String team = "ABC";

      SQLSets sqlSets= new SQLSets();

      ResultSet set = sqlSets.getSpectator(team);

      String sql=sqlSets.getSpectatorSql(team);

%>

// 1. Alphablox works directly with sql statement: 

<blox:grid id="myGrid">

  <blox:data

    dataSourceName="basis"

    query= "<%=sql%>"/>

</blox:grid>

// 2. Alphablox works with Result Set:

<blox:data id="mydata"/>

<blox:resultSet id="res" dataBlox="<%=mydata%>" />

<blox:grid id="MyGrid2">

    <blox:data bloxRef="mydata" />

</blox:grid>

<%

  res.loadResultSet(set);

%>