A little direction needed

I am currently doing a JDBC project where I am manipulating data in a Access DB on a table named empDetail and one of my tasks has got me stumped, considering I only started learning about JDBC yesterday.
I hope somebody can give me a bit of direction as to what I need to do.

Basically I have to populate Jtextfields on a JFrame on start up, which I have done here:

Now I need to make a action performed method for a Jbutton (called New)
this is the task:"When the new button is clicked, all the Jtextfields should be cleared except for the Employee No which should be populated by an employee number one higher then the largest Employee number in the EmpDetails table".

Clearing the text is no problem, but I am a little stumped on the rest.
Any pointers would be very much appreciated.

When "New" is clicked, the question wants you to create a new employee entry. The employee number will be one higher than the existing number of employees present obviously. So what I suggest is that you get from the DB [unless you've already stored it somewhere] the employee no. of the last employee, add it by one, and set the value for the employee number textbox field. Just reply if you have a problem with writing the code and I'll help you out there, too! :)

When "New" is clicked, the question wants you to create a new employee entry. The employee number will be one higher than the existing number of employees present obviously. So what I suggest is that you get from the DB [unless you've already stored it somewhere] the employee no. of the last employee, add it by one, and set the value for the employee number textbox field. Just reply if you have a problem with writing the code and I'll help you out there, too! :)

Sorry I may not have written my question clearly but you are right that is exactly what I need to do but its the code that I am unsure of.

I need to figure out what code to write to find the last record and add 1
I know this won't make sense but I was trying to use while(rs.next)and then do something ?
am I even close?

Hi. so this is actually a continuation from another question of mine[Here](https://www.daniweb.com/programming/software-development/threads/506795/dynamically-add-values-into-datagridview-cell-from-listbox-vb2010) but i was advised to start a new thread as the original question …

I have a 2d matrix with dimension (3, n) called A, I want to calculate the normalization and cross product of two arrays (b,z) (see the code please) for each column (for the first column, then the second one and so on).
the function that I created to find the ...

Write a C program that should create a 10 element array of random integers (0 to 9). The program should total all of the numbers in the odd positions of the array and compare them with the total of the numbers in the even positions of the array and indicate ...