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:
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);
%>