java and search into the database

i know how to connect java to an acess database but i don't know how to search it and retieve data from it

suppose i have a database that have 4 colums

itemsoldTillmarchsoldTillJuneSoldTillSep

car 1020 5

pens3004015

pc20

and so on

and i want to give the user all the sold quantities when he enteres the item name

for example if the user enter car the output will be

10205

if the user enter pc

the output will be 20

and so on

any ideas?

[533 byte] By [TheNewLeadera] at [2007-11-27 4:54:55]

# 1

Put Java aside, do you know how to do what you need using plain SQL statements?

JDBC does only three things with any database:

1 - connects to the desired db engine.

2 - sends an sql statement (query) to it.

3 - recieves the query result(s).

I think it is clear.

Ahmad Elsafty

NourElsaftya at 2007-7-12 10:09:43 >

# 2

i think that i just know the first step create a connection i know sql but not through java do u know any link i can read from Thanks in advanced

TheNewLeadera at 2007-7-12 10:09:43 >

# 3

[url http://java.sun.com/docs/books/tutorial/]JDBC Database Access[/url]

camickra at 2007-7-12 10:09:43 >

# 4

http://java.sun.com/docs/books/tutorial/jdbc/index.html

NourElsaftya at 2007-7-12 10:09:43 >

Java Essentials New Topic