Method PrintResult

storage/connect/Client.java:86–169

(int ncol)

	} // end of main

	private static void PrintResult(int ncol) {
    	// Get result set meta data
    	int i;
    	Date date = new Date(0);
    	Time time = new Time(0);
    	Timestamp tsp = new Timestamp(0);
    	String columnName;
		Object job;

    	// Get the column names; column indices start from 1
    	for (i = 1; i <= ncol; i++) {
    		columnName = jdi.ColumnName(i);
    		
    		if (columnName == null)
    			return;

    		// Get the name of the column's table name
    		//String tableName = rsmd.getTableName(i);
    		
    		if (i > 1)
		    	System.out.print("\t");
    		
    		System.out.print(columnName);
    	} // endfor i
    	
    	System.out.println();
	    
	    // Loop through the result set
	    while (jdi.ReadNext() > 0) {
	    	for (i = 1; i <= ncol; i++) {
	    		if (i > 1)
			    	System.out.print("\t");
	    		
	    		if (DEBUG)
	    			System.out.print("(" + jdi.ColumnType(i, null) + ")");
	    		
	    		switch (jdi.ColumnType(i, null)) {
	    		case java.sql.Types.VARCHAR:
	    		case java.sql.Types.LONGVARCHAR:
	    		case java.sql.Types.CHAR:
				case 1111:
			    	System.out.print(jdi.StringField(i, null));
	    			break;
	    		case java.sql.Types.INTEGER:
			    	System.out.print(jdi.IntField(i, null));
	    			break;
	    		case java.sql.Types.BIGINT:
			    	System.out.print(jdi.BigintField(i, null));
	    			break;
	    		case java.sql.Types.TIME:
	    			time.setTime((long)jdi.TimeField(i, null) * 1000);
			    	System.out.print(time);
	    			break;
	    		case java.sql.Types.DATE:
	    			date.setTime((long)jdi.DateField(i, null) * 1000);
			    	System.out.print(date);
	    			break;
	    		case java.sql.Types.TIMESTAMP: