Pull解析, 并添加到数据库中

import java.util.ArrayList;
import java.util.List;

import org.xmlpull.v1.XmlPullParser;
import org.xmlpull.v1.XmlPullParserException;
import org.xmlpull.v1.XmlPullParserFactory;

import com.example.pull.bean.Student;
import com.example.pull.utils.MySQLiteOpenHelper;

import android.os.Bundle;
import android.app.Activity;
import android.content.ContentValues;
import android.database.sqlite.SQLiteDatabase;
import android.util.Log;
import android.view.Menu;
import android.widget.ArrayAdapter;
import android.widget.ListView;

public class MainActivity extends Activity {

private ListView lv;
private Student stu;
private List<Student> list;
MySQLiteOpenHelper helper;

@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);

lv = (ListView) findViewById(R.id.lv);

helper = new MySQLiteOpenHelper(this);

jiexiPull();
lv.setAdapter(new ArrayAdapter<Student>(MainActivity.this,
android.R.layout.simple_list_item_1, list));
}
private void sql(List<Student> list) {
for(Student s: list){
SQLiteDatabase dp = helper.getWritableDatabase();
ContentValues values=new ContentValues();
values.put("id", s.getId());
values.put("group", s.getGroup());
values.put("name", s.getName());
values.put("sex", s.getSex());
values.put("age", s.getAge());
values.put("email", s.getEmail());
values.put("birthday", s.getBirthday());
values.put("memo", s.getMemo());
dp.insert("mmm", null, values);
}
}

private void jiexiPull() {

try {
// 获取一个xmlPull的工厂对象
XmlPullParserFactory factory = XmlPullParserFactory.newInstance();
// 使用对象生产一个解析器
XmlPullParser parser = factory.newPullParser();
// 使用解析器 引入要解析的xml文件
parser.setInput(getAssets().open("NewFile.xml"), "utf-8");

// 解析
int eventType = parser.getEventType();
// String tag_name = parser.getName();
while (eventType != XmlPullParser.END_DOCUMENT) {

switch (eventType) {
case XmlPullParser.START_DOCUMENT:
list = new ArrayList<Student>();
break;
case XmlPullParser.START_TAG:
String startTag = parser.getName();
if ("student".equals(startTag)) {
String id = parser.getAttributeValue(0);
String group = parser.getAttributeValue(1);
stu = new Student();

stu.setId(id);
stu.setGroup(group);
} else if ("name".equals(startTag)) {
stu.setName(parser.nextText());
} else if ("sex".equals(startTag)) {
stu.setSex(parser.nextText());
} else if ("age".equals(startTag)) {
stu.setAge(parser.nextText());
} else if ("email".equals(startTag)) {
stu.setEmail(parser.nextText());
} else if ("birthday".equals(startTag)) {
stu.setBirthday(parser.nextText());
} else if ("memo".equals(startTag)) {
stu.setMemo(parser.nextText());
}

break;
case XmlPullParser.TEXT:

break;
case XmlPullParser.END_TAG:

String endTag = parser.getName();

if ("student".equals(endTag)) {
list.add(stu);
sql(list);
}

break;

default:
break;
}
eventType = parser.next();
}
Log.i("================", list.toString());
} catch (Exception e) {
e.printStackTrace();
}

}

}