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(); } }
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(); } }
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(); } }
public void closeDataObjects() { try { if (resultSet != null) { resultSet.close(); } if (statement != null) { statement.close(); } if (connection != null) { connection.close(); } } catch (Exception e) { } }
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(); } }
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(); } }