Netbeans string concatenation wrap

Newbie & Debugging Questions
#1

Hi guys, I want my string concatenation to be wrapped when I press Alt + Shift + F.

Now I have


rset = cmd.executeQuery(
                    "SELECT COUNT(username) AS found FROM users WHERE username = '" + username + "' AND password = '" + password + "';");

I’d like to get

rset = cmd.executeQuery("SELECT COUNT(username) AS found FROM users WHERE username = '" + 
                        username + "' AND password = '" + password + "';");

How can I do that?

#2

offtopic: study ‘sql injection’ and ‘prepared statements’ or all your base will belong to us.

#3

Yes and security vulnerabilities aside, in NetBeans you can set most formatting preferences by going “Tools|Options” then going to the “Editor” tab and then the “Formatting” sub-tab. There all kinds of options in there for all the various languages you have support installed for. I don’t know if that is there (and off the top of my head, I thought it did it automatically) but if the option exists I recon that is where it will be.