title: Prefix-concatenate in SQL for prepared statement
body: <p>How do i concatenate in jdbc sql? For example. I want the title to have a string/characters before it. So it would be like <code>"0001-title"</code>. I want that value to be stored inside a variable so that i can easily change it. I also what the value to be increment for over a time.  Is there a way on how to do this? </p>
  
  <p>Here's what i've tried so far but no luck. please help!</p>
  
  <pre><code>public void update(String title, String artist, String album){
   String SQL = "INSERT INTO music(title, artist, album) VALUES(?, ?, ?);
  jdbcTemplateObject.update(SQL, title, artist, album);
  return;
  }
  </code></pre>