Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Blob imageBlob = resultSet.getBlob(yourBlobColumnIndex);
- InputStream binaryStream = imageBlob.getBinaryStream(0, imageBlob.length());
- byte[] imageBytes = imageBlob.getBytes(1, (int) imageBlob.length());
- InputStream binaryStream = resultSet.getBinaryStream(yourBlobColumnIndex);
- final String dbURL = "jdbc:mysql://localhost:3306/portfolio";
- final String dbUser = "root";
- final String dbPass = "";
- Connection conn = null;
- Statement stmt = null;
- try {
- //DriverManager.registerDriver(new com.mysql.jdbc.Driver());
- Class.forName("com.mysql.jdbc.Driver");
- conn = DriverManager.getConnection(dbURL, dbUser, dbPass);
- System.out.println("db connected");
- stmt = (Statement) conn.createStatement();
- ResultSet rs1;
- rs1 = stmt.executeQuery("select profileImage from tbl_welcome where id = 1117");
- if (rs1.next()) {
- byte[] imgData = rs1.getBytes("profileImage");//Here r1.getBytes() extract byte data from resultSet
- System.out.println(imgData);
- response.setHeader("expires", "0");
- response.setContentType("image/jpg");
- OutputStream os = response.getOutputStream(); // output with the help of outputStream
- os.write(imgData);
- os.flush();
- os.close();
- }
- } catch (SQLException ex) {
- // String message = "ERROR: " + ex.getMessage();
- ex.printStackTrace();
- } finally {
- if (conn != null) {
- // closes the database connection
- try {
- conn.close();
- } catch (SQLException ex) {
- ex.printStackTrace();
- }
- }
- }
- private void loadFileDataBlobFromDataBase()
- {
- List<Blob> bFile = jdbcTemplate.query(sql, new RowMapper<Blob>() {
- @Override
- public Blob mapRow(ResultSet rs, int rowNum)
- throws SQLException {
- return rs.getBlob(1);
- }
- });
- if (bFile != null && bFile.size() > 0) {
- bufReader = new BufferedReader(new InputStreamReader(bFile.get(
- 0).getBinaryStream()));
- }
- if (null != bufReader) {
- dataVO record = null;
- String lineStr = bufReader.readLine();
- record = (dataVO) lineMapper.mapLine(lineStr, 1);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement