/*

*/
package test;
import java.sql.*;

public class SixJdbc {
   static final String url = "jdbc:oracle:thin:@192.168.3.211:1521:chi";
   static final String userID = "scott";
   static final String passwd = "oracle";
   Connection conn = null;
   ResultSet rs = null;
   CallableStatement cstmt =null;

   public static void main(String[] args) {
       new SixJdbc().TestCallable();
   }

   public void TestCallable(){
       try{
           Class.forName("oracle.jdbc.driver.OracleDriver");
           conn = DriverManager.getConnection(url, userID, passwd);
           cstmt = conn.prepareCall("{?=call test1_func(?,?)}");
           cstmt.setInt(2, 11);
           cstmt.setString(3, "tom11");
           cstmt.registerOutParameter(1, Types.VARCHAR);
           cstmt.execute();
           System.out.println("USERNAME = " + cstmt.getString(1));
           cstmt.close();
       }catch(Exception e){
           e.printStackTrace();
       }
       finally{
           if(conn!= null){
               try{conn.close();}catch(Exception ex){ex.printStackTrace();}
           }
       }

       }

   }

ITPub博客

Jdbc callablestatement 3

最新文章