Skip to main content

Sqlite database connection to Android Studio

IN THIS PROJECT THERE ARE TWO FILES 
FIRST IS TO CREATE A DATABASE AND CONNECT TO DATABASE
SECOND IS JAVA FILE

Mainactivity.java file


package com.example.programmingknowledge.sqliteapp;

import android.app.AlertDialog;
import android.database.Cursor;
import android.support.v7.app.ActionBarActivity;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;


public class MainActivity extends ActionBarActivity {
    DatabaseHelper myDb;
    EditText editName,editSurname,editMarks ,editTextId;
    Button btnAddData;
    Button btnviewAll;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        myDb = new DatabaseHelper(this);

        editName = (EditText)findViewById(R.id.editText_name);
        editSurname = (EditText)findViewById(R.id.editText_surname);
        editMarks = (EditText)findViewById(R.id.editText_Marks);
        editTextId = (EditText)findViewById(R.id.editText_id);
        btnAddData = (Button)findViewById(R.id.button_add);
        btnviewAll = (Button)findViewById(R.id.button_viewAll);
        AddData();
        viewAll();
    }
    public  void AddData() {
        btnAddData.setOnClickListener(
                new View.OnClickListener() {
                    @Override
                    public void onClick(View v) {
                       boolean isInserted = myDb.insertData(editName.getText().toString(),
                                editSurname.getText().toString(),
                                editMarks.getText().toString() );
                        if(isInserted == true)
                            Toast.makeText(MainActivity.this,"Data Inserted",Toast.LENGTH_LONG).show();
                        else
                            Toast.makeText(MainActivity.this,"Data not Inserted",Toast.LENGTH_LONG).show();
                    }
                }
        );
    }

    public void viewAll() {
        btnviewAll.setOnClickListener(
                new View.OnClickListener() {
                    @Override
                    public void onClick(View v) {
                       Cursor res = myDb.getAllData();
                        if(res.getCount() == 0) {
                            // show message
                            showMessage("Error","Nothing found");
                            return;
                        }

                        StringBuffer buffer = new StringBuffer();
                        while (res.moveToNext()) {
                            buffer.append("Id :"+ res.getString(0)+"\n");
                            buffer.append("Name :"+ res.getString(1)+"\n");
                            buffer.append("Surname :"+ res.getString(2)+"\n");
                            buffer.append("Marks :"+ res.getString(3)+"\n\n");
                        }

                        // Show all data
                        showMessage("Data",buffer.toString());
                    }
                }
        );
    }

    public void showMessage(String title,String Message){
        AlertDialog.Builder builder = new AlertDialog.Builder(this);
        builder.setCancelable(true);
        builder.setTitle(title);
        builder.setMessage(Message);
        builder.show();
    }


    @Override
    public boolean onCreateOptionsMenu(Menu menu) {
        // Inflate the menu; this adds items to the action bar if it is present.
        getMenuInflater().inflate(R.menu.menu_main, menu);
        return true;
    }

    @Override
    public boolean onOptionsItemSelected(MenuItem item) {
        // Handle action bar item clicks here. The action bar will
        // automatically handle clicks on the Home/Up button, so long
        // as you specify a parent activity in AndroidManifest.xml.
        int id = item.getItemId();

        //noinspection SimplifiableIfStatement
        if (id == R.id.action_settings) {
            return true;
        }

        return super.onOptionsItemSelected(item);
    }
}



Databasehelper.java file
//this file create database  as well as modify that data.


package com.example.programmingknowledge.sqliteapp;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

/**
 * Created by ProgrammingKnowledge on 4/3/2015.
 */
public class DatabaseHelper extends SQLiteOpenHelper {
    public static final String DATABASE_NAME = "Student.db";
    public static final String TABLE_NAME = "student_table";
    public static final String COL_1 = "ID";
    public static final String COL_2 = "NAME";
    public static final String COL_3 = "SURNAME";
    public static final String COL_4 = "MARKS";

    public DatabaseHelper(Context context) {
        super(context, DATABASE_NAME, null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table " + TABLE_NAME +" (ID INTEGER PRIMARY KEY AUTOINCREMENT,NAME TEXT,SURNAME TEXT,MARKS INTEGER)");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS "+TABLE_NAME);
        onCreate(db);
    }

    public boolean insertData(String name,String surname,String marks) {
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        contentValues.put(COL_2,name);
        contentValues.put(COL_3,surname);
        contentValues.put(COL_4,marks);
        long result = db.insert(TABLE_NAME,null ,contentValues);
        if(result == -1)
            return false;
        else
            return true;
    }

    public Cursor getAllData() {
        SQLiteDatabase db = this.getWritableDatabase();
        Cursor res = db.rawQuery("select * from "+TABLE_NAME,null);
        return res;
    }

  
}

Xml file

<?xml version="1.0" encoding="utf-8"?><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=".MainActivity">

    <TextView        android:layout_width="wrap_content"        android:layout_height="wrap_content"        android:textAppearance="?android:attr/textAppearanceLarge"        android:text="Name"        android:id="@+id/textView"        android:layout_alignParentTop="true"        android:layout_alignParentLeft="true"        android:layout_alignParentStart="true" />

    <TextView        android:layout_width="wrap_content"        android:layout_height="wrap_content"        android:textAppearance="?android:attr/textAppearanceLarge"        android:text="Surname"        android:id="@+id/textView2"        android:layout_below="@+id/editText_name"        android:layout_alignParentLeft="true"        android:layout_alignParentStart="true" />

    <TextView        android:layout_width="wrap_content"        android:layout_height="wrap_content"        android:textAppearance="?android:attr/textAppearanceLarge"        android:text="Marks"        android:id="@+id/textView3"        android:layout_below="@+id/editText_surname"        android:layout_alignParentLeft="true"        android:layout_alignParentStart="true" />

    <EditText        android:layout_width="match_parent"        android:layout_height="wrap_content"        android:id="@+id/editText_name"        android:layout_alignTop="@+id/textView"        android:layout_toRightOf="@+id/textView"        android:layout_toEndOf="@+id/textView" />

    <EditText        android:layout_width="match_parent"        android:layout_height="wrap_content"        android:id="@+id/editText_surname"        android:layout_alignTop="@+id/textView2"        android:layout_toRightOf="@+id/textView2"        android:layout_toEndOf="@+id/textView2" />

    <EditText        android:layout_width="match_parent"        android:layout_height="wrap_content"        android:id="@+id/editText_Marks"        android:layout_below="@+id/editText_surname"        android:layout_toRightOf="@+id/textView3"        android:layout_toEndOf="@+id/textView3" />

    <Button        android:layout_width="wrap_content"        android:layout_height="wrap_content"        android:text="Add Data"        android:id="@+id/button_add"        android:layout_below="@+id/editText_Marks"        android:layout_alignParentLeft="true"        android:layout_alignParentStart="true"        android:layout_marginTop="76dp" />

    <Button        android:layout_width="wrap_content"        android:layout_height="wrap_content"        android:text="View All"        android:id="@+id/button_viewAll"        android:layout_above="@+id/button_update"        android:layout_centerHorizontal="true" />

  

    <TextView        android:layout_width="wrap_content"        android:layout_height="wrap_content"        android:textAppearance="?android:attr/textAppearanceLarge"        android:text="id"        android:id="@+id/textView_id"        android:layout_below="@+id/editText_Marks"        android:layout_alignParentLeft="true"        android:layout_alignParentStart="true" />

    <EditText        android:layout_width="match_parent"        android:layout_height="wrap_content"        android:id="@+id/editText_id"        android:layout_alignTop="@+id/textView_id"        android:layout_toRightOf="@+id/textView3"        android:layout_toEndOf="@+id/textView3" />

</RelativeLayout>






Demo image





















































Comments











Post a Comment























Popular posts from this blog





















RecyclerView in Android




























     #Java class  #In this file we connect model class and viewholdw class to show in recyclerview  public class AdminProductShow extends AppCompatActivity {       private Query ProductsRef ;     private RecyclerView recyclerView ;     RecyclerView.LayoutManager layoutManager ;      @Override     protected void onCreate(Bundle savedInstanceState) {         super .onCreate(savedInstanceState);         setContentView(R.layout. activity_admin_product_show );           ProductsRef = FirebaseDatabase. getInstance ().getReference( "Products" );          recyclerView = findViewById(R.id. allProduct_recyclerview );         recyclerView .setHasFixedSize( true );         layoutManager = new LinearLayoutManager( this );         recyclerView .setLayoutManager( layoutManager );       }      protected void onStart() {         super .onStart();          final DatabaseReference AdminProductsRef = FirebaseDatabase. getInstance ().getReference( "Products" );           FirebaseRecycle...




















Post a Comment









Read more






























Register page in Android Studio using Firebase Databse




























          #Register page in android Studio  #Connect your project to firebase database  #Here typed add data in store in your firebase storage as node    public class RegisterActivity extends AppCompatActivity {      private Button CreateAccountButton;     private EditText InputName,InputPhoneNumber, InputPassword;     private ProgressDialog loadingBar;      @Override     protected void onCreate(Bundle savedInstanceState) {         super .onCreate(savedInstanceState);         setContentView(R.layout.activity_register);          CreateAccountButton = (Button) findViewById(R.id.register_btn);         InputName = (EditText) findViewById(R.id.register_username_input);         InputPassword = (EditText) findViewById(R.id.register_password_input);         InputPhoneNumber = (EditText) findViewById(R.id.register_phone_number_input);         loadingBar = new ProgressDialog( this );             CreateAccountButton.setOnClickListener( new View.OnClickListener() {             @Override           ...




















Post a Comment









Read more




























MyWaah Marathi




























Privacy Policy Mihir Vaste built the Waah Marathi app as a Free app. This SERVICE is provided by Mihir Vaste at no cost and is intended for use as is. This page is used to inform visitors regarding my policies with the collection, use, and disclosure of Personal Information if anyone decided to use my Service. If you choose to use my Service, then you agree to the collection and use of information in relation to this policy. The Personal Information that I collect is used for providing and improving the Service. I will not use or share your information with anyone except as described in this Privacy Policy. The terms used in this Privacy Policy have the same meanings as in our Terms and Conditions, which is accessible at Waah Marathi unless otherwise defined in this Privacy Policy. Information Collection and Use For a better experience, while using our Service, I may require you to provide us with certain personally identifiable information, including but not limited to location,intern...




















Post a Comment









Read more