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
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