Generate auto increment serial number in java eclipse

See more:

Java

I designed one form in java where textfield is there.so I want to display serial numbers in this textfield...means current textfield value should be 1..then I'll fill up these form and submitted...when I'll come back textfield value should be 2...after submitting this form textfield value become 3 and so on...So how to make auto increment serial number and display in JTextfield..

What I have tried:

Here I used java eclipse and sqlite database.
I tried following code


textField = new JTextField();
try
{
String query="Select max(`Enquiry No`) as max from enquiry ";
PreparedStatement pst=conn.prepareStatement(query);
ResultSet rs=pst.executeQuery();

while(rs.next())
{
int num = rs.getInt("max");
int inc=num+1;
textField.setText(valueOf(inc));

}

}

catch(Exception a)
{
a.printStackTrace();
}