Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Java (http://www.go4expert.com/forums/java/)
-   -   Database (http://www.go4expert.com/forums/database-t679/)

kunju 3Apr2006 00:35

Database
 
HI,
Pls help me..

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

coderzone 3Apr2006 07:35

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

kunju 3Apr2006 10:59

Re: 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.

pradeep 3Apr2006 11:04

Re: Database
 
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 3Apr2006 23:38

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

Amit Ray 4Apr2006 12:34

Re: Database
 
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 4Apr2006 23:04

Re: Database
 
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

Amit Ray 5Apr2006 10:32

Re: Database
 
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 5Apr2006 10:39

Re: Database
 
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 5Apr2006 11:40

Re: Database
 
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


All times are GMT +5.5. The time now is 05:03.