BASIC

没用的

 

	Connection conn = null;
		Statement st = null;
		ResultSet rs = null;

		try {

		} catch (Exception e) {

		}

		finally {
			if (rs != null)
				try {
					rs.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}

			if (st != null)
				try {
					st.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}

			if (conn != null)
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}

 

 

public static void main(String[] args) throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException {
		Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();  
		String url="jdbc:oracle:thin:@3.242.164.94:1521:ICAMCH2"; //ICAMCH2为数据库的SID  
		String user="ICAM2USER1";  
		String password="ICAM2USER1";  
	    Connection conn= DriverManager.getConnection(url,user,password);
	    OracleCallableStatement proc = (OracleCallableStatement)conn.prepareCall("{call cosmos_test_boyu.cross_table_test(?,?)}");
        proc.registerOutParameter(1, OracleTypes.CURSOR);
        proc.registerOutParameter(2, OracleTypes.LONGVARCHAR);


        proc.execute();
        ResultSet rs = (ResultSet)proc.getObject(1);
        String str = proc.getObject(2).toString();
        //System.out.println(str);

        ResultSetMetaData rsMetaData = rs.getMetaData();
        int intColumn = rsMetaData.getColumnCount();

        for (int i =1;i<=intColumn;i++){
        	String strColumn =rsMetaData.getColumnName(i);
        	System.out.print(  (strColumn.length()>7?strColumn.substring(0,7):strColumn) +"\t\t");
    	}
        System.out.println();

        while(rs.next()) {
        	for (int i =1;i<=intColumn;i++){
        		System.out.print(rs.getString(i)+"\t\t");
        	}
        	System.out.println();
        }

	}