{"id":10379,"date":"2019-07-08T13:44:42","date_gmt":"2019-07-08T13:44:42","guid":{"rendered":"https:\/\/ittutorial.org\/?p=10379"},"modified":"2019-07-08T14:06:49","modified_gmt":"2019-07-08T14:06:49","slug":"android-programlama-46-sqlite-insert-islemi","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/android-programlama-46-sqlite-insert-islemi\/","title":{"rendered":"Android Programlama -46 SQLite \u0130nsert \u0130\u015flemi"},"content":{"rendered":"<p>Merhaba arkada\u015filar bu g\u00fcn ki makalemde SQite database ine insert i\u015flemini g\u00f6rece\u011fiz.<\/p>\n<p>Bir \u00f6nceki makalemde SQLite da tablo create&#8217; ine de\u011finmi\u015ftim. Okumad\u0131ysan\u0131z \u00f6ncelikle onu\u0131 okuman\u0131z\u0131 tavsiye ederim. <a href=\"https:\/\/ittutorial.org\/android-programlama-45-sqlite-provider-class\/\">Buradan<\/a> ula\u015fabilirsiniz.<\/p>\n<pre>import java.text.SimpleDateFormat;\r\nimport java.util.Calendar;\r\nimport java.util.GregorianCalendar;\r\nimport java.util.Locale;\r\n\r\npublic class AddProductActivity extends AppCompatActivity implements DatePickerDialog.OnDateSetListener {\r\nEditText urun_kodu;\r\nEditText urun_adi;\r\nEditText urun_cinsi;\r\nEditText urun_adeti;\r\nEditText urun_ozelligi;\r\nButton urun_giris_tarihi;\r\nButton urun_cikis_tarihi;\r\nSimpleDateFormat simpleDateFormat;\r\nString urun_cikis;\r\nprivate int loaderKeyCode = 0;\r\nprivate DbHelper mDbHelper;\r\n\r\n@Override\r\nprotected void onCreate(Bundle savedInstanceState) {\r\nsuper.onCreate(savedInstanceState);\r\nsetContentView(R.layout.activity_add_product);\r\nurun_kodu = (EditText) findViewById(R.id.urun_kod);\r\nurun_adi = (EditText) findViewById(R.id.urun_adi);\r\nurun_adeti = (EditText) findViewById(R.id.urun_adeti);\r\nurun_cinsi = (EditText) findViewById(R.id.urun_cins);\r\nurun_ozelligi = (EditText) findViewById(R.id.urun_ozellik);\r\nurun_giris_tarihi = (Button) findViewById(R.id.urun_gris_tarih);\r\nurun_cikis_tarihi = (Button) findViewById(R.id.urun_c\u0131k\u0131s_tarih);\r\nsimpleDateFormat = new SimpleDateFormat(\"dd MM yyyy\", Locale.US);\r\nButton btnAdd = findViewById(R.id.urun_ekle);\r\n\r\nbtnAdd.setOnClickListener(new View.OnClickListener() {\r\n@Override\r\npublic void onClick(View view) {\r\ninsertdata();\r\n}\r\n});\r\nurun_cikis_tarihi.setOnClickListener(new View.OnClickListener() {\r\n@Override\r\npublic void onClick(View view) {\r\nshowDate(1980, 0, 1, R.style.DatePickerSpinner);\r\n}\r\n});\r\n\r\nurun_giris_tarihi.setOnClickListener(new View.OnClickListener() {\r\n@Override\r\npublic void onClick(View view) {\r\nshowDate(1980, 0, 1, R.style.DatePickerSpinner);\r\n}\r\n});\r\n}\r\n\r\n\r\npublic void insertdata() {\r\n\r\nDbHelper dbHelper = new DbHelper(this);\r\nSQLiteDatabase db = dbHelper.getWritableDatabase();\r\n\/* if (urun_kodu.getText().toString().isEmpty()\r\n|| urun_adi.getText().toString().isEmpty()\r\n|| urun_cinsi.getText().toString().isEmpty() ||\r\nurun_ozelligi.getText().toString().isEmpty() ||\r\nurun_adeti.getText().toString().isEmpty()\r\n|| urun_giris_tarihi.getText().toString().isEmpty()\r\n|| urun_cikis_tarihi.getText().toString().isEmpty()){\r\nToast.makeText(AddProductActivity.this, \"You need to fill everywhere.\", Toast.LENGTH_SHORT).show();\r\n} else {*\/\r\n\r\nContentValues cv = new ContentValues();\r\ncv.put(ProductContract.ProductEntry.COLUMN_PRODUCT_NAME, urun_kodu.getText().toString());\r\ncv.put(ProductContract.ProductEntry.COLUMN_PRODUCT_PRICE, urun_adi.getText().toString());\r\ncv.put(ProductContract.ProductEntry.COLUMN_PRODUCT_QUANTITY, urun_cinsi.getText().toString());\r\ncv.put(ProductContract.ProductEntry.COLUMN_SUPPLIER_NAME, urun_ozelligi.getText().toString());\r\ncv.put(ProductContract.ProductEntry.COLUMN_SUPPLIER_EMAIL, urun_adeti.getText().toString());\r\ncv.put(ProductContract.ProductEntry.COLUMN_SUPPLIER_PHONE, \"\");\r\ncv.put(ProductContract.ProductEntry.COLUMN_PRODUCT_IMAGE, urun_cikis);\r\n\r\ndb.insert(ProductContract.ProductEntry.TABLE_NAME, null, cv);\r\nToast.makeText(this, urun_adi.getText().toString(), Toast.LENGTH_SHORT).show();\r\nfinish();\r\n\/\/ }\r\n\r\n}<\/pre>\n<p>\u00d6rnek kodu inceleyecek olursak, database&#8217; e kay\u0131t etmek istedi\u011fimiz verileri kullan\u0131c\u0131n\u0131n uygulama aray\u00fcz\u00fcnden girmesini istiyoruz. Bu y\u00fczden xml dosyas\u0131na tan\u0131mlad\u0131\u011f\u0131m\u0131z edittext ve di\u011fer komponentlerimizi tan\u0131ml\u0131yoruz. Sonra findviewByid methodu ile xml kodlar\u0131n da tan\u0131mlad\u0131\u011f\u0131m\u0131z komponentlerle ba\u011fl\u0131yoruz.\u00a0 Kaydet butonunun setonclinklistener \u00f6zelli\u011fini aktifle\u015ftirip i\u00e7erisinde insertdate() methodunu \u00e7a\u011f\u0131r\u0131yoruz.\u00a0 Bu methodun i\u00e7inde daha \u00f6nceki makalelerde ayr\u0131nt\u0131l\u0131 g\u00f6rd\u00fc\u011f\u00fcm\u00fcz dbHelper class\u0131n\u0131n nesnesini olu\u015fturuyoruz. Bu nesnenin de\u00a0getWritableDatabase(); methodu sayesinde kullan\u0131c\u0131dan ald\u0131\u011f\u0131m de\u011ferleri database&#8217; e yazma i\u015flemini sa\u011flayaca\u011f\u0131m. Bu a\u015famada girilen alanlar\u0131n doluluk bo\u015flu\u011funu kontrol ediyoruz. B\u00fct\u00fcn alanlar do\u011fru ise kullan\u0131c\u0131n\u0131n girmi\u015f oldu\u011fu b\u00fct\u00fcn de\u011ferler al\u0131n\u0131p olu\u015fturulan Contract methodunun nesnesine atan\u0131r. Son a\u015fama insert komutuyla contract taki veriler database&#8217;e eklenir.<\/p>\n<p>Bir makalenin daha sonuna geldik, esenle kal\u0131n..<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Merhaba arkada\u015filar bu g\u00fcn ki makalemde SQite database ine insert i\u015flemini g\u00f6rece\u011fiz. Bir \u00f6nceki makalemde SQLite da tablo create&#8217; ine de\u011finmi\u015ftim. Okumad\u0131ysan\u0131z \u00f6ncelikle onu\u0131 okuman\u0131z\u0131 tavsiye ederim. Buradan ula\u015fabilirsiniz. import java.text.SimpleDateFormat; import java.util.Calendar; import java.util.GregorianCalendar; import java.util.Locale; public class AddProductActivity extends AppCompatActivity implements DatePickerDialog.OnDateSetListener { EditText urun_kodu; EditText urun_adi; EditText urun_cinsi; EditText urun_adeti; EditText urun_ozelligi; &hellip;<\/p>\n","protected":false},"author":44,"featured_media":10302,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-10379","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-android"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/sqlite-and-Android.jpg","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/10379","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/44"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=10379"}],"version-history":[{"count":3,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/10379\/revisions"}],"predecessor-version":[{"id":10384,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/10379\/revisions\/10384"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/10302"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=10379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=10379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=10379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}