Package dev.frostlake.executor.procedural

Class Cursor

java.lang.Object

dev.frostlake.executor.procedural.Cursor

public class Cursor
extends Object

Represents a cursor for iterating through query results in stored procedures

Constructor Summary

Constructors

Constructor	Description
Cursor(String name, String selectQuery)
Cursor(String name, String selectQuery, String resultSetVariableName)

Method Summary

Modifier and Type	Method	Description
void	close()
Row	fetch()
int	getCurrentPosition()
String	getName()
ResultSet	getResultSet()
String	getResultSetVariableName()	The RESULTSET variable this cursor iterates, or null when it is declared over a SELECT query.
String	getSelectQuery()
boolean	hasNext()
boolean	isOpen()
void	open(ResultSet resultSet)
boolean	wasEverOpened()	True once this cursor has been opened at least once, however it was later closed.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

Cursor

public Cursor(String name,
 String selectQuery)

Cursor

public Cursor(String name,
 String selectQuery,
 String resultSetVariableName)

Method Details

getName

public String getName()

getSelectQuery

public String getSelectQuery()

getResultSetVariableName

public String getResultSetVariableName()

The RESULTSET variable this cursor iterates, or null when it is declared over a SELECT query.

open

public void open(ResultSet resultSet)

wasEverOpened

public boolean wasEverOpened()

True once this cursor has been opened at least once, however it was later closed.

fetch

public Row fetch()

close

public void close()

isOpen

public boolean isOpen()

hasNext

public boolean hasNext()

getCurrentPosition

public int getCurrentPosition()

getResultSet

public ResultSet getResultSet()