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