作者laruku2000 (阿本)
看板java
标题[问题] 资料库资料输出档案?
时间Sun Feb 11 23:58:33 2007
我需要从资料库捞资料输出至档案,不过我对java.io给他很不熟~,~,不知程式是那里出错
,无法正确输出,请求支援~~
Class.forName("com.mysql.jdbc.Driver");
Connection MyConn = DriverManager.getConnection(
"jdbc:mysql://xxx.xxx.xxx.xxx/xxxx", "xxxxx", "xxxxx");
Statement s = MyConn.createStatement();
String sql = "select * from xxxxx";
ResultSet r = s.executeQuery(sql);
while (r.next()) {
PrintWriter abcd = new PrintWriter(new FileWriter("java.txt"),true);
for (int i = 1; i <= 9; i++) {
abcd.println(r.getString(i)+",");
}
感觉是蛮简易的功能但我不会写>"<,本来是要印出9个栏位的所有资料逗点隔开输出到txt
档的,但完全不行...............Orz
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 61.216.196.111