private void PopulateStudentProfilePage(String studentNo) throws Exception {
   try (IDatabaseConnection connection = DatabaseConnectionService.createDatabaseConnection()) {
     try (IStatementExecutor stmtExecutor =
         DatabaseConnectionService.createStatementExecutor(connection)) {
       String student = String.format("SELECT * FROM Students WHERE studentNo ='%s' ", studentNo);
       try (IQueryResultSet resultSet = stmtExecutor.executeQuery(student)) {
         resultSet.moveToFirstRow();
         SetRowValuesToTextboxControls(resultSet);
       }
     }
   }
 }
 private void SetRowValuesToTextboxControls(final IQueryResultSet resultSet) {
   studentNoTextBox.setText(resultSet.getString("studentNo"));
   firstNameTextBox.setText(resultSet.getString("firstName"));
   lastNameTextBox.setText(resultSet.getString("lastName"));
   dobTextBox.setText(resultSet.getString("dob"));
   homePhoneTextBox.setText(resultSet.getString("homePhone"));
   workPhoneTextBox.setText(resultSet.getString("workPhone"));
   sexTextBox.setText(resultSet.getString("sex"));
   nationalityTextBox.setText(resultSet.getString("nationality"));
   deptIdTextBox.setText(resultSet.getString("deptId"));
   streetTextBox.setText(resultSet.getString("street"));
   cityTextBox.setText(resultSet.getString("city"));
   pincodeTextBox.setText(resultSet.getString("pincode"));
   classificationTextField.setText(resultSet.getString("STUDENTCLASSIFICATION"));
   degreeTextField.setText(resultSet.getString("DEGREEPROGRAM"));
   yearTextField.setText(resultSet.getString("STUDENTPROGRAM"));
 }