sqlite的问题。小白求救。。

各位大大 问题如下。。 想把数据库的数据用listview显示出来.在插入数据时候用键值对显示在listview上
但就是 ID这一个显示为null. 下面为代码


java code:

sqldbhelp.java

public class DBhelp extends SQLiteOpenHelper{
private final static int DataBaseVesion= 1;
private final static String DATABASE_NAME="DataBase.db";
public DBhelp(Context context, String name, CursorFactory factory,
int version) {
super(context, name, null, version);
// TODO Auto-generated constructor stub
}

@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
db.execSQL("create table if not exists user(id integer AUTOINC primary key ,name varchar(20) not null , age INTEGER not null )");
db.execSQL("insert into user(id,name,age)values(?,?,?)",new Object[]{1,"feifeishijie",18});
db.execSQL("insert into user(id,name,age)values(?,?,?)",new Object[]{2,"cccccc",20});
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub

}

}




mainactivity.java


public class MainActivity extends Activity implements OnClickListener,
OnItemSelectedListener {
private ListView listView;
private Button saveButton;
private EditText editText_Name;
private EditText editText_Age;
private SQLiteDatabase sqLiteDatabase;
private LayoutInflater inflater;
private String[] provinces = new String[]{"编辑","删除","帮助"};

DBhelp dBhelp;
Cursor cursor;
List<Map<String, Object>> items;
ListAdapter adapter;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
listView = (ListView) findViewById(R.id.listview1);
saveButton = (Button) findViewById(R.id.save_button);
editText_Name = (EditText) findViewById(R.id.EditText_Name);
editText_Age = (EditText) findViewById(R.id.EditText_Age);
saveButton.setOnClickListener(this);
dBhelp = new DBhelp(this, "DataBase.db", null, 1);
sqLiteDatabase = dBhelp.getReadableDatabase();
cursor = sqLiteDatabase.rawQuery("select id ,name,age from user", null);
items = new ArrayList<Map<String, Object>>();
for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) {
Map<String, Object> item = new HashMap<String, Object>();
// int nameindex=cursor.getColumnIndex("name");
// String nameString=cursor.getColumnName(nameindex);
// int ageindex=cursor.getColumnIndex("age");
// String ageString=cursor.getColumnName(ageindex);
String id = cursor.getString(cursor.getColumnIndex("id"));
Log.d("id_____________________!", id+"");
String name = cursor.getString(cursor.getColumnIndex("name"));
String age = cursor.getString(cursor.getColumnIndex("age"));
item.put("id", id);
item.put("name", name);
item.put("age", age);
//System.out.println("namestring------>" + name);
items.add(item);
}
adapter = new ListAdapter(items);
listView.setAdapter(adapter);
listView.setOnItemSelectedListener(this);
}
public void refsesh(){
dBhelp = new DBhelp(this, "DataBase.db", null, 1);
sqLiteDatabase = dBhelp.getReadableDatabase();
cursor = sqLiteDatabase.rawQuery("select id,name,age from user", null);
items = new ArrayList<Map<String, Object>>();
for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) {
Map<String, Object> item = new HashMap<String, Object>();
// int nameindex=cursor.getColumnIndex("name");
// String nameString=cursor.getColumnName(nameindex);
// int ageindex=cursor.getColumnIndex("age");
// String ageString=cursor.getColumnName(ageindex);
String id = cursor.getString(cursor.getColumnIndex("id"));
String name = cursor.getString(cursor.getColumnIndex("name"));
String age = cursor.getString(cursor.getColumnIndex("age"));
item.put("id", id);

item.put("name", name);
item.put("age", age);
//System.out.println("namestring------>" + name);
items.add(item);
Log.d("id_____________________________!", String.valueOf(id));
}
adapter = new ListAdapter(items);
listView.setAdapter(adapter);
listView.setOnItemSelectedListener(this);

}


class ListAdapter extends BaseAdapter {
public List<Map<String, Object>> list;

public ListAdapter(List<Map<String, Object>> list) {
this.list = list;
}


@Override
public int getCount() {
return list.size();
}

@Override
public Object getItem(int positon) {
// TODO Auto-generated method stub
return list.get(positon);
}

@Override
public long getItemId(int positon) {
// TODO Auto-generated method stub
return positon;
}

@Override
public View getView(int positon, View contenView, ViewGroup parent) {

inflater = LayoutInflater.from(MainActivity.this);
View view = inflater.inflate(R.layout.item, null);
TextView Text_id = (TextView) view.findViewById(R.id.Text_id);
TextView Text_name = (TextView) view.findViewById(R.id.Text_name);
TextView Text_age = (TextView) view.findViewById(R.id.Text_age);
Map<String, Object> map = list.get(positon);
// System.out.println("map.get(name)------->"+map.get("name"));
Text_id.setText(map.get("id")+"");
Text_name.setText(map.get("name") + "");
Text_age.setText(map.get("age") + "");
return view;
}
}


@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 void onItemSelected(AdapterView<?> parent, View contenView, int positon,
long id) {
// TODO Auto-generated method stub
Log.d("onitem", "onitemselected");
new AlertDialog.Builder(MainActivity.this).setTitle("123").
setItems(provinces, new DialogInterface.OnClickListener() {

@Override
public void onClick(DialogInterface dialog, int which) {
// TODO Auto-generated method stub

switch (which) {

case 0:
Toast.makeText(MainActivity.this, "case______________!000", Toast.LENGTH_SHORT).show();
break;

case 1:
break;

case 2:
break;
}
Log.d("which", String.valueOf(which));
}
}).show();

}

@Override
public void onNothingSelected(AdapterView<?> arg0) {
// TODO Auto-generated method stub

}

//保存按钮
public void save() {
DBhelp dbHelper = new DBhelp(this, "DataBase.db", null, 1);
sqLiteDatabase = dbHelper.getWritableDatabase();
sqLiteDatabase.beginTransaction();
String editname = editText_Name.getText().toString().trim();
Integer age = Integer.parseInt(editText_Age.getText().toString().trim());
if (editname != null) {
if (age !=null) {

sqLiteDatabase.execSQL("insert into user(name,age)values(?,?)",
new Object[] { editname, age });
Log.d("editname_________________________!", editname + "" + age);
sqLiteDatabase.setTransactionSuccessful();
sqLiteDatabase.endTransaction();
Toast.makeText(this, "保存成功", Toast.LENGTH_SHORT).show();
//刷新map

/*Map<String,Object> map=new HashMap<String, Object>();
map.put("name",editname);
map.put("age",age);
adapter.list.add(map);
adapter.notifyDataSetChanged();*/

} else {
Toast.makeText(this, "输入的类型不正确，请重新输入", Toast.LENGTH_SHORT)
.show();
editText_Age.setText("");
}
} else {
Toast.makeText(this, "输入的类型不正确，请重新输入", Toast.LENGTH_SHORT).show();
editText_Name.setText("");
}

}


@Override
public void onClick(View view) {
// TODO Auto-generated method stub
switch (view.getId()) {
case R.id.save_button:
save();
refsesh();
break;

default:
break;
}
}

}