package pulsebeat.example.excelToDatabase;

import java.io.InputStream;

import jxl.Cell;

import jxl.Sheet;

import jxl.Workbook;

import android.app.Activity;

import android.database.Cursor;

import android.os.Bundle;

import android.util.Log;

import android.view.View;

import android.widget.Button;

import android.widget.TextView;

publicclass MainActivity extends Activity {

private NotesDbAdapter dbAdapter;

privatestaticfinal String TAG = "NotesDbAdapter";

@Override

publicvoid onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.main);

Log.d(TAG, "DatabaseTest :: onCreate()");

this.dbAdapter = new NotesDbAdapter(this);

copyExcelDataToDatabase();

Button bt = (Button) findViewById(R.id.addButton);

bt.setOnClickListener(new View.OnClickListener() {

publicvoid onClick(View v) {

String title = "러키";

String body = "해피";

dbAdapter.open();

dbAdapter.createNote(title, body);

dbAdapter.close();

TextView tv = (TextView) findViewById(R.id.message);

tv.setText(title + ", " + body + "를추가하였습니다.");

}

});

Button bt1 = (Button) findViewById(R.id.loadButton);

bt1.setOnClickListener(new View.OnClickListener() {

publicvoid onClick(View v) {

dbAdapter.open();

Cursor result = dbAdapter.fetchAllNotes();

result.moveToFirst();

String resultStr = "";

while (!result.isAfterLast()) {

String title = result.getString(1);

String body = result.getString(2);

resultStr += title + ", " + body + "\n";

result.moveToNext();

}

TextView tv = (TextView) findViewById(R.id.message);

tv.setText(resultStr);

result.close();

dbAdapter.close();

}

});

}

privatevoid copyExcelDataToDatabase() {

Log.w("ExcelToDatabase", "copyExcelDataToDatabase()");

Workbook workbook = null;

Sheet sheet = null;

try {

InputStream is =

getBaseContext().getResources().getAssets().open("notes.xls");

workbook = Workbook.getWorkbook(is);

if (workbook != null) {

sheet = workbook.getSheet(0);

if (sheet != null) {

int nMaxColumn = 2;

int nRowStartIndex = 0;

int nRowEndIndex =

sheet.getColumn(nMaxColumn-1).length - 1;

int nColumnStartIndex = 0;

int nColumnEndIndex = sheet.getRow(2).length - 1;

dbAdapter.open();

for (int nRow = nRowStartIndex; nRow <= nRowEndIndex; nRow++) {

String title =

sheet.getCell(nColumnStartIndex, nRow).getContents();

String body =

sheet.getCell(nColumnStartIndex + 1, nRow).getContents();

dbAdapter.createNote(title, body);

}

dbAdapter.close();

} else {

System.out.println("Sheet is null!!");

}

} else {

System.out.println("WorkBook is null!!");

}

} catch (Exception e) {

e.printStackTrace();

} finally {

if (workbook != null) {

workbook.close();

}

}

}

}

InputStream is = getBaseContext().getResources().getAssets().open("notes.xls");

<?xmlversion="1.0"encoding="utf-8"?>

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"

android:layout_width="fill_parent"

android:layout_height="wrap_content"

android:orientation="vertical">

<TextView

android:id="@+id/message"

android:layout_width="fill_parent"

android:layout_height="wrap_content"

android:text="@string/hello"

/>

<Button

android:id="@+id/loadButton"

android:layout_height="wrap_content"

android:text="데이터베이스불러오기"

android:lines="2"

android:layout_gravity="center_vertical"

android:layout_width="fill_parent"

/>

<Button

android:id="@+id/addButton"

android:layout_height="wrap_content"

android:text="데이터베이스추가"

android:lines="2"

android:layout_gravity="center_vertical"

android:layout_width="fill_parent"

/>

</LinearLayout>