SQL Server导入导出数据

  create table win_sentence.dbo.test_bluk(term nvarchar(50),freq int);BULK INSERT win_sentence.dbo.test_bluk FROM 'Z:/Syn/temp/a.txt' WITH(fieldterminator='&');

bulk insert只支持数据导入，导出数据可以使用bcp工具（bcp工具也支持数据导入）

 bcp [win_sentence].[dbo].[sim_60] out D:\workspace\sim_60.dat -T -c

SQL语句：

EXEC master..xp_cmdshell  'bcp [win_sentence].[dbo].[sim_60] out D:\workspace\sim_60.data -T -c'

在JDBC中：

//package FS;
import java.io.IOException;
import java.sql.*;
public class BCP
{
 static Connection con;
 static PreparedStatement sql;
 static ResultSet res;
 public Connection getConnection()
 {
  try 
  {
   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
   con = DriverManager.getConnection(
     "jdbc:microsoft:sqlserver://localhost:1433;"
       + "DatabaseName=uep", "sa", "data");
  } catch (Exception e) {
   e.printStackTrace();
  }
  return con;
 }
 public static void main(String[] args) 
 {
  BCP c = new BCP();
  con = c.getConnection();
  
        /**直接当作SQL语句调用*/
  try 
  {
      String sql = "EXEC master..xp_cmdshell " + "/' "+"BCP" + " /"" + " SELECT TOP 4 * FROM uep.dbo.A_experiment"+"/"" + " queryout e://currency2.txt -F 1 -L 3 -c -U " + "/"sa/"" + " -P " + "/"" + "data" + "/"" + "/'";
   con.createStatement().execute(sql);
  } 
  catch (SQLException e) 
  {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  System.out.println("ok");
  }  
 
}