title: Running SQL files scripts from a Java program
body: <p>I have a set of SQL files that transform my original dataset. Currently, I open each file and execute it. How can I execute each file inside a Java program? The goal is to make this process a lot more automatic. </p>
  
  <p>I would like to do something like <code>SqlScript.execute("myScript.sql");</code></p>
  
  <p><strong>NOTE</strong> these SQL scripts act on one database. I assume I would have to pass some kind of connection string. I am using MySQL.</p>
  
  <ol>
  <li>What objects, libraries, packages, etc... do I need to perform this inside Java?</li>
  </ol>