package com.zjhcsoft.test.utl;

 import java.sql.CallableStatement;

 import java.sql.Connection;

 import java.sql.DriverManager;

 import java.sql.ResultSet;

 import oracle.jdbc.OracleCallableStatement;

 import oracle.jdbc.driver.OracleTypes;

 public class TestOracleProc3 {

 	/**

 	 * @param args

 	 */

 	public static void main(String[] args) {

 		try {

 			Class.forName("oracle.jdbc.driver.OracleDriver");

 		} catch (Exception e) {

 			e.printStackTrace();

 		}

 		Connection conn = null;

 		String DBurl = "jdbc:oracle:thin:@134.98.8.168:1521:ora817";

 		try {

 			conn = DriverManager.getConnection(DBurl, "sfz2", "sfz2_123");

 			System.out.println("Getting Connection...");

 			conn.close();

 		} catch (Exception e) {

 			e.printStackTrace();

 		}

 		try {

 			conn = DriverManager.getConnection(DBurl, "sfz2", "sfz2_123");

 			long start = System.currentTimeMillis();

 			//最关键一步

 			conn.setAutoCommit(false);

 			OracleCallableStatement cstmt = (OracleCallableStatement)conn.prepareCall("{call sfz_obj.proc_sfz_proc_test(?,?)}");

 			cstmt.setString(1, "");

 			cstmt.registerOutParameter(2,OracleTypes.CURSOR);

 			cstmt.execute();

 			long end = System.currentTimeMillis();

 			System.out.println("this procedure consumes "+((end-start)/1000)+" excute time.");

 			start = System.currentTimeMillis();

 			int i=0;

 			ResultSet rs = (ResultSet)cstmt.getObject(2);

 			   while (rs.next()) {

 				   System.out.println("column"+(i+1)+":"+rs.getString(1)+",  "+rs.getString(2)+",  "+rs.getString(3));

 				   i++;

 			   }

 			   System.out.println("this procedure has "+(i-1)+" data.");

 			end = System.currentTimeMillis();

 			System.out.println("show this procedure data consumes "+((end-start)/1000)+" excute time.");

 			conn.commit();

 			cstmt.close();

 			conn.close();

 		} catch (Exception e) {

 			e.printStackTrace();

 		}

 	}

 }