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)"); ...