Danke für Deine Antwort, aber meine Idee sieht etwas anders aus, geht es nicht vielleicht auch so:
import java.io.*;
import java.net.*;
import java.sql.*;
import java.util.*;
//
import javax.swing.*;
import java.io.*;
import java.lang.*;
import java.awt.*;
import java.awt.event.*;
public class ExcelConnect extends javax.swing.JFrame {
static final String DRIVER_NAME = „sun.jdbc.odbc.JdbcOdbcDriver“;
static final String DATABASE_URL = „jdbc:odbc:Mappe1“;
////////////////////////////////////////////////////////////////////////////////////
/** Creates a new instance of ExcelConnect */
public ExcelConnect() {
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
initComponents();
setSize(600,600);
int sheetAnzahl = 3;
int zeilen, spalten, i, j, k;
}
///////////////////////////////////////////////////////////////////////////////////
public void readData() {
// Lesen aus der Excel-Tabelle
try {
Class.forName(DRIVER_NAME);
Connection conn = null;
conn = DriverManager.getConnection(DATABASE_URL);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(„select * from [CCS$]“);
while (rs.next() == true) {
String x1 = rs.getString(1);
String x2 = rs.getString(2);
String x3 = rs.getString(3);
String x4 = rs.getString(4);
String x5 = rs.getString(5);
String x6 = rs.getString(6);
String x7 = rs.getString(7);
String x8 = rs.getString(8);
String x9 = rs.getString(9);
String x10 = rs.getString(10);
String x11 = rs.getString(11);
String x12 = rs.getString(12);
String x13 = rs.getString(13);
String x14 = rs.getString(14);
String x15 = rs.getString(15);
String x16 = rs.getString(16);
String x17 = rs.getString(17);
System.out.println(x1 + x2 + x3 + x4 + x5 + x6 + x7 + x8 + x9 + x10 + x11 + x12 + x13 + x14 + x15 + x16 + x17);
}
rs.close();
stmt.close();
} catch (ClassNotFoundException cnfe) {
System.out.println(„ClassNotFoundException Was Thrown!“);
cnfe.printStackTrace();
} catch (SQLException sqle) {
System.err.println(„SQLException Was Thrown!“);
sqle.printStackTrace();
}
}
///////////////////////////////////////////////////////////////////////////////////////
private void initComponents(){
JTextField textField = new javax.swing.JTextField();
int sheetAnzahl = 3;
// Vorbereitung für das Auffangen der Daten
String[] sheetName = new String[sheetAnzahl];
JTable[] table = new JTable[sheetAnzahl];
JTabbedPane registerkarte = new JTabbedPane();
String[] kopf;
String[][] daten;
content.add(new JScrollPane(table), BorderLayout.CENTER);
}
//////////////////////////////////////////////////////////////////////////////////////
public int getZeilen(){
}
public int getSpalten(){
}
public String getSheetName(){
}
public String getSpaltenName(){
}
///////////////////////////////////////////////////////////////////////////////////////
public static void main (String [] args) {
new ExcelConnect().setVisible(true);
}
}
Gruß
Nicole
