android账本-添加listview，列头

代码更新：

package com.example.account;

import com.example.account.database.MainDao;

import android.app.TabActivity;
import android.database.Cursor;
import android.os.Bundle;
import android.view.LayoutInflater;
import android.view.Menu;
import android.view.MenuItem;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;
import android.widget.TabHost;
import android.widget.TabHost.OnTabChangeListener;
import android.widget.Toast;


@SuppressWarnings({ "deprecation" })
public class MainActivity extends TabActivity {

	ListView listView;
	SimpleCursorAdapter simpleCursorAdapter;
	MainDao mainDao = null;
	TabHost tabHost;
	//TextView textView1,textView2;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        
        tabHost = getTabHost();
           
        //newTabSpec设置标签，跟下面响应时间对应。
        //setIndicator设置页面标题。
        tabHost.addTab(tabHost.newTabSpec("0").setIndicator("主页").setContent(R.id.tv1));
        tabHost.addTab(tabHost.newTabSpec("1").setIndicator("流水").setContent(R.id.tv2));
        tabHost.addTab(tabHost.newTabSpec("2").setIndicator("总账").setContent(R.id.tv3));
        
        //设置背景颜色
        //tabHost.setBackgroundColor(Color.argb(150, 22, 70, 150));
        
        //设置默认界面
        tabHost.setCurrentTab(0);
        
        tabHost.setOnTabChangedListener(new OnTabChangeListener() {
			
			@Override
			public void onTabChanged(String tabId) {
				// TODO Auto-generated method stub
				if(tabId == "0"){
					Toast.makeText(MainActivity.this, "tab1", Toast.LENGTH_LONG).show();
				}else if(tabId == "1"){
					Toast.makeText(MainActivity.this, "tab2", Toast.LENGTH_LONG).show();
				}else if(tabId == "2"){
					Toast.makeText(MainActivity.this, "tab3", Toast.LENGTH_LONG).show();
				}
			}
		});
        
        listView = (ListView) this.findViewById(R.id.tv1);
        
        mainDao = new MainDao(this);      
        
        //为listview添加列头，listView.addHeaderView(headerView,null,false);使列头不可点击
        listView.addHeaderView(LayoutInflater.from(this).inflate( R.layout.adapter, null),null,false);
        
        String sql = "select _id,title,message from main";
        Cursor cursor = mainDao.query(sql,null);
        simpleCursorAdapter = new SimpleCursorAdapter(this,R.layout.adapter,cursor,new String[]{"title","message"},new int[]{R.id.text1,R.id.text2});
        listView.setAdapter(simpleCursorAdapter);
    }


    @Override
    public boolean onCreateOptionsMenu(Menu menu) {
        // Inflate the menu; this adds items to the action bar if it is present.
        getMenuInflater().inflate(R.menu.main, menu);
        return true;
    }

    @Override
    public boolean onOptionsItemSelected(MenuItem item) {
        // Handle action bar item clicks here. The action bar will
        // automatically handle clicks on the Home/Up button, so long
        // as you specify a parent activity in AndroidManifest.xml.
        int id = item.getItemId();
        if (id == R.id.action_settings) {
            return true;
        }
        return super.onOptionsItemSelected(item);
    }
}

数据库DBService.java

package com.example.account.database;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DBService extends SQLiteOpenHelper{

	private static final String DBNAME = "account.db";
	private static final int VERSION = 1;
	
	public DBService(Context context) {
		super(context, DBNAME, null, VERSION);
		// TODO Auto-generated constructor stub
	}

	@Override
	public void onCreate(SQLiteDatabase db) {
		// TODO Auto-generated method stub
		String sql = "create table main(_id integer PRIMARY KEY autoincrement,title varchar[10],message varchar[100])";
		db.execSQL(sql);
		
		//初始化
		String sql1 = "insert into main(title,message) values('吃饭','50')";
		db.execSQL(sql1);
	}

	@Override
	public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
		// TODO Auto-generated method stub
		
	}

}

数据操作MainDao.java

package com.example.account.database;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

public class MainDao {

	DBService dbService;
	SQLiteDatabase db;
	
	public MainDao(Context context){
		dbService = new DBService(context);//创建一个帮助类
		db = dbService.getWritableDatabase();//获得一个可写数据库
	}
	
	//查询操作
	public Cursor query(String sql, String [] args){
		Cursor cursor = db.rawQuery(sql, args);
		return cursor;  		
	}
}

需要注意的：

//为listview添加列头，listView.addHeaderView(headerView,null,false);使列头不可点击
        listView.addHeaderView(LayoutInflater.from(this).inflate( R.layout.adapter, null),null,false);