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"));
}