Briefly my classes:
1) MyFileUpload/WEB-INF/classes/data/ImageCRUD
---------------------------------------------------------------------------------------------------------
public class ImageCRUD{
...
public ResultSet listImage(){
try{
Class.forName(...);
if(conn == null){
conn = DriverManager.getConnection(...);
ps = conn.prepareStatement("select idImage, Name from images");
rs = ps.executeQuery();
while(rs.next()){
int numColumn = rs.getMetaData().getColumnCount();
for(int i=1; i <= numColumn; i++){
System.out.println(rs.getObject(i));
}
}
...
return rs;
}
-------------------------------------------------------------------------------------------------------------------
2) MyFileUpload/WEB-INF/classes/ImageServlet.java
--------------------------------------------------------------------------------------------------------------------
public class ImageServlet extends HttpServlet{
...
try{
// The code for add an image to DB. Work well
ic.addImage( image ); // ic = new ImageCRUD Object
ResultSet rs = ic.listImage();
RequestDispatcher dispatcher;
dispatcher = getServletContext().getRequestDispatcher("/ShowImage.jsp");
request.setAttribute("rs", rs);
dispatcher.forward(request,response);
}catch(...){
...
}
...
---------------------------------------------------------------------------------------------------------------------
3) MyFileUpload/ShowImage.jsp
----------------------------------------------------------------------------------------------------------------------
...
<%
rs = request.getAttribute("rs");
while(rs.next()){
int numColumn = rs.getMetaData().getColumnCount();
for(int i=1; i <= numColumn; i++){
out.println(rs.getObject(i));
}
}
%>
...
-------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
