java로 DB에 저장된 이미지파일 화면에 출력
글쓴이: database1 / 작성시간: 일, 2016/11/27 - 7:28오후
DB에 만들어놓은 테이블에 id값과 이미지data가 잘 들어간거 같은데
화면에 출력이 안되네요...
해결방법 아시는분있으신가요??
public void actionPerformed(DefaultTableModel t_model) { try{ String sql = "INSERT INTO pictures (id, filename, image) VALUES (?, ?, ?)"; PreparedStatement stmt = con.prepareStatement(sql); stmt.setString(1, "xxx"); stmt.setString(2, "images.jpg"); File image = new File("D:\\images.jpg"); FileInputStream fis = new FileInputStream(image); stmt.setBinaryStream(3, fis,(int) image.length()); stmt.execute(); String sql1 = "SELECT (id, filename) FROM pictures VALUES (?, ?)"; PreparedStatement stmt1 = con.prepareStatement(sql); stmt1.setString(1, "xxx"); stmt.setString(2, "images.jpg"); ResultSet resultSet = stmt1.executeQuery(); while (resultSet.next()) { String id = resultSet.getString(1); String filename = resultSet.getString(2); File image1 = new File("D:\\java.jpg"); FileOutputStream fos = new FileOutputStream(image1); byte[] buffer = new byte[1]; InputStream is = resultSet.getBinaryStream(3); while (is.read(buffer) > 0) { fos.write(buffer); } con.commit(); fis.close(); con.close(); } } catch (Exception e1){ System.out.println(e1.getMessage()); } }
Forums:
댓글 달기