need help in sql statement

[chyeeqi]

question 1 :

how can i write sql statement that insert data in table that contain a field with data type auto number??
eg :
my reception table contain 2 field
No and patient
No 's data type is auto nu,ber
patient 's data type is text
how can i write the sql statement????

question 2 :

how can i take all the data in the column??
eg :
medicine quantity
a <t> 1
b 2

how cna i get all medicine data and save it into array??

[j2me64]

question 1 :

..

question 2 :

...

hallo, do you already have established a connection with the database you want to use? a'm asking, because explaining all the details you need can take very long. so why don't your read this http://www.java-forums.org/java-tuto...nectivity.html first? after ou should be able to insert data in your table.

[chyeeqi]

i noe way to connect database..i dunno how to insert data into table which contain autonumber datatype
eg :
normally we use tis sql to insert data
INSERT INTO PATIENT VALUES ("abc","abc")

but how can i insert data into table which have autonumber data type

[j2me64]

but how can i insert data into table which have autonumber data type

what are autonumber data type? do you mean auto incremental number? if yes, do not insert the value for this type of data, because your db will increment this number automatically.

[chyeeqi]

i had try tis way
INSERT INTO PATIENT ( Patient ) VALUES ( "abc" )
but fail.
1st column is no , data type autonumber
2nd column is patient , data type text

[j2me64]

i had try tis way
INSERT INTO PATIENT ( Patient ) VALUES ( "abc" )
but fail.
1st column is no , data type autonumber
2nd column is patient , data type text

i don't know which database you use but read the documentation about autonumber for your database.

in java single quotes are used to wrap strings. to make the sql-code more readable use PreparedStatements. you will find a good documentation is the "Java Tutorials" forum.

[chyeeqi]

i d find the way to solve the problem