db2界面调用存储过程_DB2数据库调用存储过程的方法及实例

import java.net.URL;

import java.sql.*;

class test2

{publicstatic void main(Stringargs[])

{Stringurl="jdbc:db2://wellhope/sample";Stringuser="db2admin";Stringpassword="db2admin";

try

{

Class.forName("COM.ibm.db2.jdbc.net.DB2Driver").newInstance();//与数据库建立连接

Connection con=DriverManager.getConnection(url,user,password);

checkForWarning(con.getWarnings());

DatabaseMetaData dma=con.getMetaData();Stringstr="This is a string";//inthashcode=str.hashCode();//System.out.println("Hashcode"+hashcode);//创建Statement对象,用于执行SQL语句

Statement stmt=con.createStatement();//创建CallableStatement对象,用于执行存储过程

CallableStatement cs=con.prepareCall("{call PRO_YHDL1(?,?,?)}");//注册输出参数

cs.registerOutParameter (3, Types.INTEGER);intresult=0;

cs.setString(1,"123");

cs.setString(2,"123");

cs.execute();

result=cs.getInt (3);

dispResultSet(result);

cs.close();

con.close();

}

catch(SQLException ex)

{

System.out.println("* * * SQLException caught * * *");while(ex!=null)

{

System.out.println("SQLState:"+ex.getSQLState());

System.out.println("Message:"+ex.getMessage());

System.out.println("Vendor:"+ex.getErrorCode());

exex=ex.getNextException();

System.out.println("");

}

}

catch(java.lang.Exception ex)

{

ex.printStackTrace();

}

}