Форум программистов [Powered by Invision Power Board]

Код

                    Class.forName("com.hxtt.sql.paradox.ParadoxDriver").newInstance();
                    .....................
                    Connection con = DriverManager.getConnection(url+folder.getName(), properties);
                    Statement stmt = con.createStatement();                    
                    ResultSet rs = stmt.executeQuery(sql);
                    ResultSetMetaData resultSetMetaData = rs.getMetaData();
                    int iNumCols = resultSetMetaData.getColumnCount();
                     Writer outF = new OutputStreamWriter(new FileOutputStream(folder.getAbsolutePath()+"/res.xls"));                    
                    while (rs.next()) {
                        for (int i = 1; i <= iNumCols; i++) {
                             if(colval!=null) {
                                outF.write(rs.getString(i));
                            }                            
                            outF.write("\t");
                        }
                        outF.write("\r\n");
                    }