Example #1
0
 public void workerNameForCurrentWorker() throws Exception {
   userIdForCurrentUser();
   if (Global.user_id == 0) {
     return;
   }
   if (!newConnection()) {
     return;
   }
   try {
     /* PreparedStatement to issue SQL query */
     // Search worker using worker_id
     preparedStatement =
         connection.prepareStatement(
             "select last_name, first_name from workers where id = " + Global.worker_id);
     resultSet = preparedStatement.executeQuery();
     resultSet.first();
     String _worker_last_name = resultSet.getString("last_name");
     String _worker_first_name = resultSet.getString("first_name");
     Global.worker_name = _worker_last_name + ", " + _worker_first_name;
   } catch (Exception e) {
     throw e;
   } finally {
     closeDataObjects();
   }
 }
Example #2
0
 public void workerIdForCurrentUser() throws Exception {
   userIdForCurrentUser();
   if (Global.user_id == 0) {
     Global.worker_id = 0;
     return;
   }
   if (!newConnection()) {
     Global.worker_id = 0;
     return;
   }
   try {
     /* PreparedStatement to issue SQL query */
     // Search worker using user_id to extract worker_id
     preparedStatement =
         connection.prepareStatement(
             "select id, last_name, first_name from workers where user_id = " + Global.user_id);
     resultSet = preparedStatement.executeQuery();
     resultSet.first();
     Integer _worker_id = resultSet.getInt("id");
     if (_worker_id == null) {
       _worker_id = 0;
     }
     Global.worker_id = _worker_id;
   } catch (Exception e) {
     throw e;
   } finally {
     closeDataObjects();
   }
 }
Example #3
0
 public void readWorkers() throws Exception {
   try {
     if (!newConnection()) {
       return;
     }
     // PreparedStatement to issue SQL query
     preparedStatement = connection.prepareStatement("select * from workers");
     // SQL query's ResultSet with PreparedStatement
     resultSet = preparedStatement.executeQuery();
     LocalDate d = new LocalDate();
     LocalTime t = new LocalTime();
     System.out.println(Global.hostName + " - Running at " + d + " " + t + "\n");
     while (resultSet.next()) {
       // It is possible to get the columns via name
       // also possible to get the columns via the column number
       // which starts at 1
       // e.g. resultSet.getSTring(2);
       String lastName = resultSet.getString("last_name");
       String firstName = resultSet.getString("first_name");
       String workerCode = resultSet.getString("worker_code");
       Date createdAt = resultSet.getDate("created_at");
       System.out.println(
           "Worker: "
               + lastName
               + ", "
               + firstName
               + "\t ("
               + workerCode
               + ")\t Created at: "
               + createdAt);
       /*
        * System.out.println("Code: " + workerCode);
        * System.out.println("Created at: " + createdAt);
        */
     }
   } catch (Exception e) {
     throw e;
   } finally {
     closeDataObjects();
   }
 }
Example #4
0
 public void closeDataObjects() {
   try {
     if (resultSet != null) {
       resultSet.close();
     }
     if (statement != null) {
       statement.close();
     }
     if (connection != null) {
       connection.close();
     }
   } catch (Exception e) {
   }
 }
Example #5
0
 public void userIdForCurrentUser() throws Exception {
   if (!newConnection()) {
     return;
   }
   try {
     /* PreparedStatement to issue SQL query */
     // Search user using current_user to extract user_id
     preparedStatement =
         connection.prepareStatement(
             "select id from users where name = '" + Global.current_user + "'");
     resultSet = preparedStatement.executeQuery();
     resultSet.first();
     Integer _user_id = resultSet.getInt("id");
     if (_user_id == null) {
       Global.user_id = 0;
     } else {
       Global.user_id = _user_id;
     }
   } catch (Exception e) {
     throw e;
   } finally {
     closeDataObjects();
   }
 }
Example #6
0
 public void readTimeRecordCodes() throws Exception {
   try {
     if (!newConnection()) {
       return;
     }
     // PreparedStatement to issue SQL query
     preparedStatement =
         connection.prepareStatement("select id, name from timerecord_codes order by id");
     // SQL query's ResultSet with PreparedStatement
     resultSet = preparedStatement.executeQuery();
     // Load codes list
     Global.codesList.clear();
     while (resultSet.next()) {
       Integer _id = resultSet.getInt("id");
       String _name = resultSet.getString("name");
       TimeRecordCode _code = new TimeRecordCode(_id, _name);
       Global.codesList.add(_code);
     }
   } catch (Exception e) {
     throw e;
   } finally {
     closeDataObjects();
   }
 }