Skip to main content

Sqlite Database With Cursor Adapter in Android








First Create Database Helper :



now in your first layout : res/main.xml

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:orientation="vertical"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    >
    <ListView
    android:layout_height="fill_parent"
    android:id="@+id/@android:list"
    android:layout_width="fill_parent"></ListView>
</LinearLayout>

second layout for insert Values: res/inslayout.xml

<?xml version="1.0" encoding="UTF-8"?>
    <RelativeLayout android:id="@+id/relativeLayout1"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    xmlns:android="http://schemas.android.com/apk/res/android">
   
        <EditText android:hint="Enter Your Name"
       
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentTop="true"
        android:layout_alignParentLeft="true"
        android:layout_marginTop="14dp"
        android:layout_alignParentRight="true"
        android:id="@+id/insName">
            <requestFocus></requestFocus>
        </EditText>
       
        <EditText android:hint="Enter Your Number"
        android:layout_width="wrap_content"
        android:inputType="phone"
        android:layout_height="wrap_content"
        android:layout_below="@+id/insName"
        android:layout_alignParentLeft="true"
        android:layout_marginTop="17dp"
        android:layout_alignParentRight="true"
        android:id="@+id/insNumber"></EditText>
       
        <Button android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_below="@+id/insNumber"
        android:layout_alignParentLeft="true"
        android:text="@string/Add_User"
        android:id="@+id/insBtn"></Button>
       
        <Button android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignTop="@+id/insBtn"
        android:layout_alignParentRight="true"
        android:id="@+id/insCancel"
        android:text="@string/Cancle"></Button>
       
    </RelativeLayout>

now third Layout for Edit Values : res/editlayout.xml

<?xml version="1.0" encoding="UTF-8"?>
    <RelativeLayout android:id="@+id/relativeLayout1"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    xmlns:android="http://schemas.android.com/apk/res/android">
        <EditText
        android:layout_height="wrap_content"
        android:layout_width="wrap_content"
        android:layout_alignParentTop="true"
        android:layout_alignParentLeft="true"
        android:layout_marginTop="15dp"
        android:layout_alignParentRight="true"
        android:id="@+id/Ename">
            <requestFocus></requestFocus>
        </EditText>
        <EditText
        android:layout_height="wrap_content"
        android:layout_width="wrap_content"
        android:inputType="phone"
        android:layout_below="@+id/Ename"
        android:layout_alignParentLeft="true"
        android:layout_alignParentRight="true"
        android:id="@+id/Enumber">
           
        </EditText>
        <Button
        android:layout_height="wrap_content"
        android:layout_width="wrap_content"
        android:layout_below="@+id/Enumber"
        android:layout_alignParentLeft="true"
        android:id="@+id/Eok"
        android:text="@string/OK"></Button>
        <Button
        android:layout_height="wrap_content"
        android:layout_width="wrap_content"
        android:layout_below="@+id/Enumber"
        android:layout_alignParentRight="true"
        android:id="@+id/Ecancle"
        android:text="@string/Cancle"></Button>
        <Button
        android:layout_height="wrap_content"
        android:layout_width="wrap_content"
        android:layout_alignTop="@+id/Ecancle"
        android:layout_centerHorizontal="true"
        android:id="@+id/EDelete"
        android:text="@string/Delete"></Button>
    </RelativeLayout>

now in your main Activity :


Comments

Popular posts from this blog

Android - Google MAP V2 PART 3 (add Polyline)

Download Full Code  of  PART-1 , 2 , 3 , 4 Before go ahead Please look in to PART-1 & PART-2 I have just modify Main Activity class: package com.djandroid.mapsv2; import android.graphics.Color; import android.os.Bundle; import android.support.v4.app.FragmentActivity; import android.support.v4.app.FragmentManager; import com.google.android.gms.maps.GoogleMap; import com.google.android.gms.maps.GoogleMap.OnMapClickListener; import com.google.android.gms.maps.GoogleMap.OnMarkerClickListener; import com.google.android.gms.maps.SupportMapFragment; import com.google.android.gms.maps.model.LatLng; import com.google.android.gms.maps.model.Marker; import com.google.android.gms.maps.model.MarkerOptions; import com.google.android.gms.maps.model.Polyline; import com.google.android.gms.maps.model.PolylineOptions; public class MainActivity extends FragmentActivity { private GoogleMap MAP; private boolean markClic...

Android show Data from Sqlite DB into Grid View

Shaadi.com Matrimonials Shaadi.com Indian Matrimonials Your Main Activity class package com . Sqlite_grid_view ; import java . util . ArrayList ; import java . util . List ; import android . app . Activity ; import android . os . Bundle ; import android . util . Log ; import android . view . View ; import android . widget . AdapterView ; import android . widget . AdapterView . OnItemClickListener ; import android . widget . ArrayAdapter ; import android . widget . GridView ; import android . widget . TextView ; import android . widget . Toast ; public class AndroidSQLiteTutorialActivity extends Activity { private GridView gridView ; public static ArrayList < String > ArrayofName = new ArrayList < String >(); /** Called when the activity is first created. */ @ Override public void onCreate ( Bundle savedInstanceState ) { super . onCreate ( savedInstanceState ); setContentView ( R . l...

Connecting mysql Database in ANDROID using PHP & JSON

 To implement this tutorial you should have basic knowledge of how to run PHP script and start server.  If we talk about client-server architecture, client is Android device and in server side there is a combination of PHP Script and MySQL. In short, PHP Script sits in middle as shown in image. Lets suppose that we have a MySQL database named Employee, and a table int created, with the following SQL: CREATE TABLE `employee` (   `emp_id` int(11) NOT NULL auto_increment,   `emp_name` varchar(100) NOT NULL,   PRIMARY KEY  (`emp_id`) ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; The PHP code will be very simple: Now Create Android Project :  The Android part is only a bit more complicated: -use a HttpPost to get the data -convert response to string -parse JSON data in to List In Your First Activity : O/P :