자바에서 MSSQL CALL PROCEDURE 방법

먼저 CallableStatement 클래스를 사용하여 저장프로시져 호출 방법

 

ResultSet rs = null;

CallableStatement cs = null;

 

cs = conn.prepareCall("{call dbo.comempsearch(?)}");
cs.setString(1,"S");
rs = cs.executeQuery();

PreparedStatement 클래스를 사용하는 방법

PreparedStatement pstmt = null;

ResultSet rs = null;

 

String sqlQuery = "exec jaorderprc @pWORKGB ='S', @pUSERID ='"+userID+"', @pFIRSTDATE ='"+firstDate+"'";
sqlQuery += ", @pLASTDATE ='"+lastDate+"', @pPartNo ='"+Sabun+"', @pORDNUM ='"+OrKey+"'";
pstmt = conn.prepareStatement(sqlQuery);
rs = pstmt.executeQuery();