超简单的SQLite的使用

package com.money; import java.util.Calendar; import android.app.Activity; import android.content.ContentValues; import android.content.Intent; import android.database.sqlite.SQLiteDatabase; import android.os.Bundle; import android.util.Log; import android.view.View; import android.widget.Button; import android.widget.DatePicker; import android.widget.EditText; public class Record extends Activity { public static int year; public static int month; public static int day; Calendar c; @Override protected void onCreate(Bundle savedInstanceState) { // TODO Auto-generated method stub super.onCreate(savedInstanceState); setContentView(R.layout.record); final String tag = "TAG"; final Button ok = (Button) findViewById(R.id.ok); final EditText in = (EditText) findViewById(R.id.in); final EditText out = (EditText) findViewById(R.id.out); final Button back = (Button) findViewById(R.id.back); c = Calendar.getInstance(); DatePicker date = (DatePicker) findViewById(R.id.date); date.init(c.get(Calendar.YEAR), c.get(Calendar.MONTH), c.get(Calendar.DAY_OF_MONTH), new DatePicker.OnDateChangedListener() { @Override public void onDateChanged(DatePicker view, int year, int monthOfYear, int dayOfMonth) { // TODO Auto-generated method stub Record.year = year; Record.month = monthOfYear; Record.day = dayOfMonth; c.set(year, monthOfYear, dayOfMonth); } }); back.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { // TODO Auto-generated method stub Intent intent = new Intent(); intent.setClass(Record.this, MoneyActivity.class); startActivity(intent); Record.this.finish(); } }); ok.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { // TODO Auto-generated method stub int income = Integer.parseInt(in.getText().toString()); int pay = Integer.parseInt(out.getText().toString()); Helper helper = new Helper(Record.this, "Bank", null, 1); SQLiteDatabase db = helper.getReadableDatabase(); ContentValues values = new ContentValues(); values.put("year", Record.year); values.put("month", Record.month+1); values.put("day", Record.day); values.put("pay", pay); values.put("income", income); db = helper.getWritableDatabase(); db.insert("record", null, values); } }); } }