oracle型態分類

while(rs.next()){


        //取得欄數


        ResultSetMetaDatarsmd=rs.getMetaData();


        intrs_count=rsmd.getColumnCount();


        setLog4J("info","oracle2mysql","欄位數量："+rs_count+"<br>");


        //取得欄位型態


        for(intii=1;ii<=rs_count;ii++){


                setLog4J("info","oracle2mysql","ColumnName:"+rsmd.getColumnName(ii)+""+


        "type:"+rsmd.getColumnType(ii)+""


        );


        if(java.sql.Types.VARCHAR==rsmd.getColumnType(ii)){


                setLog4J("info","oracle2mysql","type:varchar");   


        }


        elseif(java.sql.Types.DATE==rsmd.getColumnType(ii)){


                setLog4J("info","oracle2mysql","type:date"); 


        }


        elseif(java.sql.Types.NUMERIC==rsmd.getColumnType(ii)){


                setLog4J("info","oracle2mysql","type:numeric");  


                setLog4J("info","oracle2mysql","precision:"+rsmd.getPrecision(ii)+""+


        "scale:"+rsmd.getScale(ii)


        );


        }


        elseif(java.sql.Types.LONGVARCHAR==rsmd.getColumnType(ii)){


                setLog4J("info","oracle2mysql","type:longvarchar");    


        }


        elseif(java.sql.Types.BLOB==rsmd.getColumnType(ii)){


                setLog4J("info","oracle2mysql","type:blob"); 


        }


        elseif(java.sql.Types.LONGVARBINARY==rsmd.getColumnType(ii)){


                setLog4J("info","oracle2mysql","type:LONGVARBINARY");    


        }


        


                setLog4J("info","oracle2mysql",rs.getString(ii));


        }


}