java - my application gives some error about sqlite, and i cannot connect with database -
this database java file
package net.dictionary.anilerdogan; import android.content.context; import android.database.sqlite.sqlitedatabase; import android.database.sqlite.sqliteopenhelper; import android.util.log; public class mydbhelper extends sqliteopenhelper { final protected static string database_name="kamusmm10"; public mydbhelper(context context) { super(context, database_name, null,1); } @override public void oncreate(sqlitedatabase db) { //turkish table db.execsql("create table turkish (" + "ilksatir text," + "kelime text," + "anlami text," + ");"); /************* turkish - start insert data *******************/ //turkish word datas db.execsql("insert turkish (kelime,anlami) values('kitap','book');"); db.execsql("insert turkish (kelime,anlami) values('araba','car');"); db.execsql("insert turkish (kelime,anlami) values('merhaba','hello');"); db.execsql("insert turkish (kelime,anlami) values('feel','hissetmek');"); db.execsql("insert turkish (kelime,anlami) values('ağaç','tree');"); db.execsql("insert turkish (kelime,anlami) values('ev','house');"); db.execsql("insert turkish (kelime,anlami) values('uçak','plane');"); db.execsql("insert turkish (kelime,anlami) values('kapı','door');"); db.execsql("insert turkish (kelime,anlami) values('telefon','phone');"); db.execsql("insert turkish (kelime,anlami) values('tren','train');"); db.execsql("insert turkish (kelime,anlami) values('nefret etmek','hate');"); db.execsql("insert turkish (kelime,anlami) values('domates','tomato');"); db.execsql("insert turkish (kelime,anlami) values('yatak','bed');"); db.execsql("insert turkish (kelime,anlami) values('televizyon','television');"); db.execsql("insert turkish (kelime,anlami) values('para','money');"); db.execsql("insert turkish (kelime,anlami) values('spor','sport');"); db.execsql("insert turkish (kelime,anlami) values('skor','score');"); db.execsql("insert turkish (kelime,anlami) values('not','note');"); db.execsql("insert turkish (kelime,anlami) values('monitör','monitor');"); db.execsql("insert turkish (kelime,anlami) values('anahtar','key');"); db.execsql("insert turkish (kelime,anlami) values('kod','code');"); db.execsql("insert turkish (kelime,anlami) values('veritabani','database');"); db.execsql("insert turkish (kelime,anlami) values('kalem','pen');"); db.execsql("insert turkish (kelime,anlami) values('okul','school');"); db.execsql("insert turkish (kelime,anlami) values('sınıf','class');"); db.execsql("insert turkish (kelime,anlami) values('mekan','places');"); db.execsql("insert turkish (kelime,anlami) values('kalp','heart');"); db.execsql("insert turkish (kelime,anlami) values('bir','one');"); db.execsql("insert turkish (kelime,anlami) values('puan','point');"); db.execsql("insert turkish (kelime,anlami) values('arkadaş','friend');"); db.execsql("insert turkish (kelime,anlami) values('top','ball');"); db.execsql("insert turkish (kelime,anlami) values('dükkan','shop');"); db.execsql("insert turkish (kelime,anlami) values('kamyonet','truck');"); db.execsql("insert turkish (kelime,anlami) values('kablo','wire');"); db.execsql("insert turkish (kelime,anlami) values('ağrı kesici','painkiller');"); db.execsql("insert turkish (kelime,anlami) values('masa','table');"); db.execsql("insert turkish (kelime,anlami) values('sandalye','chair');"); db.execsql("insert turkish (kelime,anlami) values('saç','hair');"); db.execsql("insert turkish (kelime,anlami) values('cüzdan','wallet');"); db.execsql("insert turkish (kelime,anlami) values('kart','card');"); log.i("db helper ","table turkish done"); //english table db.execsql("create table english(" + "firstrow text," + "word text," + "mean text,"+ ");"); //english word datas db.execsql("insert english (word,mean) values('book','kitap');"); db.execsql("insert english (word,mean) values('car','araba');"); db.execsql("insert english (word,mean) values('hello','merhaba');"); db.execsql("insert english (word,mean) values('hissetmek','feel');"); db.execsql("insert english (word,mean) values('tree','ağaç');"); db.execsql("insert english (word,mean) values('house','ev');"); db.execsql("insert english (word,mean) values('plane','uçak');"); db.execsql("insert english (word,mean) values('door','kapı');"); db.execsql("insert english (word,mean) values('phone','telefon');"); db.execsql("insert english (word,mean) values('train','tren');"); db.execsql("insert english (word,mean) values('hate','nefret etmek');"); db.execsql("insert english (word,mean) values('tomato','domates');"); db.execsql("insert english (word,mean) values('bed','yatak');"); db.execsql("insert english (word,mean) values('television','televizyon');"); db.execsql("insert english (word,mean) values('money','para');"); db.execsql("insert english (word,mean) values('sport','spor');"); db.execsql("insert english (word,mean) values('score','skor');"); db.execsql("insert english (word,mean) values('note','not');"); db.execsql("insert english (word,mean) values('monitor','monitör');"); db.execsql("insert english (word,mean) values('key','anahtar');"); db.execsql("insert english (word,mean) values('code','kod');"); db.execsql("insert english (word,mean) values('database','veritabani');"); db.execsql("insert english (word,mean) values('pen','kalem');"); db.execsql("insert english (word,mean) values('school','okul');"); db.execsql("insert english (word,mean) values('class','sınıf');"); db.execsql("insert english (word,mean) values('places','mekan');"); db.execsql("insert english (word,mean) values('heart','kalp');"); db.execsql("insert english (word,mean) values('one','bir');"); db.execsql("insert english (word,mean) values('point','puan');"); db.execsql("insert english (word,mean) values('friend','arkadaş');"); db.execsql("insert english (word,mean) values('ball','top');"); db.execsql("insert english (word,mean) values('shop','dükkan');"); db.execsql("insert english (word,mean) values('truck','kamyonet');"); db.execsql("insert english (word,mean) values('wire','kablo');"); db.execsql("insert english (word,mean) values('painkiller','ağrı kesici');"); db.execsql("insert english (word,mean) values('table','masa');"); db.execsql("insert english (word,mean) values('chair','sandalye');"); db.execsql("insert english (word,mean) values('hair','saç');"); db.execsql("insert english (word,mean) values('wallet','cüzdan');"); db.execsql("insert english (word,mean) values('card','kart');"); log.i("db helper ","table english done"); //eng-turk joiner table db.execsql("create table engturk (" + "word text," + "anlami text" +");"); log.i("db helper ","table joiner created"); /************** engturk - start insert data *******************/ db.execsql("insert engturk (word,anlami) values('book','kitap');"); db.execsql("insert engturk (word,anlami) values('car','araba');"); db.execsql("insert engturk (word,anlami) values('hello','merhaba');"); db.execsql("insert engturk (word,anlami) values('hissetmek','feel');"); db.execsql("insert engturk (word,anlami) values('tree','ağaç');"); db.execsql("insert engturk (word,anlami) values('house','ev');"); db.execsql("insert engturk (word,anlami) values('plane','uçak');"); db.execsql("insert engturk (word,anlami) values('door','kapı');"); db.execsql("insert engturk (word,anlami) values('phone','telefon');"); db.execsql("insert engturk (word,anlami) values('train','tren');"); db.execsql("insert engturk (word,anlami) values('hate','nefret etmek');"); db.execsql("insert engturk (word,anlami) values('tomato','domates');"); db.execsql("insert engturk (word,anlami) values('bed','yatak');"); db.execsql("insert engturk (word,anlami) values('television','televizyon');"); db.execsql("insert engturk (word,anlami) values('money','para');"); db.execsql("insert engturk (word,anlami) values('sport','spor');"); db.execsql("insert engturk (word,anlami) values('score','skor');"); db.execsql("insert engturk (word,anlami) values('note','not');"); db.execsql("insert engturk (word,anlami) values('monitor','monitör');"); db.execsql("insert engturk (word,anlami) values('key','anahtar');"); db.execsql("insert engturk (word,anlami) values('code','kod');"); db.execsql("insert engturk (word,anlami) values('database','veritabani');"); db.execsql("insert engturk (word,anlami) values('pen','kalem');"); db.execsql("insert engturk (word,anlami) values('school','okul');"); db.execsql("insert engturk (word,anlami) values('class','sınıf');"); db.execsql("insert engturk (word,anlami) values('places','mekan');"); db.execsql("insert engturk (word,anlami) values('heart','kalp');"); db.execsql("insert engturk (word,anlami) values('one','bir');"); db.execsql("insert engturk (word,anlami) values('point','puan');"); db.execsql("insert engturk (word,anlami) values('friend','arkadaş');"); db.execsql("insert engturk (word,anlami) values('ball','top');"); db.execsql("insert engturk (word,anlami) values('shop','dükkan');"); db.execsql("insert engturk (word,anlami) values('truck','kamyonet');"); db.execsql("insert engturk (word,anlami) values('wire','kablo');"); db.execsql("insert engturk (word,anlami) values('painkiller','ağrı kesici');"); db.execsql("insert engturk (word,anlami) values('table','masa');"); db.execsql("insert engturk (word,anlami) values('chair','sandalye');"); db.execsql("insert engturk (word,anlami) values('hair','saç');"); db.execsql("insert engturk (word,anlami) values('wallet','cüzdan');"); db.execsql("insert engturk (word,anlami) values('card','kart');"); log.i("db helper ","table joiner done"); //eng-turk joiner table db.execsql("create table turkeng ("+"kelime text,"+"mean text,"+");"); log.i("db helper ","table joiner created"); /************** turkeng - start insert data *******************/ db.execsql("insert engturk (kelime,mean) values('kitap','book');"); db.execsql("insert engturk (kelime,mean) values('araba','car');"); db.execsql("insert engturk (kelime,mean) values('merhaba','hello');"); db.execsql("insert engturk (kelime,mean) values('feel','hissetmek');"); db.execsql("insert engturk (kelime,mean) values('ağaç','ağaç');"); db.execsql("insert engturk (kelime,mean) values('ev','house');"); db.execsql("insert engturk (kelime,mean) values('uçak','plane');"); db.execsql("insert engturk (kelime,mean) values('kapı','door');"); db.execsql("insert engturk (kelime,mean) values('telefon','phone');"); db.execsql("insert engturk (kelime,mean) values('tren','train');"); db.execsql("insert engturk (kelime,mean) values('nefret etmek','hate');"); db.execsql("insert engturk (kelime,mean) values('domates','tomato');"); db.execsql("insert engturk (kelime,mean) values('yatak','bed');"); db.execsql("insert engturk (kelime,mean) values('televizyon','television');"); db.execsql("insert engturk (kelime,mean) values('para','money');"); db.execsql("insert engturk (kelime,mean) values('spor','sport');"); db.execsql("insert engturk (kelime,mean) values('skor','score');"); db.execsql("insert engturk (kelime,mean) values('not','note');"); db.execsql("insert engturk (kelime,mean) values('monitör','monitor');"); db.execsql("insert engturk (kelime,mean) values('anahtar','key');"); db.execsql("insert engturk (kelime,mean) values('kod','code');"); db.execsql("insert engturk (kelime,mean) values('veritabanı','database');"); db.execsql("insert engturk (kelime,mean) values('kalem','pen');"); db.execsql("insert engturk (kelime,mean) values('okul','school');"); db.execsql("insert engturk (kelime,mean) values('sınıf','class');"); db.execsql("insert engturk (kelime,mean) values('mekan','place');"); db.execsql("insert engturk (kelime,mean) values('kalp','heart');"); db.execsql("insert engturk (kelime,mean) values('bir','one');"); db.execsql("insert engturk (kelime,mean) values('puan','point');"); db.execsql("insert engturk (kelime,mean) values('arkadaş','friend');"); db.execsql("insert engturk (kelime,mean) values('top','ball');"); db.execsql("insert engturk (kelime,mean) values('dükkan','shop');"); db.execsql("insert engturk (kelime,mean) values('kamyonet','truck');"); db.execsql("insert engturk (kelime,mean) values('kablo','wire');"); db.execsql("insert engturk (kelime,mean) values('ağrı kesici','painkiller');"); db.execsql("insert engturk (kelime,mean) values('masa','table');"); db.execsql("insert engturk (kelime,mean) values('sandalye','chair');"); db.execsql("insert engturk (kelime,mean) values('saç','hair');"); db.execsql("insert engturk (kelime,mean) values('cüzdan','wallet');"); db.execsql("insert engturk (kelime,mean) values('kart','card');"); log.i("db helper ","table joiner done"); } @override public void onupgrade(sqlitedatabase db, int oldversion, int newversion) { if (oldversion >= newversion) return; db.execsql("drop database if exists " + database_name +";"); oncreate(db); } } -------------------------------------------------------------------------------------------this english.java file
package net.dictionary.anilerdogan; import net.dictionary.anilerdogan.r; import android.app.activity; import android.database.cursor; import android.database.sqlite.sqlitedatabase; import android.graphics.drawable.drawable; import android.os.bundle; import android.util.log; import android.view.view; import android.view.view.onclicklistener; import android.widget.button; import android.widget.edittext; import android.widget.textview; import android.widget.toast; public class english extends activity implements onclicklistener { // widget protected edittext txtenglish; protected button btnaraa; protected textview tvturk; protected mydbhelper mydbhelper; // protected cursor cursor; protected sqlitedatabase db; protected drawable drawable; @override public void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.english); txtenglish= (edittext) findviewbyid(r.id.txtenglish); txtenglish.requestfocus(); btnaraa = (button) findviewbyid(r.id.btnara); btnaraa.setonclicklistener(this); tvturk = (textview) findviewbyid(r.id.vturk); // database initial mydbhelper = new mydbhelper(this); db = mydbhelper.getreadabledatabase(); } public void onclick(view v) { string ueng=""; string turkish=""; cursor ceng; //cursor cjoiner; switch (v.getid()) { case r.id.btnara: ueng=txtenglish.gettext().tostring().trim(); //search english word string qeng="select * english word= '"+ueng+"';"; log.i("-----search table english---- ",qeng); ceng = db.rawquery(qeng, null); /*if(ceng.getcount()!=0){ ceng.movetofirst(); //get turkish word in joiner table string qjoiner ="select * turkeng mean='"+ueng+"';"; log.i("-----search table joiner----- ",qjoiner); cjoiner=db.rawquery(qjoiner, null); if(cjoiner.getcount()!=0){ cjoiner.movetofirst();//go first row turkish=cjoiner.getstring(1).tostring(); tvturk.settext("in turkish : "+turkish); }*/ string qturk ="select * turkish anlami='"+ueng+"';"; log.i("-----search table turkish---- ",qturk); ceng=db.rawquery(qturk, null); ceng.movetofirst();//go first row tvturk.settext("in turkish : "+turkish); } toast.maketext(getapplicationcontext(), "unfortunately, \'"+ueng+"\' word not in db!",toast.length_short).show(); //break; //break; } } -------------------------------------------------------------------------------------------this turkish.java file
package net.dictionary.anilerdogan; import net.dictionary.anilerdogan.r; import android.app.activity; import android.database.cursor; import android.database.sqlite.sqlitedatabase; import android.graphics.drawable.drawable; import android.os.bundle; import android.util.log; import android.view.view; import android.view.view.onclicklistener; import android.widget.button; import android.widget.edittext; import android.widget.textview; import android.widget.toast; public class turkish extends activity implements onclicklistener { // widget - protected edittext txtturk; protected button btnaraa; protected textview tveng; protected mydbhelper mydbhelper; // protected cursor cursor; protected sqlitedatabase db; protected drawable drawable; @override public void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.turkish); txtturk = (edittext) findviewbyid(r.id.txtturkish); txtturk.requestfocus(); btnaraa = (button) findviewbyid(r.id.btnara); btnaraa.setonclicklistener(this); tveng = (textview) findviewbyid(r.id.veng); // database initial mydbhelper = new mydbhelper(this); db = mydbhelper.getreadabledatabase(); } public void onclick(view v) { string uturk="",english=""; //cursor cjoiner; cursor cturk; switch (v.getid()) { case r.id.btnara: uturk=txtturk.gettext().tostring().trim(); //search turkish word string qturk ="select * turkish kelime='"+uturk+"';"; log.i("-----search table turk---- ",qturk); cturk = db.rawquery(qturk, null); /*if(cturk.getcount()!=0){ cturk.movetofirst(); //get english word in joiner table string qjoiner ="select * engturk anlami='"+uturk+"';"; log.i("-----search table joiner---- ",qjoiner); cjoiner=db.rawquery(qjoiner, null); if(cjoiner.getcount()!=0){ cjoiner.movetofirst();//go first row english=cjoiner.getstring(0).tostring(); tveng.settext("ingilizcesi : "+english); }*/ string qeng ="select * english word='"+english+"';"; log.i("-----search table english---- ",qeng); cturk=db.rawquery(qeng, null); cturk.movetofirst();//go first row tveng.settext("İngilizce anlamı : "+english); } //else{ toast.maketext(getapplicationcontext(), "maalesef, \'"+uturk+"\' adında bir kelime kayıtlı değil!",toast.length_short).show(); // break; //} //break; } } //} -------------------------------------------------------------------------------------------english.xml file
<?xml version="1.0" encoding="utf-8"?> <tablelayout xmlns:android="http://schemas.android.com/apk/res/android" android:orientation="vertical" android:background="@drawable/bd" android:layout_width="fill_parent" android:layout_height="fill_parent" android:stretchcolumns="1" > <tablerow> <textview android:layout_width="fill_parent" android:layout_height="wrap_content" android:text="@string/enterenglishword" android:textcolor="#ffffff" /> </tablerow> <tablerow> <edittext android:text="" android:layout_column="0" android:id="@+id/txtenglish" android:layout_width="fill_parent" android:layout_height="wrap_content" android:layout_span="2" android:inputtype=""/> <button android:id="@+id/btnara" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_column="2" android:text="@string/btnsearch" /> </tablerow> <tablerow> <textview android:id="@+id/vturk" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_column="0" android:text="@string/inturkish" android:textcolor="#ffffff" /> </tablerow> </tablelayout>
turkish.xml file
<?xml version="1.0" encoding="utf-8"?> <tablelayout xmlns:android="http://schemas.android.com/apk/res/android" android:orientation="vertical" android:background="@drawable/bd" android:layout_width="fill_parent" android:layout_height="fill_parent" android:stretchcolumns="1" > <!-- admob --> <tablerow> <textview android:layout_width="fill_parent" android:layout_height="wrap_content" android:text="@string/turkcekelimegir" android:textcolor="#ffffff" /> </tablerow> <tablerow> <edittext android:id="@+id/txtturkish" android:layout_width="fill_parent" android:layout_height="wrap_content" android:layout_column="0" android:layout_span="2" android:inputtype="text" android:text="" /> <button android:id="@+id/btnara" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_column="2" android:text="@string/btnara" /> </tablerow> <tablerow> <textview android:id="@+id/veng" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_column="0" android:text="@string/ingilizceanlami" android:textcolor="#ffffff" /> </tablerow> </tablelayout> this application dictionary in android,and programs gives error that;
android.widget.tabhost$intentcontentstrategy.getcontentview(tabhost.java:749) 04-14 15:15:07.188: e/androidruntime(1031): @ android.widget.tabhost.setcurrenttab(tabhost.java:413) 04-14 15:15:07.188: e/androidruntime(1031): @ android.widget.tabhost.addtab(tabhost.java:240) 04-14 15:15:07.188: e/androidruntime(1031): @ net.dictionary.anilerdogan.kamusmm.newtabintent(kamusmm.java:43) 04-14 15:15:07.188: e/androidruntime(1031): @ net.dictionary.anilerdogan.kamusmm.oncreate(kamusmm.java:32) 04-14 15:15:07.188: e/androidruntime(1031): @ android.app.activity.performcreate(activity.java:5243) 04-14 15:15:07.188: e/androidruntime(1031): @ android.app.instrumentation.callactivityoncreate(instrumentation.java:1087) 04-14 15:15:07.188: e/androidruntime(1031): @ android.app.activitythread.performlaunchactivity(activitythread.java:2140) 04-14 15:15:07.188: e/androidruntime(1031): ... 11 more 04-14 15:15:07.188: e/androidruntime(1031): caused by: android.database.sqlite.sqliteexception: near ")": syntax error (code 1): , while compiling: create table turkish (kelime text,anlami text,); 04-14 15:15:07.188: e/androidruntime(1031): @ android.database.sqlite.sqliteconnection.nativepreparestatement(native method) 04-14 15:15:07.188: e/androidruntime(1031): @ android.database.sqlite.sqliteconnection.acquirepreparedstatement(sqliteconnection.java:889) 04-14 15:15:07.188: e/androidruntime(1031): @ android.database.sqlite.sqliteconnection.prepare(sqliteconnection.java:500) 04-14 15:15:07.188: e/androidruntime(1031): @ android.database.sqlite.sqlitesession.prepare(sqlitesession.java:588) 04-14 15:15:07.188: e/androidruntime(1031): @ android.database.sqlite.sqliteprogram.<init>(sqliteprogram.java:58) 04-14 15:15:07.188: e/androidruntime(1031): @ android.database.sqlite.sqlitestatement.<init>(sqlitestatement.java:31) 04-14 15:15:07.188: e/androidruntime(1031): @ android.database.sqlite.sqlitedatabase.executesql(sqlitedatabase.java:1672) 04-14 15:15:07.188: e/androidruntime(1031): @ android.database.sqlite.sqlitedatabase.execsql(sqlitedatabase.java:1603) 04-14 15:15:07.188: e/androidruntime(1031): @ net.dictionary.anilerdogan.mydbhelper.oncreate(mydbhelper.java:16) 04-14 15:15:07.188: e/androidruntime(1031): @ android.database.sqlite.sqliteopenhelper.getdatabaselocked(sqliteopenhelper.java:252) 04-14 15:15:07.188: e/androidruntime(1031): @ android.database.sqlite.sqliteopenhelper.getreadabledatabase(sqliteopenhelper.java:188) 04-14 15:15:07.188: e/androidruntime(1031): @ net.dictionary.anilerdogan.turkish.oncreate(turkish.java:48) 04-14 15:15:07.188: e/androidruntime(1031): @ android.app.activity.performcreate(activity.java:5243) 04-14 15:15:07.188: e/androidruntime(1031): @ android.app.instrumentation.callactivityoncreate(instrumentation.java:1087) 04-14 15:15:07.188: e/androidruntime(1031): @ android.app.activitythread.performlaunchactivity(activitythread.java:2140) 04-14 15:15:07.188: e/androidruntime(1031): ... 22 more 04-14 15:15:11.138: i/process(1031): sending signal. pid: 1031 sig: 9
remove commas (,) before closing brackets, , remove ending semicolons (;) in execsql() methods.
Comments
Post a Comment