SQLite jdbc and command_line on windwos

1.Download sqlite-jdbc-(VERSION).jar from https://bitbucket.org/xerial/sqlite-jdbc/downloads then append this jar file into your classpath.

2.Download sqlite-tools-xxx.zip from https://www.sqlite.org/download.html;

3.Create a Java file. Sample.java

    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Statement;

    public class Sample
    {
      public static void main(String[] args)
      {
        Connection connection = null;
        try
        {
          // create a database connection
          connection = DriverManager.getConnection("jdbc:sqlite:sample.db");
          Statement statement = connection.createStatement();
          statement.setQueryTimeout(30);  // set timeout to 30 sec.

          statement.executeUpdate("drop table if exists person");
          statement.executeUpdate("create table person (id integer, name string)");
          statement.executeUpdate("insert into person values(1, 'leo')");
          statement.executeUpdate("insert into person values(2, 'yui')");
          ResultSet rs = statement.executeQuery("select * from person");
          while(rs.next())
          {
            // read the result set
            System.out.println("name = " + rs.getString("name"));
            System.out.println("id = " + rs.getInt("id"));
          }
        }
        catch(SQLException e)
        {
          // if the error message is "out of memory",
          // it probably means no database file is found
          System.err.println(e.getMessage());
        }
        finally
        {
          try
          {
            if(connection != null)
              connection.close();
          }
          catch(SQLException e)
          {
            // connection close failed.
            System.err.println(e.getMessage());
          }
        }
      }
    }

4.Compile and run the Sample.

javac Sample.java
java -classpath ".;sqlite-jdbc-xxx.jar" Sample

5.Trying to run command tool.Double-click *.exe Startup On Windows

sqlite> .open sample.db
sqlite> .tables
person
sqlite> .show
        echo: off
         eqp: off
     explain: auto
     headers: off
        mode: list
   nullvalue: ""
      output: stdout
colseparator: "|"
rowseparator: "\n"
       stats: off
       width:
    filename: sample.db
sqlite> .schema
CREATE TABLE person (id integer, name string);
sqlite> insert into person values(111,'scott');
sqlite>
sqlite> select * from person;
1|leo
2|yui
111|scott
sqlite>
sqlite> .excel
sqlite> select * from person;
sqlite>
sqlite> .quit