将SQLite中的数据转换为Excel表
此程序能将指定SQlite数据库中的数据转换为Excel表格形式
package zhaoxing.android.tool;
import java.io.File;
import java.io.IOException;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
public class DatabaseDump {
private String mDestXmlFilename;
private SQLiteDatabase mDb;
public DatabaseDump(SQLiteDatabase db, String destXml) {
mDb = db;
mDestXmlFilename = destXml;
}
public void exportData() {
try {
// Log.i("mdb", mDb.getPath());
// get the tables out of the given sqlite database
String sql = "SELECT * FROM sqlite_master";
Cursor cur = mDb.rawQuery(sql, new String[0]);
cur.moveToFirst();
String tableName;
while (cur.getPosition() < cur.getCount()) {
tableName = cur.getString(cur.getColumnIndex("name"));
// don't process these two tables since they are used
// for metadata
if (!tableName.equals("android_metadata")
&& !tableName.equals("sqlite_sequence")) {
writeExcel(tableName);
}
cur.moveToNext();
}
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 生成一个Excel文件
*
* @param fileName
* 要生成的Excel文件名
*/
public void writeExcel(String tableName) {
WritableWorkbook wwb = null;
String fileName;
fileName = "/sdcard/QuestionData/" + tableName + ".xls";
int r = 0;
String sql = "select * from " + tableName;
Cursor cur = mDb.rawQuery(sql, new String[0]);
int numcols = cur.getColumnCount();
int numrows = cur.getCount();
// Log.i("row", numrows + "");
// Log.i("col", numcols + "");
String records[][] = new String[numrows + 1][numcols];// 存放答案，多一行标题行
if (cur.moveToFirst()) {
while (cur.getPosition() < cur.getCount()) {
for (int c = 0; c < numcols; c++) {
if (r == 0) {
records[r][c] = cur.getColumnName(c);
records[r + 1][c] = cur.getString(c);
} else {
records[r + 1][c] = cur.getString(c);
}
// Log.i("value" + r + " " + c, records[r][c]);
}
cur.moveToNext();
r++;
}
cur.close();
}
try {
// 首先要使用Workbook类的工厂方法创建一个可写入的工作薄(Workbook)对象
wwb = Workbook.createWorkbook(new File(fileName));
} catch (IOException e) {
&nbs
