本文整理汇总了Java中org.hsqldb.jdbc.JDBCResultSet类的典型用法代码示例。如果您正苦于以下问题：Java JDBCResultSet类的具体用法？Java JDBCResultSet怎么用？Java JDBCResultSet使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
JDBCResultSet类属于org.hsqldb.jdbc包，在下文中一共展示了JDBCResultSet类的7个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: getCustomResult
import org.hsqldb.jdbc.JDBCResultSet; //导入依赖的package包/类
public static ResultSet getCustomResult(Connection connection, long start,
long end) throws SQLException {
Result result = newTwoColumnResult();
if (end < start) {
long temp = start;
start = end;
end = temp;
}
if (end > 1000) {
throw org.hsqldb.jdbc.JDBCUtil.invalidArgument(
"value larger than 100");
}
if (end > start + 100) {
end = start + 100;
}
for (long i = start; i < end; i++) {
Object[] row = new Object[2];
row[0] = Long.valueOf(i);
row[1] = new BinaryData(BigInteger.valueOf(i).toByteArray(),
false);
result.navigator.add(row);
}
result.navigator.reset();
return new JDBCResultSet((JDBCConnection) connection, null, result,
result.metaData);
}
示例2: convertArgsToSQL
import org.hsqldb.jdbc.JDBCResultSet; //导入依赖的package包/类
void convertArgsToSQL(Session session, Object[] callArguments,
Object[] data) {
int extraArg = javaMethodWithConnection ? 1
: 0;
Type[] types = getParameterTypes();
int i = 0;
for (; i < types.length; i++) {
Object value = data[i + extraArg];
ColumnSchema param = getParameter(i);
if (param.parameterMode != SchemaObject.ParameterModes.PARAM_IN) {
value = java.lang.reflect.Array.get(value, 0);
}
callArguments[i] = types[i].convertJavaToSQL(session, value);
}
Result head = null;
for (; i + extraArg < data.length; i++) {
ResultSet rs = ((ResultSet[]) data[i + extraArg])[0];
if (rs != null) {
if (rs instanceof JDBCResultSet) {
Result r = ((JDBCResultSet) rs).result;
if (head == null) {
callArguments[i] = r;
head = r;
} else {
head.addChainedResult(r);
}
} else {
Error.error(ErrorCode.X_46000, "ResultSet not native");
}
}
}
}
示例3: convertArgsToSQL
import org.hsqldb.jdbc.JDBCResultSet; //导入依赖的package包/类
void convertArgsToSQL(Session session, Object[] callArguments,
Object[] data) {
int extraArg = javaMethodWithConnection ? 1
: 0;
Type[] types = getParameterTypes();
int i = 0;
for (; i < types.length; i++) {
Object value = data[i + extraArg];
ColumnSchema param = getParameter(i);
if (param.parameterMode != SchemaObject.ParameterModes.PARAM_IN) {
value = java.lang.reflect.Array.get(value, 0);
}
callArguments[i] = types[i].convertJavaToSQL(session, value);
}
Result head = null;
for (; i + extraArg < data.length; i++) {
ResultSet rs = ((ResultSet[]) data[i + extraArg])[0];
if (rs != null) {
if (rs instanceof JDBCResultSet) {
Result r = ((JDBCResultSet) rs).result;
if (head == null) {
callArguments[i] = r;
head = r;
} else {
head.addChainedResult(r);
}
} else {
Error.error(ErrorCode.X_46000, "ResultSet not native");
}
}
}
}
示例4: getCustomResult
import org.hsqldb.jdbc.JDBCResultSet; //导入依赖的package包/类
public static ResultSet getCustomResult(Connection connection, long start,
long end) throws SQLException {
Result result = newTwoColumnResult();
if (end < start) {
long temp = start;
start = end;
end = temp;
}
if (end > 1000) {
throw org.hsqldb.jdbc.Util.invalidArgument(
"value larger than 100");
}
if (end > start + 100) {
end = start + 100;
}
for (long i = start; i < end; i++) {
Object[] row = new Object[2];
row[0] = Long.valueOf(i);
row[1] = new BinaryData(BigInteger.valueOf(i).toByteArray(),
false);
result.navigator.add(row);
}
result.navigator.reset();
return new JDBCResultSet((JDBCConnection) connection, null, result,
result.metaData);
}
示例5: getObject
import org.hsqldb.jdbc.JDBCResultSet; //导入依赖的package包/类
public <T> T getObject(int columnIndex, Class<T> type) throws SQLException {
try {
return ((JDBCResultSet)wrapped).getObject( columnIndex, type);
} catch (SQLException e) {
throw new UcanaccessSQLException(e);
}
}
示例6: convertArgsToSQL
import org.hsqldb.jdbc.JDBCResultSet; //导入依赖的package包/类
void convertArgsToSQL(Session session, Object[] callArguments,
Object[] data) {
int extraArg = javaMethodWithConnection ? 1
: 0;
Type[] types = getParameterTypes();
int i = 0;
for (; i < types.length; i++) {
Object value = data[i + extraArg];
ColumnSchema param = getParameter(i);
if (param.parameterMode != SchemaObject.ParameterModes.PARAM_IN) {
value = java.lang.reflect.Array.get(value, 0);
}
callArguments[i] = types[i].convertJavaToSQL(session, value);
}
Result head = null;
for (; i + extraArg < data.length; i++) {
ResultSet rs = ((ResultSet[]) data[i + extraArg])[0];
if (rs != null) {
if (rs instanceof JDBCResultSet) {
Result r = ((JDBCResultSet) rs).result;
if (head == null) {
callArguments[i] = r;
head = r;
} else {
head.addChainedResult(r);
}
} else {
throw Error.error(ErrorCode.X_46000,
"ResultSet not native");
}
}
}
}
示例7: testExecutionException
import org.hsqldb.jdbc.JDBCResultSet; //导入依赖的package包/类
@Test
public void testExecutionException(@Mocked final JDBCDatabaseMetaData meta,
@Mocked final JDBCResultSet resultSet) throws Throwable {
new Expectations() {
{
// prevent calls to functions that also call resultSet.next
meta.getDatabaseProductName(); result = "hsqldb";
// prevent calls to functions that also call resultSet.next
meta.getDatabaseProductVersion(); result = "1.0";
// Generate an exception on a call to resultSet.next
resultSet.next(); result = new SQLException("Generated Exception.");
}
};
SqlLine sqlLine = new SqlLine();
ByteArrayOutputStream os = new ByteArrayOutputStream();
PrintStream sqllineOutputStream = new PrintStream(os);
sqlLine.setOutputStream(sqllineOutputStream);
sqlLine.setErrorStream(sqllineOutputStream);
String[] args = {
"-d",
"org.hsqldb.jdbcDriver",
"-u",
"jdbc:hsqldb:res:scott",
"-n",
"SCOTT",
"-p",
"TIGER"
};
DispatchCallback callback = new DispatchCallback();
sqlLine.initArgs(args, callback);
// If sqlline is not initialized, handleSQLException will print
// the entire stack trace.
// To prevent that, forcibly set init to true.
Deencapsulation.setField(sqlLine, "initComplete", true);
sqlLine.getConnection();
sqlLine.runCommands(
Arrays.asList("CREATE TABLE rsTest ( a int);",
"insert into rsTest values (1);",
"insert into rsTest values (2);",
"select a from rsTest; "),
callback);
String output = os.toString("UTF8");
assertThat(output, containsString("Generated Exception"));
}