질문 JTable의 행을 누르면 이미지가 출력이 안되는데 경로문제가 아니라고 합니다...

Question

Jtable의 행을 클릭하면 JLabel에 이미지가 출력되게 해놨는데 오류 없이 이미지가 안 나옵니다.이미지 출력 문제로 3일이 넘어갔습니다.. 살려주세요... 고수님들...package DBConnect;import java.util.Date;public class DBdata {private int book_id;private String callnumber;private String title;private int price;private String author;private String publisher;private String date;private String field;private int search;private int checkout;private String image;public DBdata() {}public DBdata(String callnumber, String title, int price, String author, String publisher, String field, String date,String image) { this.callnumber = callnumber; this.title = title; this.price = price; this.author = author; this.publisher = publisher; this.field = field; this.date = date; this.image = image;}public String getCallnumber() { return callnumber;}public void setCallnumber(String callnumber) { this.callnumber = callnumber;}public String getTitle() { return title;}public void setTitle(String title) { this.title = title;}public int getPrice() { return price;}public void setPrice(int price) { this.price = price;}public String getAuthor() { return author;}public void setAuthor(String author) { this.author = author;}public String getPublisher() { return publisher;}public void setPublisher(String publisher) { this.publisher = publisher;}public String getField() { return field;}public void setField(String field) { this.field = field;}public String getDate() { return date;}public void setDate(String date) { this.date = date;}public String getImage() { return image;}public void setImage(String image) { this.image = image;}public int getBook_id() {return book_id;}public void setBook_id(int book_id) {this.book_id = book_id;}public int getSearch() {return search;}public void setSearch(int search) {this.search = search;}public int getCheckout() {return checkout;}public void setCheckout(int checkout) {this.checkout = checkout;}}package DBConnect;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.ArrayList;import java.util.List;public class DBuse { private Connection conn = null; private PreparedStatement pstmt = null; private ResultSet rs = null; public Connection getDBConn() { try { Class.forName("com.mysql.cj.jdbc.Driver"); conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/cban", "root", "1234"); } catch (ClassNotFoundException e) { System.out.println("JDBC 드라이버 로드 에러"); } catch (SQLException e) { System.out.println("DB 연결 오류"); } return conn; } public List readData() { List list = new ArrayList<>(); try { conn = getDBConn(); String sql = "SELECT * FROM book"; pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while (rs.next()) { DBdata dd = new DBdata(); dd.setBook_id(rs.getInt("book_id")); dd.setCallnumber(rs.getString("callnumber")); dd.setTitle(rs.getString("title")); dd.setPrice(rs.getInt("price")); dd.setAuthor(rs.getString("author")); dd.setPublisher(rs.getString("publisher")); dd.setDate(rs.getString("date")); dd.setField(rs.getString("field")); dd.setSearch(rs.getInt("search")); dd.setCheckout(rs.getInt("checkout")); dd.setImage(rs.getString("image")); list.add(dd); } } catch (SQLException e) { System.out.println("DB 연결 오류"); } finally { dbClose(); } return list; } public List searchData(String title, String author, String publisher, String field) { List result = new ArrayList<>(); try { conn = getDBConn(); String sql = "SELECT * FROM book WHERE title LIKE '%" + title + "%' OR author LIKE '%" + author + "%' OR publisher LIKE '%" + publisher + "%' OR field LIKE '%" + field + "%'"; pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while (rs.next()) { int book_id = rs.getInt("book_id"); String callnumber = rs.getString("callnumber"); String booktitle = rs.getString("title"); int price = rs.getInt("price"); String authorName = rs.getString("author"); String publisherName = rs.getString("publisher"); String date = rs.getString("date"); String fieldInfo = rs.getString("field"); String image = rs.getString("image"); result.add(new DBdata(callnumber, booktitle, price, authorName, publisherName, fieldInfo, date, image)); } } catch (SQLException e) { System.out.println("DB 연결 오류"); } finally { dbClose(); } return result;}public void dbClose() {try {if (rs != null)rs.close();if (pstmt != null)pstmt.close();if(conn != null)conn.close();} catch (Exception e) {System.out.println(e + "=> dbClose fail");}}}package bp;import java.awt.BorderLayout;import java.awt.Container;import java.awt.Image;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.awt.event.MouseAdapter;import java.awt.event.MouseEvent;import java.net.MalformedURLException;import java.net.URL;import java.sql.SQLException;import java.util.List;import javax.swing.ImageIcon;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JPanel;import javax.swing.JScrollPane;import javax.swing.JTable;import javax.swing.JTextField;import javax.swing.table.DefaultTableModel;import DBConnect.DBdata;import DBConnect.DBuse;public class bookpratics extends JFrame { List list; DefaultTableModel model; JLabel imageLabel = null; @SuppressWarnings("serial")public bookpratics() { setTitle("도서 검색"); Container c = getContentPane(); c.setLayout(null); JTextField searchtxt = new JTextField(); JButton searchbtn = new JButton("검색"); String[] header = {"기호", "제목", "가격", "저자", "출판사", "분야", "출시일","경로"}; model = new DefaultTableModel(header, 0) { public boolean isCellEditable(int rowIndex, int mColindex) { return false; }// 값 수정 불가 }; JTable sr = new JTable(model); JScrollPane jsp = new JScrollPane(sr); searchtxt.setLocation(100, 50); searchtxt.setSize(900, 50); searchbtn.setLocation(1000, 50); searchbtn.setSize(90, 50); jsp.setBounds(400, 120, 700, 500); sr.addMouseListener(new MouseAdapter() { @Override public void mouseClicked(MouseEvent e) { int row = sr.getSelectedRow(); String imageurl = (String) sr.getModel().getValueAt(row, 7); ImageIcon imageIcon = null; if (imageurl != null) { try { imageIcon = new ImageIcon(new URL("file:///"+imageurl)); imageLabel.setIcon(imageIcon); // JLabel에 이미지 설정 } catch (MalformedURLException ex) { ex.printStackTrace(); } } } }); // JLabel 위치와 크기 설정 imageLabel = new JLabel(); imageLabel.setBounds(50, 120, 300, 500); c.add(imageLabel); searchbtn.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { if (e.getSource() == searchbtn) { String keyword = searchtxt.getText(); list = new DBuse().searchData(keyword, keyword, keyword, keyword); model.setRowCount(0); for (DBdata tmp : list) { Object[] row = {tmp.getCallnumber(), tmp.getTitle(), tmp.getPrice(), tmp.getAuthor(), tmp.getPublisher(), tmp.getField(), tmp.getDate(),tmp.getImage()}; model.addRow(row); } imageLabel.setIcon(null); // 검색 결과가 변경되면 JLabel의 이미지 초기화 } } }); imageLabel = new JLabel(); imageLabel.setBounds(10, 120, 300, 500); c.add(imageLabel); showbook(); //DB값들 출력 c.add(searchbtn); c.add(searchtxt); c.add(jsp); setSize(1200, 750); setLocationRelativeTo(null); setDefaultCloseOperation(EXIT_ON_CLOSE); setVisible(true); } public void showbook() { list = new DBuse().readData(); model.setRowCount(0); for (DBdata tmp : list) { Object[] row = {tmp.getCallnumber(), tmp.getTitle(), tmp.getPrice(), tmp.getAuthor(), tmp.getPublisher(), tmp.getField(), tmp.getDate(), tmp.getImage()}; model.addRow(row); //결과 출력 } } }

질문 JTable의 행을 누르면 이미지가 출력이 안되는데 경로문제가 아니라고 합니다...

0개의 답변

Q&A 목록