보관함

java 연동 callablestatement

AI 윤 선생 2020. 12. 14. 11:19
반응형

CREATE PROCEDURE PARTS_ON_HAND (IN PARTNUM INTEGER,
OUT COST DECIMAL(7,2),
OUT QUANTITY INTEGER)
EXTERNAL NAME 'parts!onhand'
LANGUAGE JAVA PARAMETER STYLE DB2GENERAL;


CallableStatement stpCall ;
String sql = "CALL PARTS_ON_HAND ( ?,?,? )" ;
stpCall = con.prepareCall( sql ) ; /* con is the connection */
stpCall.setInt( 1, variable1 ) ;
stpCall.setBigDecimal( 2, variable2 ) ;
stpCall.setInt( 3, variable3 ) ;
stpCall.registerOutParameter( 2, Types.DECIMAL, 2 ) ;
stpCall.registerOutParameter( 3, Types.INTEGER ) ;
stpCall.execute() ;
variable2 = stpCall.getBigDecimal(2) ;
variable3 = stpCall.getInt(3) ;

 

반응형

'보관함' 카테고리의 다른 글

DB2] 참조  (0) 2020.12.14
DB2 cusror사용  (0) 2020.12.14
db2 함수모음  (0) 2020.12.14
이완용 인물백과사전  (0) 2020.12.13
강예빈 인물백과사전  (0) 2020.12.06