Android 个人理财工具四：添加账单页面下

2019-12-12 05:29:50

字体：大中小

来源：转载

供稿：网友

本文考虑把账单界面整理下，实现如下图中的功能。做之前感觉应该不难，但实际做时发现排列界面布局甚至比编写程序代码还要复杂。网上搜索发现，关于这种布局的资料能用的很少，Google Demo中用的最多的就是Listview了，但本实例的界面似乎要复杂一些。

spinner和cursor如何配合使用成了完成此实例过程中的难点，本来应该很简单，但却把我郁闷坏了。

先给大家贴上最终的效果图片：

界面的xml：

XML/HTML代码

<?xml version="1.0" encoding="utf-8"?> <ScrollView xmlns:android="http://schemas.android.com/apk/res/android"  android:orientation="vertical"  android:layout_height="fill_parent" android:layout_width="fill_parent"> <LinearLayout android:id="@+id/LinearLayout01" android:orientation="vertical" android:layout_height="fill_parent" android:layout_width="fill_parent">  <LinearLayout android:id="@+id/LinearLayout02" android:layout_width="wrap_content" android:layout_height="wrap_content">  <TextView android:id="@+id/TextView01" android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="选择账目" android:minWidth="80dip" android:textAppearance="?android:attr/textAppearanceLarge"></TextView>  <EditText android:id="@+id/edittext_acctitem" android:layout_width="wrap_content" android:layout_height="wrap_content" android:width="200dip" android:maxLines="1" android:editable="false" android:cursorVisible="false"></EditText>   </LinearLayout>  <View android:layout_width="fill_parent" android:layout_height="1dip" android:background="?android:attr/listDivider"/>  <LinearLayout android:id="@+id/LinearLayout03" android:layout_width="wrap_content" android:layout_height="wrap_content">  <TextView android:id="@+id/TextView03" android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="填入费用" android:minWidth="80dip" android:textAppearance="?android:attr/textAppearanceLarge"></TextView>  <EditText android:id="@+id/Fee" android:layout_width="wrap_content" android:layout_height="wrap_content" android:numeric="decimal" android:width="160dip"></EditText>  <TextView android:id="@+id/TextView13" android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="(元)" android:textAppearance="?android:attr/textAppearanceLarge"></TextView>  </LinearLayout>  <View android:layout_width="fill_parent" android:layout_height="1dip" android:background="?android:attr/listDivider"/>  <LinearLayout android:id="@+id/LinearLayout04" android:layout_height="wrap_content" android:layout_width="fill_parent">  <TextView android:id="@+id/TextView02" android:layout_height="wrap_content" android:text="选择时间" android:layout_width="fill_parent" android:fadingEdge="horizontal" android:height="24dip" android:drawablePadding="2dip"></TextView>  </LinearLayout>   <LinearLayout android:id="@+id/LinearLayout05" android:layout_width="wrap_content" android:layout_height="wrap_content">  <TextView android:id="@+id/vdate" android:layout_width="wrap_content" android:layout_height="wrap_content" android:textAppearance="?android:attr/textAppearanceLarge" android:width="120dip"></TextView>  <Button android:id="@+id/BtnDate" android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="+" android:textStyle="bold" android:textSize="24dip" android:height="30dip" android:width="30dip"></Button>  <TextView android:id="@+id/vtime" android:layout_width="wrap_content" android:layout_height="wrap_content" android:textAppearance="?android:attr/textAppearanceLarge" android:width="80dip" android:gravity="center_horizontal"></TextView>  <Button android:id="@+id/BtnTime" android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="+" android:textStyle="bold" android:textSize="24dip"></Button>  </LinearLayout>  <View android:layout_width="fill_parent" android:layout_height="1dip" android:background="?android:attr/listDivider"/>  <LinearLayout android:id="@+id/LinearLayout06" android:layout_height="wrap_content" android:layout_width="fill_parent">  <TextView android:id="@+id/TextView01" android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="账目类型" android:minWidth="80dip" android:textAppearance="?android:attr/textAppearanceLarge"></TextView>   <Spinner android:id="@+id/Spinner01" android:layout_height="wrap_content" android:minWidth="200dip" android:layout_width="wrap_content"></Spinner>  </LinearLayout>  <View android:layout_width="fill_parent" android:layout_height="1dip" android:background="?android:attr/listDivider"/>  <TextView android:id="@+id/TextView07" android:layout_height="wrap_content" android:text="填写备注" android:layout_width="fill_parent" android:height="24dip" ></TextView>  <EditText android:id="@+id/EditTextDESC" android:layout_width="fill_parent" android:layout_height="wrap_content" android:lines="4" android:gravity="top"></EditText>  <View android:layout_width="fill_parent" android:layout_height="1dip" android:background="?android:attr/listDivider"/>  <LinearLayout android:id="@+id/LinearLayout08" android:layout_height="wrap_content" android:layout_width="fill_parent">  <Button android:id="@+id/BtnSave" android:width="160dip" android:text="保 存" android:textStyle="bold" android:textSize="24dip" android:layout_width="wrap_content" android:layout_height="wrap_content"></Button>  <Button android:id="@+id/BtnCancel" android:width="160dip" android:text="取 消" android:textStyle="bold" android:textSize="24dip" android:layout_width="wrap_content" android:layout_height="wrap_content"></Button>  </LinearLayout>  <View android:layout_width="fill_parent" android:layout_height="1dip" android:background="?android:attr/listDivider"/> </LinearLayout> </ScrollView>

下面我们来看下spinner和cursor的用法。

主要就是一个SimpleCursorAdapter。

代码如下：

Java代码

s1=(Spinner) findViewById(R.id.Spinner01); String[] from= new String[]{"caption"};//需要显示游标里面的字段 int[] to=new int[]{android.R.id.text1}; Cursor cur=billdb.getUserid(); SimpleCursorAdapter mAdapter=new SimpleCursorAdapter(this,android.R.layout.simple_spinner_item, cur,from, to); mAdapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item); s1.setAdapter(mAdapter);

我在这儿居然搞了2天，其实写法一直没错，可是每次报未知的行 _ID。这个错误我也知道就是使用SimpleCursorAdapter 该方法的游标里面必须包括一个_ID的字段，可是我的表里面肯定有的，在我重试了无数次后发现，区分大小写，我倒!

而事实上我建表的语句是：

Java代码

db.execSQL("Create table tusers (_id integer primary key autoincrement," +  "caption text not null)");

而我在函数getUserid 里面cursor定义是：

Java代码

public Cursor getUserid(){  Log.v("cola","run get users cursor");  return db.query("tusers", new String[]{"_ID", "caption" }, null, null, null, null, null);  }

你单独测试这个cursor是没有问题的。

这都没用问题,也就是在这儿是不区分大小写的。但是如果你用这个cursor 绑定到SimpleCursorAdapter 这个里面去，一定要和建表语句的一致，不然就出错。这儿把我郁闷坏了。

上面界面布局和这个spinner 搞定后，后面就是完善代码，完善界面的功能，没有新的地方了。

在用户选择完账目，填写费用，选择时间，账目类型后就保存进数据库bills表。

附最新的代码Frm_Addbills.java：

Java代码

package com.cola.ui; import java.util.Calendar; import java.util.TimeZone; import android.app.Activity; import android.app.AlertDialog; import android.app.DatePickerDialog; import android.app.Dialog; import android.app.TimePickerDialog; import android.content.DialogInterface; import android.content.Intent; import android.database.Cursor; import android.os.Bundle; import android.util.Log; import android.view.KeyEvent; import android.view.Menu; import android.view.MenuItem; import android.view.View; import android.view.View.OnClickListener; import android.widget.Button; import android.widget.DatePicker; import android.widget.EditText; import android.widget.SimpleCursorAdapter; import android.widget.Spinner; import android.widget.TextView; import android.widget.TimePicker; import android.widget.Toast; public class Frm_Addbills extends Activity implements OnClickListener {  EditText edittext_acctitem,EditTextDESC,Fee;  TextView mDate;  TextView mTime;  static final int RG_REQUEST = 0;   private int mYear;  private int mMonth;  private int mDay;  private int mHour;  private int mMinute;  Spinner s1;  Button BtnDate,BtnTime;  Button BtnCancel,BtnSave;   BilldbHelper billdb;   int acctitemid=-1;  public void onCreate(Bundle icicle) {  super.onCreate(icicle);  setTitle("ColaBox-添加账单");  setContentView(R.layout.frm_addbills);   edittext_acctitem = (EditText)findViewById(R.id.edittext_acctitem);  edittext_acctitem.setOnClickListener(this);   EditTextDESC=(EditText)findViewById(R.id.EditTextDESC);  Fee=(EditText)findViewById(R.id.Fee);   BtnDate=(Button)findViewById(R.id.BtnDate);  BtnDate.setOnClickListener(this);  BtnTime=(Button)findViewById(R.id.BtnTime);  BtnTime.setOnClickListener(this);   BtnCancel=(Button)findViewById(R.id.BtnCancel);  BtnCancel.setOnClickListener(this);  BtnSave=(Button)findViewById(R.id.BtnSave);  BtnSave.setOnClickListener(this);   mDate = (TextView) findViewById(R.id.vdate);  mTime = (TextView) findViewById(R.id.vtime);   //Calendar c=Calendar.getInstance(Locale.CHINA);  initTime();    setDatetime();  billdb = new BilldbHelper(this);  s1=(Spinner) findViewById(R.id.Spinner01);  String[] from= new String[]{"caption"};  int[] to=new int[]{android.R.id.text1};  Cursor cur=billdb.getUserid();  SimpleCursorAdapter mAdapter=new SimpleCursorAdapter(this,android.R.layout.simple_spinner_item, cur,from, to);  mAdapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);  s1.setAdapter(mAdapter);    }  public boolean onCreateOptionsMenu(Menu menu) {  super.onCreateOptionsMenu(menu);  menu.add(0, 1, 0, "账目明细").setIcon(R.drawable.editbills);  menu.add(0, 2, 0, "账目统计").setIcon(R.drawable.editbills2);  menu.add(0, 3, 0, "账目报表").setIcon(R.drawable.billsum1);  menu.add(0, 4, 0, "退 出").setIcon(R.drawable.quit);   return true;  }  public void onClick(View v) {  if (v.equals(edittext_acctitem)) {  Log.v("ColaBox", "cmd=edittext_acctitem");  Intent intent = new Intent();  intent.setClass(Frm_Addbills.this, Frm_Editacctitem.class);  startActivityForResult(intent, RG_REQUEST);  } else if (v.equals(BtnTime)){  showDialog(1);  } else if (v.equals(BtnDate)){  showDialog(2);  } else if (v.equals(BtnCancel)){  cancel();  } else if (v.equals(BtnSave)){  save();  }   }  public boolean onOptionsItemSelected(MenuItem item) {  //Log.v("ColaBox", "getmenuitemid=" + item.getItemId());  switch (item.getItemId()) {  case 1:  return true;  case 2:   return true;  case 3:  return true;  case 4:  QuitApp();  return true;  }  return false;  }  public void QuitApp() {  new AlertDialog.Builder(Frm_Addbills.this).setTitle("提示").setMessage(  "确定退出?").setIcon(R.drawable.quit).setPositiveButton("确定",  new DialogInterface.OnClickListener() {   public void onClick(DialogInterface dialog, int whichButton) {   billdb.close();   finish();   }  }).setNegativeButton("取消",  new DialogInterface.OnClickListener() {   public void onClick(DialogInterface dialog, int whichButton) {   }  }).show();  }  protected void onActivityResult(int requestCode, int resultCode, Intent data) {  if (requestCode == RG_REQUEST) {  if (resultCode == RESULT_CANCELED) {  // setTitle("Canceled...");  } else if (resultCode == RESULT_OK) {  // setTitle((String)data.getCharSequenceExtra("DataKey"));  edittext_acctitem.setText((String) data.getCharSequenceExtra("name"));  acctitemid=Integer.parseInt((String)data.getCharSequenceExtra("id"));  Log.v("cola","get acctitemid="+acctitemid);    }  }  }   private void cancel(){  Log.v("cola","u put cancel btn");  edittext_acctitem.setText("");  Fee.setText("");  acctitemid=-1;  initTime();setDatetime();  EditTextDESC.setText("");  }  private void save(){  Log.v("cola","u put save btn");  if (acctitemid==-1){  new AlertDialog.Builder(this)  .setMessage("请首先选择账目.")  .show();  return;  }  int fee=0;  String s=Fee.getText().toString();  int pos=s.indexOf(".");  //Log.v("cola","i="+(s.length()-pos));  if (pos>0){  if (s.length()-pos<3){  s=s+"0";  }  fee=Integer.parseInt(s.substring(0,pos)+s.substring(pos+1,pos+3));  }else{  fee=Integer.parseInt(s)*100;   }  Log.v("cola","u put save btn");  if (billdb.Bills_save(acctitemid,fee,(int)s1.getSelectedItemId(), ((TextView)mDate).getText().toString(), ((TextView)mTime).getText().toString(),EditTextDESC.getText().toString())){  Toast.makeText(this, "保存成功.", Toast.LENGTH_SHORT).show();  cancel();  }else{  Toast.makeText(this, "保存失败,请检查数据.", Toast.LENGTH_SHORT).show();  }  }   public boolean onKeyDown(int keyCode, KeyEvent event) {   switch (keyCode) {  case KeyEvent.KEYCODE_BACK:  QuitApp();  return true;   }  return false;  }  private void initTime(){  Calendar c = Calendar. getInstance(TimeZone.getTimeZone("GMT+08:00"));  mYear = c.get(Calendar.YEAR);  mMonth = c.get(Calendar.MONTH);  mDay = c.get(Calendar.DAY_OF_MONTH);  mHour = c.get(Calendar.HOUR_OF_DAY);  mMinute = c.get(Calendar.MINUTE);  }   private void setDatetime(){  mDate.setText(mYear+"-"+mMonth+"-"+mDay);  mTime.setText(pad(mHour)+":"+pad(mMinute));  }   @Override  protected Dialog onCreateDialog(int id) {  switch (id) {  case 1:  return new TimePickerDialog(this,   mTimeSetListener, mHour, mMinute, false);  case 2:  return new DatePickerDialog(this,   mDateSetListener,   mYear, mMonth, mDay);  }  return null;  }  @Override  protected void onPrepareDialog(int id, Dialog dialog) {  switch (id) {  case 1:  ((TimePickerDialog) dialog).updateTime(mHour, mMinute);  break;  case 2:  ((DatePickerDialog) dialog).updateDate(mYear, mMonth, mDay);  break;  }  }   private DatePickerDialog.OnDateSetListener mDateSetListener =  new DatePickerDialog.OnDateSetListener() {  public void onDateSet(DatePicker view, int year, int monthOfYear,   int dayOfMonth) {  mYear = year;  mMonth = monthOfYear;  mDay = dayOfMonth;  setDatetime();  }  };  private TimePickerDialog.OnTimeSetListener mTimeSetListener =  new TimePickerDialog.OnTimeSetListener() {  public void onTimeSet(TimePicker view, int hourOfDay, int minute) {  mHour = hourOfDay;  mMinute = minute;  setDatetime();  }  };  private static String pad(int c) {  if (c >= 10)  return String.valueOf(c);  else  return "0" + String.valueOf(c);  } }

最新的billdbhelper.java ：

Java代码

package com.cola.ui; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.util.Log; /**  * Provides access to a database of notes. Each note has a title, the note  * itself, a creation date and a modified data.  */ public class BilldbHelper {  private static final String TAG = "Cola_BilldbHelper";  private static final String DATABASE_NAME = "cola.db";   SQLiteDatabase db;  Context context;   BilldbHelper(Context _context) {  context=_context;  db=context.openOrCreateDatabase(DATABASE_NAME, 0, null);  Log.v(TAG,"db path="+db.getPath());  }   public void CreateTable_acctitem() {  try{  db.execSQL("CREATE TABLE acctitem ("   + "_ID INTEGER PRIMARY KEY,"   + "PID integer,"   + "NAME TEXT"    + ");");  Log.v("cola","Create Table acctitem ok");  }catch(Exception e){  Log.v("cola","Create Table acctitem err,table exists.");  }  }   public void CreateTable_bills() {  try{  db.execSQL("CREATE TABLE bills ("   + "_ID INTEGER primary key autoincrement,"   +" acctitemid integer,"   + "fee integer,"   + "userid integer,"   + "sdate TEXT,"   + "stime TEXT,"   + "desc TEXT"    + ");");   Log.v("cola","Create Table acctitem ok");  }catch(Exception e){  Log.v("cola","Create Table acctitem err,table exists.");  }  }   public boolean Bills_save(int acctid,int fee,int userid,String date,String time,String text){  String sql="";  try{  sql="insert into bills values(null,"+acctid+","+fee+","+userid+",'"+date+"','"+time+"','"+text+"')";  db.execSQL(sql);   Log.v("cola","insert Table bills ok");  return true;   }catch(Exception e){  Log.v("cola","insert Table bills err="+sql);  return false;  }  }   public void CreateTable_colaconfig() {  try{  db.execSQL("CREATE TABLE colaconfig ("   + "_ID INTEGER PRIMARY KEY,"   + "NAME TEXT"   + ");");  Log.v("cola","Create Table colaconfig ok");  }catch(Exception e){  Log.v("cola","Create Table acctitem err,table exists.");  }  }   public void CreateTable_users() {  try{  db.execSQL("Create table tusers (_id integer primary key autoincrement," +   "caption text not null)");  Log.v("cola","Create Table users ok");  db.execSQL("insert into tusers values (null,'个人')");  db.execSQL("insert into tusers values (null,'公司')");  }catch(Exception e){  Log.v("cola","Create Table tusers err,table exists.");  }  }   public void InitAcctitem() {  try{  //s.getBytes(encoding);  db.execSQL("insert into acctitem values (1,null,'收入')");  db.execSQL("insert into acctitem values (2,1,'工资')");  db.execSQL("insert into acctitem values (9998,1,'其他')");  db.execSQL("insert into acctitem values (0,null,'支出')");  db.execSQL("insert into acctitem values (3,0,'生活用品')");  db.execSQL("insert into acctitem values (4,0,'水电煤气费')");  db.execSQL("insert into acctitem values (5,0,'汽油费')");  db.execSQL("insert into acctitem values (9999,0,'其他')");   //db.execSQL("insert into bills values(100,135,10000,'','','备注')");  Log.v("cola","insert into ok");  }catch(Exception e)  {  Log.v("cola","init acctitem e="+e.getMessage());  }   }  public void Acctitem_newitem(String text,int type){   Cursor c =db.query("acctitem", new String[]{"max(_id)+1"}, "_id is not null and _id<9998", null, null, null, null);  c.moveToFirst();  int maxid=c.getInt(0);  String sql="insert into acctitem values ("+maxid+","+type+",'"+text+"')";  db.execSQL(sql);  Log.v("cola","newitem ok text="+text+" id="+type+" sql="+sql);   }   public void Acctitem_edititem(String text,int id){  db.execSQL("update acctitem set name='"+text+"' where _id="+id);  Log.v("cola","edititem ok text="+text+" id="+id);  }   public void Acctitem_delitem(int id){   db.execSQL("delete from acctitem where _id="+id);  Log.v("cola","delitem ok id="+id);  }   public void QueryTable_acctitem(){   }   public void FirstStart(){  try{  String col[] = {"type", "name" };  Cursor c =db.query("sqlite_master", col, "name='colaconfig'", null, null, null, null);  int n=c.getCount();  if (c.getCount()==0){  CreateTable_acctitem();  CreateTable_colaconfig();  CreateTable_bills();  CreateTable_users();  InitAcctitem();  }  //test();  Log.v("cola","c.getCount="+n+"");    }catch(Exception e){  Log.v("cola","e="+e.getMessage());  }  }    public void close(){  db.close();  }   public Cursor getParentNode(){  return db.query("acctitem", new String[]{"_id", "name" }, "pid is null", null, null, null, "pid,_id");  }   public Cursor getChildenNode(String pid){  Log.v("cola","run getchildenNode");  return db.query("acctitem", new String[]{"_id", "name" }, "pid="+pid, null, null, null, "_id");  }   public Cursor getUserid(){  Log.v("cola","run get users cursor");  return db.query("tusers", new String[]{"_id", "caption" }, null, null, null, null, null);  }   public String test(){  try{   Cursor c2 =getUserid();  String ss="";  c2.moveToFirst();  while(!c2.isAfterLast()){   ss = c2.getString(0) +", "+ c2.getString(1);  //byte b[]=c2.getString(1).getBytes();    c2.moveToNext();    Log.v("cola","ss="+ss+"");  }   return ss;  }catch(Exception e){  Log.v("cola","e="+e.getMessage());  return "err";  }  } }

系列文章：

Android 个人理财工具六：显示账单明细下

Android 个人理财工具五：显示账单明细上

Android 个人理财工具四：添加账单页面下

Android 个人理财工具三：添加账单页面上

Android 个人理财工具二：使用SQLite实现启动时初始化数据

Android 个人理财工具一：项目概述与启动界面的实现

以上就Android 理财工具详情页面的开发，后续继续补充，其他功能，谢谢大家对本站的支持！

上一篇：Android 个人理财工具五：显示账单明细上

下一篇：Android 个人理财工具三：添加账单页面上