Etiket: android arrayadepter
Android Puantaj Uygulaması
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>
Android DataBase ve Özelleştirilmiş Adepter Kullanımı
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>
Android ListView ve Spinner kullanımı
<RelativeLayout
android:layout_width="375dp"
android:layout_height="503dp">
<TableLayout
android:layout_width="match_parent"
android:layout_marginTop="10dp"
android:layout_height="450dp"
android:layout_marginLeft="10dp">
<TableRow
android:layout_width="match_parent"
android:layout_height="100dp">
<TableRow
android:layout_width="190dp"
android:layout_height="300dp">
<ListView
android:id="@+id/llist"
android:layout_width="170dp"
android:layout_height="250dp"
android:layout_marginLeft="10dp"
android:layout_marginTop="10dp"></ListView>
</TableRow>
<Spinner
android:id="@+id/slist"
android:layout_width="100dp"
android:layout_height="50dp"
></Spinner>
</TableRow>
<TableRow
android:layout_width="match_parent"
android:layout_height="100dp">
<EditText
android:id="@+id/tad"
android:layout_width="100dp"
android:layout_height="45dp"/>
</TableRow>
<TableRow
android:layout_width="match_parent"
android:layout_height="100dp">
<Button
android:id="@+id/btn_ekle"
android:layout_width="100dp"
android:layout_height="45dp"
android:text="Ekle"
/>
<Button
android:id="@+id/btn_sil"
android:layout_width="100dp"
android:layout_height="45dp"
android:text="Sil"
/>
<Button
android:id="@+id/newactivity"
android:layout_width="120dp"
android:layout_height="45dp"
android:text="NEW FORM"
/>
</TableRow>
</TableLayout>
</RelativeLayout>
package com.example.ali.ilkuygulama;
import android.content.Intent;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.*;
import java.util.ArrayList;
public class MainActivity extends AppCompatActivity implements View.OnClickListener{
EditText tad;
Button btnekle,btnsil,btn_frm;
ListView llist;
Spinner slist;
ArrayList<String>[] liste;
ArrayAdapter<String>[] adp;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
tad=(EditText)findViewById(R.id.tad);
btnekle=(Button)findViewById(R.id.btn_ekle);
btnekle.setOnClickListener(this);
btnsil=(Button)findViewById(R.id.btn_sil);
btnsil.setOnClickListener(this);
btn_frm=(Button)findViewById(R.id.newactivity);
btn_frm.setOnClickListener(this);
liste=new ArrayList[]{new ArrayList(),new ArrayList()};
adp=new ArrayAdapter[]{new ArrayAdapter(this,android.R.layout.simple_list_item_1,liste[0]),new ArrayAdapter(this,android.R.layout.simple_spinner_item,liste[1])};
//Yukarı da listeleri adeptere baglıyorum
llist=(ListView)findViewById(R.id.llist);
slist=(Spinner)findViewById(R.id.slist);
llist.setAdapter(adp[0]);//Componentlere adepterleri bağlıyorum yani set ediyorum
slist.setAdapter(adp[1]);
}
@Override
public void onClick(View view) {
switch (view.getId()){//Butonların id'sine göre
case R.id.btn_ekle:ekle();break;
case R.id.btn_sil:sil();break;
case R.id.newactivity:newfrm();break;
}
}
public void ekle(){
if(tad.getText().length()>0) {
adp[0].add(tad.getText()+"");//item'leri Adepter ile ekliyorum
adp[1].add(tad.getText()+"");
tad.setText("");
}else
Toast.makeText(getApplicationContext(),"Bilgileri Doğru giriniz!!", Toast.LENGTH_LONG).show();
//Mesaj verme
}
public void sil(){
int secilen=slist.getSelectedItemPosition();//Spinner den sectiğim item' in index numarası
if(secilen>-1)
liste[1].remove(secilen);//Array den siliyorum
adp[1].notifyDataSetChanged();//Adepter'i güncelliyorum
}
public void newfrm(){
// Intent frm=new Intent(this,Main2Activity.class);
// startActivity(frm);
//Intent nesnesi ile suan için işim olmadıgı için 2.forma böyle gecis
startActivity(new Intent(this,Main2Activity.class));
}
}
<span id="mce_marker" data-mce-type="bookmark" data-mce-fragment="1"></span>