Question

java线程读取数据库

SQLiteDatabase db = helper.getReadableDatabase();
Cursor cur = db.query("i", null, null, null, null, null, null);
SimpleCursorAdapter adapter = new SimpleCursorAdapter(Main.this,
R.layout.list, cur,
new String[] { "_id", "name", "favourite" }, new int[] {
R.id.textView1, R.id.textView2, R.id.textView3 }, 0);
ListView.setAdapter(adapter);

请问以上操作如何修改为在子线程中执行？

Answer 1

//将数据库中的数据条数分段
public void division(){
//获取要导入的总的数据条数
String sql3="SELECT count(*) FROM [CMD].[dbo].[mycopy1]";
try {
pss=cons.prepareStatement(sql3);
rss=pss.executeQuery();

while(rss.next()){
System.out.println("总记录条数:"+rss.getInt(1));
sum=rss.getInt(1);
}
//每30000条记录作为一个分割点
if(sum>=30000){
n=sum/30000;
residue=sum%30000;
}else{