java 调用DB2 SYSPROC.ADMIN_CMD存储过程导出数据

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class CallADMIN_CMD{
    public static void main(String[] args) {
         String url = "jdbc:db2://localhost:50000/TEST" ;     
         String username = "******" ;    
         String password = "******" ; 
         Connection con = null;
         CallableStatement cstmt = null;
        
         try{    
                //加载DB2的驱动类    
                Class.forName("com.ibm.db2.jcc.DB2Driver") ;    
             }catch(ClassNotFoundException e){    
                System.out.println("找不到驱动程序类 ,加载驱动失败!");    
                e.printStackTrace() ;    
             } 
          try{    
                con = DriverManager.getConnection(url , username , password ) ;    
             }catch(SQLException se){    
                System.out.println("数据库连接失败!");    
                se.printStackTrace() ;    
             }
          try {
              String sql = "CALL SYSPROC.ADMIN_CMD(?)";
              cstmt = con.prepareCall(sql);
              String param = "export to d:\TEST\lnlnslns.del of del select * from SAACNACN";
              cstmt.setString(1, param);
              boolean flag = cstmt.execute();
        } catch (SQLException e) {            
            e.printStackTrace();
        } 
         
    }

}
原文地址:https://www.cnblogs.com/heml/p/3485365.html