How to Insert Blob Data into database using JDBC ..
String blobData="My Blob Data String."; BigDecimal id= BigDecimal.ONE; String QUERY = "INSERT INTO USER_BLOB(ID, BLOB_DATA) VALUES(?,?) "; Connection connection = null; PreparedStatement statement = null; try{ connection = Connections.getDataBaseConnection(); statement =connection.prepareStatement(QUERY); byte[] blobData = blobData.getBytes(); InputStream inputStream = new ByteArrayInputStream(blobData); statement.setBinaryStream(1,inputStream, blobData.length); statement.setBigDecimal(2,id); statement.executeUpdate(); connection.commit(); }catch(Exception e){ }finally { statement.close(); connection.close(); }
No comments:
Post a Comment