package com.example.gps0528;
import java.util.ArrayList;
import android.app.Activity;
import android.app.ListActivity;
import android.content.Context;
import android.content.Intent;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
import android.os.Bundle;
import android.widget.ArrayAdapter;
import android.widget.ListView;
import android.widget.TextView;
public class dbActivity extends ListActivity {
ArrayList<String> item;
ArrayAdapter<String> adapter;
ListView listo;
TextView data;
Context context;
DBHelper dbHelper;
final static String dbName = "terbo.db";
final static int dbVersion = 2;
SQLiteDatabase db;
String sql;
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
//setContentView(R.layout.activity2nd);
// TODO Auto-generated method stub
Intent intent = getIntent();
String time = intent.getExtras().getString("time").toString();
String juso = intent.getExtras().getString("local").toString();
item = new ArrayList<String>();
item.add(time+juso);
adapter = new ArrayAdapter<String>(this,
android.R.layout.simple_list_item_multiple_choice, item);
getListView().setTextFilterEnabled(true);
//리스트액티비티의 아이디 찾는 방법은 다르다.
listo = (ListView)findViewById(android.R.id.list);
listo.setAdapter(adapter);
adapter.notifyDataSetChanged();
//db에 저장
dbHelper = new DBHelper(this, dbName, null, dbVersion);
db = dbHelper.getWritableDatabase();
sql=String.format("INSERT INTO dbName VALUES(null, '%s', '%s');", adapter, 55);
db.execSQL(sql);
}
public class DBHelper extends SQLiteOpenHelper {
//생성자
public DBHelper(Context context, String name, CursorFactory factory, int version) {
super(context, name, factory, version);
}
//최초 DB를 만들때 한번만 호출된다.
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
db.execSQL("CREATE TABLE dbName(_id INTEGER PRIMARY KEY AUTOINCREMENT,"+ "time INTEGER, juso TEXT);");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
db.execSQL("DROP TABLE IF EXISTS dbName");
onCreate(db);
}
}
}
time 필드안에
현재시간과 날짜값이 들어가야는데
안 들어가네여.
현재시간과 날짜는 이전액티비티에서 버튼을 클릭해서 얻은 값을 intent를 이용하여
위소스의 액티비티로 넘겨주는 형태입니다.
adapter값 대신 listo, item 다 넣어봤는대 안되네요
다른 문제인것 같은데...감을 못잡겠네요
산넘어 산.............산을 대체 몇개를 넘어야 ................
;;;;;
