Hi Guys! Can you advice some good method to reduce this spaghetti: ``` val confirm...

# server

[pyrkamarcin]

Hi Guys!

Can you advice some good method to reduce this spaghetti:

val confirmAccountDeletionEmailStatement = configurationConnection().prepareStatement("SELECT t.id,t.name,t.subject,t.content FROM email_templates t WHERE name='confirm_account_deletion'")

                val confirmAccountDeletionEmailResultSet = confirmAccountDeletionEmailStatement.executeQuery()
                var confirmAccountDeletionEmailId = 0
                var confirmAccountDeletionEmailName = ""
                var confirmAccountDeletionEmailSubject = ""
                var confirmAccountDeletionEmailContent = ""
                while (confirmAccountDeletionEmailResultSet.next()) {
                    confirmAccountDeletionEmailId = confirmAccountDeletionEmailResultSet.getInt(1)
                    confirmAccountDeletionEmailName = confirmAccountDeletionEmailResultSet.getString(2)
                    confirmAccountDeletionEmailSubject = confirmAccountDeletionEmailResultSet.getString(3)
                    confirmAccountDeletionEmailContent = confirmAccountDeletionEmailResultSet.getString(4)
                }

?

[tddmonkey]

Use Spring JdbcTemplate?

[pyrkamarcin]

Maybe some tricky method to map response to data class?

[Felipe Assoline]

I would use a mix of the above responses 🙂

[Mike]

Or MyBatis or JOOQ if you want something to manage the mappings more automatically.

[Marc Knaup]

• Move the code into its own function so that you can get rid of the confirmAccountDeletionEmail variable name prefix.
• Show more code how the variables are used. You shouldn’t need var nor have a need for initializing the variable at all if there is no result in the result set. But for that more context is needed 🙂