java csv

package com;

import java.lang.Class;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import antlr.collections.List;

public class DbConecter {
 public static void main(String[] args) {
  ArrayList li = new ArrayList();
  try {
   Class.forName("com.mysql.jdbc.Driver");
   String url = "jdbc:mysql://localhost:3306/knowledge";
   String user = "root";
   String password = "root";
   Connection conn = DriverManager.getConnection(url, user, password);
   Statement stmt = conn.createStatement();
   if (!conn.isClosed()) {
    int i = 0;
    System.out.println("已连接! ");
    ResultSet rs = stmt.executeQuery("select * from sample");
    ResultSetMetaData rsmd = rs.getMetaData();
    int columnCount = rsmd.getColumnCount();
    String a = rsmd.getColumnName(2);
    System.out.println(a);
    FileWriter fw = new FileWriter("d://helloCsv.csv");
    fw.write("www,www,www,www,www,www,www,www/r/n");
    while (rs.next()) {
     // rs.gets
     fw.write(rs.getString("ID") + "," + rs.getString("aveidf")
       + "," + rs.getString("categoryID") + "/r/n");

    }
    fw.close();
    System.out.println(li.size());
   }

   else {
    System.out.println("未连接! ");
   }

  } catch (Exception e) {
   System.out.println("出错啊 ");
   e.printStackTrace();
  }
 }
}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值