CallableStatement¸¦ ÀÌ¿ëÇØ µ¥ÀÌÅͺ£À̽ºÀÇ ÇÁ·Î½ÃÀú¸¦ È£ÃâÇÏ´Â ¿¹Á¦
CallableStatementTest.java
import java.sql.*;
public class CallableStatementTest{
public static void main(String[] args){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:dbdsn", "id", "password");
CallableStatement cs = con.prepareCall("{call myStoredProcedure(?,?,?)}");
cs.setInt(1,2);
cs.registerOutParameter(2, java.sql.Types.VARCHAR);
cs.registerOutParameter(3, java.sql.Types.INTEGER);
cs.execute();
System.out.println("*name : "+ cs.getString(2) +"*age : "+ cs.getInt(3));
cs.close();
con.close();
}catch(Exception e){System.out.println(e);}
}
}
MS-SQL¿¡¼ »ç¿ëÇÒ ÇÁ·Î½ÃÀú ±¸¹®
CREATE PROCEDURE myStoredProcedure
@age int
, @na varchar(20) OUTPUT
, @ageo int OUTPUT
AS
SELECT @na = name, @ageo = age FROM mytest
WHERE age = @age
C:\javaExample\19>javac CallableStatementTest.java
C:\javaExample\19>java CallableStatementTest
*name : Jabook *age : 2
CallableStatement´Â sqlÀÇ ÇÁ·Î½ÃÀú¸¦ ½ÇÇà½Ã۱â À§ÇÑ ÀÎÅÍÆäÀ̽ºÀÌ´Ù.
jabookÀúÀÚ¸íÇÔ |
Á¦¸ñ:¼Ò¼³°°Àº¹Ì´ÏÄÚµå ÀÛ¼ºÀÚ:Àںϸâ¹ö ÇÑâÇå |