Torna al Thread

boolean trovato=false; String temp=""; String database="jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=" + filename.trim() + ";DriverID=22;READONLY=true}"; Connection conn = DriverManager.getConnection( database ,"",""); Statement state = conn.createStatement(); DatabaseMetaData dbmd=conn.getMetaData(); ResultSet rs=dbmd.getTables(null, null, "%", null); while(rs.next()){ temp=rs.getString("TABLE_NAME"); if(temp.equalsIgnoreCase("Pippo")){ trovato=true; } } rs.close(); state.close(); conn.close(); return trovato;
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5