title: Use SQLite to create table failed
body: <p>My project is Java Swing, and it needs a table, so I try to use SQLite.
  And when I use SQLite, it can create a connection but when create table it failed. Please teach me, thanks in advance.</p>
  
  <pre><code>public class SqliteMethod {
  private Connection conn;
  
  private static String Create_Table = "create table if not exists table_message("
          + "_id integer primary key autoincrement," 
          + "name varchar(50)," 
          + "input_id varchar(50),"
          + "picture blob," 
          + "template blob"
          + ")";
  
  public SqliteMethod() {
      try {
  
          Class.forName("org.sqlite.JDBC");
          conn = DriverManager.getConnection("jdbc:sqlite:scanner.db");
  
          Statement stat = conn.createStatement();
          if (!stat.execute(Create_Table))
              System.out.println("create table failed");
          stat.close();
          conn.close();
      } catch (Exception e) {
          e.printStackTrace();
      }
  }
  </code></pre>
  
  <p>The <code>conn</code> is not <code>null</code>, but when it go to create table, it failed</p>
  
  <pre><code>if (!stat.execute(Create_Table))
      System.out.println("create table failed");
  </code></pre>