=expression

Description:

Execute a statement through esProc JDBC and return the result set.

Syntax:

=expression

Note:

This statement works similarly to an expression in the esProc calculation cell. The Statement can be generated by directly using con.createStatement(). Use st.executeQuery() to execute the statement directly, and return the result set. If the statement contains the tab/enter separator, a cellset will be dynamically generated for executing it. Notice that the expression must start with an equal sign. If there are parameters in the statement, they always start with arg.

Parameter:

expression

SQL statement or expression. If there are multiple expressions in the bracket, the expressions will be computed one by one and the value of the last expression will be returned, for example: (arg1=1,arg2=2,arg1+arg2), the return value is 3

Return value:

Result set

Example:

public void testDataServer() {

Connection con = null;

java.sql.PreparedStatement st;

java.sql.Statement st2;

try{

Class.forName("com.esproc.jdbc.InternalDriver");

con=DriverManager.getConnection("jdbc:esproc:local://"); 

// Call the stored procedure

st=con.prepareCall("call test(3)");

// Execute statement directly, return result set

ResultSet set = st.executeQuery("=(arg=3,arg+3)");

// Print results

printRs(set);

// Create Statement directly

st2=con.createStatement(); 

ResultSet set2 = st2.executeQuery("=(arg=3,arg+4)");

printRs(set2);

// If the statement contains the tab/enter separator, a cellset will be dynamically generated for executing it

ResultSet b =st2.executeQuery("==null\nfor 1,11,5\n\t>A1=A1+A2");

printRs(b);

}

catch(Exception e){

System.out.println(e);

}

finally{

// Close the connection

if (con!=null) {

try {

con.close();

}

catch(Exception e) {

System.out.println(e);

}

}

}

}