package org.nashorn.Exam0901;
import static org.nashorn.Exam0901.Constants.TABLE_NAME;
import static org.nashorn.Exam0901.Constants.WORD;
import static org.nashorn.Exam0901.Constants.DEFINITION;
import java.util.ArrayList;
import android.app.Activity;
import android.content.ContentValues;
import android.database.*;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.ListView;
import android.widget.Toast;
public class Exam0901 extends Activity {
private String[ ] wordList = null;
private String[ ] definitionList = null;
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
/* */
Button addButton = (Button)findViewById(R.id.add);
addButton.setOnClickListener(new View.OnClickListener( ) {
@Override
public void onClick(View arg0) {
// TODO Auto-generated method stub
writeDatabase( );
readDatabase( );
}
});
}
public void writeDatabase( )
{
Dictionary dictionary = new Dictionary(this);
/* */
try {
SQLiteDatabase db = dictionary.getWritableDatabase( );
ContentValues values = new ContentValues( );
values.put(WORD, "test");
values.put(DEFINITION, "테스트");
db.insertOrThrow(TABLE_NAME, null, values);
}
catch (Throwable t) {
Toast
.makeText(this, "Exception: "+t.toString( ), 2000)
.show( );
}
}
public void readDatabase( )
{
Cursor curosor;
int listcount = 0;
Dictionary dictionary = new Dictionary(this);
/* */
try {
String[ ] FROM = { WORD, DEFINITION };
SQLiteDatabase db = dictionary.getReadableDatabase( );
/<-----------------에러부분---------------------->/
cursor = db.query(TABLE_NAME, FROM, null, null, null, null,
null);
startManagingCursor(cursor);
wordList = new String[cursor.getCount( )];
definitionList = new String[cursor.getCount( )];
while(cursor.moveToNext( )) {
wordList[listcount] = cursor.getString(0);
definitionList[listcount] = cursor.getString(1);
listcount++;
/<-----------------에러부분----------------->/
}
} finally {
dictionary.close( );
}
if (listcount > 0) {
ArrayList<String> listString = new ArrayList<String>( );
for (int i = 0; i < wordList.length; i++)
{
listString.add(wordList[i]+" ("+definitionList[i]+")");
}
ListView listView = (ListView)findViewById(R.id.list);
ArrayAdapter<String> arrayAdapter = new
ArrayAdapter<String>(getBaseContext( ),
android.R.layout.simple_list_item_1, listString);
listView.setAdapter(arrayAdapter);
}
}
}
sql lite 예제 리스트뷰 만들고 있는데
밑줄 cursor가 아닌가요? 에러 납니다. 도와주세요. 책보고 똑같이 만든건데 안되네요.



