1<<0 java,java.sql.SQLException：列索引超出范围，0< 1

I want to display all the images from database. I have written code but that is displaying error java.sql.SQLException: Column Index out of range, 0 < 1. below is the my database table

| application_name | varchar(45) |

| application_id | varchar(10) |

| application_path | varchar(500) |

| application_icon | blob |

I want to display only images.below is my servlet code

IconDownload.java

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

// TODO Auto-generated method stub

response.setContentType("image/jpeg");

PrintWriter out=response.getWriter();

try {

Connection connection= DBUtil.getConnection();

PreparedStatement preparedStatement=connection.prepareStatement("select application_icon from application_master");

ResultSet resultSet=preparedStatement.executeQuery();

System.out.println("resultSet"+resultSet);

out.print("

photo

");

while (resultSet.next()) {

out.print(" " );

}

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

解决方案

Column Index should start from 1 and not 0

Parameters: columnIndex - the first column is 1, the second is 2, ...

Should be

resultSet.getBlob(1) //first column