qtforum.de

Code: Alles auswählen

public static void initTable(QTableWidget table, String sql ) {
		try {
			Databaseconnection db = new Databaseconnection();

			//Spalten
			ResultSet rs = db.getRs(sql);
			
			int anzahlCol = db.getColumnCout(rs);
			int anzahlRows = db.getRowsCount(rs);
			
			ArrayList<String> labels = new ArrayList<String>();
			for (int i = 1; i <= anzahlCol; i++) {
				labels.add(db.getColumnName(rs,i));
			}
			
			table.setColumnCount(db.getColumnCout(rs));
			table.setHorizontalHeaderLabels(labels);
			
			//Daten
			table.setRowCount(anzahlRows);
			int row = 0;
			while(rs.next()) {
				for(int i = 1; i <= anzahlCol; i++) {
					table.setItem(row, i - 1 , new QTableWidgetItem(rs.getString(i)));
					
				}
				row++;
			}
			
		} catch (Exception e) {	e.printStackTrace(); }
	}

Code: Alles auswählen

   ArrayList<String> labels = new ArrayList<String>(); 

Code: Alles auswählen

Databaseconnection db = new Databaseconnection();

Code: Alles auswählen

import java.sql.*;

public class Databaseconnection {
	
	public Databaseconnection() throws ClassNotFoundException, SQLException {
		this.initConnection();
	}
	
	private Connection con;
	private Statement stmt;
	
	private void initConnection() throws ClassNotFoundException, SQLException {
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		this.con = DriverManager.getConnection("jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=Daten.mdb");
		this.stmt = this.con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);

	}
	
	public void destroyConnection () throws SQLException {
		stmt.close();
		con.close();
	}
	
	public ResultSet getRs(String sql) throws SQLException {
		return this.stmt.executeQuery(sql);
	}
	
	public ResultSetMetaData getResultSetMetaData(ResultSet rs) throws SQLException {
		return rs.getMetaData();
	}
	
	public int getColumnCout(ResultSet rs) throws SQLException {
		ResultSetMetaData rsmd = getResultSetMetaData(rs);
		return rsmd.getColumnCount();
	}
	
	public String getColumnName(ResultSet rs, int index) throws SQLException {
		ResultSetMetaData rsmd = getResultSetMetaData(rs);
		return rsmd.getColumnName(index);
	}
	
	public int getRowsCount(ResultSet rs) throws SQLException {
		rs.last();
		int count = rs.getRow();
		rs.beforeFirst();
		return count;
	}
	
}

Code: Alles auswählen

Driver   Class name      Constructor arguments                                       File to include
QPSQL   QPSQLDriver      PGconn *connection                                          qsql_psql.cpp
QMYSQL   QMYSQLDriver   MYSQL *connection                                          qsql_mysql.cpp
QOCI   QOCIDriver      OCIEnv *environment, OCISvcCtx *serviceContext                     qsql_oci.cpp
QODBC   QODBCDriver      SQLHANDLE environment, SQLHANDLE connection                        qsql_odbc.cpp
QDB2   QDB2         SQLHANDLE environment, SQLHANDLE connection                        qsql_db2.cpp
QTDS   QTDSDriver      LOGINREC *loginRecord, DBPROCESS *dbProcess, const QString &hostName   qsql_tds.cpp
QSQLITE   QSQLiteDriver   sqlite *connection                                          qsql_sqlite.cpp
QIBASE   QIBaseDriver   isc_db_handle connection                                    qsql_ibase.cpp 

Code: Alles auswählen

QApplication.initialize(args);
		 
		QSqlDatabase db = QSqlDatabase.addDatabase(DB_DRIVER);

		if (!db.isValid())
			System.out.println("invalid driver");

Code: Alles auswählen

import com.trolltech.qt.gui.QApplication;
import com.trolltech.qt.sql.QSqlDatabase;

public class DatenbankQt {

	public static void main(String[] args) {
		QApplication.initialize(args);
		
		QApplication.addLibraryPath("lib");
		
		QSqlDatabase db = QSqlDatabase.addDatabase("QODBC4");
		  
		if (!db.isValid())
			System.out.println("geht nicht");
		else
			System.out.println("geht!");
	}
}