Error when retrieve Image(Blob) data from SQLite database

Question

I am trying to retrieve Image(Blob) Data from database But it gives my null pointer exception . What is wrong with it ? Here is the Code

    JButton show = new JButton("New button");
    show.addActionListener(new ActionListener() {
        public void actionPerformed(ActionEvent e) {
            try{
                String iid="10";
                //iid=id.getText().toString();
                String q="select * from image where id='"+iid+"'";

                PreparedStatement ps=con.prepareStatement(q);
                //ps.setString(1, id.getText());
                ps.executeQuery();
                ResultSet rs=ps.executeQuery();         
                while (rs.next()) {
                    InputStream in = rs.getBinaryStream("image");
                    bufImg = ImageIO.read(in);
                    img.setIcon(new ImageIcon (bufImg));
                }
                rs.close();
                ps.close();


                }catch(Exception c)
                {
                    c.printStackTrace();
                }
        }
    });

Additionally, you should *always* use parameterized SQL to avoid SQL injection attacks. — Jon Skeet, Jul 31 '15 at 15:11
why do you call `executeQuery()` twice? try remove the first `ps.executeQuery()` — Alex S. Diaz, Jul 31 '15 at 15:14
the first one was commented out . but unfortunately i forgot to comment out it in here . it still shows the error — CodeHead, Jul 31 '15 at 15:18

Error when retrieve Image(Blob) data from SQLite database

0 Answers0