本节内容:
iText不光可以生成pdf文件,也可以生成txt文件;
从数据库里查出数据,并将其写在txt文件里!和上一篇用的是同样的数据库,只是换了下代码:
看代码:
package com.keith.DB;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.PrintStream;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.keith.DB.util.DBConnection;
public class ITextDbTxt {
public static final String URI = "/home/core/Desktop/itext_test/iTextDB.txt";
public static void main(String[] args) throws SQLException {
try {
PrintStream out = new PrintStream(new FileOutputStream(URI));
DBConnection connection = new DBConnection();
String sql = "select * from user";
ResultSet rs = connection.executeQuery(sql, new Object[] {});
while (rs.next()) {
out.print(rs.getString("name"));
}
connection.close();
out.flush();
out.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
}
}
}
运行,看效果!