by ·0 Yorum

Tamamını indir

package com.example.ali.kopyalakaydet.Service;

import android.app.Service;
import android.content.ClipData;
import android.content.ClipboardManager;
import android.content.ContentValues;
import android.content.Intent;
import android.database.sqlite.SQLiteDatabase;
import android.os.IBinder;
import android.support.annotation.Nullable;
import android.widget.Toast;
import com.example.ali.kopyalakaydet.Database.database;
import java.text.SimpleDateFormat;
import java.util.Date;
public class KopyalaService extends Service {
    ClipboardManager cm;
    SQLiteDatabase db;
    database vt;
    @Nullable
    @Override
    public IBinder onBind(Intent ıntent) {
        return null;
    }

    @Override
    public void onCreate() {
        super.onCreate();
    }

    @Override
    public int onStartCommand(Intent intent, int flags, int startId) {
        cm = (ClipboardManager) getSystemService(Service.CLIPBOARD_SERVICE);

                    cm.addPrimaryClipChangedListener(new ClipboardManager.OnPrimaryClipChangedListener() {
                        @Override
                        public void onPrimaryClipChanged() {
                           try {
                               vt = new database(getApplicationContext());
                               db = vt.getWritableDatabase();
                               ClipData cd = cm.getPrimaryClip();
                               String item=cd.getItemAt(0).getText() + "";
                               ContentValues par=new ContentValues();
                               par.put("ITEM",item);
                               SimpleDateFormat frm=new SimpleDateFormat("yyyy-MM-dd");
                               par.put("DATE",frm.format(new Date()));
                               db.insertOrThrow("COPYITEMS",null,par);
                               Toast.makeText(getApplicationContext(),item+" Kayıt Edildi.", Toast.LENGTH_LONG).show();
                               db.close();
                           }
                           catch (Exception ex)
                           {
                               Toast.makeText(getApplicationContext(),"Hata="+ex.getMessage(), Toast.LENGTH_LONG).show();
                           }
                           }
                    });

      return  super.onStartCommand(intent, flags, startId);
    }

}

 

by ·0 Yorum

Puantaj APK indir
Puantaj Uygulaması Kaynak Kodları indir

package com.example.ali.puantajuygulamas;

import android.app.AlertDialog;
import android.app.DatePickerDialog;
import android.content.ContentValues;
import android.content.Context;
import android.content.DialogInterface;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.support.v7.app.AppCompatActivity;
import android.view.View;
import android.widget.AdapterView;
import android.widget.Button;
import android.widget.DatePicker;
import android.widget.EditText;
import android.widget.LinearLayout;
import android.widget.ListView;
import android.widget.TextView;
import android.widget.Toast;
import adepter.adepter;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.List;
import puantaj.Puantaj;
import veritabani.database;

public class MainActivity extends AppCompatActivity implements View.OnClickListener,AdapterView.OnItemClickListener {
    public Button[] btn;
    public ListView lv;
    public EditText[] et,gun_et;
    static ArrayList<Puantaj> liste;
    DatePickerDialog trh;
    public static adepter adp;
    static Calendar clr;
    static database vt;
    static SQLiteDatabase db;
    static TextView[] genel_text;
    int[] genel_text_id={R.id.topgun,R.id.topmesai};
    public int btnid[]={R.id.btngun,R.id.btnayrinti};
    public int etid[]={R.id.mesai,R.id.not};
    public static int yilid;
    private static  Context context;
    public static    Date date;
    static ArrayList<Integer> id;
    DatePicker dp;
   @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        dp=(DatePicker)findViewById(R.id.tarih);
        vt=new database(this);
        context=this;
        date=new Date();
        id=new ArrayList<Integer>();
        clr=Calendar.getInstance();
        btn=new Button[btnid.length];
        et=new EditText[etid.length];
        gun_et=new EditText[et.length];
        genel_text=new TextView[genel_text_id.length];
        for(int i=0;i<btnid.length;i++)
        {
            btn[i]=(Button)findViewById(btnid[i]);
            if(i<etid.length) {
                et[i] = (EditText) findViewById(etid[i]);
               genel_text[i]=(TextView)findViewById(genel_text_id[i]);
            }
            btn[i].setOnClickListener(this);
        }
        et[0].setText("0");
        liste=new ArrayList<Puantaj>();
        adp=new adepter(this,liste);
        lv=(ListView)findViewById(R.id.list);
        lv.setAdapter(adp);
        datagetir();
        geneltoplam(genel_text,liste);
        lv.setOnItemClickListener(this);
   }
    @Override
    public void onClick(View view) {
     switch (view.getId())
     {
         case R.id.btngun:ekle();break;
         case R.id.btnayrinti:ayrinti();break;
     }
    }
    public static void baglan()
    {
        try {
            vt=new database(context);
            db=vt.getWritableDatabase();
        }catch (Exception ex)
        {
            Toast.makeText(context,ex.getMessage(),Toast.LENGTH_LONG).show();
        }
    }
    public void ayrinti()
    {
       Intent frm=new Intent(this,Main2Activity.class);
       startActivity(frm);
    }
    public static boolean checkdata1()
    {
        try {
            baglan();
            Cursor c=db.rawQuery("select yilid from Yil where yil=?",new String[] {clr.get(Calendar.YEAR)+""});
            c.moveToPosition(-1);
            while(c.moveToNext())
            {
                yilid=c.getInt(0);
                c.close();
                db.close();
                return false;
            }
          c.close();
          db.close();
        }catch (Exception ex)
        {
            Toast.makeText(context,ex.getMessage(),Toast.LENGTH_LONG).show();
        }
        //önceden bu tarih eklenmmemis
        return  true;
    }
    public boolean checkdata2(String gun)
    {  //Aynı gün eklenmesini engelliyoruz
        try {
            baglan();
            Cursor c=db.query("Puantaj",new String[]{"id"},"yilid=? and gun like ?",new String[]{yilid+"",gun+"%"},null,null,null);
            c.moveToPosition(-1);
            while(c.moveToNext())
            {
                c.close();
                db.close();
                return false;
            }
            c.close();
            db.close();
        }catch (Exception ex)
        {
            Toast.makeText(this,ex.getMessage(),Toast.LENGTH_LONG).show();
        }

        return  true;
    }
    public String trh_cevir(int y,int a,int g)
    {  String tarih=y+"";
        if(a<10)
            tarih+="0"+a;
        else
            tarih+=a;
        if(g<10)
            tarih+="0"+g;
        else
            tarih+=g;
 return tarih;
    }
public void ekle()
{
  if(et[0].getText().length()>0) {
    try { //Yıl ve ay ekliyoruz
        double mesai=Double.parseDouble(et[0].getText()+"");
        String tarih=trh_cevir(dp.getYear(),dp.getMonth()+1,dp.getDayOfMonth());
        if (checkdata1()) { //yil ve gün eklenecek
       baglan();
       ContentValues par1=new ContentValues();
       par1.put("yil",clr.get(Calendar.YEAR));
       db.insertOrThrow("Yil",null,par1);
       db.close();
       checkdata1();
            baglan();
            ContentValues par=new ContentValues();
            par.put("gun",tarih);
            par.put("mesai",mesai);
            par.put("yilid",yilid);
            par.put("gunluk",et[1].getText()+"");
            long tran=  db.insertOrThrow("Puantaj",null,par);
            db.close();
            datagetir();
            et[1].setText("");
            et[0].setText("0");
        } else {
            //normal sadece gün ekleniyor
            if(checkdata2(tarih)) {
                baglan();
                ContentValues par = new ContentValues();
                par.put("gun", tarih);
                par.put("mesai", mesai);
                par.put("yilid", yilid);
                par.put("gunluk", et[1].getText() + "");
                long tran = db.insertOrThrow("Puantaj", null, par);
                db.close();
                datagetir();
                et[1].setText("");
                et[0].setText("0");
            }
            else
                Toast.makeText(this,"Aynı Tarih Eklenemez!!!", Toast.LENGTH_LONG).show();
        }
    } catch (Exception ex) {
        Toast.makeText(this, ex.getMessage(), Toast.LENGTH_LONG).show();
    }

}

}

public static void datagetir()
{
    try {
        DateFormat frmt=new SimpleDateFormat("yyyyMM");
        String tarih=frmt.format(date);
        tarih+="%";
        checkdata1();
        baglan();
        Cursor c=db.query("Puantaj",new String[]{"gun","mesai","gunluk","id"},"gun like ? and yilid=?",new String[]{tarih,yilid+""},null,null,"gun ASC");
        liste.clear();
        id.clear();
        adp.notifyDataSetChanged();
        c.moveToPosition(-1);
        while(c.moveToNext())
        {
             String tarih1=c.getString(0);
             String tarih2=tarih1.substring(0,4)+"/";
             tarih2+=tarih1.substring(4,6)+"/";
             tarih2+=tarih1.substring(6,8);
           liste.add(new Puantaj(tarih2,c.getDouble(1),c.getString(2)));
            id.add(c.getInt(3));
        }
        c.close();
        db.close();
        geneltoplam(genel_text,liste);
}catch (Exception ex)
    {
        Toast.makeText(context, ex.getMessage(), Toast.LENGTH_LONG).show();
    }
}
public void guncelle(String gun,String  mesai,String not,int secilen_id)
{    if(gun.length()>0&&mesai.length()>0)//gün ve mesai' yi kontrol ediyoruz
{     double gmesai=Double.parseDouble(mesai);
    try {
        if(checkdata2(gun)) {
            baglan();
            ContentValues par = new ContentValues();
            par.put("gun", gun);
            par.put("mesai", gmesai);
            par.put("gunluk", not);
            db.update("Puantaj", par, "id=?", new String[]{"" + secilen_id});
            db.close();
            datagetir();
        }
        else
        {
            Toast.makeText(this,"Aynı Tarih Güncellenemez ve not veya mesai güncellendi", Toast.LENGTH_LONG).show();
            baglan();
            ContentValues par = new ContentValues();
            par.put("mesai", gmesai);
            par.put("gunluk", not);
            db.update("Puantaj", par, "id=?", new String[]{"" + secilen_id});
            db.close();
            datagetir();
        }


    }catch (Exception ex)
    {
        Toast.makeText(this, ex.getMessage(), Toast.LENGTH_LONG).show();
    }
}
else
    Toast.makeText(this, "Lütfen Değerleri Doğru Giriniz!!!", Toast.LENGTH_LONG).show();
}
//tıklanan notu dialogta gösteriyoruz
public static void notgoster(String not)
{
    if(not.length()>0) {
        LinearLayout layout = new LinearLayout(context);
        TextView tgunluk = new TextView(context);
        tgunluk.setText(not);
        layout.addView(tgunluk);
        AlertDialog.Builder dialog = new AlertDialog.Builder(context);
        dialog.setTitle("NOT");
        dialog.setCancelable(true);
        dialog.setView(layout);
        dialog.create().show();
    }
    else
        Toast.makeText(context,"Bu güne ait herhangi bir not yok!!",Toast.LENGTH_LONG).show();

}
public void sil(int sil_indis)
{
    try {
        baglan();
        db.delete("Puantaj","id=?",new String[]{id.get(sil_indis)+""});
        db.close();
        datagetir();
    }catch (Exception ex)
    {
        Toast.makeText(this, ex.getMessage(), Toast.LENGTH_LONG).show();
    }
}
//toplam gün ve mesai
public static void geneltoplam(TextView[] genel,ArrayList<Puantaj> liste)
{
    String[] ay=Main2Activity.aylar;
    SimpleDateFormat sdf=new SimpleDateFormat("MM");
    final int tarih=Integer.parseInt(sdf.format(date));
    genel[0].setText(ay[tarih-1]+" ay'ı Toplam="+liste.size()+" gün");
    double mesaitop=0.0;
    for(int i=0;i<liste.size();i++)
    {
        Puantaj p=liste.get(i);
        mesaitop+=p.mesai;
    }
   genel[1].setText("Mesai Toplam="+mesaitop+" saat");
}
String secilen_tarih;
   int secilen_indis;
    String[] dt;
   @Override
   //Listview in tıklanma olayı
    public void onItemClick(AdapterView<?> adapterView, View view, int i, long l) {
      Puantaj k=liste.get(i);
    final   String[] dt={k.gun.substring(0,4),k.gun.substring(5,7),k.gun.substring(8,10)};
      secilen_tarih=dt[0]+dt[1]+dt[2];
       secilen_indis=i;
       Puantaj p=liste.get(i);
       double mesai=p.mesai;
       String not=p.not;
        LinearLayout layout = new LinearLayout(context);
        layout.setOrientation(LinearLayout.VERTICAL);
        Button btn_tarih=new Button(this);
        btn_tarih.setText("Gün Seçiniz");
        btn_tarih.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                trh=new DatePickerDialog(context, new DatePickerDialog.OnDateSetListener() {
                    @Override
                    public void onDateSet(DatePicker datePicker, int i, int i1, int i2) {
                       secilen_tarih=trh_cevir(i,(i1+1),i2);

                    }
                },Integer.parseInt(dt[0]),Integer.parseInt(dt[1])-1,Integer.parseInt(dt[2]));
                trh.setTitle("Tarih Seciniz");
                trh.setButton(DatePickerDialog.BUTTON_POSITIVE,"Ayarla",trh);
                trh.setButton(DatePickerDialog.BUTTON_NEGATIVE,"Iptal",trh);
                trh.show();
            }
        });
        layout.addView(btn_tarih);
        for(int a=0;a<gun_et.length;a++)
        {
            gun_et[a]=new EditText(this);
           layout.addView(gun_et[a]);
        }
        gun_et[0].setText(mesai+"");
        gun_et[1].setText(not);
        final AlertDialog.Builder dialog = new AlertDialog.Builder(context);
        dialog.setTitle("Düzenle veya Sil");
        dialog.setCancelable(true);
        dialog.setView(layout);
        dialog.setPositiveButton("Düzenle", new DialogInterface.OnClickListener() {
            @Override
            public void onClick(DialogInterface dialogInterface, int i) {
                   if(secilen_tarih.length()>0)
                   {
                       guncelle(secilen_tarih,gun_et[0].getText()+"",gun_et[1].getText()+"",id.get(secilen_indis));
                   }
                   else
                       Toast.makeText(getApplicationContext(), "Lütfen Tarihi Seçiniz", Toast.LENGTH_LONG).show();
            }
        });
        dialog.setNegativeButton("Sil", new DialogInterface.OnClickListener() {
            @Override
            public void onClick(DialogInterface dialogInterface, int i) {
                     sil(secilen_indis);
            }
        });
        dialog.create().show();
    }
}
package com.example.ali.puantajuygulamas;

import android.app.AlertDialog;
import android.content.Context;
import android.content.DialogInterface;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.CheckBox;
import android.widget.LinearLayout;
import android.widget.ListView;
import android.widget.RadioButton;
import android.widget.RadioGroup;
import android.widget.Spinner;
import android.widget.TextView;
import android.widget.Toast;

import adepter.adepter1;
import puantaj.Puantaj;
import veritabani.*;
import java.io.DataOutputStream;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;

public class Main2Activity extends AppCompatActivity implements View.OnClickListener{
    public ListView lv;
    public Button btn,btn_sil;
    public Spinner[] sp;
   public int[] sp_id={R.id.syil,R.id.say};
   public ArrayList<String> list[];
    public ArrayList<Integer> id,lvlis_id;
   ArrayList<Puantaj> lvlist;
   public ArrayAdapter<String >[] adp;
   adepter1 myadp;
   database vt;
   SQLiteDatabase db;
    private static Context context;
    RadioButton[] rbtn;
    TextView[] genel_text;
    int[] genel_text_id={R.id.topgun,R.id.topmesai};
   public static String[] aylar={"Ocak","Şubat","Mart","Nisan","Mayıs","Haziran","Temmuz","Ağustos","Eylül","Ekim","Kasım","Aralık"};
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main2);
        context=this;
        list=new ArrayList[sp_id.length];
        lvlis_id=new ArrayList<Integer>();
       vt=new database(this);
        sp=new Spinner[sp_id.length];
        adp=new ArrayAdapter[list.length];
       id=new ArrayList<Integer>();
        genel_text=new TextView[genel_text_id.length];
        for(int i=0;i<sp.length;i++)
       {
           sp[i]=(Spinner)findViewById(sp_id[i]);
           list[i]=new ArrayList<String>();
           adp[i]=new ArrayAdapter<String>(this,android.R.layout.simple_spinner_item,list[i]);
           sp[i].setAdapter(adp[i]);
           genel_text[i]=(TextView)findViewById(genel_text_id[i]);
       }
    lvlist=new ArrayList<Puantaj>();
       myadp=new adepter.adepter1(this,lvlist);
       lv=(ListView)findViewById(R.id.liste);
       lv.setAdapter(myadp);
       spdoldur();
       for(int i=0;i<aylar.length;i++)
           adp[1].add(aylar[i]);
       Date date=new Date();
       SimpleDateFormat sdf=new SimpleDateFormat("MM");
       final int tarih=Integer.parseInt(sdf.format(date));
        sp[1].setSelection(tarih-1);
        btn_sil=(Button)findViewById(R.id.btnsil);
        btn_sil.setEnabled(false);
        btn_sil.setOnClickListener(this);
        btn=(Button)findViewById(R.id.btnara);
        btn.setOnClickListener(this);

    }
    public static void notgoster(String not)
    {
        if(not.length()>0) {
            LinearLayout layout = new LinearLayout(context);
            TextView tgunluk = new TextView(context);
            tgunluk.setText(not);
            layout.addView(tgunluk);
            AlertDialog.Builder dialog = new AlertDialog.Builder(context);
            dialog.setTitle("NOT");
            dialog.setCancelable(true);
            dialog.setView(layout);
            dialog.create().show();
        }
        else
            Toast.makeText(context,"Bu güne ait herhangi bir not yok!!",Toast.LENGTH_LONG).show();

    }
public void baglan()
{
    try
    {
   db=vt.getWritableDatabase();
    }
    catch (Exception ex)
    {
        Toast.makeText(this,ex.getMessage(), Toast.LENGTH_LONG).show();
    }
}
public void spdoldur()
{
    try
    {
       list[0].clear();
       adp[0].notifyDataSetChanged();
       id.clear();
        baglan();
        Cursor c=db.query("Yil",new String[]{"yilid","yil"},null,null,null,null,null);
        c.moveToPosition(-1);
        while(c.moveToNext())
        {
            adp[0].add(c.getString(1));
            id.add(c.getInt(0));
        }
        c.close();
        db.close();
    }
    catch (Exception ex)
    {
        Toast.makeText(this,ex.getMessage(), Toast.LENGTH_LONG).show();
    }
}

    @Override
    public void onClick(View view) {
        switch (view.getId())
        {
            case R.id.btnara:ara();break;
            case R.id.btnsil:hepsinisil();break;
        }
    }
    public void ara()
    {
        int secilen_yil=sp[0].getSelectedItemPosition();
        int secilen_ay=sp[1].getSelectedItemPosition();
        if(secilen_ay>-1&&secilen_yil>-1)
            try
            {
                String tarih_query=(secilen_ay+1)+"";
                if(tarih_query.length()<2)
                    tarih_query="0"+tarih_query;
                tarih_query=adp[0].getItem(secilen_yil)+tarih_query+"%";
                lvlist.clear();
                lvlis_id.clear();
                myadp.notifyDataSetChanged();
                baglan();
                Cursor c=db.query("Puantaj",new String[]{"gun","mesai","gunluk","id"},"yilid=? and gun like ?",new String[]{id.get(secilen_yil)+"",tarih_query},null,null,"gun ASC");
                c.moveToPosition(-1);
                while(c.moveToNext())
                {   String tarih1=c.getString(0);
                    String tarih3=tarih1.substring(0,4)+"/";
                    tarih3+=tarih1.substring(4,6)+"/";
                    tarih3+=tarih1.substring(6,8);
                    lvlist.add(new Puantaj(tarih3,c.getDouble(1),c.getString(2)));
                    lvlis_id.add(c.getInt(3));
                }
                c.close();
                db.close();
                if(lvlist.size()!=0)
                    btn_sil.setEnabled(true);
                else
                    btn_sil.setEnabled(false);
                MainActivity.geneltoplam(genel_text,lvlist);
            }
            catch (Exception ex)
            {
                Toast.makeText(getApplicationContext(),ex.getMessage(), Toast.LENGTH_LONG).show();
            }
    }
    public void hepsinisil()
    {   final AlertDialog.Builder dialog=new AlertDialog.Builder(this);
         dialog.setTitle("Seçim");
         dialog.setCancelable(false);
        LinearLayout layout=new LinearLayout(this);
       layout.setOrientation(LinearLayout.VERTICAL);
        final RadioGroup grup=new RadioGroup(this);
        final RadioButton[] rbtn={new RadioButton(this),new RadioButton(this)};
        rbtn[0].setText(list[0].get(sp[0].getSelectedItemPosition()));
        rbtn[1].setText(list[1].get(sp[1].getSelectedItemPosition()));
        grup.addView(rbtn[0]);
        grup.addView(rbtn[1]);
        layout.addView(grup);
        dialog.setView(layout);
        dialog.setPositiveButton("Hepsini Sil", new DialogInterface.OnClickListener() {
            @Override
            public void onClick(DialogInterface dialogInterface, int i) {
                int secilen_yil=sp[0].getSelectedItemPosition();
                int secilen_ay=sp[1].getSelectedItemPosition();
                if(secilen_ay>-1&&secilen_yil>-1) {
                    try {
                         int secilen_id=grup.getCheckedRadioButtonId();
                        if (secilen_id==rbtn[0].getId())//Yıl'a göre hepsini silme
                        {
                            baglan();
                            db.delete("Puantaj","yilid=?",new String[]{id.get(secilen_yil)+""});
                            db.close();
                            MainActivity.datagetir();
                            spdoldur();
                            ara();
                        }
                        else if(secilen_id==rbtn[1].getId())//Secili yıl'ın bu hesini silme
                        {
                            baglan();
                            for(int a=0;a<lvlis_id.size();a++)
                                db.delete("Puantaj","id=? and yilid=?",new String[]{lvlis_id.get(a)+"",id.get(secilen_yil)+""});
                            db.close();
                            MainActivity.datagetir();
                            ara();
                        }
                        else
                            Toast.makeText(getApplicationContext(),"Hiçbir secim yapılmadı!!",Toast.LENGTH_SHORT).show();
                    } catch (Exception ex) {

                    }
                }
            }
        });
        dialog.setNegativeButton("Vazgeç", new DialogInterface.OnClickListener() {
            @Override
            public void onClick(DialogInterface dialogInterface, int i) {

            }
        });
    dialog.create().show();
    }
}
<span data-mce-type="bookmark" style="display: inline-block; width: 0px; overflow: hidden; line-height: 0;" class="mce_SELRES_start"></span>

 

by ·0 Yorum

KaloriHesaplama Hepsini indir

package com.example.ali.kalorihesaplama;

import android.content.ContentValues;
import android.content.Context;
import android.content.DialogInterface;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.support.v7.app.AlertDialog;
import android.support.v7.app.AppCompatActivity;
import android.view.View;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.EditText;
import android.widget.LinearLayout;
import android.widget.ListView;
import android.widget.Spinner;
import android.widget.TextView;
import android.widget.Toast;

import java.util.ArrayList;
import java.util.List;

import kaloriler.Kalori;
import list.listadepter;
import veritabani.DB;

public class MainActivity extends AppCompatActivity implements View.OnClickListener,AdapterView.OnItemClickListener {
    Intent frm;
    static   DB katman;
    static  SQLiteDatabase db;
    static   Spinner  curun,gunurun,cins;
    ListView list;
    EditText miktar;
    TextView genelt,topkalori;
    List<Kalori> liste;
    static ArrayList<String> clist,gunlist,cinsiyet;
    static  ArrayList<Integer> urunid,id,gunurun_id;
    static ArrayAdapter<String> cadp,gunadp,cinsadp;
 public  Button btn;
    Context contex;
    int[] btnid={R.id.btnekle,R.id.btnurun,R.id.btn_kalori};
    int[] text={R.id.tboy,R.id.tyas,R.id.tkilo};
    EditText[] jtext;
    EditText jtext_gun;
    double[] degerler;
    listadepter adp;
    AlertDialog.Builder dialog;
    LinearLayout layout;




    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        katman=new DB(this);
        contex=this;
        jtext=new EditText[text.length];
        degerler=new double[jtext.length];
        topkalori=(TextView)findViewById(R.id.genelkalori);
        for(int i=0;i<btnid.length;i++)
        {
            btn=(Button)findViewById(btnid[i]);
            btn.setOnClickListener(this);
        }
       for(int i=0;i< text.length;i++)
       {
           jtext[i]=(EditText)findViewById(text[i]);
           jtext[i].setText(i+1+"");
       }

        miktar=(EditText)findViewById(R.id.tmiktar);
        list=(ListView)findViewById(R.id.lis);
        curun=(Spinner)findViewById(R.id.curun);
        urunid=new ArrayList<Integer>();
         id=new ArrayList<Integer>();
        clist=new ArrayList<String>();
        cins=(Spinner)findViewById(R.id.cins);
        cinsiyet=new ArrayList<String>();
        cinsadp=new ArrayAdapter<String>(this,android.R.layout.simple_spinner_item,cinsiyet);
        cins.setAdapter(cinsadp);
        cinsadp.add("Erkek");
        cinsadp.add("Kadın");


         genelt=(TextView)findViewById(R.id.toplam);
        cadp=new ArrayAdapter<String>(this,android.R.layout.simple_spinner_item,clist);
        liste=new ArrayList<Kalori>();
        adp=new listadepter(this,liste);
        list.setAdapter(adp);
        curun.setAdapter(cadp);
        spinnerdoldur(contex);
        datagetir();
        toplam();
        list.setOnItemClickListener(this);
    }
    public void toplam(){
        double gtoplam=0.0;
        for(int i=0;i<adp.getCount();i++)
        {
            Kalori k=liste.get(i);
            gtoplam+=k.toplam;
        }
        gtoplam=virgul(gtoplam);
        genelt.setText("Toplam="+gtoplam);
    }
    public static void baglan(){
        db=katman.getWritableDatabase();
    }
    public boolean kontrolet()
    {
        int sayac=0;
        for(int i=0;i<jtext.length;i++) {
            if (jtext[i].getText().length() > 0) {
                try {
                    degerler[i] =Double.parseDouble(jtext[i].getText()+"");
                } catch (Exception ex) {
                    Toast.makeText(this,"Lütfen değerleri doğru giriniz!!!",Toast.LENGTH_LONG).show();
                    break;
                }
                sayac++;
            }
             else
                 break;
        }
    if(sayac==jtext.length)
        return true;
    return false;
    }
    public void ekle()
    {
        try {
            baglan();
            long secilen=curun.getSelectedItemId();
            int id=urunid.get((int)secilen);
            if(secilen>-1&&miktar.getText().length()>0&&kontrolet()){
                double kmiktar=Double.parseDouble(miktar.getText()+"");
                ContentValues par=new ContentValues();
                par.put("Urunid",id);
                par.put("Miktar",kmiktar);
                db.insertOrThrow("Kalori",null,par);
                katman.close();
                datagetir();

            }
        }catch(Exception ex){
            Toast.makeText(this,ex.getMessage(),Toast.LENGTH_LONG).show();

        }
    }

    public void sil(int id)
    {
        try {
            baglan();
            db.delete("Kalori","id=?",new String[]{id+""});
            katman.kapat();
            datagetir();
        }catch(Exception ex){
            Toast.makeText(this,ex.getMessage(),Toast.LENGTH_LONG).show();

        }

    }
    public void duzenle(int id,double miktar,int urun_id)
    {
        try {
             baglan();
             ContentValues par=new ContentValues();
             par.put("Urunid",urun_id);
             par.put("Miktar",miktar);
             db.update("Kalori",par,"id=?",new String[]{id+""});
            katman.kapat();
            datagetir();
        }catch(Exception ex){
            Toast.makeText(this,ex.getMessage(),Toast.LENGTH_LONG).show();

        }
    }

    public static void spinnerdoldur(Context context)
    {
        try{
            baglan();
            Cursor c=db.query("Urun",new String[]{"id","Urunad"},null,null,null,null,null);
            clist.clear();
            cadp.notifyDataSetChanged();
            urunid.clear();
            c.moveToPosition(-1);
            while(c.moveToNext())
            {
                cadp.add(c.getString(1));
                urunid.add(c.getInt(0));

            }
            c.close();
            katman.close();
        }catch(Exception ex){
            Toast.makeText(context,ex.getMessage(),Toast.LENGTH_LONG).show();
        }
    }
    public void datagetir(){
        try {
           baglan();
            Cursor isaretci=db.rawQuery("select k.id,u.Urunad,k.Miktar,u.Kalori,(u.Kalori*k.Miktar) from Kalori k inner join Urun u on u.id=k.Urunid ",null);
            liste.clear();
            adp.notifyDataSetChanged();
            id.clear();
            isaretci.moveToPosition(-1);
            while(isaretci.moveToNext())
            {
                id.add(isaretci.getInt(0));
                Kalori k=new Kalori();
                k.urunad=isaretci.getString(1);
                k.miktar=isaretci.getDouble(2);
                k.kalori=isaretci.getDouble(3);
                k.toplam=virgul(isaretci.getDouble(4));
                liste.add(k);
            }
            isaretci.close();
            katman.close();
            toplam();
        }catch(Exception ex){
            Toast.makeText(this,ex.getMessage(),Toast.LENGTH_LONG).show();
        }

    }
    public void frm2()
    {
        frm=new Intent(this, Main3Activity.class);
        startActivity(frm);

    }
    @Override
    public void onClick(View view) {
        switch (view.getId()){
            case R.id.btnekle:ekle();break;
            case R.id.btnurun:frm2();break;
            case R.id.btn_kalori:kalorihesapla();break;
        }
    }
    public double virgul(double sayi)
    {
        int sayi2=(int)(sayi*100);
        sayi=sayi2/100.0;
        return sayi;
    }
    public void kalorihesapla()
    {
        if(kontrolet())
        {
            double[] erkek= {66,6.8,13.7,5};
            double[] kadin= {655,4.7,9.6,1.8};
            double sonuc=0.0;
            double[] oranlar=kadin;
            double[] degerler=new double[4];
            degerler[0]=1;
            for(int i=0;i<jtext.length;i++)
                degerler[i+1]=Double.parseDouble(jtext[i].getText()+"");

            if(cins.getSelectedItemPosition()==0)//jrd radiobuuton secilimi değilmi
                oranlar=erkek;
                sonuc=(oranlar[0]*degerler[0]+oranlar[1]*degerler[1]+oranlar[2]*degerler[2])-(oranlar[3]*degerler[3]);
                sonuc=virgul(sonuc);
            topkalori.setText("Gün Kalori="+sonuc);
        }else{

            Toast.makeText(contex, "Bilgileri doğru giriniz!!!!", Toast.LENGTH_LONG).show();
        }

    }
int secileni;
    @Override
    public void onItemClick(AdapterView<?> adapterView, View view, int i, long l) {
           secileni = i;
           jtext_gun = new EditText(this);
           gunlist = new ArrayList<String>();
           for (int a = 0; a < cadp.getCount(); a++)
               gunlist.add(cadp.getItem(a));
           gunadp = new ArrayAdapter<String>(this, android.R.layout.simple_spinner_item, gunlist);
           gunurun = new Spinner(this);
           gunurun.setAdapter(gunadp);
           gunurun_id = new ArrayList<Integer>();
           for (int a = 0; a < urunid.size(); a++)
               gunurun_id.add(urunid.get(a));
           layout = new LinearLayout(this);
           layout.setOrientation(LinearLayout.VERTICAL);
           dialog = new AlertDialog.Builder(this);
           layout.addView(gunurun);
           layout.addView(jtext_gun);
           dialog.setView(layout);
           Kalori k = liste.get(i);
           jtext_gun.setText(k.miktar + "");
           dialog.setCancelable(true);
           dialog.setTitle("Sil veya Düzenle");
           dialog.setPositiveButton("Sil", new DialogInterface.OnClickListener() {
               @Override
               public void onClick(DialogInterface dialogInterface, int i) {
                   sil(id.get(secileni));
               }
           });
           dialog.setNeutralButton("Düzenle", new DialogInterface.OnClickListener() {
               @Override
               public void onClick(DialogInterface dialogInterface, int i) {

                   if (secileni > -1 && jtext_gun.getText().length() > 0) {
                       try {
                           double miktar = Double.parseDouble(jtext_gun.getText() + "");
                           int urun_id = gunurun_id.get(gunurun.getSelectedItemPosition());
                           duzenle(id.get(secileni), miktar, urun_id);
                       } catch (Exception ex) {
                           Toast.makeText(contex, "Bilgileri doğru giriniz catch!!!!", Toast.LENGTH_LONG).show();
                       }

                   } else
                       Toast.makeText(contex, "Bilgileri doğru giriniz!!!!", Toast.LENGTH_LONG).show();
               }
           });
           dialog.create().show();
       }
}
package com.example.ali.kalorihesaplama;

import android.app.Activity;
import android.content.ContentValues;
import android.content.Context;
import android.content.DialogInterface;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.graphics.Color;
import android.os.Bundle;
import android.support.v7.app.AlertDialog;
import android.support.v7.app.AppCompatActivity;
import android.support.v7.widget.Toolbar;
import android.text.InputType;
import android.util.Log;
import android.view.View;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.EditText;
import android.widget.LinearLayout;
import android.widget.ListView;
import android.widget.Spinner;
import android.widget.Toast;

import java.util.ArrayList;
import java.util.List;
import java.util.concurrent.Executors;
import java.util.zip.Inflater;

import list.URUN;
import list.urunadepter;
import veritabani.DB;

public class Main3Activity extends AppCompatActivity implements View.OnClickListener {
    DB vt;
    SQLiteDatabase db;
    ListView liste;
    urunadepter adp;
    List<URUN> list;
    ArrayList<Integer> id;
    Button btn;
    EditText urun,kalori;
    AlertDialog.Builder dialog;
    Context contex=this;
    int secilenid;
    URUN u;
    LinearLayout layout;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main3);
        urun=(EditText)findViewById(R.id.turun);
        kalori=(EditText)findViewById(R.id.tkalori);
        btn=(Button)findViewById(R.id.btninsert);
        btn.setOnClickListener(this);
        layout=new LinearLayout(this);
        id=new ArrayList<Integer>();
        vt= new DB(this);
        liste=(ListView)findViewById(R.id.lurun);
        list=new ArrayList<URUN>();
        adp=new urunadepter(this,list);
        liste.setAdapter(adp);
        datagetir();
        final EditText gunurun=new EditText(this);
        final EditText gunkalori=new EditText(this);
        layout.setOrientation(LinearLayout.VERTICAL);
        layout.addView(gunurun);
        layout.addView(gunkalori);
        liste.setOnItemClickListener(new AdapterView.OnItemClickListener() {
            @Override
            public void onItemClick(AdapterView<?> adapterView, View view, int i, long l) {
                u=list.get(i);
                secilenid=id.get(i);
                gunurun.setText(u.urunad);
                gunkalori.setText(u.kalori+"");
                dialog=new AlertDialog.Builder(contex);
                dialog.setView(layout);
                dialog.setTitle("Sil veya Düzenle");
                dialog.setCancelable(true);
                dialog.setPositiveButton("Sil", new DialogInterface.OnClickListener() {
                    @Override
                    public void onClick(DialogInterface dialogInterface, int i) { sil(secilenid); }});
                dialog.setNeutralButton("Düzenle", new DialogInterface.OnClickListener() {
                    @Override
                    public void onClick(DialogInterface dialogInterface, int i) {
                        if(gunurun.getText().length()>0&&gunkalori.getText().length()>0){
                            double kal=Double.parseDouble(gunkalori.getText()+"");
                            guncelle(secilenid,gunurun.getText()+"",kal);
                        }
                    }
                });
                dialog.create().show();
            }
        });

    }
    public void baglan()
    {
        db=vt.getWritableDatabase();
    }
    @Override
    public void onClick(View view) {
        try {
            baglan();
            if (urun.getText().length() > 0 && kalori.getText().length() > 0)
            {
                double kal=Double.parseDouble(kalori.getText()+"");
                ContentValues par=new ContentValues();
                par.put("Urunad",urun.getText()+"");
                par.put("Kalori",kal);
                long durum= db.insertOrThrow("Urun",null,par);
                urun.setText("");
                kalori.setText("");
                vt.kapat();
                datagetir();
                MainActivity.spinnerdoldur(this);

            }
        }catch(Exception ex){
            Toast.makeText(this,ex.getMessage(),Toast.LENGTH_LONG).show();
        }
    }

    public void sil(int id)
    {
        try {
            baglan();
            db.delete("Urun","id=?",new String[]{id+""});
            datagetir();
        }
        catch(Exception ex){
            Toast.makeText(this,ex.getMessage(),Toast.LENGTH_LONG).show();
        }

    }
    public void guncelle(int id,String ad,double kalori)
    {
        try {
            baglan();
            ContentValues par=new ContentValues();
            par.put("Urunad",ad);
            par.put("Kalori",kalori);
            db.update("Urun",par,"id=?",new String[]{id+""});
            vt.kapat();
            datagetir();
        }catch(Exception ex){
            Toast.makeText(this,ex.getMessage(),Toast.LENGTH_LONG).show();
        }
    }
    public void datagetir()
    {
        try {
            baglan();
            String[] col={"id","Urunad","Kalori"};
            Cursor c=db.query("Urun",col,null,null,null,null,null);
            list.clear();
            adp.notifyDataSetChanged();
            id.clear();
            c.moveToPosition(-1);
            while(c.moveToNext())
            {  URUN d=new URUN();
                d.urunad=c.getString(1);
                d.kalori=c.getDouble(2);
                id.add(c.getInt(0));
                list.add(d);
            }
            c.close();
            vt.kapat();
        }catch(Exception ex){
            Toast.makeText(this,ex.getMessage(),Toast.LENGTH_LONG).show();
        }
    }
}

by ·0 Yorum

DataBaseKullanm Tamamını indir

package com.example.ali.databasekullanm;

import android.app.AlertDialog;
import android.content.ContentValues;
import android.content.Context;
import android.content.DialogInterface;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.support.v7.app.AppCompatActivity;
import android.view.View;
import android.widget.AdapterView;
import android.widget.Button;
import android.widget.EditText;
import android.widget.LinearLayout;
import android.widget.ListView;
import android.widget.Toast;

import java.util.ArrayList;
import java.util.List;

import adepter.myadepter;
import kisi.Kisi;
import veritabani.vt;

public class MainActivity extends AppCompatActivity implements View.OnClickListener{
    ListView lv;
    EditText[] et,et_gun;
    int[] id={R.id.ad,R.id.soyad,R.id.yas};
    myadepter adp;
    List<Kisi> liste;
    ArrayList<Integer> idliste;
    Button btn;
    vt vtys;
    SQLiteDatabase db;
    AlertDialog.Builder dialog;
    LinearLayout layout;
    int secilenid;
    Context context;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        context=this;
        et=new EditText[id.length];
        vtys=new vt(this);
        lv=(ListView)findViewById(R.id.list);
        liste=new ArrayList<Kisi>();
        adp=new myadepter(this,liste);
        lv.setAdapter(adp);
        for(int i=0;i<id.length;i++)
            et[i]=(EditText)findViewById(id[i]);
        btn=(Button)findViewById(R.id.btnekle);
        btn.setOnClickListener(this);
        idliste=new ArrayList<Integer>();
        datagetir();
        lv.setOnItemClickListener(new AdapterView.OnItemClickListener() {
            @Override
            public void onItemClick(AdapterView<?> adapterView, View view, int i, long l) {
                secilenid=i;
                layout=new LinearLayout(context);
                layout.setOrientation(LinearLayout.VERTICAL);
                dialog=new AlertDialog.Builder(context);
                dialog.setTitle("Düzenle veya Sil");
                dialog.setCancelable(true);
                et_gun=new EditText[et.length];
                for(int a=0;a<id.length;a++) {
                    et_gun[a] = new EditText(context);
                    layout.addView(et_gun[a]);
                }
                Kisi k=liste.get(secilenid);
                et_gun[0].setText(k.ad);
                et_gun[1].setText(k.soyad);
                et_gun[2].setText(k.yas+"");
                dialog.setView(layout);
                dialog.setPositiveButton("Düzenle", new DialogInterface.OnClickListener() {
                    @Override
                    public void onClick(DialogInterface dialogInterface, int i) {

                        if(kontrol(et_gun))
                          {   int id=idliste.get(secilenid);
                              try {

                                  baglan();
                                  int yas=Integer.parseInt(et_gun[2].getText()+"");
                                  ContentValues par=new ContentValues();
                                  par.put("ad",et_gun[0].getText()+"");
                                  par.put("soyad",et_gun[1].getText()+"");
                                  par.put("yas",yas);
                                  db.update("Kisi",par,"id=?",new String[]{id+""});
                                  db.close();
                                  datagetir();
                              }catch (Exception ex)
                              {
                                  Toast.makeText(context,ex.getMessage(),Toast.LENGTH_LONG).show();
                              }

                          }
                    }
                });
                dialog.setNegativeButton("Sil", new DialogInterface.OnClickListener() {
                @Override
                public void onClick(DialogInterface dialogInterface, int i) {
                    int id=idliste.get(secilenid);
                    try {
                        baglan();
                        int yas=Integer.parseInt(et_gun[2].getText()+"");
                        db.delete("Kisi","id=?",new String[]{id+""});
                        db.close();
                        datagetir();
                    }catch (Exception ex) {
                        Toast.makeText(context, ex.getMessage(), Toast.LENGTH_LONG).show();
                    }
                }
            });
                dialog.create().show();
                }

        });
    }
public void baglan()
{
    try {
        db=vtys.getWritableDatabase();
    }
    catch (Exception ex)
    {
        Toast.makeText(getApplicationContext(),ex.getMessage(),Toast.LENGTH_LONG).show();
    }

}
public boolean kontrol(EditText[] jtext)
{
    int sayac=0;
 for(int i=0;i<jtext.length;i++)
     if(jtext[i].getText().length()>0)
         sayac++;
    if(sayac==jtext.length)
        return  true;
 return false;
}
    @Override
    public void onClick(View view) {
        try {

            baglan();
            int yas=Integer.parseInt(et[2].getText()+"");
            if(kontrol(et))
            {
                ContentValues par=new ContentValues();
                par.put("ad",et[0].getText()+"");
                par.put("soyad",et[1].getText()+"");
                par.put("yas",yas);
              db.insertOrThrow("Kisi",null,par);
              db.close();
             datagetir();
            }
        }
        catch (Exception ex)
        {
            Toast.makeText(getApplicationContext(),ex.getMessage(),Toast.LENGTH_LONG).show();
        }
    }
 public void datagetir(){
        try {
            baglan();
            Cursor c=db.query("Kisi",new String[]{"id","ad","soyad","yas"},null,null,null,null,null);
            liste.clear();
            idliste.clear();
            adp.notifyDataSetChanged();//liste değisiklik oldupu için adepteri güncelliyoruz
            c.moveToPosition(-1);//işaretcinin(Cursor) pozisyonu ayalıyoruz tablonun ilk satırından baslaması için
            while(c.moveToNext())//ileri diyoruz boylece Cursor tablonun ilk satırına geciyor
            {
                Kisi k=new Kisi();
                k.ad=c.getString(1);
                k.soyad=c.getString(2);
                k.yas=c.getInt(3);
                liste.add(k);//liste Kisi tipinde item aldığı için Kisi sınıfından nesne turetip degiskenlerine atıp nesneyi attık
                idliste.add(c.getInt(0));
            }
            db.close();
            c.close();
        }
        catch (Exception ex)
        {
           Toast.makeText(getApplicationContext(),ex.getMessage(),Toast.LENGTH_LONG).show();
        }

 }
}
package adepter;

import android.app.Activity;
import android.content.Context;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.BaseAdapter;
import android.widget.TextView;

import com.example.ali.databasekullanm.R;

import java.util.List;

import kisi.Kisi;

public class myadepter extends BaseAdapter {
    List<Kisi> liste;
    LayoutInflater layout;
    public myadepter(Activity a,List<Kisi> liste){
        this.liste=liste;
        layout=(LayoutInflater)a.getSystemService(Context.LAYOUT_INFLATER_SERVICE);
    }
    @Override
    public int getCount() {
        return liste.size();
    }

    @Override
    public Object getItem(int i) {
        return liste.get(i);
    }

    @Override
    public long getItemId(int i) {
        return i;
    }

    @Override
    public View getView(int i, View view, ViewGroup viewGroup) {
        View v=layout.inflate(R.layout.colum,null);
        TextView t1=(TextView)v.findViewById(R.id.ad);
        TextView t2=(TextView)v.findViewById(R.id.soyad);
        TextView t3=(TextView)v.findViewById(R.id.yas);
        Kisi k=liste.get(i);
       t1.setText(k.ad);
       t2.setText(k.soyad);
       t3.setText(""+k.yas);
        return v;
    }
}<span id="mce_marker" data-mce-type="bookmark" data-mce-fragment="1">​</span>
 package kisi;

public class Kisi {
public String ad;
public String soyad;
public int yas;
}
<span id="mce_marker" data-mce-type="bookmark" data-mce-fragment="1">​</span>