package app.smtit_yd;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import android.app.Activity;
import android.app.AlertDialog;
import android.content.Context;
import android.content.DialogInterface;
import android.content.Intent;
import android.content.res.AssetManager;
import android.os.Bundle;
import android.view.LayoutInflater;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.view.View.OnClickListener;
import android.view.ViewGroup;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.Spinner;
public class MainActivity extends Activity {
Button alert;
static final String [] all_item = {"기본값:자동조회","월~목","금요일","토, 일"};
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
Spinner spinner = (Spinner) findViewById(R.id.selector1);
ArrayAdapter<String> adapter = new ArrayAdapter<String>
(this, android.R.layout.simple_spinner_dropdown_item, all_item);
spinner.setAdapter(adapter);
alert=(Button)findViewById(R.id.imgbtn01);
alert.setOnClickListener(clickListener1);
startActivity(new Intent(MainActivity.this, ListView_Act.class));
}
package app.smtit_yd;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import android.app.ListActivity;
import android.content.Context;
import android.content.res.AssetManager;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.widget.ArrayAdapter;
import android.widget.TextView;
public class ListView_Act extends ListActivity {
TextView tv1, tv2, tv3;
public static Context mContext;
public static final String PACKAGE_DIR = "/data/data/app.smtit_yd/";
public static final String DATABASE_NAME = "M_T_in_time.db";
public static final String COPYDATA_NAME = "M_T_in_time.db";
public static void initalize(Context ctx) {
File folder = new File(PACKAGE_DIR + "databases");
folder.mkdir();
File outfile = new File(PACKAGE_DIR + "database/" + COPYDATA_NAME);
if (outfile.length() <= 0) {
AssetManager assetManager = ctx.getResources().getAssets();
try {
InputStream is = assetManager.open(DATABASE_NAME, AssetManager.ACCESS_BUFFER);
long filesize = is.available();
byte [] tempdata = new byte[(int)filesize];
is.read();
is.close();
outfile.createNewFile();
FileOutputStream fo = new FileOutputStream(outfile);
fo.write(tempdata);
fo.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
public void onCreate(Bundle savedInstanceState) {
mContext = this;
setContentView(R.layout.activity_main);
initalize(getApplicationContext());
String [] stationTime = null;
String [] townTime = null;
String [] univTime = null;
try {
SQLiteDatabase db = openOrCreateDatabase("M_T_in_time.db", Context.MODE_PRIVATE, null);
Cursor cur = db.rawQuery("SELECT * From M_T_in_time", null);
cur.moveToFirst();
int i = 0;
do{
stationTime[i] = cur.getString(0);
townTime[i] = cur.getString(0);
univTime[i] = cur.getString(0);
i++;
} while(cur.moveToNext());
cur.close();
} catch (Exception e){
Log.i("ERROR!!!!","" + e.toString());
}
ArrayAdapter<String> s_Adap = new ArrayAdapter<String> (this, R.layout.row, R.id.station_func,stationTime);
ArrayAdapter<String> t_Adap = new ArrayAdapter<String> (this, R.layout.row, R.id.town_func,townTime);
ArrayAdapter<String> u_Adap = new ArrayAdapter<String> (this, R.layout.row, R.id.univ_func,univTime);
setListAdapter(s_Adap);
setListAdapter(t_Adap);
setListAdapter(u_Adap);
TextView tv1 = (TextView)findViewById(R.id.station_func);
TextView tv2 = (TextView)findViewById(R.id.town_func);
TextView tv3 = (TextView)findViewById(R.id.univ_func);
}
}
