Package noNamespace.EXPORTINFODocument

Examples of noNamespace.EXPORTINFODocument.EXPORTINFO


    public void doExport(String sqlStatement, File fHandle) throws Exception{
        Rep("Will execute <"+sqlStatement+">");
        TABLEDATADocument doc = TABLEDATADocument.Factory.newInstance();
        TABLEDATA tableData = doc.addNewTABLEDATA();
        EXPORTINFO exportInfo = tableData.addNewEXPORTINFO();
        exportInfo.setSTATEMENT(sqlStatement);
        exportInfo.setTIMESTAMP(Calendar.getInstance());
        ResultSet prs = oraConnection.prepareCall(sqlStatement).executeQuery();
        ResultSetMetaData columns = prs.getMetaData();
        int colCount = columns.getColumnCount();
        Rep("Statement returns "+colCount+" columns");
        String wColumns = "";
        for(int i=0;i<colCount;i++){
            COLUMNTYPE colType = exportInfo.addNewCOLUMNTYPE();
            colType.setNAME(columns.getColumnName(i+1));
            colType.setTYPE(columns.getColumnTypeName(i+1));
            if(columns.getColumnTypeName(i+1).equalsIgnoreCase("DATE")){
                colType.setFORMATMASK(DATE_FORMAT);
            }
View Full Code Here

TOP

Related Classes of noNamespace.EXPORTINFODocument.EXPORTINFO

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.