Scribd Logo
Upload

Welcome to Scribd!

  • 9 views

    String - XML: Resources String String String

    Uploaded by

    rehan
    The document contains code to create a SQLite database table on an Android application. It defines strings for the table creation statement, an insert statement, and a select statement. The main activity code opens the database, executes the creation and insert statements, then performs a query and iterates through the results to access the field values.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    String - XML: Resources String String String

    Uploaded by

    rehan
    9 views1 page
    The document contains code to create a SQLite database table on an Android application. It defines strings for the table creation statement, an insert statement, and a select statement. The main activity code opens the database, executes the creation and insert statements, then performs a query and iterates through the results to access the field values.

    Original Description:

    this is good

    Original Title

    Mysql Lite

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains code to create a SQLite database table on an Android application. It defines strings for the table creation statement, an insert statement, and a select statement. The main activity code opens the database, executes the creation and insert statements, then performs a query and iterates through the results to access the field values.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    9 views1 page

    String - XML: Resources String String String

    Uploaded by

    rehan
    The document contains code to create a SQLite database table on an Android application. It defines strings for the table creation statement, an insert statement, and a select statement. The main activity code opens the database, executes the creation and insert statements, then performs a query and iterates through the results to access the field values.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 1

    STRING.

    XML

    <resources>
    <string name="app_name">MySQLite</string>
    <string name="create">CREATE TABLE IF NOT EXISTS tbl_student
    (stu_id INTEGER PRIMARY KEY AUTOINCREMENT,
    stu_name VARCHAR(50),
    stu_add VARCHAR(100) NULL,
    stu_gpa FLOAT);
    </string>
    <string name="insert">
    INSERT INTO tbl_student
    VALUES ('SOK visual',
    'phnon penh', 4.0);

    </string>
    <string name="select">SELECT * FROM tbl_student</string>

    </resources>

    MAIN ACTIVITY

    package com.example.rehan.mysqlite;

    import android.database.Cursor;
    import android.database.sqlite.SQLiteDatabase;
    import android.support.v7.app.AppCompatActivity;
    import android.os.Bundle;

    public class MainActivity extends AppCompatActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);

    SQLiteDatabase db = openOrCreateDatabase("Test", MODE_PRIVATE, null);

    db.execSQL(getString(R.string.create));
    db.execSQL(getString(R.string.insert));
    Cursor result = db.rawQuery(getString(R.string.select), null );
    result.moveToFirst();
    while(result.isAfterLast()!= true){
    result.getInt(0);
    result.getString(1);
    result.getString(2);
    result.getFloat(3);

    result.moveToNext();
    }

    }
    }

    You might also like