private void UpdateStudentProfile(String studentNo) throws Exception { try (IDatabaseConnection connection = DatabaseConnectionService.createDatabaseConnection()) { // Address table needs to be updated before updating the student table due to foreign key // constraint UpdateStudentAddress(connection); try (IStatementExecutor stmtExecutor = DatabaseConnectionService.createStatementExecutor(connection)) { String updateStudentProfileInfo = String.format( "UPDATE Students " + "SET homePhone = '%s'," + "workPhone = '%s'," + "sex = '%s'," + "nationality = '%s'," + "street = '%s'," + "city = '%s'," + "pincode = '%s'" + "WHERE studentNo = '%s'", homePhoneTextBox.getText(), workPhoneTextBox.getText(), sexTextBox.getText(), nationalityTextBox.getText(), streetTextBox.getText(), cityTextBox.getText(), pincodeTextBox.getText(), studentNo); stmtExecutor.executeUpdate(updateStudentProfileInfo); } } }
private void ChangeEditModeOfTextBoxes(boolean makeEditable) { homePhoneTextBox.setEditable(makeEditable); workPhoneTextBox.setEditable(makeEditable); sexTextBox.setEditable(makeEditable); nationalityTextBox.setEditable(makeEditable); streetTextBox.setEditable(makeEditable); cityTextBox.setEditable(makeEditable); pincodeTextBox.setEditable(makeEditable); }
private void UpdateStudentAddress(IDatabaseConnection connection) throws Exception { try (IStatementExecutor stmtExecutor = DatabaseConnectionService.createStatementExecutor(connection)) { String updateStudentAddressInfo = String.format( "INSERT INTO Addresses (street,city,pincode)" + " SELECT '%s','%s','%s' FROM DUAL" + " WHERE NOT EXISTS" + "(SELECT * FROM Addresses WHERE street='%s' AND city='%s' AND pincode='%s') ", streetTextBox.getText(), cityTextBox.getText(), pincodeTextBox.getText(), streetTextBox.getText(), cityTextBox.getText(), pincodeTextBox.getText()); stmtExecutor.executeUpdate(updateStudentAddressInfo); } }
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")); }