Database

HI,
Pls help me..

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

 

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

 

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.

 

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.

 

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

 

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.

 

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

 

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.

 

I agree.

 

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

 

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