• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    公众号

Java JDBCResultSet类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了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);
}
 
开发者ID:tiweGH,项目名称:OpenDiabetes,代码行数:37,代码来源:TestJavaFunctions.java


示例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");
            }
        }
    }
}
 
开发者ID:Julien35,项目名称:dev-courses,代码行数:41,代码来源:Routine.java


示例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");
            }
        }
    }
}
 
开发者ID:RabadanLab,项目名称:Pegasus,代码行数:40,代码来源:Routine.java


示例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);
}
 
开发者ID:RabadanLab,项目名称:Pegasus,代码行数:37,代码来源:TestJavaFunctions.java


示例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);
	}
}
 
开发者ID:andrew-nguyen,项目名称:ucanaccess,代码行数:8,代码来源:UcanaccessResultSet.java


示例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");
            }
        }
    }
}
 
开发者ID:tiweGH,项目名称:OpenDiabetes,代码行数:42,代码来源:Routine.java


示例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"));
}
 
开发者ID:mozafari,项目名称:verdict,代码行数:45,代码来源:SqlLineArgsTest.java



注:本文中的org.hsqldb.jdbc.JDBCResultSet类示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
Java BooleanLiteralSet类代码示例发布时间:2022-05-22
下一篇:
Java AndroidListener类代码示例发布时间:2022-05-22
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap