<%-- Programm 6-12: BSP_ROOT/meinewebapp/simpel/ContentTypeExcel.jsp --%>
<%@ page contentType="application/vnd.ms-excel" 
         import="java.sql.*" %>
<% Class.forName("org.gjt.mm.mysql.Driver");
   Connection c =DriverManager.getConnection("jdbc:mysql://localhost:3306/Kurse");
   Statement s = c.createStatement();
     if (s.execute("SELECT * FROM Dozenten")) {                  // ..ausführen!
       ResultSet r = s.getResultSet();
       ResultSetMetaData rm = r.getMetaData();
       int count = rm.getColumnCount();
       for (int i = 1; i <= count; i++) {          // Spaltennamen
         out.print(rm.getColumnName(i));
         if (i != count) out.print("\t"); else out.println();     // Tabulator
       }
       while(r.next()) {
         for (int i = 1; i <= count; i++) {        // Spaltenwerte
           out.print(r.getString(i));
           if (i != count) out.print("\t"); else out.println();   // Tabulator
         }
       }
     }
%>