/**
@version 1.00 2001-07-18
@author Cay Horstmann
*/import java.util.*;
import java.sql.*;
import java.io.*;/**
This program demonstrates how to sort a table column.
Double-click on a table columm to sort it.
*/
public class test
{
public static void main(String[] args)
{
try{
System.setProperty("jdbc.drivers", "oracle.jdbc.driver.OracleDriver");
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn= DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ouyang", "scott", "tiger");
CallableStatement cstmt = conn.prepareCall("{ call ?=Test_Query(?,?,?) }");
cstmt.registerOutParameter (1, Types.VARCHAR);//output parameter
cstmt.setString(2,"18879");
cstmt.registerOutParameter (3, Types.VARCHAR);//output parameter
cstmt.registerOutParameter (4, Types.FLOAT);//output parameter
cstmt.execute();
System.out.println("Procedure @par3 is '" + cstmt.getString(3) + "'");
System.out.println("Procedure @par1 is '" + cstmt.getString(3) + "'"); System.out.println("Procedure @par4 is '" + cstmt.getFloat(4) + "'\n");
cstmt.close();
conn.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
@version 1.00 2001-07-18
@author Cay Horstmann
*/import java.util.*;
import java.sql.*;
import java.io.*;/**
This program demonstrates how to sort a table column.
Double-click on a table columm to sort it.
*/
public class test
{
public static void main(String[] args)
{
try{
System.setProperty("jdbc.drivers", "oracle.jdbc.driver.OracleDriver");
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn= DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ouyang", "scott", "tiger");
CallableStatement cstmt = conn.prepareCall("{ call ?=Test_Query(?,?,?) }");
cstmt.registerOutParameter (1, Types.VARCHAR);//output parameter
cstmt.setString(2,"18879");
cstmt.registerOutParameter (3, Types.VARCHAR);//output parameter
cstmt.registerOutParameter (4, Types.FLOAT);//output parameter
cstmt.execute();
System.out.println("Procedure @par3 is '" + cstmt.getString(3) + "'");
System.out.println("Procedure @par1 is '" + cstmt.getString(3) + "'"); System.out.println("Procedure @par4 is '" + cstmt.getFloat(4) + "'\n");
cstmt.close();
conn.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货