*/
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();}
}
}
}
}