จาก code นี้ เมื่อ export data จาก database แล้ว รายละเอียดของ CSV file ที่ได้จากการ Export จาก Database ไม่มี Headerมาด้วยคะ
อยากสอบถามพี่ๆ ว่าต้องใส่ code อย่างไร Headerถึงจะมาด้วยคะ ....ขอบพระคุณมากนะคะ
Cursor cursor = null;
String sql = "select * from '" + table + "' where " + condition;
try {
cursor = db.rawQuery(sql,null);
} catch (Exception e){
//
}
if ( cursor == null ){
db.close();
return "SQL query error:["+sql+"]";
}
//
// Read data and convert to CSV
//
StringBuilder csvData = new StringBuilder(sql+"\n");
cursor.moveToFirst();
final int column = cursor.getColumnCount();
if ( cursor.getCount() > 0 ){
do {
for ( int c=0; c<column; c++ ){
String val = cursor.getString(c);
if ( c != 0 ){
csvData.append(",");
}
csvData.append(val);
}
csvData.append("\n");
} while (cursor.moveToNext());
}
cursor.close();
db.close();
//
// Write CSV data to SD under "csv" folder.
//
final String folderName =
Environment.getExternalStorageDirectory().getAbsolutePath() +
CSVFOLDER;
File csvfile = new File(folderName);
if ( csvfile.exists() == false ) {
csvfile.mkdir();
}
OutputStream outputStream;
final String csvFileName =
Environment.getExternalStorageDirectory().getAbsolutePath() +
CSVFOLDER + "/" + csvName;
try {
csvfile = new File(csvFileName);
outputStream = new FileOutputStream(csvfile);
} catch(Exception e) {
return e.getMessage();
}
String cvsDataString = csvData.toString();
try {
outputStream.write(cvsDataString.getBytes("TIS620"));
outputStream.close();
} catch(Exception e){
return e.getMessage();
}
return cvsDataString;
}
ขอความช่วยเหลือกเกี่ยวกับ code java คะ
อยากสอบถามพี่ๆ ว่าต้องใส่ code อย่างไร Headerถึงจะมาด้วยคะ ....ขอบพระคุณมากนะคะ
Cursor cursor = null;
String sql = "select * from '" + table + "' where " + condition;
try {
cursor = db.rawQuery(sql,null);
} catch (Exception e){
//
}
if ( cursor == null ){
db.close();
return "SQL query error:["+sql+"]";
}
//
// Read data and convert to CSV
//
StringBuilder csvData = new StringBuilder(sql+"\n");
cursor.moveToFirst();
final int column = cursor.getColumnCount();
if ( cursor.getCount() > 0 ){
do {
for ( int c=0; c<column; c++ ){
String val = cursor.getString(c);
if ( c != 0 ){
csvData.append(",");
}
csvData.append(val);
}
csvData.append("\n");
} while (cursor.moveToNext());
}
cursor.close();
db.close();
//
// Write CSV data to SD under "csv" folder.
//
final String folderName =
Environment.getExternalStorageDirectory().getAbsolutePath() +
CSVFOLDER;
File csvfile = new File(folderName);
if ( csvfile.exists() == false ) {
csvfile.mkdir();
}
OutputStream outputStream;
final String csvFileName =
Environment.getExternalStorageDirectory().getAbsolutePath() +
CSVFOLDER + "/" + csvName;
try {
csvfile = new File(csvFileName);
outputStream = new FileOutputStream(csvfile);
} catch(Exception e) {
return e.getMessage();
}
String cvsDataString = csvData.toString();
try {
outputStream.write(cvsDataString.getBytes("TIS620"));
outputStream.close();
} catch(Exception e){
return e.getMessage();
}
return cvsDataString;
}