之前一直在电脑上用Excel表格记录家庭帐单，不久前重装系统不小心干掉了，伤心了好久，那可是我记了五年的帐单呀！这段时间用的是随手记，好用但是不太符合我的习惯，所以我自己写了一个小小的帐单记录APP，App小到只有一个Activity。当然更多的需求我正在研发中，呵呵！现在已经完成了把每天记录的数据保存到Sqilte数据库中，然后可以导出到excel表格。代码也是借助网上的一些资料写成的，代码也比较容易，，只需要用到一个jxl.jar包，感谢网友的帮助。
贴上主要代码，再附上文件包：
public class MainActivity extends Activity implements OnClickListener {private EditText mFoodEdt;private EditText mArticlesEdt;private EditText mTrafficEdt;private EditText mTravelEdt;private EditText mClothesEdt;private EditText mDoctorEdt;private EditText mRenQingEdt;private EditText mBabyEdt;private EditText mLiveEdt;private EditText mOtherEdt;private EditText mRemarkEdt;private Button mSaveBtn;private File file;private String[] title = { "日期", "食物支出", "日用品项", "交通话费", "旅游出行", "穿着支出", "医疗保健", "人情客往", "宝宝专项", "房租水电", "其它支出", "备注说明" };private String[] saveData;private DBHelper mDbHelper;private ArrayList<ArrayList<String>>bill2List;@Overrideprotected void onCreate(Bundle savedInstanceState) {super.onCreate(savedInstanceState);setContentView(R.layout.activity_main);findViewsById();mDbHelper = new DBHelper(this);mDbHelper.open();bill2List=new ArrayList<ArrayList<String>>();}private void findViewsById() {mFoodEdt = (EditText) findViewById(R.id.family_bill_food_edt);mArticlesEdt = (EditText) findViewById(R.id.family_bill_articles_edt);mTrafficEdt = (EditText) findViewById(R.id.family_bill_traffic_edt);mTravelEdt = (EditText) findViewById(R.id.family_bill_travel_edt);mClothesEdt = (EditText) findViewById(R.id.family_bill_clothes_edt);mDoctorEdt = (EditText) findViewById(R.id.family_bill_doctor_edt);mRenQingEdt = (EditText) findViewById(R.id.family_bill_laiwang_edt);mBabyEdt = (EditText) findViewById(R.id.family_bill_baby_edt);mLiveEdt = (EditText) findViewById(R.id.family_bill_live_edt);mOtherEdt = (EditText) findViewById(R.id.family_bill_other_edt);mRemarkEdt = (EditText) findViewById(R.id.family_bill_remark_edt);mSaveBtn = (Button) findViewById(R.id.family_bill_save);mSaveBtn.setOnClickListener(this);}@Overridepublic void onClick(View v) {if (v.getId() == R.id.family_bill_save) {saveData = new String[] { new SimpleDateFormat("yyyy-MM-dd").format(new Date()), mFoodEdt.getText().toString().trim(), mArticlesEdt.getText().toString().trim(), mTrafficEdt.getText().toString().trim(), mTravelEdt.getText().toString().trim(), mClothesEdt.getText().toString().trim(), mDoctorEdt.getText().toString().trim(), mRenQingEdt.getText().toString().trim(), mBabyEdt.getText().toString().trim(), mLiveEdt.getText().toString().trim(), mOtherEdt.getText().toString().trim(), mRemarkEdt.getText().toString().trim() };if (canSave(saveData)) {ContentValues values = new ContentValues();values.put("time", new SimpleDateFormat("yyyy-MM-dd").format(new Date()));values.put("food", mFoodEdt.getText().toString());values.put("use", mArticlesEdt.getText().toString());values.put("traffic", mTrafficEdt.getText().toString());values.put("travel", mTravelEdt.getText().toString());values.put("clothes", mClothesEdt.getText().toString());values.put("doctor", mDoctorEdt.getText().toString());values.put("laiwang", mRenQingEdt.getText().toString());values.put("baby", mBabyEdt.getText().toString());values.put("live", mLiveEdt.getText().toString());values.put("other", mOtherEdt.getText().toString());values.put("remark", mRemarkEdt.getText().toString());long insert = mDbHelper.insert("family_bill", values);if (insert > 0) {initData();}}else {Toast.makeText(this, "请填写任意一项内容", Toast.LENGTH_SHORT).show();}}}@SuppressLint("SimpleDateFormat")public void initData() {file = new File(getSDPath() + "/Family");makeDir(file);ExcelUtils.initExcel(file.toString() + "/bill.xls", title);ExcelUtils.writeObjListToExcel(getBillData(), getSDPath() + "/Family/bill.xls", this);}private ArrayList<ArrayList<String>> getBillData() {Cursor mCrusor = mDbHelper.exeSql("select * from family_bill");while (mCrusor.moveToNext()) {ArrayList<String> beanList=new ArrayList<String>();beanList.add(mCrusor.getString(1));beanList.add(mCrusor.getString(2));beanList.add(mCrusor.getString(3));beanList.add(mCrusor.getString(4));beanList.add(mCrusor.getString(5));beanList.add(mCrusor.getString(6));beanList.add(mCrusor.getString(7));beanList.add(mCrusor.getString(8));beanList.add(mCrusor.getString(9));beanList.add(mCrusor.getString(10));beanList.add(mCrusor.getString(11));beanList.add(mCrusor.getString(12));bill2List.add(beanList);}mCrusor.close();return bill2List;}public static void makeDir(File dir) {if (!dir.getParentFile().exists()) {makeDir(dir.getParentFile());}dir.mkdir();}public String getSDPath() {File sdDir = null;boolean sdCardExist = Environment.getExternalStorageState().equals(android.os.Environment.MEDIA_MOUNTED);if (sdCardExist) {sdDir = Environment.getExternalStorageDirectory();}String dir = sdDir.toString();return dir;}private boolean canSave(String[] data) {boolean isOk = false;for (int i = 0; i < data.length; i++) {if (i > 0 && i < data.length) {if (!TextUtils.isEmpty(data[i])) {isOk = true;}}}return isOk;}}
———————————–
就是对虚怀若谷谦虚谨慎八个字真正理解的人，
