1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Database

Discussion in 'Java' started by kunju, Apr 2, 2006.

  1. kunju

    kunju New Member

    HI,
    Pls help me..

    How to get the first record next record previous record and last from Database
    in java?
     
  2. coderzone

    coderzone Super Moderator

    Why do you need that type of fetching from the database.
     
  3. kunju

    kunju New Member

    I want to get display the item when I clicked the next button.So i need to get the nextrecord.
    if it is last should get any messge. Could you pls do me a favour too?How to add Images in to
    databases in Java?.Pls give me query. thanx.
     
  4. pradeep

    pradeep Team Leader

    You can use the functions built inside the JDBC class for moving the cursor from & to wherever you want.

    Code:
    Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                           ResultSet.CONCUR_UPDATABLE);
      ResultSet uprs = stmt.executeQuery("SELECT * FROM COFFEES")
      
      /* Move to first */
      uprs.first();
      /* Move to last */
      uprs.last();
      /* Next */
      uprs.next();
      /* previous */
      uprs.previous();


    There are more, which you can find here http://java.sun.com/docs/books/tutorial/jdbc/jdbc2dot0/inserting.html.

     
  5. kunju

    kunju New Member

    thanks.
    How Can I add image(gif) to Database in Java?
     
  6. Amit Ray

    Amit Ray New Member

    Hi Kunju ...

    Can you please tell us what exactly you want to do? If you want to insert the binary information of the image in a database field you might want to use BLOBs (Binary Large Objects) to store the data in the DB.

    Depending on what DB are you talking about the implementation might vary a little.

    You can take a look at: BLOBs & Java

    Amit Ray.
     
  7. kunju

    kunju New Member

    Hello,

    Actually what i am doing is a matrimonial work. I want to insert the image i.e
    photo into the Database. I am using MSAccess as backend. So I dont know the query which
    I want to use.Moreover, I want to search the image from the Database.I am displaying
    the image in the panel. And how to set the image into the panel after the search has been
    completed.I am searching one image at a time.So what query I should use?Could you pls give me a small example?

    I have experienced the following query. But it didnt work. May be my mistake.

    Image img=(Image)rs.getBlob("photo");

    is it wrong?I got the castexception . anyway pls give me example too.
    bye
     
    Last edited: Apr 4, 2006
  8. Amit Ray

    Amit Ray New Member

    Just wondering ... wouldnt it be much easier to save the url of the image in the database and use the url of the image to load it during run time ... The url can be anything from a directory on your local machine to a url on the web.

    Amit Ray.
     
  9. coderzone

    coderzone Super Moderator

    I agree.
     
  10. kunju

    kunju New Member

    hello,

    I am using stand alone application. Not web based. I am using only core java.
    pls give me any example of using image Database connection in Java.Also
    retrieval from the Database.Pls help me. Its urgent
     
  11. coderzone

    coderzone Super Moderator

    You dont need any web based or anything to be using the image paths to be stored in the database.
     

Share This Page