Database

kunju's Avatar
Light Poster
HI,
Pls help me..

How to get the first record next record previous record and last from Database
in java?
coderzone's Avatar, Join Date: Jul 2004
Team Leader
Why do you need that type of fetching from the database.
kunju's Avatar
Light Poster
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.
pradeep's Avatar, Join Date: Apr 2005
Team Leader
You can use the functions built inside the JDBC class for moving the cursor from & to wherever you want.

Code: java
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/tutor...inserting.html.

kunju's Avatar
Light Poster
thanks.
How Can I add image(gif) to Database in Java?
Amit Ray's Avatar, Join Date: Jul 2004
Contributor
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.
kunju's Avatar
Light Poster
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 by kunju; 4Apr2006 at 23:09..
Amit Ray's Avatar, Join Date: Jul 2004
Contributor
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.
coderzone's Avatar, Join Date: Jul 2004
Team Leader
Quote:
Originally Posted by Amit Ray
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.
kunju's Avatar
Light Poster
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