ResultSet: getBlob(String colName) : ResultSet « java.sql « Java by API

Home Java by API 1. com.sun.image.codec.jpeg 2. java.applet 3. java.awt 4. java.awt.datatransfer 5. java.awt.dnd 6. java.awt.event 7. java.awt.font 8. java.awt.geom 9. java.awt.im.spi 10. java.awt.image 11. java.awt.print 12. java.beans 13. java.beans.beancontext 14. java.io 15. java.lang 16. java.lang.annotation 17. java.lang.instrument 18. java.lang.management 19. java.lang.ref 20. java.lang.reflect 21. java.math 22. java.net 23. java.nio 24. java.nio.channels 25. java.nio.charset 26. java.rmi.dgc 27. java.rmi.server 28. java.security 29. java.security.cert 30. java.security.spec 31. java.sql 32. java.text 33. java.text.spi 34. java.util 35. java.util.concurrent 36. java.util.concurrent.atomic 37. java.util.concurrent.locks 38. java.util.jar 39. java.util.logging 40. java.util.prefs 41. java.util.regex 42. java.util.spi 43. java.util.zip 44. javax.accessibility 45. javax.activation 46. javax.annotation.security 47. javax.comm 48. javax.crypto 49. javax.crypto.spec 50. javax.ejb 51. javax.imageio 52. javax.imageio.event 53. javax.jws 54. javax.mail 55. javax.mail.internet 56. javax.media.jai 57. javax.microedition.io 58. javax.microedition.lcdui 59. javax.microedition.media 60. javax.microedition.media.control 61. javax.microedition.midlet 62. javax.microedition.pim 63. javax.microedition.rms 64. javax.naming 65. javax.naming.directory 66. javax.naming.event 67. javax.naming.ldap 68. javax.naming.spi 69. javax.net 70. javax.net.ssl 71. javax.persistence 72. javax.print 73. javax.print.attribute 74. javax.print.attribute.standard 75. javax.print.event 76. javax.script 77. javax.servlet 78. javax.servlet.http 79. javax.sound.midi 80. javax.sound.sampled 81. javax.sql 82. javax.sql.rowset 83. javax.swing 84. javax.swing.border 85. javax.swing.colorchooser 86. javax.swing.event 87. javax.swing.filechooser 88. javax.swing.plaf.basic 89. javax.swing.plaf.metal 90. javax.swing.plaf.synth 91. javax.swing.table 92. javax.swing.text 93. javax.swing.text.html 94. javax.swing.text.html.parser 95. javax.swing.text.rtf 96. javax.swing.tree 97. javax.swing.undo 98. javax.tools 99. javax.transaction 100. javax.xml 101. javax.xml.bind 102. javax.xml.bind.annotation 103. javax.xml.crypto.dsig 104. javax.xml.crypto.dsig.keyinfo 105. javax.xml.namespace 106. javax.xml.parsers 107. javax.xml.soap 108. javax.xml.stream 109. javax.xml.stream.events 110. javax.xml.transform 111. javax.xml.transform.dom 112. javax.xml.transform.stream 113. javax.xml.validation 114. javax.xml.ws 115. javax.xml.xpath 116. junit.extensions 117. junit.framework 118. junit.textui 119. org.apache.commons.lang 120. org.apache.commons.lang.builder 121. org.apache.commons.lang.exception 122. org.apache.commons.lang.time 123. org.apache.commons.logging 124. org.apache.commons.math 125. org.eclipse.jface.action 126. org.eclipse.jface.dialogs 127. org.eclipse.jface.operation 128. org.eclipse.jface.viewers 129. org.eclipse.jface.window 130. org.eclipse.jface.wizard 131. org.eclipse.swt 132. org.eclipse.swt.browser 133. org.eclipse.swt.custom 134. org.eclipse.swt.dnd 135. org.eclipse.swt.events 136. org.eclipse.swt.graphics 137. org.eclipse.swt.layout 138. org.eclipse.swt.ole.win32 139. org.eclipse.swt.printing 140. org.eclipse.swt.program 141. org.eclipse.swt.widgets 142. org.junit 143. org.w3c.dom 144. org.xml.sax 145. org.xml.sax.helpers 146. sun.audio

Java by API » java.sql » ResultSet   ResultSet: getBlob(String colName)   import java.sql.Blob; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import javax.swing.JPanel; public class BlobSelect extends JPanel {   public static void main(String args[]) throws Exception {     Connection conn = null;     byte[] data = getBLOB(01, conn);   }   public static byte[] getBLOB(int id, Connection conn) throws Exception {     ResultSet rs = null;     PreparedStatement pstmt = null;     String query = "SELECT photo FROM MyPictures WHERE id = ?";     try {       pstmt = conn.prepareStatement(query);       pstmt.setInt(1, id);       rs = pstmt.executeQuery();       rs.next();       Blob blob = rs.getBlob("photo");       // materialize BLOB onto client       return blob.getBytes(1, (int) blob.length());     } finally {       rs.close();       pstmt.close();       conn.close();     }   } }                          Related examples in the same category 1. ResultSet.CLOSE_CURSORS_AT_COMMIT 2. ResultSet.CONCUR_READ_ONLY 3. ResultSet.CONCUR_UPDATABLE 4. ResultSet.HOLD_CURSORS_OVER_COMMIT 5. ResultSet.TYPE_SCROLL_INSENSITIVE 6. ResultSet.TYPE_SCROLL_SENSITIVE 7. ResultSet: TYPE_FORWARD_ONLY 8. ResultSet: absolute(int row) 9. ResultSet: beforeFirst() 10. ResultSet: cancelRowUpdates() 11. ResultSet: close() 12. ResultSet: deleteRow() 13. ResultSet: first() 14. ResultSet.getAsciiStream(int columnIndex) 15. ResultSet: getBinaryStream(int columnIndex) 16. ResultSet: getBigDecimal(int columnIndex) 17. ResultSet: getBlob(int columnIndex) 18. ResultSet: getBytes(int columnIndex) 19. ResultSet: getClob(int columnIndex) 20. ResultSet: getConcurrency() 21. ResultSet: getDate(int columnIndex) 22. ResultSet: getDouble(String columnLabel) 23. ResultSet: getInt(int columnIndex) 24. ResultSet: getInt(String columnName) 25. ResultSet: getMetaData() 26. ResultSet: getObject(int columnIndex) 27. ResultSet: getObject(String columnLabel) 28. ResultSet: getRef(int columnIndex) 29. ResultSet: getRow() 30. ResultSet: getShort(String columnLabel) 31. ResultSet: getString(int columnIndex) 32. ResultSet: getString(String columnLabel) 33. ResultSet: getTime(int columnIndex) 34. ResultSet: getTimestamp(int columnIndex) 35. ResultSet: getType() 36. ResultSet: getWarnings() 37. ResultSet: insertRow() 38. ResultSet: isAfterLast() 39. ResultSet: isBeforeFirst() 40. ResultSet: isFirst() 41. ResultSet: last() 42. ResultSet: moveToInsertRow() 43. ResultSet: next() 44. ResultSet: previous() 45. ResultSet: refreshRow() 46. ResultSet: relative(int rows) 47. ResultSet: setFetchSize(int rows) 48. ResultSet: updateInt(String columnLabel, int x) 49. ResultSet: updateRow() 50. ResultSet: updateDouble(int columnIndex, double x) 51. ResultSet: updateString(String columnName, String x) 52. ResultSet: wasNull()