首页 > 代码库 > jdbc 读取oracle long raw 字段,里面存的是文本
jdbc 读取oracle long raw 字段,里面存的是文本
jdbc 读取oracle long raw 字段,里面存的是文本
参考:
http://singlewolf.iteye.com/blog/278769
http://blog.csdn.net/restraint/article/details/7190265
http://blog.csdn.net/bq1073100909/article/details/49335491
String sql = "select condition from tbl t where t.a = ? and t.b = ?"; PreparedStatement statement = hebSgConn.prepareStatement(sql); statement.setString(1, "20170305"); statement.setInt(2, 146897); ResultSet resultSet = statement.executeQuery(); if (resultSet.next()) { InputStream inputStream = resultSet.getBinaryStream("condition"); ByteArrayOutputStream infoStream = new ByteArrayOutputStream(); int len = 0; byte[] bytes = new byte[1024]; try { while ((len = inputStream.read(bytes)) != -1) { // 将bcache中读取的input数据写入infoStream infoStream.write(bytes, 0, len); } } catch (IOException e1) { throw new Exception("输入流读取异常"); } finally { try { inputStream.close(); // 输入流关闭 } catch (IOException e) { throw new Exception("输入流关闭异常"); } } try { String result = infoStream.toString(DEFAULT_ENCODING); System.out.println(result); } catch (UnsupportedEncodingException e) { throw new Exception("输出异常"); } }
基本上是流操作;
jdbc 读取oracle long raw 字段,里面存的是文本
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。