Get it on jitpack DatabaseHelper
SQLite3 db = DatabaseHelper.sqLite3Builder()
.file(new File("database.db"))
.build();
db.connect();
SQLite3 db = DatabaseHelper.sqLite3Builder()
.file(new File("database.db"))
.build();
db.disconnect();
SQLite3 db = new SQLite3(new File("database.db"));
db.connect();
//Inserts into "mycolumn" value "myvalue" in table "mytable"
db.insertData().table("mytable").insert("mycolumn", "myvalue").executeAsync();
SQLite3 db = new SQLite3(new File("database.db"));
db.connect();
//Gets data "PLAYERNAME" and "PLAYERMONEY" where "PLAYERID" is "SOMEID" and hashmap of it
var data = db.getData().table("TABLE")
.columns("PLAYERNAME", "PLAYERMONEY")
.where("PLAYERID", "SOMEID").completeAsync();
data.subscribe(System.out::println);
SQLite3 db = new SQLite3(new File("database.db"));
db.connect();
//Updates "MYCOLUMN" by value "myvalue" in table "TABLE"
db.updateData().table("TABLE").column("MYCOLUMN", "myvalue").executeAsync();
SQLite3 db = new SQLite3(new File("database.db"));
db.connect();
//Deletes every row from table "TABLE" where "ID" is 100
db.deleteData().table("TABLE").where("ID", 100).executeAsync();
SQLite3 db = new SQLite3(new File("database.db"));
db.connect();
//Creates table with column "1COLUMN" that can store TEXT and "2COLUMN" that can store INT
db.createTable().table("TABLE").columns("1COLUMN TEXT", "2COLUMN INT").executeAsync();
SQLite3 db = new SQLite3(new File("database.db"));
db.connect();
//Deletes 2 columns from table "TABLE"
db.deleteColumn().table("TABLE").columns("1COLUMN", "2COLUMN").executeAsync();
SQLite3 db = new SQLite3(new File("database.db"));
db.connect();
//Add to table "TABLE" columns "3COLUMN" that can store text and add "4COLUMN" that can store
db.addColumn().table("TABLE").columns("3COLUMN TEXT", "4COLUMN INT").executeAsync();
If you have any problems join this discord Support or you can contact me on Discord: ThePepeYT#1139.
Xmonpl for all help with Rxjava
dan1st for all help with small fixes