sqlite - downgoon/hello-world GitHub Wiki
linux 和 mac 下无需安装就默认有了。
如果没有，在mac下 brew install sqlite 即自动安装。
或者下载 sqlite-autoconf-3071502.tar.gz后安装：
$tar xvfz sqlite-autoconf-3071502.tar.gz
$cd sqlite-autoconf-3071502
$./configure --prefix=/usr/local
$make
$make install
$ sqlite3 test.db
此命令，如果当前目录有test.db文件，则表示连接到数据库；否则，表示创建数据库。
创建表：
create table mytable(id integer primary key, value text);
INSERT INTO "mytable" VALUES(1,'Micheal');
INSERT INTO "mytable" VALUES(2,'Jenny');
INSERT INTO "mytable" VALUES(3,'Francis');
INSERT INTO "mytable" VALUES(4,'Kerk');
- 备份数据库：
sqlite3 test.db .dump > backup.sql
- 恢复数据库
sqlite3 recovery.db < backup.sql
- 查看数据
$ sqlite3 recovery.db
SQLite version 3.8.5 2014-08-15 22:37:57
Enter ".help" for usage hints.
sqlite> .table
mytable
sqlite> select * from mytable
...> ;
1|Micheal
2|Jenny
3|Francis
4|Kerk
$ git checkout sqlite
$ git checkout sqlite-c1-jdbc
<dependency>
<groupId>org.xerial</groupId>
<artifactId>sqlite-jdbc</artifactId>
<version>3.15.1</version>
</dependency>
Class.forName("org.sqlite.JDBC");
Connection conn = DriverManager.getConnection("jdbc:sqlite:test.db");
final String sql = "SELECT * FROM mytable;";
Statement statement = conn.createStatement();
ResultSet rs = statement.executeQuery(sql);
while (rs.next()) {
/* index number started from 1 rather than 0 */
String name = rs.getString(2);
System.out.println(name);
}
rs.close();
statement.close();
conn.close();