일단소스는
package SQLite.testdb.test;
import android.app.Activity;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;
public class SQLiteTestActivity extends Activity implements View.OnClickListener {
private Button savebutton,raedbutton;
private TextView viewtext;
private EditText edittext;
private String outputtext;
@Override
protected void onCreate(Bundle savedInstanceState) {
// TODO Auto-generated method stub
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
savebutton = (Button)findViewById(R.id.button1);
raedbutton = (Button)findViewById(R.id.button2);
viewtext = (TextView)findViewById(R.id.textView1);
edittext = (EditText)findViewById(R.id.editText1);
savebutton.setOnClickListener(this);
raedbutton.setOnClickListener(this);
outputtext = String.valueOf(this.edittext.getText()).trim();
}
class SQLitetest2 extends SQLiteOpenHelper {
/** Called when the activity is first created. */
public SQLitetest2(Context context) {
super(context,"jjamtest.db", null, 1);
// TODO Auto-generated constructor stub
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
db.execSQL("Create table jjamtest (name TEXT,age INTEGER,nicname TEXT);");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
db.execSQL("drop table if exists jjamtest;");
onCreate(db);
}
}
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
SQLiteOpenHelper dbtest = new SQLitetest2(this);
SQLiteDatabase db = dbtest.getReadableDatabase();
switch(v.getId()){
case R.id.button1:
ContentValues cv = new ContentValues();
cv.put("name","kimchanho");
cv.put("age","26");
cv.put("nicname", outputtext);
db.insert("jjamtest", null,cv);
break;
case R.id.button2:
String msql = "select *from jjamtest;";
Cursor result;
result = db.rawQuery(msql,null);
String str = "";
while( result.moveToNext()) {
String name = result.getString(0);
int age = result.getInt(1);
String nicname = result.getString(2);
str = str + (name + " " + age + " " + nicname + "\n");
}
viewtext.setText(str);
break;
}
db.close();
}
}
저렇게 결과가 나옵니다..edittext에서 입력받는 내용을 String으로 형변환하고 이것을 다시 cv.put("nicname", outputtext); 이렇게 넣었는데 실행은 되는데 edittext에서 입력받은 내용을 저장하지못하네요..아님 getString에서 colume값을 잘못준것인지..왜안될까요??저장하기를 누르면 kimchanho와26이라는 값이 저장되고 가져오기를하면 kimchanho와26만 꺼내주네용..흑흑 ㅠㅠ




outputtext의 값을 찍어보세요.
onCreate에서 값을 가져오셨는데 당연히 그 때 값은 공백이겠죠.
onClick에서 에디트텍스트 값을 얻어와서 넣어주세요.