mysql.rar_infobright

package daochutest; //将mysql数据库中的一个表导出为csv文件 import java.io.*; import java.util.Date.*; import java.text.*; import java.sql.*; public class mydc{ /* public static String formatDate(Date date){ return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(date); } */ public static void main(String[] args)throws Exception { { try { Class.forName("com.mysql.jdbc.Driver"); //本地建立的一个mysql数据库 String url="jdbc:mysql://202.117.77.151:8094/gps_process?useUnicode=true&characterEncoding=UTF-8"; String username="mfl345909"; String password="Mfl91112$"; Connection conn=DriverManager.getConnection(url,username,password); if(conn!=null) { Statement stmt=conn.createStatement(); // String sql="select * from gps_inf into outfile 'e://output1.csv' fields terminated by ','optionally enclosed by ''lines terminated by '\r\n';"; String sql="select * from gps_inf where speed=1"; //String sql="select * from gps_inf where gps_time>"2014-3-21"&&gps_time<"2014-3-22"&&vnum="陕AT0141";"; FileOutputStream fos=new FileOutputStream("e://output1.csv"); StringBuilder bf; ResultSet rs=stmt.executeQuery(sql); int i=0; while(rs.next()) { bf=new StringBuilder(); bf.append(rs.getString("vnum")).append(",").append(rs.getDate("gps_time")).append(" ").append(rs.getTime("gps_time")).append(",").append(rs.getString("lont")).append(",").append(rs.getString("laut")).append(",").append(rs.getString("speed")).append(",").append(rs.getString("height")).append(",").append(rs.getString("direction")).append(",").append(rs.getString("car_stat")).append("\r\n"); fos.write(bf.toString().getBytes()); i++; System.out.print(bf.toString()); } System.out.println(i); stmt.execute(sql); stmt.close(); conn.close(); System.out.println("数据库导出成功！"); } else System.out.println("数据库连接失败！"); } catch(ClassNotFoundException e1) { e1.printStackTrace(); } catch(SQLException e2) { e2.printStackTrace(); } } } }