public class RegisterActivity extends Activity{
@Override
 protected void onCreate (Bundle savedInstanceState){
super.onCreate(savedInstanceState);
 setContentView(R.layout.activity_register);

 }
myDBHelper myHelper = new myDBHelper(this);
 EditText edtId, edtPw, edtName, edtAdd, edtBirth, edtPhone, edtMphone, edtEmail;
 public class myDBHelper extends SQLiteOpenHelper{
public myDBHelper(Context context){
super(context, "DB",null,1);
 }
@Override
 public void onCreate (SQLiteDatabase db){
db.execSQL("CREATE TABLE memberTBL (ID CHAR(8) PRIMARY KEY, PW CHAR(10), NAME CHAR(20), " +
"BIRTH CHAR(10), ADDRESS CHAR(100), PHONE CHAR(13), MPHONE CHAR(13), EMAIL CHAR(50));");
 edtId = (EditText) findViewById(R.id.edtId);
 edtPw = (EditText) findViewById(R.id.edtPw);
 edtName = (EditText) findViewById(R.id.edtName);
 edtAdd = (EditText) findViewById(R.id.edtAdd);
 edtBirth = (EditText) findViewById(R.id.edtBirth);
 edtPhone = (EditText) findViewById(R.id.edtPhone);
 edtMphone = (EditText) findViewById(R.id.edtMphone);
 edtEmail = (EditText) findViewById(R.id.edtEmail);
 }
@Override
 public void onUpgrade (SQLiteDatabase db, int oldVersion, int newVersion){
}
}
SQLiteDatabase memberDB;
 public void 온클릭(View v){
switch(v.getId()){
case R.id.registerDB :
memberDB = myHelper.getWritableDatabase();
 if(memberDB.isOpen()){
memberDB.execSQL("INSERT INTO memberTBL VALUES('" + edtId.getText().toString() +
"', '" + edtPw.getText().toString() + "', '" + edtName.getText().toString() +
"', '" + edtBirth.getText().toString() + "', '" + edtAdd.getText().toString() +
"', '" + edtPhone.getText().toString() + "', '" + edtMphone.getText().toString() +
"', '" + edtEmail.getText().toString() + "');");
 memberDB.close();
 Toast.makeText(this, "등록되었습니다", Toast.LENGTH_SHORT).show();
 break;
 }
else Toast.makeText(this, "DB 등록 오류!", Toast.LENGTH_SHORT).show();
 case R.id.cancel_register :
finish(); break;
 }
}
}