its very urgent please help me

how can i retrieve all images from ms access database and display in jsp pages

View Answers

March 2, 2011 at 10:37 AM

JSP retrieve all images from MS Access database:

1)images.jsp:

<%@ page import="java.sql.*,java.io.*,java.util.*" %> 
<HTML>
 <table >
   <%
  try{      
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Connection con = DriverManager.getConnection("jdbc:odbc:student");
    Statement stmt=con.createStatement();
    String strQuery = "select * from user";
    ResultSet rs = stmt.executeQuery(strQuery);
    while(rs.next()){
       %>
      <tr>

      <td>
      <img src="image.jsp?imgid=<%=rs.getInt(1)%>" width="100" height="100">
</a></td>
      </tr>
      <%
    }
    rs.close();
    con.close();
    stmt.close();
  }
  catch(Exception e)
  {
    e.getMessage();
  }
  %>
 </table>
</HTML>

2)image.jsp:

<%@ page import="java.sql.*,java.io.*,java.util.*" %> 
<%
  int id =  Integer.parseInt(request.getParameter("imgid"));
  try{      
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Connection con = DriverManager.getConnection("jdbc:odbc:student");
    Statement st=con.createStatement();
    String strQuery = "select image from user where id="+id;
    ResultSet rs = st.executeQuery(strQuery);

    String imgLen="";
    if(rs.next()){
      imgLen = rs.getString(1);
       }  
    rs = st.executeQuery(strQuery);
    if(rs.next()){
      int len = imgLen.length();
      byte [] rb = new byte[len];
      InputStream readImg = rs.getBinaryStream(1);
      int index=readImg.read(rb, 0, len);  
      st.close();
      response.reset();
      response.getOutputStream().write(rb,0,len); 
      response.getOutputStream().flush();        
    }
  }
  catch (Exception e){
    e.printStackTrace();
  }
%>

Ads

Advertisements

Ple help me its very urgent
Ple help me its very urgent Hi.. I have one string 1)'2,3,4' i want do like this '2','3','4' ple help me very urgent

urgent...pleAse help me.....please!
urgent...pleAse help me.....please! please help me urgent! how can i do dictionary with the use of array code in java, where i will type the word then the corresponding meaning for that word will appear...thanks

pls help me sir its urgent
pls help me sir its urgent thanks for reply, but i am getting this error pls help me its urgent type Exception report message description The server encountered an internal error () that prevented it from

CAN ANYONE SOLVE THIS FOR ME. URGENT HELP NEEDED. PLEASE HELP
CAN ANYONE SOLVE THIS FOR ME. URGENT HELP NEEDED. PLEASE HELP The Task Write a class whose objects will represent students. The class should have three fields for representing a student�??s

CAN ANYONE SOLVE THIS FOR ME. URGENT HELP NEEDED. PLEASE HELP
CAN ANYONE SOLVE THIS FOR ME. URGENT HELP NEEDED. PLEASE HELP Write a class whose objects will represent students.The class should have three fields for representing a studentâ�?��?�s name, this studentâ�?��?�s

PLease reply its urgent
PLease reply its urgent Write a java function that has the signature â�?��?Public static int clock Inter sections(int hours, int minutes)â�?��...:minute:second format. How's that urgent

servlet not working properly ...pls help me out....its really urgent
servlet not working properly ...pls help me out....its really urgent Hi, Below is the front page of my project 1)enty.jsp </form> <...;Please go through the following link: Servlet Tutorials

urgent please, help!
urgent please, help! how to make jTable unclickable and have unmovable columns, thanks in advance import javax.swing.*; import java.awt.*; public class SimpleJTableExample{ public static void main(String[] args

please help me.
please help me. Please send me a code of template in opencms and its procedure.so i can implement the code. Thanks trinath

pls help me it urgent
pls help me it urgent hey, pls help me i want to know that can we call java/.bat file from plsql/proceudre /trigger

displaying List of records from database in a jsp using ajax, onclick it should display the results ?? its urgent can u help me
displaying List of records from database in a jsp using ajax, onclick it should display the results ?? its urgent can u help me displaying List... ?? its urgent can u help me

please help me.
please help me. How to read a properties file in java with a suitable example. Please send me. Thanks Trinath Please visit the following link: Java read properties file

please help me.
please help me. Please send me the validation of this below link. the link is http://www.roseindia.net/answers/viewqa/JSP-Servlet/9584-JSP-Servlet-Search-and-Edit.html Thanks Trinath

please help me.
please help me. How to move the edits.jsp in below link? http://www.roseindia.net/answers/viewqa/JSP-Servlet/9584-JSP-Servlet-Search-and-Edit.html

please help me.
please help me. I have a jsp page under that i add a list box under i get the countries through my database. so how can i do

please help me
please help me how to use two browse buttons, one browse button for displaying the first image and second for the second image along with its file path and also to display text file along with its path using layouts or panels

help me please
help me please Hello I want helping for this question , Please Write a program that reads some friendsâ�?��?� names, stores them in an array, and then prints out on the screen all friends who start by a particular letter

please help me
before. This name list should get from the database. Please help me. By the way, I'm...please help me Dear sir, I have a problem. How to write JSP coding, if a user select a value from drop down list for example department, the another

Please help me.
Please help me. Hi i am trinath in below there is a url.In that url there is a code of edit a jsp page.I understand that code but only one thing i not get it i.e; What is the work of "id".and what is the data type of id? http

please help me.
please help me. I have three table in mysql,and i hava create a excel sheet and add this sheet.but my question is in every sheet i can display one one table result.how can i do

please help me...
please help me... write an application that print number in the following order using a FOR-Loop 1 2 3 4 5 2 4 6 8 10 3 6 9 1215 4 8 121620 5 10152025

please help me in these prog
please help me in these prog create 2 jdbc programs including awt create 2 jdbc programs including swing create 2 jdbc programs including command line argument create 2 jdbc programs including io class 4 jdbc prog using

please help me to this problem..
please help me to this problem.. i wrote a program like keyboard... inside the JTextField) but i want to make this program to let me write where i clicked (i.e allows me to write any thing at the field where i clicked

Please help me
Please help me program for when a user enter his card number, it has to create default security pin in the database

Please help me
Please help me Hi Sir, please send me the code for the following progrems... 1) all sets are integer type: input: set1={10,20,30,40} set2={15,25,35} output: union={10,15,20,25,30,35,40} 2) input: "Hi what

please help me
please help me interface Test1 { String toString(); } public class Test { public static void main(String[] args) { System.out.println(new Test1() { public String toString() { return "test

Ads