일단소스는

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();
}
}

제목 없음.png

저렇게 결과가 나옵니다..edittext에서 입력받는 내용을 String으로 형변환하고 이것을 다시 cv.put("nicname", outputtext); 이렇게 넣었는데 실행은 되는데 edittext에서 입력받은 내용을 저장하지못하네요..아님 getString에서 colume값을 잘못준것인지..왜안될까요??저장하기를 누르면 kimchanho와26이라는 값이 저장되고 가져오기를하면 kimchanho와26만 꺼내주네용..흑흑 ㅠㅠ