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

最新推荐文章于 2024-01-08 11:00:50 发布

weixin_30699955

最新推荐文章于 2024-01-08 11:00:50 发布

阅读量595

点赞数

文章标签： java 数据库

原文链接：http://www.cnblogs.com/heml/p/3485365.html

版权

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();
        } 
         
    }

}