2011. 8. 5. 02:24
반응형


Connection con ;
Class.forName("oracle.jdbc.driver.OracleDriver");
con  =  DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:TEST","scott","tiger");
CallableStatement cs;

cs = con.prepareCall("{? = call find_pwd(?,?,?)}");
              cs.registerOutParameter(1,Types.VARCHAR);
      //cs.registerOutParameter(1,Types.INTEGER);

       cs.setInt(2,s_no_p);
       cs.setString(3,gruhigh);
       cs.setString(4,fname);
      
       cs.execute();
       result = cs.getString(1);
       cs.close();

반응형
Posted by seongsland