Langsung ke konten utama

SQLiteDatabase Part2: inserting data into Table Example

Part 2: inserting data into tables

ScreenShots:







Step 1: add the following method in DBAdapter

DBAdapter.java

public long insertValues(String name, String contact) {
              ContentValues values = new ContentValues();
              values.put("name", name);
              values.put("phone", contact);
              return database.insert(DBOpenHelper.SAMPLE_TABLE_NAME, null, values);
       }

Step 2: Create InsertActivity and its respective xml write the following code in xml and Activity

activity_insert.xml

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    tools:context=".InsertActivity" >

    <EditText
        android:id="@+id/insert_editText_name"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_alignParentLeft="true"
        android:layout_alignParentTop="true"
        android:ems="10"
        android:hint="Enter Your Name" >

        <requestFocus />
    </EditText>

    <EditText
        android:id="@+id/insert_editText_contact"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_alignLeft="@+id/insert_editText_name"
        android:layout_below="@+id/insert_editText_name"
        android:layout_marginTop="20dp"
        android:ems="10"
        android:hint="Enter Your Contact Number"
        android:inputType="phone" />

    <Button
        android:id="@+id/insert_button_submit"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignLeft="@+id/insert_editText_contact"
        android:layout_below="@+id/insert_editText_contact"
        android:layout_marginLeft="10dp"
        android:layout_marginTop="24dp"
        android:text="Submit"
        android:onClick="submit" />

    <Button
        android:id="@+id/insert_button_cancel"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignBottom="@+id/insert_button_submit"
        android:layout_alignRight="@+id/insert_editText_contact"
        android:layout_marginRight="10dp"
        android:text="Cancel"
        android:onClick="cancel" />

</RelativeLayout>

InsertActivity.java

packagecom.swamys.databaseexample;

importandroid.app.Activity;
import android.os.Bundle;
import android.view.View;
importandroid.widget.EditText;
importandroid.widget.Toast;

importcom.swamys.database.dbadapter.DBAdapter;

public class InsertActivity extends Activity {

       EditText editText_name, editText_contact;
       String name, contact;
       DBAdapter dbAdapter;

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

              // create references for all the four views
              editText_name = (EditText) findViewById(R.id.insert_editText_name);
              editText_contact = (EditText) findViewById(R.id.insert_editText_contact);

              // create reference for DBAdaper
              dbAdapter = newDBAdapter(getApplicationContext());
       }

       // submit button click listener
       public void submit(View view) {
              name = editText_name.getText().toString();
              contact = editText_contact.getText().toString();

              long response = dbAdapter.insertValues(name, contact);
              if (response == -1) {
                     Toast.makeText(getApplicationContext(), "Data failed to insert",
                                  Toast.LENGTH_LONG).show();
              } else {
                     Toast.makeText(getApplicationContext(),
                                  "Data inserted successfully", Toast.LENGTH_LONG).show();
              }

              finish();
       }

       // cancel button click listener
       public void cancel(View view) {
              finish();
       }

       @Override
       protected void onDestroy() {
              super.onDestroy();
              dbAdapter.closeConnection();
       }

}

Step 3: create button in activity_main.xml name it as insert

activity_main.xml

<Button
        android:id="@+id/main_button_insert"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentTop="true"
        android:layout_centerHorizontal="true"
        android:layout_marginTop="18dp"
        android:text="Insert"
        android:onClick="insert" />


Step 4: add insert(View) method in MainActivity

MainActivity.java

public void insert(View view) {
              Intent intent = new Intent(getApplicationContext(),
                           InsertActivity.class);
              startActivity(intent);
       }

Step 5: Register InsertActivity in Manifest file

Manifest.xml

<?xml version="1.0"encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    package="com.swamys.databaseexample"
    android:versionCode="1"
    android:versionName="1.0" >

    <uses-sdk
        android:minSdkVersion="9"
        android:targetSdkVersion="17" />

    <application
        android:allowBackup="true"
        android:icon="@drawable/ic_launcher"
        android:label="@string/app_name"
        android:theme="@style/AppTheme" >
        <activity
            android:name="com.swamys.databaseexample.MainActivity"
            android:label="@string/app_name" >
            <intent-filter>
                <action android:name="android.intent.action.MAIN"/>

                <category android:name="android.intent.category.LAUNCHER"/>
            </intent-filter>
        </activity>
        <activity
            android:name="com.swamys.databaseexample.InsertActivity"
            android:label="@string/title_activity_insert">
        </activity>
    </application>

</manifest>

Komentar

Posting Komentar

Postingan populer dari blog ini

Android Tutorial: Use LeakCanary to detect memory leaks

Overview The memory leak can be a headache to detect and to resolve, small memory leaks can be hidden and may be seen after a long usage of the application and hunting memory leaks is not a simple task. In this tutorial we will create a leaked application and we will use the LeakCanary library to detect the memory leak. Step 1: add the LeakCanary dependency to the application Modify the app/build.gradle to add the LeakCanary dependency as follows: Step 2: Extend and configure the Application class We need to call LeakCanary.install in onCreate method: Step 3: Create a leaked activity For this we will create a singleton class that saves the context: Then, the main activity (leaked one), will use the singleton and then we'll go to a new activity: Then, in the new activity we'll call System.gc to force the garbage collector in order to accelerate the analysis. Step 4: Retrieve the analysis result A nice notification can be shown: The result can be retrieved from logcat: Source c...
Posting Komentar
Baca selengkapnya

FlatBuffers Android Tutorial

FlatBuffers is an efficient cross platform serialization library for C++, Java, C#, Go, Python and JavaScript. It was originally created at Google for game development and other performance-critical applications. FlatBuffers is Open Source (Apache license V2) and available on GitHub . It's currently used by:   Cocos2d-x , the open source mobile game engine and used to serialize the game data. Facebook uses it for client-server communication in the Android app (see the article) . Fun Propulsion Labs at Google in most of libraries and games. Solution overview  The schema will be defind in JSON format, then it will be converted to FlatBuffer format outside the application The Java classes of the Data model will be generated manually using flatc (FlatBuffer compiler) Step 1: Build FlatBuffers Download the source code in Google’s flatbuffers repository .  The build process is described on Google's documentation FlatBuffers Building .  On MacOS for example: Open the ...
Posting Komentar
Baca selengkapnya

Download file using Okio in Android

Okio is a library that complements java.io and java.nio to make it much easier to access, store, and process your data. Simply Okio is a modern I/O API for Java.  In this post, we will see how to download image or any file using Okio. Okio is component for OkHttp Coding Part Create a new project in Android Studio. Add following dependencies to your  app-level  build.gradle  file. compile 'com.squareup.okhttp3:okhttp:3.6.0' Don't forget to add the following permission in your AndroidManifest.xml <uses-permission android:name="android.permission.INTERNET"/> <uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE"/> Implementation Paste the following code in your Activity and Here, I have kept as MainActivity.java public void downloadImg(View view) { try { Request request = new Request.Builder() .url(imageLink) .build(); new OkHttpClient().newCall(request).enqueue(new Callback() { @Override public void onFail...
Posting Komentar
Baca selengkapnya