XML 입니다..
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:orientation="vertical"
android:layout_width="fill_parent"
android:layout_height="fill_parent"
>
<LinearLayout
android:orientation="horizontal"
android:layout_width="wrap_content"
android:layout_height="wrap_content">
<TextView
android:text="거래처코드"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:textSize="15px">
</TextView>
<EditText
android:id="@+id/code"
android:bufferType="editable"
android:textColor="#707070"
android:textSize="20px"
android:layout_width="200px"
android:layout_height="wrap_content">
</EditText>
</LinearLayout>
<LinearLayout
android:orientation="horizontal"
android:layout_width="wrap_content"
android:layout_height="wrap_content">
<TextView
android:text="거래처명"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:textSize="15px">
</TextView>
<EditText
android:id="@+id/name"
android:bufferType="editable"
android:textColor="#707070"
android:textSize="20px"
android:layout_width="200px"
android:layout_height="wrap_content">
</EditText>
</LinearLayout>
<LinearLayout
android:orientation="horizontal"
android:layout_width="wrap_content"
android:layout_height="wrap_content">
<TextView
android:text="거래여부"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:textSize="15px">
</TextView>
<EditText
android:id="@+id/ooo"
android:bufferType="editable"
android:textColor="#707070"
android:textSize="20px"
android:layout_width="200px"
android:layout_height="wrap_content">
</EditText>
</LinearLayout>
<LinearLayout
android:orientation="horizontal"
android:layout_width="wrap_content"
android:layout_height="wrap_content">
<TextView
android:text="담당자명"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:textSize="15px">
</TextView>
<EditText
android:id="@+id/code"
android:bufferType="editable"
android:textColor="#707070"
android:textSize="20px"
android:layout_width="200px"
android:layout_height="wrap_content">
</EditText>
</LinearLayout>
<LinearLayout
android:orientation="horizontal"
android:layout_width="wrap_content"
android:layout_height="wrap_content">
<TextView
android:text="전화번호"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:textSize="15px">
</TextView>
<EditText
android:id="@+id/name"
android:bufferType="editable"
android:textColor="#707070"
android:textSize="20px"
android:layout_width="200px"
android:layout_height="wrap_content">
</EditText>
</LinearLayout>
<LinearLayout
android:orientation="horizontal"
android:layout_width="wrap_content"
android:layout_height="wrap_content">
<TextView
android:text="주소"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:textSize="15px">
</TextView>
<EditText
android:id="@+id/code"
android:bufferType="editable"
android:textColor="#707070"
android:textSize="20px"
android:layout_width="200px"
android:layout_height="wrap_content">
</EditText>
</LinearLayout>
<LinearLayout
android:orientation="horizontal"
android:layout_width="wrap_content"
android:layout_height="wrap_content">
<TextView
android:text="E-Mail"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:textSize="15px">
</TextView>
<EditText
android:id="@+id/code"
android:bufferType="editable"
android:textColor="#707070"
android:textSize="20px"
android:layout_width="200px"
android:layout_height="wrap_content">
</EditText>
</LinearLayout>
<LinearLayout
android:orientation="horizontal"
android:layout_width="wrap_content"
android:layout_height="wrap_content">
<Button
android:text="읽기"
android:id="@+id/Button_read"
android:textSize="15px"
android:gravity="fill"
android:layout_width="82px"
android:layout_height="wrap_content">
</Button>
<Button
android:text="쓰기 "
android:id="@+id/Button_write"
android:textSize="15px"
android:gravity="fill"
android:layout_width="82px"
android:layout_height="wrap_content">
</Button>
<Button
android:text="삭제 "
android:id="@+id/Button_delete"
android:textSize="15px"
android:gravity="fill"
android:layout_width="82px"
android:layout_height="wrap_content">
</Button>
</LinearLayout>
<EditText
android:text="정보읽기/삭제>>"
android:id="@+id/et_queryprint"
android:textSize="15px"
android:textColor="#0000ff"
android:layout_width="fill_parent"
android:layout_height="fill_parent">
</EditText>
</LinearLayout>
java 소스입니다
package com.hannam.project.sqlite;
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.SQLiteOpenHelper;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;
public class ActivityAndroidSQLite extends Activity {
private EditText user_id = null;
private EditText user_passwd = null;
private EditText query_print = null;
private Button infoRead = null;
private Button infoWrite = null;
private Button infoDelete = null;
private final String db_file_name = "data.db";
private final int db_version = 1;
private DBHelper dbHelper = null;
private SQLiteDatabase sqliteDB = null;
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
this.user_id = (EditText) findViewById(R.id.code);
this.user_passwd = (EditText) findViewById(R.id.name);
this.query_print = (EditText) findViewById(R.id.et_queryprint);
this.infoRead = (Button) findViewById(R.id.Button_read);
this.infoWrite = (Button) findViewById(R.id.Button_write);
this.infoDelete = (Button) findViewById(R.id.Button_delete);
this.infoRead.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
String str = "";
Cursor cursor = null;
System.out.println("읽기버튼클릭");
try {
cursor = readDB(user_id.getText().toString(), user_passwd
.getText().toString());
cursor.moveToFirst();
System.out
.println("커서의 현재 포커스위치 : " + cursor.getPosition());
System.out.println("컬럼의 수 : " + cursor.getColumnCount());
System.out.println("레코드 수 : " + cursor.getCount());
while (true) {
for (int i = 0; i < cursor.getColumnCount(); i++) {
str += cursor.getColumnName(i) + " : "
+ cursor.getString(i) + " ";
}
break;
}
query_print.setText(str);
} catch (Exception e) {
System.out.println("읽기 에러발생 : " + e.getMessage());
} finally {
cursor.close();
}
}
});
this.infoWrite.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
System.out.println("쓰기 버튼 클릭");
try {
writeDB(user_id.getText().toString(), user_passwd.getText()
.toString());
} catch (Exception e) {
System.out.println("쓰기에러발생 : " + e.getMessage());
}
}
});
this.infoDelete.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
System.out.println("삭제 버튼 클릭");
try {
deleteDB(user_id.getText().toString(), user_passwd
.getText().toString());
} catch (Exception e) {
System.out.println("삭제 에러발생 : " + e.getMessage());
}
}
});
this.dbHelper = new DBHelper(this);
this.sqliteDB = this.dbHelper.getWritableDatabase();
}
private void writeDB(String id, String passwd) throws Exception {
ContentValues cv = new ContentValues();
cv.put("Id", id);
cv.put("passwd", passwd);
long colNum = this.sqliteDB.insert("IDPASSWORD", "", cv);
this.showToast("쓰기 완료 : " + colNum);
}
private Cursor readDB(String id, String passwd) throws Exception {
Cursor cursor = this.sqliteDB.query("IDPASSWORD", new String[] { "id",
"passwd" }, "id = ? and passwd = ?",
new String[] { id, passwd }, null, null, null, null);
this.showToast("읽기완료");
return cursor;
}
private void deleteDB(String id, String passwd) throws Exception {
int colNum = this.sqliteDB.delete("IDPASSWORD", "id = ? and passwd = ?", new String[]{id,passwd});
this.showToast("삭제 완료 : " + colNum);
}
public class DBHelper extends SQLiteOpenHelper {
public DBHelper(Context context) {
super(context,db_file_name,null, db_version);
}
@Override
public void onCreate(SQLiteDatabase db) {
System.out.println("데이터베이스가 생성되었습니다.");
}
@Override
public synchronized void close() {
super.close();
System.out.println("데이터베이스가 닫혔습니다.");
}
@Override
public void onOpen(SQLiteDatabase db) {
super.onOpen(db);
System.out.println("데이터베이스가 오픈되었습니다.");
db.execSQL("create table if not exists IDPASSWORD" + "(id VARCHAR(20) primary key," + "passwd CARCHAR(20))");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("drop table if exists IDPASSWORD");
onCreate(db);
}
}
private void showToast(String msg) {
Toast.makeText(getApplicationContext(), msg, Toast.LENGTH_SHORT).show();
}
@Override
protected void onDestroy() {
super.onDestroy();
this.sqliteDB.close();
}
}
현재 이 소스인데.. 첨부파일처럼 구현했습니다. 만들고싶습니다. 레이아웃은 지금 첨부파일의 사진처럼 만들었는데..
저상태에서 저장되게 하려면 어떻게 해야하는지 궁금합니다.
처음부터 만든게 아니라 변형시킨거라서 더 어렵겠지만.. 가능하리라 봅니다
고수님들 도와주셔요!!! 약간만 고치면 될거깥은데... 원래 초기에는 버튼이 2개뿐이였습니다.
ID,PW 였거든요.