By

Contents
  1. 1. usage
  2. 2. JDBC

usage

yum install sqlite

1
2
3
4
5
6
7
8
9
10
11
12
sqlite3 test.db
.header on
create table stu(id int, name char, sex char , score int);
insert into stu values(1001, 'zhangsan', 'm', 89);
select * from stu where id=1001;
delete from stu where id=1004;
update stu set score=98 where id=1003;
.database
.table
.schema stu
select * from sqlite_master
drop  table  stu;

JDBC

xerial/sqlite-jdbc: SQLite JDBC Driver (github.com)

jdbc:sqlite:/home/leo/work/mydatabase.db
org.sqlite.JDBC