· 6 years ago · Mar 27, 2019, 10:00 AM
1 private saveNewDataToDatabase() {
2 this.sqlite.create({
3 name: "sekolahku.db",
4 location: "default"
5 }).then((db: SQLiteObject) => {
6 let sqlCreateTable = "CREATE TABLE IF NOT EXISTS siswa(" +
7 "id INTEGER PRIMARY KEY AUTOINCREMENT, " +
8 "nama_depan TEXT, " +
9 "nama_belakang TEXT, " +
10 "no_hp TEXT, " +
11 "email TEXT, " +
12 "jenjang TEXT, " +
13 "gender TEXT, " +
14 "hobi TEXT, " +
15 "alamat TEXT, " +
16 "tgl_lahir TEXT)"
17
18 db.executeSql(sqlCreateTable)
19
20 console.log("Open database successfully");
21 }, error => {
22 console.error("GAGAL COOYYYY : " + JSON.stringify(error));
23 })
24 }