sqlite3创建数据库

1.将sqlite3.exe目录添加到环境变量中
2.创建数据库：sqlite3.exe everyDayTasks.db
提示：
SQLite version 3.15.2 2016-11-28 19:13:37
Enter ".help" for usage hints.


C:\Users\Malt>sqlite3 everyDayTaks.db
SQLite version 3.15.2 2016-11-28 19:13:37
Enter ".help" for usage hints.
sqlite> create table test(name char(10), age smallint, score float);
sqlite> insert into test values('yanggang', 24, 98);
sqlite> select * from test;
yanggang|24|98.0
sqlite> ^C


注意：db文件存储在执行命令行下面，如下：
dbType=sqlite
validationQuery=SELECT 'x'

jdbc.driverClassName=org.sqlite.JDBC
jdbc.url=jdbc:sqlite:C:/Documents and Settings/Malt/everyDayTasks.db
jdbc.username=root
jdbc.password=root