How to create multiple Tables in a database Sqlite Android Tutorial



How to create multiple Tables in a database Sqlite Android Tutorial

How to create multiple Tables in a database Sqlite Android Tutorial

How to create multiple Tables in a database Sqlite Android Tutorial

class MainActivity : AppCompatActivity() {
var desFile: File? = null
var myFile: File? = null
var db: SQLiteDatabase? = null

override fun onCreate(savedInstanceState: Bundle?) {
super.onCreate(savedInstanceState)
setContentView(R.layout.activity_main)
}

fun createDb(view: View) {
val folder = File(getExternalFilesDir(Environment.DIRECTORY_DOCUMENTS).toString()+”/Database”)
if (!folder.exists()) {
folder.mkdir()
} else {
//Toast.makeText(this, folder.absolutePath.toString(), Toast.LENGTH_LONG).show()
}
myFile = File(folder,”Test.db”)
db = SQLiteDatabase.openOrCreateDatabase(myFile!!.absolutePath,null,null)
CreateTable()
@SuppressLint(“Recycle”)
var cursor =
db!!.rawQuery(“SELECT name FROM sqlite_master WHERE type=’table’ “, null)
if (cursor.getCount() != 0)
{
Toast.makeText(this,”TOTAL Table = ” + cursor.getCount().toString(), Toast.LENGTH_LONG).show()

}
}

fun CreateTable(){
var create_table : String
create_table =
“CREATE TABLE IF NOT EXISTS item (itmid INTEGER PRIMARY KEY AUTOINCREMENT, classid INTEGER, itmname TEXT,” +
“rate REAL,itmunit TEXT, itmimg BLOB) ”
db!!.execSQL(create_table)
create_table =
“CREATE TABLE IF NOT EXISTS category (catid INTEGER PRIMARY KEY AUTOINCREMENT, catname TEXT, classid INTEGER)”
db!!.execSQL(create_table)
create_table =
“CREATE TABLE IF NOT EXISTS ledgers (ldid INTEGER PRIMARY KEY AUTOINCREMENT, classid INTEGER, ldname TEXT, ldaddrs TEXT, ldstate TEXT,” +
” mobileno TEXT opbl REAL)”
db!!.execSQL(create_table)

}

}

Comments are closed.