안드로이드 도와 주실분 계신가용? ㅠㅠ
지금 4시간째 이것만 붙잡고 있는데 모르겟어요.. 학교 과제 인데
이제 50분 남앗네요 ㅠ 제출시간... 안드로이드 너무 어려운거 같아요..
조회 버튼을 누르면 등록한 DB가 토스트 메시지로 나와야 되는 건데..
진짜 모르겟서요 ㅠㅠ 맨 밑에쯤 보시면 else if(v.getId() == R.id.button2) 이게
조회 버튼 이거등요 ㅠㅠ 도와 주십쇼 !!!!!!!!!!!
=================================================================================
DBHandler.java
package ex.DBHomework;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
public class DBHandler {
private Context ctx;
private DBHelper helper;
private SQLiteDatabase db;
public DBHandler(Context ctx){
this.ctx = ctx;
helper = new DBHelper(ctx);
db = helper.getWritableDatabase();
}
public static DBHandler open(Context ctx) throws SQLException{
DBHandler handler = new DBHandler(ctx);
return handler;
}
public void close(){
helper.close();
}
public long insert(String name,String number,String mail){
ContentValues values = new ContentValues();
values.put("name",name);
values.put("number",number);
values.put("mail",mail);
long result = db.insert("dbtable",null, values);
return result;
}
public Cursor selectAll(){
Cursor cursor = db.query(true, "dbtable", new String[] {"id","name","number","mail"}, null, null, null, null, null, null);
return cursor;
}
public long deleteAll(String name){
long result = db.delete("dbtable", "name= '" + name + "'", null);
return result;
}
}
============================================================================================
DBHelper.java
package ex.DBHomework;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class DBHelper extends SQLiteOpenHelper {
private static final String DB_NAME = "dbz";
private static final int DB_VER = 1;
public DBHelper(Context context){
super(context,DB_NAME,null,DB_VER);
}
public void onCreate(SQLiteDatabase db){
String sql = "create table dbtable("
+"id integer primary key autoincrement,"
+"name text not null, number text not null, mail text not null)";
db.execSQL(sql);
}
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion){
db.execSQL("drop table if exist dbtable");
onCreate(db);
}
}
======================================================================================
DBHomeworkActivity.java
package ex.DBHomework;
import android.app.Activity;
import android.database.Cursor;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnCl1ickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;
public class DBHomeworkActivity extends Activity implements OnCl1ickListener {
DBHandler dbhandler;
EditText edname, ednumber, edmail;
Cursor cursor = null;
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
Button button1 = (Button) findViewById(R.id.button1);
Button button2 = (Button) findViewById(R.id.button2);
Button button3 = (Button) findViewById(R.id.button3);
button1.setOnCl1ickListener(this);
button2.setOnCl1ickListener(this);
button3.setOnCl1ickListener(this);
edname = (EditText) findViewById(R.id.editText1);
ednumber = (EditText) findViewById(R.id.editText2);
edmail = (EditText) findViewById(R.id.editText3);
}
public void onCl1ick(View v){
dbhandler = DBHandler.open(this);
if(v.getId() == R.id.button1 ){
dbhandler.insert(edname.getText().toString(), ednumber.getText().toString(), edmail.getText().toString());
String selectIdStr = edname.getText().toString()+ednumber.getText().toString()+edmail.getText().toString();
Toast.makeText(this,selectIdStr+"입력되었습니다." , Toast.LENGTH_LONG).show();
}
else if(v.getId() == R.id.button2){
String selectIdStr = edname.getText().toString();
int selectId = Integer.parseInt(selectIdStr);
Cursor cursor = dbhandler.selectAll();
startManagingCursor(cursor);
String car = cursor.getString(cursor.getColumnIndex("id"));
Toast.makeText(this,car, Toast.LENGTH_LONG).show();
}
else if(v.getId() == R.id.button3){
dbhandler.deleteAll(edname.getText().toString());
Toast.makeText(this,edname.getText().toString()+"가 삭제 되었습니다", Toast.LENGTH_LONG).show();
edname.setText("");
ednumber.setText("");
edmail.setText("");
}
dbhandler.close();
}
}
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.