1,105,625 Community Members

Inserting and Java Database Auto Increment Problem

Member Avatar
nagatron
Junior Poster
109 posts since Aug 2008
Reputation Points: 0 [?]
Q&As Helped to Solve: 2 [?]
Skill Endorsements: 0 [?]
 
0
 

Hello to all java programmers I have a java database problem specifically the auto increment. In my MSAccess I have a table named "Confirm" and in that table I got two fields, the "confirm" which is set to text and the "id" which is set to auto number or auto increment which is also my primary key. In my java application I have a textfield then a button save. If the button is clicked, the text in the textfield will be saved in the database field "confirm" then the id will increment. In my code, what I did is this:

String insert = "insert into Confirm values ('"+confirmation.getText()+"',"+missing code here+")";
st.execute(insert);

confirmation.getText() is my JTextField

I don't know what code to put in "missing code here" in order the program to work and the id will auto increment.

Member Avatar
Majestics
Practically a Master Poster
694 posts since Jul 2007
Reputation Points: 84 [?]
Q&As Helped to Solve: 66 [?]
Skill Endorsements: 6 [?]
 
2
 

there is no need to mention auto increment explicitly , it will increment automatically when ever you insert a new row

further more the query must be like this

insert into Confirm(columnname) values(columnvalue)

Hope this Help......

Member Avatar
nagatron
Junior Poster
109 posts since Aug 2008
Reputation Points: 0 [?]
Q&As Helped to Solve: 2 [?]
Skill Endorsements: 0 [?]
 
1
 

Thank you so much. . It did work. . hehe I did it this way:

String insert = "insert into Confirm (confrim) values ('"+confirmation.getText()+"')";
st.execute(insert);

=)

Question Answered as of 2 Years Ago by Majestics
You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: