/*main Activity类*/
package com.example.trvl;
import android.os.Bundle;
import android.app.Activity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.support.v4.widget.SimpleCursorAdapter;
import android.util.Log;
import android.view.Menu;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.SimpleAdapter;
import android.widget.Spinner;
import android.widget.Toast;
public class MainActivity extends Activity {
MyDatabaseHelper dbHelper;
Button insert = null;
Button dbQuery = null;
Spinner spi = null ;
Spinner spi2 = null ;
Cursor cursor = null;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
dbHelper = new MyDatabaseHelper(this, "ppmy.db", 1);
insert = (Button) findViewById(R.id.button1);
dbQuery = (Button) findViewById(R.id.query);
insert.setOnClickListener(new OnClickListener() {
@Override