title: Punch Clock in java
body: <p>I am working on a personal project creating a punch clock in java. Since there will be several users clocking in and out I created a <code>JTextField</code> where users will type their <code>ID number</code> and when they click on the <code>button(jButton1)</code> the program should do two things. </p>
  
  <ol>
  <li>should go through the column of the database JDBC looking for the ID number and </li>
  <li>Once the ID number is found the program should copy the current time into the record for clock in or out, otherwise display an error message such as "ID number not found". </li>
  </ol>
  
  <p>This is the idea, I have learnt some things on my own and with the help of google. However, I cannot find this part, any help/direction at all is appreciated. Thank you.</p>