怎么把数据库表中的数据一行一行的写入文本文件,并且每个字段加上分隔符
比如分隔符为逗号承保笔数|保险金额(外币)|保额|保单保费(外币)
4|15340234.00|15340234.00|15340.22
1|2089030.00|2089030.00|4178.06
1|2900000.00|2900000.00|3480.00
9|1098000.00|1098000.00|2240.00
比如分隔符为逗号承保笔数|保险金额(外币)|保额|保单保费(外币)
4|15340234.00|15340234.00|15340.22
1|2089030.00|2089030.00|4178.06
1|2900000.00|2900000.00|3480.00
9|1098000.00|1098000.00|2240.00
FileWriter fw = new FileWriter("myfile.txt");
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/microblog","root","admin");
Statement st=con.createStatement();
ResultSet rs= st.executeQuery("select * from t_users");
//可以用这个取列名,或者在这里输出你第一行的表头
ResultSetMetaData rsmd = rs.getMetaData(); int col = rsmd.getColumnCount();
while (rs.next()) {
for (int i = 1; i <= col;i++) {
fw.write(rs.getString(i));
if (i < col)
fw.write("|");
}
fw.write("\n");
}
fw.close();
st.close();
rs.close();
con.close();
很谢谢您
Runtime.getRuntime().exec("cmd /c start myfile.txt\\");
换行为何不起作用?