title: Trouble inserting data in a SQLite databae
body: <pre><code>public static void main(String[] args) {
      try {
          Class.forName("org.sqlite.JDBC");  
          connection = DriverManager.getConnection("jdbc:sqlite:C:\\users\\tim\\airline\\flightschedule.db");  
          PreparedStatement statement = connection.prepareStatement("INSERT INTO flights (flightID,departure,arrival)VALUES(?,?,?)");
              statement.setInt(1,5);
              statement.setString(2,"David");
              statement.setString(3,"Ortiz");
              statement.executeUpdate();
  
      } catch (Exception e) {  
          e.printStackTrace();  
      } finally {  
          try {  
              resultSet.close();  
              statement.close();  
              connection.close();  
          } catch (Exception e) {  
              e.printStackTrace();  
          }  
      }
  
  }
  </code></pre>